[sqlalchemy] Re: Updating existing objects

2008-12-27 Thread Eric Abrahamsen
On Dec 27, 2008, at 1:39 PM, Andreas Jung wrote: On 27.12.2008 3:06 Uhr, Eric Abrahamsen wrote: Sorry for the very beginner question, but I haven't been able to find a good discussion of this issue online (possibly because it's too basic). I'm using sqlalchemy as part of a basic web-based

[sqlalchemy] Updating existing objects

2008-12-26 Thread Eric Abrahamsen
Sorry for the very beginner question, but I haven't been able to find a good discussion of this issue online (possibly because it's too basic). I'm using sqlalchemy as part of a basic web-based CRUD-style CMS. I've got the Create, Read and Delete parts down, but I'm not sure how best to handle

[sqlalchemy] filtering by datetime elements

2008-05-17 Thread Eric Abrahamsen
Hi there, I'm new to this, so please be patient if I'm a little slow... I'm trying to filter Article objects by a datetime field ('pubdate'), and expected that I would be able to do something like this: arts = sess.query(Article).filter(and_(Article.pubdate.year==year,

[sqlalchemy] Re: filtering by datetime elements

2008-05-17 Thread Eric Abrahamsen
On May 17, 2008, at 11:17 PM, [EMAIL PROTECTED] wrote: it's SQL that is not working with python objects, and the column pubdate (associated with type DateTime on python side) has no attr .year or .month. lookup the messages in the group, there were some sugestions long time ago, but