本文介绍了使用sqlalchemy的row_to_json的语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想弄清楚如何将PostgreSQL(9.2)row_to_json与SqlAlchemy一起使用.但是我还无法提出任何有效的语法.
I would like to figure out how to use Postgres' (9.2) row_to_json with SqlAlchemy. However I haven't been able to come up with any working syntax.
details_foo_row_q = select([Foo.*] ).where(Foo.bar_id == Bar.id ).alias('details_foo_row_q') details_foo_q = select([ func.row_to_json(details_foo_row_q).label('details') ]).where(details_foo_row_q.c.bar_id == Bar.id ).alias('details_foo_q')理想情况下,我希望不必键入表格模型中的每个字段.
I would ideally like to not to have to type out each and every field from the table model if possible.
从"mn"那里得到答案:
Got the answer from 'mn':
应该更像这样:
details_foo_row_q = select([Foo]).where(Foo.bar_id == Bar.id).alias('details_foo_row_q') details_foo_q = select([ func.row_to_json(literal_column(details_foo_row_q.name)).label('details') ]).select_from(details_foo_row_q).where( details_foo_row_q.c.bar_id == Bar.id ).alias('details_foo_q')谢谢你,很棒!
推荐答案您的查询生成了不正确的SQL
Your query generates an incorrect SQL
SELECT row_to_json(SELECT ... FROM foo) AS details FROM (SELECT ... FROM foo) AS details_foo_row_q应该是
SELECT row_to_json(details_foo_row_q) AS details FROM (SELECT ... FROM foo) AS details_foo_row_q您需要使用select作为 literal_column
You need to use select as literal_column
from sqlalchemy.sql.expression import literal_column details_foo_q = select([ func.row_to_json(literal_column(details_foo_row_q.name)).label('details') ]).select_from(details_foo_row_q).where( details_foo_row_q.c.bar_id == Bar.id ).alias('details_foo_q')更多推荐
使用sqlalchemy的row
发布评论