是否可以从SQLAlchemy模型的列中提取相关的序列名称?

这样发现:init元数据,反映特定的表,而不是遍历所有约束并找到您需要的约束。

from model import Model
from sqlalchemy import MetaData
m = MetaData()
m.reflect(Model.query.session.bind, only=[Model.__tablename__])
table_constraints = m.tables[Model.__tablename__].constraints
for constr in table_constraints:
    # checking isinstance(constr, PrimaryKeyConstraint) can be added
    for col in c.columns.values():
        if col.server_default is not None and col.server_default.arg is not None:
            print c.server_default.arg
            # prints nextval('table_id_seq'::regclass)

UPD。 版本允许无需迭代即可获取特定列的序列名称:

from model import Model
from sqlalchemy import MetaData
m = MetaData()
m.reflect(Model.query.session.bind, only=[Model.__tablename__])
sequence_name = Model.id.server_default.arg.text