Sqlacodegen生成混合模型和表格

执行此命令:

sqlacodegen  --outfile db.py 

db.py包含生成的表:

t_table1 = Table(...)

和班级:

Table2(Base):
    __tablename__ = 'table2'

问题是表只以一种方式生成 - 表或类.

我想让它只生成模型(类),但在提供的标志中我找不到这样的选项.任何的想法？

看起来你所描述的是一个功能本身.sqlacodegen不会总是生成类模型.

它只会为具有主键且不是关联表的表形成模型类,如源代码中所示:

# Only form model classes for tables that have a primary key and are not association tables
if noclasses or not table.primary_key or table.name in association_tables:
    model = self.table_model(table)
else:
    model = self.class_model(table, links[table.name], self.inflect_engine, not nojoined)
    classes[model.name] = model

# Only form model classes for tables that have a primary key and are not association tables
# if noclasses or not table.primary_key or table.name in association_tables:
#    model = self.table_model(table)
# else:
model = self.class_model(table, links[table.name], self.inflect_engine, not nojoined)
classes[model.name] = model

t_Admin_op = Table(
    'Admin_op', metadata,
    Column('id_admin', Integer, nullable=False),
    Column('id_op', Integer, nullable=False)
)

class AdminOp(Base):
    __tablename__ = 'Admin_op'

    id_admin = Column(Integer, nullable=False)
    id_op = Column(Integer, nullable=False)