`]@sddlmZddlmZddlmZmZddlmZmZm Z m Z m Z m Z eZ Gddde ZGddde Zd d Zd d Zed kreedS)) create_engine)declarative_base) sessionmaker relationship)ColumnIntegerString ForeignKeyUniqueConstraintIndexc@sLeZdZdZeeddddZeeZeedZ dS)UserTypeZusertype primary_keyT autoincrement N) __name__ __module__ __qualname__ __tablename__rridager user_typerrFE:\整理版笔记\python\day46-SQLAlchemy-ORM框架\connsqlalchemy.pyr s  r c@sgeZdZdZeeddddZeedZeedZ eee dZ dS)userinfor Trr@z usertype.idN) rrrrrrrrnamepasswordr Z user_type_idrrrrr"s rcCs&tddd}tjj|dS)NzFmysql+pymysql://linyaohong:111111@47.244.4.192/linyaohong?charset=utf8 max_overflow)rBasemetadata create_all)enginerrr create_table+sr#cCs&tddd}tjj|dS)NzFmysql+pymysql://linyaohong:111111@47.244.4.192/linyaohong?charset=utf8rr)rrr drop_all)r"rrr drop_table/sr%__main__N) sqlalchemyrsqlalchemy.ext.declarativersqlalchemy.ormrrrrrr r r rr rr#r%rrrrrs.