simple update in sqlalchemy

Question

UserTable is:

Serving a web page request i have a user id in hand and I only wish to update the last_login field to 'now'.

It seems to me that there are 2 ways:

Both work fine but look quite disgusting in code.

Is anyone aware of a more elegant way of doing an update-with-no-query using sqlalchemy? Is there another ORM who has got this right?

Thanks

ebo · Accepted Answer · 2009-06-19 11:18:24Z

23

Assuming you have a mapper UserTable in place:

DBSession.query(UserTable).filter_by(id = user_id).\
    update({"last_login":datetime.datetime.now()}, synchronize_session=False)

Additional parameters in the docs.

answered Jun 19, 2009 at 11:10

ebo

9,2853 gold badges33 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment