I’m querying a Postgres view which returns JSON (SELECT
json_build_object(…)) which I’ve declared as a view in my db:
allinfra = Table("allinfra", db.metadata, autoload_with=db.engine)
res = db.session.query(allinfra).scalar()
But this gives me a Python dict, when what I want is the JSON string
returned by the view - serializing it with json.dumps() on the Python side
defeats the point (getting Postgres to do the heavy lifting). Apologies if
this question has an obvious answer, but I’ve found it impossible to search
for.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/5f84f3a9-aace-43ab-b7d7-1f1a143f1a53n%40googlegroups.com.
