So anyone else who asks this knows, the following works:
A query with just a column:
qq = session.query(Configuration.name)
Normally I would loop, but in this case, taking just the first column:
yy = qq.column_descriptions[0]['expr']
yy.expression.table.name
gives: ''configurations”
On Apr 21, 2013, at 10:04 PM, Rob Fowler mia...@gmail.com wrote:
We are using the sharding module included in our application.
Currently we are selecting shards based on field. This works really well, as
the field that gets hashed to select the shard needs to be migrated to the
other
If the query does not have a table in it we don't get the tables.
For example, the following simple query gets a list of connection_strings
column from the Connection table:
aa = session.query(Connection.connection_string)
aa.column_descriptions
[{'aliased': False,
'expr':
from that expr, assuming it's a Column, you should be able to say
attribute.expression.table, where attribute is that InstrumentedAttribute
object.
If it can be any kind of expression, then you'd need to look into some of the
SQL utilities to find tables within the expression.
On Apr 22,
We are using the sharding module included in our application.
Currently we are selecting shards based on field. This works really well,
as the field that gets hashed to select the shard needs to be migrated to
the other tables that exist only in that shard.
Now we would like to have