[sqlalchemy] Re: Mapping temporal data for easy querying using time dimension

2009-12-30 Thread Adam Dziendziel
On 28 Gru, 21:16, "Michael Bayer" wrote: > > A query in the general can be against any number of individual columns, > mapped entities, or aggregate functions.   It can be selecting from many > tables at once, as well as from other Query objects as subqueries.   > Trying to guess if filter_by() ha

Re: [sqlalchemy] Re: Mapping temporal data for easy querying using time dimension

2009-12-28 Thread Michael Bayer
Adam Dziendziel wrote: > On 28 Gru, 20:19, "Michael Bayer" wrote: >> >> query.get() doesn't work with filtering criterion.  This because it >> looks >> up in the current session by primary key, and if present issues no SQL. >> If it were filtered, you'd get different results based on whether or no

[sqlalchemy] Re: Mapping temporal data for easy querying using time dimension

2009-12-28 Thread Adam Dziendziel
On 28 Gru, 20:19, "Michael Bayer" wrote: > > query.get() doesn't work with filtering criterion.  This because it looks > up in the current session by primary key, and if present issues no SQL. > If it were filtered, you'd get different results based on whether or not > the object were already load

Re: [sqlalchemy] Re: Mapping temporal data for easy querying using time dimension

2009-12-28 Thread Michael Bayer
Adam Dziendziel wrote: > On 27 Gru, 19:58, Michael Bayer wrote: >> On Dec 27, 2009, at 12:01 PM, Adam Dziendziel wrote: >> >> this answer to this required enough creativity and testing that I made >> it into a usage recipe. Please give it a road test >> athttp://www.sqlalchemy.org/trac/wiki/Usag

[sqlalchemy] Re: Mapping temporal data for easy querying using time dimension

2009-12-28 Thread Adam Dziendziel
On 27 Gru, 19:58, Michael Bayer wrote: > On Dec 27, 2009, at 12:01 PM, Adam Dziendziel wrote: > > this answer to this required enough creativity and testing that I made it > into a usage recipe. Please give it a road test > athttp://www.sqlalchemy.org/trac/wiki/UsageRecipes/GlobalFilterand let