Use Python List in the SQL as parameter

Asked Apr 16 '20 at 22:31

Active Apr 20 '20 at 11:38

Viewed 158 times

I am referring to question

what if I have to pass some extra parameter along with list in the query. Suppose I want to pass the location as well

`placeholder= '?' # For SQLite. See DBAPI paramstyle.
 placeholders= ', '.join(placeholder for unused in l)
 query= 'SELECT name FROM students WHERE id IN (%s) and location= %(location)s' % placeholders
 cursor.execute(query, {'location' : 'canada', 'desired_list' : list_of_ids })

how to convert list into tuple for using in sql query? Thanks

asked Apr 16 '20 at 22:31

Rahul Reddy

`tuple(list_of_ids)` – Błotosmętek Apr 16 '20 at 22:35
When the list size is 1, tuple ends up like `(1,)` , which fails while executing the query – Rahul Reddy Apr 16 '20 at 22:36
For a completely different reason though. – Błotosmętek Apr 16 '20 at 22:40
How about `','.join(list_of_ids)`, in case of a single list or tuple element, it'll print `(1)` instead of `(1,)`. `join` however, works with string elements only, so if your `id's` are integer, you could use - `','.join(map(str, list_of_ids))` instead. – tidakdiinginkan Apr 16 '20 at 22:41

Use Python List in the SQL as parameter

0 Answers0