sqlalchemy 简单例子

最新推荐文章于 2024-02-29 08:00:00 发布

aminic

最新推荐文章于 2024-02-29 08:00:00 发布

阅读量2.5k

点赞数

分类专栏： mssql python

本文链接：https://blog.youkuaiyun.com/aminic/article/details/42970843

版权

python 同时被 2 个专栏收录

5 篇文章

订阅专栏

mssql

1 篇文章

订阅专栏

这篇博客介绍了如何在SQLAlchemy中结合pymssql驱动，实现使用MSSQL的GUID类型作为数据表ID的简单例子。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用了pymssql做为sqlalchemy的底层驱动，ID使用了MSSQL的类型内容为值为GUID

import uuid
from sqlalchemy.sql import text
from sqlalchemy.types import TypeDecorator,CHAR
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.dialects.mssql.base import MSUniqueIdentifier

from sqlalchemy import create_engine,  ForeignKey,func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Table, Column, Integer, String,DateTime,Boolean
import sqlalchemy.orm as o
import sqlalchemy as s
import sqlalchemy.types as types


engine = create_engine('mssql+pymssql://sa:123456@localhost:1433/test',echo=True)
#engine=create_engine('mysql+mysqlconnector://root:123456@localhost:3306/test',echo=True)

Base = declarative_base()
metadata=Base.metadata


class User(Base):
    __tablename__ = 'user'
    #id = Column(Integer, primary_key=True)
    id = Column(MSUniqueIdentifier(),server_default=text('newid()'),primary_key=True)
    name = Column(String(200),nullable=False)
    fullname = Column(String(200),nullable=False)
    password = Column(String(200),nullable=False)
    createTime=Column(DateTime, default=func.now(),nullable=False)
    isDelete=Column(Boolean,default=False,nullable=False)


    def __repr__(self):
        return "<User(name='%s', fullname='%s',password='%s',createTime='%s',isDelete='%s')>" % \
        (self.name, self.fullname, self.password,self.createTime,self.isDelete)


metadata.create_all(bind=engine)

Session=o.sessionmaker(bind=engine)
s=Session()


lucy=User(name='lucy',fullname='lucy.F',password='asdf')
s.add(lucy)
s.commit()

users=[User(name='maven',fullname='maven.sms',password='1234'),
       User(name='fang',fullname='zhang fang',password='lkjhsd')]
s.add_all(users)
s.commit()


fang=s.query(User).filter(User.name=='fang').first()
print fang
users=fang=s.query(User).filter(User.name=='fang').all()
print users
count=s.query(User).filter(User.name=='fang').count()
print count