from sqlalchemy import * from sqlalchemy.orm import declarative_base from datetime import datetime Base = declarative_base() class Course_Model(Base): __tablename__ = 'wl_course' id = Column(Integer,autoincrement=True) course_id = Column(String(50),primary_key=True) course_name = Column(String(50)) play_time=Column(Integer) create_date = Column(DATETIME, default=datetime.now) update_date = Column(DATETIME, default=datetime.now, onupdate=datetime.now) delete_status = Column(Integer,default=0,comment='删除状态:0未删除,1已删除')