forked from wolin_ck666_999/StuManagerSys
28 lines
1.2 KiB
Python
28 lines
1.2 KiB
Python
|
from sqlalchemy import Integer, String, Column, DateTime, Enum as SQLEnum,Boolean,create_engine
|
||
|
|
from sqlalchemy.orm import declarative_base,sessionmaker
|
||
|
|
|
||
|
|
from enum import Enum
|
||
|
|
from datetime import datetime
|
||
|
|
|
||
|
|
tea_url ='mysql+pymysql://root:123456@127.0.0.1:3306/ai0824_stu?charset=utf8'
|
||
|
|
|
||
|
|
engine = create_engine(tea_url,pool_size=100, echo=False)
|
||
|
|
Base = declarative_base()
|
||
|
|
class Sex(Enum):
|
||
|
|
w = '女'
|
||
|
|
m = '男'
|
||
|
|
|
||
|
|
class Teacher(Base):
|
||
|
|
__tablename__ = 's_teacher'
|
||
|
|
id =Column(Integer, primary_key=True,autoincrement=True)
|
||
|
|
t_name = Column(String(100),comment='教师名称')
|
||
|
|
t_age = Column(Integer,comment='年龄')
|
||
|
|
t_phone = Column(String(20),unique=True,comment='电话')
|
||
|
|
t_sex = Column(SQLEnum(Sex,values_callable=lambda x: [e.value for e in x]),comment='性别')
|
||
|
|
class_id = Column(String(100),comment='带班编号')
|
||
|
|
create_time = Column(DateTime,default=datetime.now,comment='创建时间')
|
||
|
|
update_time = Column(DateTime,default=datetime.now,onupdate=datetime.now,comment='更新时间')
|
||
|
|
is_delete = Column(Boolean,default=False,comment='判断是否删除')
|
||
|
|
|
||
|
|
Base.metadata.create_all(engine)
|
||
|
|
Session = sessionmaker(bind=engine,autoflush=False,autocommit=False)
|