from sqlalchemy import create_engine,Table,Column,Integer,String,MetaData,ForeignKey
engine=create_engine("mysql+pymysql://root:123@localhost:3306/school",echo=True)
metadata=MetaData(engine)
user=Table('class',metadata,
Column('class_id',Integer,primary_key=True),
Column('class_name',String(20)),
Column('like',String(40)),
)
address_table = Table('student', metadata,
Column('student_id', Integer, primary_key=True),
Column('student_name', None, ForeignKey('user.id')),
Column('email', String(128), nullable=False),
Column('sex',String(14)),
)
metadata.create_all()
python-sqlalchemy
最新推荐文章于 2024-05-31 14:08:21 发布