How to insert a dynamic list into sqlite3 query? sqlite3.ProgrammingError: Incorrect number of bindings supplied

Question

I trying to use sqlite3 query like this one:

books = c.execute("SELECT * FROM books WHERE id IN (?)", session["cart"])

Where session["cart"] is a dynamic list. For example: session["cart"] = ['1', '7']

I get an error as given in title while trying to execute it.

How may I insert whole list in the question mark placeholder? I can't use multiple question marks, because their number may vary.

Does anyone has any clue? Or maybe better idea how to achieve so?

Nullman · Accepted Answer · 2020-12-10 09:24:38Z

1

You will have to format your python list into something sql can read, this is easily done with str.join

stringified_list = ", ".join(session["cart"])
books = c.execute("SELECT * FROM books WHERE id IN (?)", stringified_list )

in case you are unfamiliar, str.join(iterable) will make a string with all the string representations of the items in the iterable separated by the str you called join on, i.e. '---'.join([1,2,3]) will produce "1---2---3" (a string)

answered Dec 10, 2020 at 9:24

Nullman

4,2842 gold badges18 silver badges32 bronze badges

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

1 Comment

humanbeing Over a year ago

Thanks, works perfectly. I know this method, but I was completely fixed with idea that I may do so without additional variable.

Collectives™ on Stack Overflow

How to insert a dynamic list into sqlite3 query? sqlite3.ProgrammingError: Incorrect number of bindings supplied

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related