On Sep 13, 2010, at 2:48 PM, Gregg Lind wrote: > > Suppose this is my table: > > a_table = Table( > 'a_table', metadata, > Column('ts',Integer, index=True, nullable=False), > Column('country',String, index=True, nullable=False), > Column('somestat',Integer,nullable=False), > PrimaryKeyConstraint('ts','country',name='summary_pk'), > ) > > then: > >>>> print select([a_table]).where(a_table.c.country=='de') > SELECT a_table.ts, a_table.country, a_table.somestat > FROM a_table > WHERE a_table.country = %(country_1)s > > Suppose further that in the Postgres, there are several PARTITIONS > INHERIT > from this main table, and I want to query them directly... what is a > sensible > way to do this? I can figure out *which* partition to use, based on > outside > code, so it doesn't need to be very smart. > > As a final answer I want something like: > >>>> print <SOMETHING> > SELECT a_table_PARITION1.ts, a_table_PARITION1.country, > a_table_PARITION1.somestat > FROM a_table_PARITION1 > WHERE a_table_PARITION1.country = %(country_1)s > > In my head, it is like "oh, use a_table, except sub in a new value > for > a_table.name TEMPORARILY".
this is not very hard so I created a recipe for this case: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/PartitionTable > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.