sqlalchemy 简单例子

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