If I have an integer column I can easily select the column minus one:
session.query(mytable.column - 1)
If I want to select a datetime column minus one minute, there doesn't
seem to be an easy way to do it.
I would have expected to be to do something like:
session.query(mytable.column -
seconds' AS
ano...
On Dec 20, 3:02 pm, Michael Bayer mike...@zzzcomputing.com wrote:
On Dec 20, 2010, at 8:22 AM, ellonweb wrote:
If I have an integer column I can easily select the column minus one:
session.query(mytable.column - 1)
If I want to select a datetime column minus one minute
against pg9 will work fine on 8.4? (This is the reason
I'm using such an old version)
Here's the full traceback if it's useful:
http://paste.pound-python.org/show/740/
On Dec 20, 5:24 pm, Michael Bayer mike...@zzzcomputing.com wrote:
On Dec 20, 2010, at 11:58 AM, ellonweb wrote:
FYI, I'm using
I've updated to psycopg2 2.2.1, working now. Sorry for wasting your
time!
On Dec 20, 6:01 pm, ellonweb ellon...@gmail.com wrote:
print session.query(Updates.timestamp - td).first()
2010-12-20 17:44:45,757 INFO sqlalchemy.engine.base.Engine.0x...dad0
BEGIN (implicit)
2010-12-20 17:44:45,766
I've added a few extra columns to one of my tables (nothing fancy,
just plain Integers and Floats) and created them manually in the db.
Now every time I try to query an object from this table I get the
error in the subject. Using declarative in SA 0.6.3 on PG8.4.
Traceback below, any help is much
Hi, just wondering if there's support for window functions, or if
there's any plans to add this yet?
Thanks
--
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
Hi,
I have a query object to which I'm performing the following join and
filter:
Q = Q.outerjoin(Table.history_loader)
Q = Q.filter(TableHistory.tick == 123)
Table.history_loader is a dynamic loader that maps the two tables
based on their id property.
This produces the following
Silly mistake, this works fine now, thanks!
On Mar 19, 12:53 am, Michael Bayer mike...@zzzcomputing.com wrote:
On Mar 18, 2010, at 8:28 PM, ellonweb wrote:
Hi,
I have a query object to which I'm performing the following join and
filter:
Q = Q.outerjoin(Table.history_loader
Hi
I'm using a few association proxies in a 1:1 relationship, it works
nicely, I have a proxy on table1 pointing to an attribute on table2,
and another on table1 that points to a relation between table2 and
table3. So what I really have is also a 1:1:1 relationship. Is there a
way to make a proxy
I actually just realised that it's not a 1:1:1 relationship, 1:1 and
many:1 in the case of table1:table2 and table2:table3 respectively,
but I don't think it really matters here, given I've already got
proxies that work!
On Jan 15, 2:29 am, ellonweb ellon...@gmail.com wrote:
Hi
I'm using a few
On Dec 23, 9:02 pm, Michael Bayer mike...@zzzcomputing.com wrote:
ellonweb wrote:
Hi,
I was just wondering if there's any eta on 0.5.7 yet? The website does
say a typical release pace of one point release per month and it's
been over 3 months since .5.6! My code relies on a couple
Hi,
I was just wondering if there's any eta on 0.5.7 yet? The website does
say a typical release pace of one point release per month and it's
been over 3 months since .5.6! My code relies on a couple of the
bugfixes in it and it's always easier for users to install releases
than getting the
12 matches
Mail list logo