How to get sanitized postgres SQL string in python for later use?

Question

I have a query that I want to append to a file (to generate a list of queries) that will be executed later.

location_filter="SELECT id FROM developers WHERE location='%s'"
out_file.write((location_filter, (location)))

But the output that gets written can't be executed in pgadmin:

("SELECT id FROM developers WHERE location='%s'", u'Seattle')

How can I safely generate this statement?

Clodoaldo Neto · Accepted Answer · 2016-02-11 16:21:48Z

2

conn = psycopg2.connect(database='cpn')
cur = conn.cursor()

location_filter = "SELECT id FROM developers WHERE location = %s"
out_file.write(cur.mogrify(location_filter, (location,)))

edited Feb 11, 2016 at 16:21

answered Feb 11, 2016 at 16:15

Clodoaldo Neto

127k30 gold badges250 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

How to get sanitized postgres SQL string in python for later use?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related