On Mon, Mar 21, 2016 at 05:21:21PM +0100, [email protected] wrote: > > ReferenceAuthor is an instance of sqlalchemy.Table, so you can refer > > to its columns as ReferenceAuthor.c.Index. > > Ah nice. But something is still wrong. > Part of the query: > > .join(ReferenceAuthor, > ReferenceAuthor.c.Index=0) \ > > result in > ReferenceAuthor.c.Index=0) \ > ^ > > SyntaxError: keyword can't be an expression > > Not sure what is wrong here. But I think c.Index doesn't exist?
That's not it, try:
q.join(ReferenceAuthor, ReferenceAuthor.c.Index == 0)
If you use a single equals sign, Python understands that as an attempt
to use a keyword argument; keyword arguments need to be valid Python
identifiers, not arbitrary expressions. That's why it gave you a
SyntaxError.
In this case, you do not want to use a keyword argument, but an
ordinary expression that gets translated into SQL by SQLAlchemy.
Good luck,
Michal
--
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 https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: Digital signature
