How to insert multidimensional list into sqlite db

Question

I need to insert list like this

 list = [['1'], ['2'], ['3'], ['4']]

so I unpack it and try to insert it into db

 a,b,c,d = list

 db.execute("INSERT INTO show (titolo,stagioni,clima,temperature) VALUES (?,?,?,?)",(a,b,c,d))
 db.commit()

but It returns this error

exception=InterfaceError('Error binding parameter 0 - probably unsupported type.')>

I tried even [list]

any help , thank

Ch3steR · Accepted Answer · 2021-02-26 06:52:24Z

2

You have to match the exact signature of list here.

a, b, c, d = lst
# a -> ['1']
# b -> ['2']
# c -> ['3']
# d -> ['4']

([a], [b], [c], [d]) = lst
# a -> '1'
# b -> '2'
# c -> '3'
# d -> '4'

One more option is to use itertools.chain

from itertools import chain
a, b, c, d = chain.from_iterable(lst)
# a -> '1'
# b -> '2'
# c -> '3'
# d -> '4'

answered Feb 26, 2021 at 6:52

Ch3steR

20.8k4 gold badges34 silver badges66 bronze badges

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

1 Answer 1