# coding=utf-8 from sqlalchemy import Column, Integer, String, schema from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import create_engine # def table_args(): # return { # 'mysql_engine': 'InnoDB', # 'mysql_charset': 'utf8' # } # 创建模型类继承类的基类 Base = declarative_base() class Stranger(Base): ''' 创建一个陌生人的模型类,字段为 id , name , sex, stranger ''' # 定义创建的表的名字 __tablename__ = 'stranger' # 设置联合唯一 # __table_args__ = ( # schema.UniqueConstraint(), # table_args() # ) id = Column(Integer, primary_key=True, autoincrement='auto', nullable=False) name = Column(String(255), nullable=False) sex = Column(String(255), nullable=False) stranger = Column(String(255), nullable=False) class Acquiaintance(Base): ''' 定义一个熟人的模型类,字段为id,name,sex,acquintance ''' #定义创建的表的名字 __tablename__ = 'acquiaintance' # 设置联合唯一 # __table_args__ = ( # schema.UniqueConstraint(), # table_args() # ) id = Column(Integer, primary_key=True, autoincrement='auto', nullable=False) name = Column(String(255), nullable=False,) sex = Column(String(255), nullable=False) acquiaintance = Column(String(255), nullable=False) # 创建数据库引擎并把字段映射到对应数据表中 args = 'mysql+pymysql://root:shen123@localhost:3306/test2' engine = create_engine(args) Base.metadata.create_all(engine) # 创建模型类的对象 t1 = Stranger() t2 = Acquiaintance()
模型类
最新推荐文章于 2020-12-23 17:15:43 发布