Mysql SELECT IN clause with Python tuple

Question

Python newbie here...I want to create a new tuple from a for loop. The tuple will be used inside a MySQL select query in the IN clause. It's not working correct, telling me I have the following issue on the cur.execute line.

TypeError: not all arguments converted during string formatting

check_tz = []
for tz in pytz.common_timezones:
    if now_utc.astimezone(timezone(tz)).strftime('%H') == '01':
        check_tz.append(tz)

print check_tz

# Prints out something as follows. I cut the output short for the sake of this example.
# ['America/Anguilla', 'America/Antigua', 'US/Eastern']

cur.execute("SELECT * FROM users where timezone IN (%s)", check_tz)

for row in cur.fetchall():
    print row[0]

score 1 · Answer 1 · answered Jul 12 '13 at 05:39

1

You probably need to convert the list of timezones to string:

cur.execute("SELECT * FROM users where timezone IN (%s)", ','.join(map(lambda x: "'%s'" % x, check_tz))

answered Jul 12 '13 at 05:39

plaes

31,788
11
91
89

Doesn't work, the solution in the link to the possible duplicate works perfectly. – sdot257 Jul 12 '13 at 05:43
@luckytaxi Indeed, it was missing quoting of elements. – plaes Jul 12 '13 at 05:44

Mysql SELECT IN clause with Python tuple

1 Answers1