import pandas as pd
from sqlchemy import literal
.... # 其他引用包
tmp_sql = select(Level1.id.label('level1_id'),
literal(None, Text).label('leve1_name'))
with dbSession() as session:
result = session.execute(tmp_sql)
df = pd.DataFrame(result.mappings().all())
print(df.shape)
sqlalchemy 查询结果增加一个常量新列
发布时间 2023-03-30 13:19:22作者: lqqgis