一次Sqlalchemy从model类定义到数据库表的SQL脚本自动生成日志

一次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