Use function input as code Python

Question

I have this function (SQLAlchemy):

# table: Table to search (should be the class name)
# column: filter to use
# search: search term
#
# Returns a list [object] with the found entries in the database
# Uses the SQL LIKE statement

def search(table, column, search):
    results = dbsession.query(table).filter(column.like('%' + search + '%')).all()
    return results

So this search function searches in the class 'table', uses the filter 'column' and searches for 'search'. The problem I'm having now is that if I enter a value for 'column' (wich is actually not a string but a piece of code) I always get an error that the name doesn't exists:

  users =  search(User, fname, 'Jo')
NameError: name 'fname' is not defined

Does anybody know how to code this properly?

That is a runtime error because you did not define fname, not a sqlalchemy problem. — Martijn Pieters
– Martijn Pieters, Commented Mar 7, 2013 at 11:26
alright, but how should I do it then? I want to search in the fname column? — arnoutaertgeerts
– arnoutaertgeerts, Commented Mar 7, 2013 at 11:26
If you have the table object, why not just grab it from there? User.fname is the column.. — Martijn Pieters
– Martijn Pieters, Commented Mar 7, 2013 at 11:28

waitingkuo · Accepted Answer · 2013-03-07 11:28:55Z

1

Use users = search(User, User.fname, 'Jo') instead.

answered Mar 7, 2013 at 11:28

waitingkuo

94.5k28 gold badges119 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

Use function input as code Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related