On Mon, Mar 21, 2016 at 05:21:21PM +0100, c.bu...@posteo.jp 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 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.
signature.asc
Description: Digital signature