一次Sqlalchemy从model类定义到数据库表的SQL脚本自动生成日志
CREATE TABLE session (
session_id VARCHAR(128) NOT NULL,
atime TIMESTAMP NULL,
data TEXT,
PRIMARY KEY (session_id)
)
一个Python模型类的定义如下:
class Group(Base):
__tablename__ = 'group'
id = Column(Integer, primary_key=True)
name = Column(String(64), nullable=False)
users = relationship("User", secondary=group_user_asso_table, backref=backref('groups'))
模型类Group生成的SQL如下:
CREATE TABLE `group` (
id INTEGER NOT NULL AUTO_INCREMENT,
name VARCHAR(64) NOT NULL,
PRIMARY KEY (id)
)
-----------------------------------------------------------------------------------------------
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True)
username = Column(String(32), nullable=False)
password = Column(String(64), nullable=False)
email = Column(String(64), nullable=False)
is_active = Column(Boolean, nullable=False, default=False)
is_superuser = Column(Boolean, nullable=False, default=False)
last_login = Column(TIM