您可以使用来告知
TextClause(由产生
text())列类型
.columns():
from sqlalchemy import inspectsession = Session()stmt = text('select * from t').columns(*inspect(T).columns)t = session.query(T).from_statement(stmt).first()assert type(t.attrs) == dict, repr(t.attrs)
或者,对于SQLAlchemy
<0.9,使用typemap参数:
from sqlalchemy import inspectsession = Session()typemap = {c.name: c.type for c in inspect(T).columns}stmt = text('select * from t', typemap=typemap)t = session.query(T).from_statement(stmt).first()assert type(t.attrs) == dict, repr(t.attrs)
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)