python StringBuilder for MySQL query execution

Question

I am trying to query my database where one of the columns is a python variable:

weekNum = "week" + str(i)               #i is either 2, 3, 4, 5
cur.execute("select %s from golden_table where nGram = %s and hash_tag = %s", (weekNum, tup[0], tup[1]))

Note that the SQL table: golden_table includes the 4 columns: week2 week3 week4 week5. However, python or MySQL is not treating the value of weekNum as a column. Instead what is returned from the query is the value "weeki." where i is as above. In Java, I know the way around this is the StringBuilder class.

What is the equivalent way of solving this problem in python?
What is a better way to solve this in python?

All help is appreciated, and let me know if you need more information.

razpeitia · Accepted Answer · 2013-07-22 05:19:42Z

2

If your python version is recent (2.6+). You could use format.

weekNum = "week" + str(i)               #i is either 2, 3, 4, 5
query = "select {0} from golden_table where nGram = %s and hash_tag = %s".format(weekNum)
cur.execute(query, (tup[0], tup[1]))

answered Jul 22, 2013 at 5:19

razpeitia

2,0074 gold badges17 silver badges37 bronze badges

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

Comments

Daniel Roseman · Accepted Answer · 2013-07-22 03:19:22Z

0

Parameter replacement in execute is for values, not fieldnames. You'll need to use normal string interpolation for that. So:

sql = "select %s from golden_table where nGram = %%s and hash_tag = %%s" % weekNum
cur.execute(sql, tup)

Note the double percents in the first statement so that they pass through the string interpolation unscathed.

answered Jul 22, 2013 at 3:19

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Collectives™ on Stack Overflow

python StringBuilder for MySQL query execution

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related