I'm using SQLAlchemy version 0.9.8, connecting to Postgres 9.4. I'm trying
to do something like this:
query = select([func.to_json(User)]).select_from(User)
# Printing the query returns something that seems to make sense:
# >>> print select([func.to_json(User)]).select_from(User)
# SELECT to_json(:to_json_2) AS to_json_1
# FROM users
# But when I go to execute, I get:
session.execute(query)
# sqlalchemy.exc.ProgrammingError: (ProgrammingError) can't adapt type
'DeclarativeMeta' 'SELECT to_json(%(to_json_2)s) AS to_json_1 \nFROM users'
{'to_json_2': <class 'monitoring.models.User'>}
Obviously I'm doing something terribly wrong. Might someone be able to
point me in the right direction? I haven't been able to find anything in
the docs that addresses trying to do such a thing. Oh, I've also tried
passing the model's Table object, but that seems to be even worse. It's as
if the parameter wasn't ever passed.
Thanks!
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
