Python Dynamic Parameterized Query

Question

I'm hoping to create a build a query dynamically that I can populate through paramerters. E.g. Something like:

INSERT INTO Table (Col1, Col2, Col3, ...) VALUES (%s, %s, %s, ...)

Then I want to populate it like shown in How to put parameterized sql query into variable and then execute in Python? :

sql = "INSERT INTO table VALUES (%s, %s, %s)"
args= var1, var2, var3
cursor.execute(sql, args)

Building the query string above should be pretty easy, however I'm not sure how to build the list of args. Once I can do that, the rest should be easy.

James Oravec · Accepted Answer · 2014-09-08 22:53:56Z

0

Looks like my question was easier than I thought, it looks like arrays behave like lists in python. The following gave me what I needed:

results = []

results.append("a")
results.append("b")
results.append("c")
results.append("d")

print results

I can use the above to make my arg list.

answered Sep 8, 2014 at 22:53

James Oravec

20.5k31 gold badges100 silver badges164 bronze badges

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

Comments

g.d.d.c · Accepted Answer · 2014-09-08 23:04:37Z

0

I typically use something like this to achieve what you describe:

>>> def prepquery(qrystr, args):
...   # Assumes Qry Str has a %s in it instead of column placeholders.
...   return qrystr % ', '.join('?' * len(args)) # ['%s'] * len(args), depending on DB.
...
>>>
>>> prepquery('Insert Into Table Values (%s)', range(5))
'Insert Into Table Values (?, ?, ?, ?, ?)'

answered Sep 8, 2014 at 23:04

g.d.d.c

48.3k12 gold badges105 silver badges116 bronze badges

Collectives™ on Stack Overflow

Python Dynamic Parameterized Query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related