Michael Bayer wrote:
>
> thats not an incompatibility, thats just a bug. or maybe the backref
> youre setting up needs to know the "primaryjoin" as well since it might
> not be as likely to make a "guess" in more recent versions:
Yep, that enabled it to 'guess' correctly :-) Thanks!
Next question - I have a few instances of very hairy queries that are done as
pure text (mainly for my sanity as they are hangovers from the bad old days of
using another ORM and took ages to get right). These are executed in the helper
functions using:
obj.mapper.table.engine.execute('''... lots of sql ...''').fetchall()
This is (obviously) not the cleanest approach, but it worked. In 0.2x, I can
use
obj.mapper.mapped_table.metadata.engine.execute() but that makes me unwell just
looking at it :-)
What is the preferred/recommended way to get hold of an engine for these type
of
queries (or using text() for that matter), given that these helper functions
only have access to the class mapper?
Robert
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
