[问题]sqlalchemy依list创立table column

楼主: alfven (冯小丸)   2020-10-23 08:59:30
以下范例来自sqlalchemy官方
https://docs.sqlalchemy.org/en/13/core/metadata.html
## 范例:在数据库新增一个表
engine = create_engine('sqlite:///:memory:')
meta = MetaData()
employees = Table('employees', meta,
Column('employee_id', Integer, primary_key=True),
Column('employee_name', String(60), nullable=False, key='name'),
Column('employee_dept', Integer, ForeignKey("departments.department_id"))
)
employees.create(engine)
## 范例结束
我想请问 如果有一list
employee_sister = ['sis年纪','sis三围','sis学校']
我们该如何将employee_sister 传入employees
再create出一个新的table呢?
作者: sherees (ShaunTheSheep)   2020-10-23 17:56:00
Table(..., *[Column(col, ...) for col in your_list])

Links booklink

Contact Us: admin [ a t ] ucptt.com