CODEWITHSUNDEEP
sqlalchemy
Carolyn Conway
Carolyn Conway

Reputation: 1506

How do you update a SQLAlchemy RowProxy?

I'm working with the SQLAlchemy Expression Language (not the ORM), and I'm trying to figure out how to update a query result.

I've discovered that RowProxy objects don't support assignment, throwing an AttributeError instead:

# Get a row from the table
row = engine.execute(mytable.select().limit(1)).fetchone()

# Check that `foo` exists on the row
assert row.foo is None

# Try to update `foo`
row.foo = "bar"

AttributeError: 'RowProxy' object has no attribute 'foo'

I've found this solution, which makes use of the ORM, but I'm specifically looking to use the Expression Language.

I've also found this solution, which converts the row to a dict and updates the dict, but that seems like a hacky workaround.

So I have a few questions:

Upvotes: 5

Views: 3056

Answers (1)

univerio
univerio

Reputation: 20548

You are misusing SQLAlchemy. The usage you've described is the benefit of using an ORM. If you only want to restrict yourself to SQLAlchemy Core, then you need to do

engine.execute(mytable.update().where(mytable.c.id == <id>).values(foo="bar"))

Upvotes: 4

Related Questions