Change Series of Numbers to List, python -

i have been given series of numbers take , put python list or tuple comma separated numbers. i've been digging around on stacked, maybe can't find correct way phrase question because keep finding ways conver tuples lists , vice versa.

this have. received email list series of numbers (but several hundred more):

417985 417986 417987 417988 417989 417990 

i use numbers query database, so:

number in (417985,417986,417987,417988,417989,417990) 

is there way in python convert series of numbers canget comma separated values in query? fyi, lot of python, that's comforable, other method interested hear.

if going use these numbers in sql query, need generate sql parameters rather build query string.

you'd read lines , turn sequence (a list do) of integers:

numbers = [int(line) line in email_lines] 

you generate query enough placeholders each of values:

statement = "select * table number in ({0})".format(     ', '.join(['?' * len(numbers)])) 

where assume database connector using uses ? sql parameter placeholder; %s.

now can ask database matching rows:

cursor.execute(statement, numbers) 

by using sql parameters few things free:

• proper quoting , escaping of values. less important here because converting integers, practice not escape , quote values yourself; miss something.
• reuse of cached query plans; database has parse statement query once , can reuse result subsequent queries.

if wanted copy , paste numbers, type this:

email_lines = """\ <paste lines numbers> """.splitlines() 

then apply first line answer result.