How to call a postgresql sql function in sqlalchemy in an update query

Question

I am new to sqlalachemy in python and i have a question. I need to port this query:

UPDATE user_list SET last_visit=now()  WHERE   name='"+username+"'

I have read a lot about the update query, but I see possibility to set the value of the last_visit to the value generated by the now() function of postgresql. How would I do that properly? Assume that I would use the update functions of sqlalachemty. I could generate this as sql string and execute() it, but then the statement could be subject of sql injection. How to do this right?

ThiefMaster · Accepted Answer · 2016-06-21 13:53:18Z

1

You can use func.now() (import func from sqlalchemy).

Reference: http://docs.sqlalchemy.org/en/latest/core/functions.html

answered Jun 21, 2016 at 13:53

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

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

Collectives™ on Stack Overflow

How to call a postgresql sql function in sqlalchemy in an update query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related