Mysql SELECT IN clause with Python tuple [duplicate]

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]

Yep. works perfectly!

sdot257
– sdot257

2013-07-12 05:43:30 +00:00
Commented Jul 12, 2013 at 5:43 — sdot257
– sdot257, Commented Jul 12, 2013 at 5:43

plaes · Accepted Answer · 2013-07-12 05:39:35Z

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, 2013 at 5:39

plaes

32.9k11 gold badges95 silver badges89 bronze badges

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

2 Comments

sdot257 Over a year ago

Doesn't work, the solution in the link to the possible duplicate works perfectly.

plaes Over a year ago

@luckytaxi Indeed, it was missing quoting of elements.

Collectives™ on Stack Overflow

Mysql SELECT IN clause with Python tuple [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related