I was thinking about this overnight.. 
Do *values* relates specifically to inserts and updates, not 
selects/deletes perhaps, which would correlate to SQL syntax. 
If, it would make sense to indicate that in the documentation

On Thursday, 8 February 2018 20:29:45 UTC, Jeremy Flowers wrote:
> I've seen you can do things like this:
> fields = ['jobmst_type', 'jobmst_name']
>  print(session.query(Jobmst).options(load_only(*fields)).first())
> But according to the documentation, you should be able to do something 
> with Query values() 
> <http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.values>
> too.
> But once again I seem to be dumbfounded by the syntatic sugar.
> What data type does the list of values need?
> *Is there a way to introspect that ahead of time?*
> Thought I was onto something with *.base_columns*, but that didn't work 
> either...
> I ended up with something like an instrumentalAttributes mismatch.
> print(session.query(Jobmst)
>              .values([Jobmst.jobmst_type.base_columns,
>                       Jobmst.jobmst_name.base_columns
>                       ])
>              .first()
>       )
> sqlalchemy.exc.InvalidRequestError: SQL expression, column, or mapped 
> entity expected - got '[{Column('jobmst_type', Numeric(scale=0, 
> asdecimal=False), table=<jobmst>, nullable=False)}, {Column('jobmst_name', 
> String(length=256), table=<jobmst>, nullable=False)}]'
> BTW: I'm aware of querying with things like query(Jobmst.jobmst_type, 
> Jobmst.jobmst_name) too - but looking to understand what values expects.
> Mike, Can documentation not specify type?

SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper


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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to