SQLAlchemy: a better way for update with declarative?

python sqlalchemy declarative
Hadrien picture Hadrien · Apr 13, 2010 · Viewed 46.2k times · Source

I am a SQLAlchemy noob.

Let's say I have an user table in declarative mode:

class User(Base):
    __tablename__ = 'user'
    id = Column(u'id', Integer(), primary_key=True)
    name = Column(u'name', String(50))

When I know user's id without object loaded into session, I update such user like this:

ex = update(User.__table__).where(User.id==123).values(name=u"Bob Marley")
Session.execute(ex)

I dislike using User.__table__, should I stop worrying with that?

Is there a better way to do this?

Thanks!

Answer

Ants Aasma picture Ants Aasma · Apr 13, 2010

There's also some update capability at the ORM level. It doesn't handle any tricky cases yet but for the trivial case of single row update (or bulk update) it works fine. It even goes over any already loaded objects and applies the update on them also. You can use it like this:

session.query(User).filter_by(id=123).update({"name": u"Bob Marley"})

Related questions

SQLAlchemy update if unique key exists

I've got a class: class Tag(Base, TimestampMixin): """Tags""" __tablename__ = 'tags' __table_args__ = {'mysql_engine' : 'InnoDB', 'mysql_charset' : 'utf8' } id = Column(Integer(11), autoincrement = True, primary_key = True) tag = Column(String(32), nullable = False, unique = True) cnt = Column(Integer(11), index = True, …

Read More
SQLAlchemy - order_by on relationship for join table

I'm using declarative SQLAlchemy and I have three models: Role, Permission, and RolePermission. In my Role model, I have the following: class Role(Base): name = Column(u'NAME', VARCHAR(50), nullable=False, unique=True) permissionLinks = relationship(RolePermission, backref="role", order_by=name) …

Read More
SQLAlchemy declarative many-to-many self-join via Association object

I have a table Users and a table Friends which maps users to other users as each user can have many friends. This relation is obviously symmetric: if user A is a friend of user B then user B is …

Read More