[storm] setting a database timestamp

Martin DeMello martindemello at gmail.com
Wed Apr 22 02:31:59 BST 2009


On Wed, Apr 22, 2009 at 6:44 AM, James Henstridge <james at jamesh.id.au> wrote:
> On Wed, Apr 22, 2009 at 8:43 AM, Martin DeMello <martindemello at gmail.com> wrote:
>> How do I access postgresql's CURRENT_TIMESTAMP function from storm?
>> That is, I want a table with a datetime column updated with the
>> server's current time, not datetime.now() on the client.
>
> Try the following:
>
> from storm.expr import SQL
>
> CURRENT_TIMESTAMP = SQL("CURRENT_TIMESTAMP")

Nice. And for the benefit of anyone googling this, I solved the second
part of my problem too -

store.find(User, (SQL("CURRENT_TIMESTAMP") - User.last_updated > '1 00:00:00'))

will find all users who haven't been active in the last day.

martin



More information about the storm mailing list