python + sqlite insert variable into PRAGMA statement [duplicate]

Question

Basiclly I wish to use a string I have saved in a python variable as my parameter 'table-name' in "PRAGMA table_info(table-name);"

import sqlite3

connect = sqlite3.connect('exampleDB.sqlite')
cur = connect.cursor()

x = 'a string'

cur.execute("PRAGMA table_info(?)", (x,))

This was my first idea. Which did not work and neither did:

cur.execute("PRAGMA table_info(table) VALUES (?)", (x,))

Which was an idea I got from here.

Just putting the variable in there like so:

cur.execute("PRAGMA table_info(x))

also proved fruitless.

Any ideas? This is my first time posting here so feel free to lecture me on how or where I should have posted this differently should you see fit.

Martin · Accepted Answer · 2018-07-27 14:44:37Z

0

Try this

cur.execute("PRAGMA table_info({})".format(x))

answered Jul 27, 2018 at 14:22

Martin

4591 gold badge8 silver badges27 bronze badges

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

Comments

carter · Accepted Answer · 2018-07-27 14:24:46Z

-2

You want to do the following:

cur.execute("PRAGMA table_info(" + x + ")")

answered Jul 27, 2018 at 14:24

carter

546 bronze badges

This worked. Thank You!