How can I get/set an SqlAlchemy query value with the Column object

Question

To make some code more generic, I'm trying to retrieve/set values in a database row using the Column object.

For example, I'll have this setup:

col = MyTable.MyColumn
result = session.query(...).one()

Now I want to get/set the values, semantically like below:

cur_value = result[col]
result[col] = new_value

What is the correct syntax to use the Column object to get/set values in the result?

col will not be a static value, but dynamically taken from a map.

cur_value =result.col, result.col = new_val db.session.commit() als this may help stackoverflow.com/questions/9667138/… — sahasrara62
– sahasrara62, Commented Dec 2, 2020 at 11:31

Mehrdad Pedramfar · Accepted Answer · 2020-12-02 11:44:18Z

1

You can do this:

cur_value = getattr(result, col.key)
setattr(result, col.key, new_value)

answered Dec 2, 2020 at 11:28

Mehrdad Pedramfar

11.1k4 gold badges43 silver badges61 bronze badges

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

2 Comments

The column objects are not strings, they are SqlAlchemy Column objects. If I knew how to get the resulting name of that column, this would work.

@edA-qamort-ora-y use: col = MyTable.MyColumn.key... this will give you your column name.