how to dynamically modify the attribute in a query using sqlalchemy

Question

I am using sqlalchemy and i wonder if its possible to dynamically modify an attribute of a class while doing a query

if school == "abc":
         school_data = (
             meta.session.query(
                 model.School.name, <=== HERE
...

i want to be able to dynamically change .name. to another field, is it possible with python and sqlalchemy?

edg · Accepted Answer · 2022-08-04 11:34:46Z

2

You can try to use getattr :

if school == "abc":
   attr = "name"
else:
   attr = "id"

school_data = meta.session.query(getattr(model.School, attr) ...)

answered Aug 4, 2022 at 11:34

edg

1,2408 silver badges18 bronze badges

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

Comments

c8999c 3f964f64 · Accepted Answer · 2022-08-04 11:38:55Z

0

I am not 100% sure if this is what you need, but you can do

c = "name"
getattr(table.c, c)

this gets a column from a table, named c - which can be any string. I am quite sure you can adapt this to model.School

answered Aug 4, 2022 at 11:38

c8999c 3f964f64

1,6491 gold badge18 silver badges32 bronze badges