[sqlalchemy] Obtaining the SQL query for a lazy load programmatically

I observe that the query for a lazy load is generated here: https://bitbucket.org/zzzeek/sqlalchemy/src/e1d1d999c9a688f4c8dbbe885438c63d6ef494c6/lib/sqlalchemy/orm/strategies.py?at=master#cl-551 I would like to run queries through an EXPLAIN QUERY PLAN or an ANALYZE programmatically for many

Re: [sqlalchemy] Serializing sqlalchemy declarative instances with yaml

Well I was hoping to just use yaml since yaml understands when two objects refer to the same underlying object. That means you don't have to write any logic to de-duplicate objects through relationships, etc. Since json doesn't have the notion of referencing, that doesn't seem straightforward

Re: [sqlalchemy] Serializing sqlalchemy declarative instances with yaml

UTC-4, Peter Waller wrote: I was also hoping to just use yaml to avoid writing custom dumping code, since it seems in general like a useful capability. So I may yet try and find the underlying bug and fix it. It might not be a bug, and the effect of an implementation feature of SqlAlchemy

[sqlalchemy] A complicated composite secondary join relationship() property involving four tables

Hi All, I am wondering if it is possible to describe in sqlalchemy the following relationship with the new features introduced since 0.9.2. I've been reading this document and it looks close to what I'm trying to achieve:

Re: [sqlalchemy] A complicated composite secondary join relationship() property involving four tables

, at 1:14 PM, Peter Waller pe...@scraperwiki.com wrote: Hi All, I am wondering if it is possible to describe in sqlalchemy the following relationship with the new features introduced since 0.9.2. I've been reading this document and it looks close to what I'm trying to achieve: http

Re: [sqlalchemy] A complicated composite secondary join relationship() property involving four tables

that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or are annotated in the join condition with the foreign() annotation. Any hints? Thanks again! On 20 October 2014 18:26, Michael Bayer mike...@zzzcomputing.com wrote: On Oct 20, 2014, at 1:14 PM, Peter Waller pe

[sqlalchemy] eager/joined loading a whole graph

Hi All, I have also created a post for this question on StackOverflow: http://stackoverflow.com/questions/3863508/joinedload-eager-loading-whole-sub-graphs-in-sqlalchemy Let's say I have a Task object which can be dependent on other Tasks. Is there a way to sensibly eager/joinedload all of a

[sqlalchemy] Re: eager/joined loading a whole graph

anyway. - Peter On 5 October 2010 14:39, Peter Waller peter.wal...@cern.ch wrote: Hi All, I have also created a post for this question on StackOverflow: http://stackoverflow.com/questions/3863508/joinedload-eager-loading-whole-sub-graphs-in-sqlalchemy Let's say I have a Task object which can

[sqlalchemy] Re-using labels

Let's say I write something like: fixed_column = cast(my_column.op(/)(2**32), Integer).label(fixed_column) print select([fixed_column]).where(fixed_column 100) I get: SELECT CAST(my_column / :my_columnn_1 AS INTEGER) AS fixed_column FROM table WHERE CAST(my_column / :my_column_1 AS INTEGER)