使用了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 = Co