How to insert a tuple/list into a database using SQLITE3?

Question

I have several pieces of data collected from a form I want to enter into my database. However, one of those data pieces is a list created from how many checkboxes a user has pressed. When I try and insert this into a list I get the error "sqlite3.InterfaceError: Error binding parameter 4 - probably unsupported type.". My code stops working at "cur.execute(sql, listing).

I've tried changing the type of data piece it is, but I need the tuple to stay as it is. I have tried to use cur.executemany but it didn't work.

title = request.form['item_name']

platform = request.form.getlist('platform_list[]')

con = create_connection(DATABASE_NAME)

listing = (title, platform)

sql = """INSERT INTO items(id, title, platform) VALUES (NULL,?,?);"""

cur = con.cursor()

cur.execute(sql, listing)

con.commit()

con.close()

DinoCoderSaurus · Accepted Answer · 2019-05-07 13:44:11Z

1

Sqlite does not have a "list" datatype. Here are two options that may solve the problem:

Transform the list to a string as with str = ",".join(platform)
Transform the list to a JSON string as with json.dumps(platform)

It would depend on how the data will be used when it is SELECTed back.

If you want one row in the database per platform, you would use executemany. You would have to construct listing differently so that each array element contains all the insert parameters. Something like listing = [(title,x) for x in platform] for instance.

answered May 7, 2019 at 13:44

DinoCoderSaurus

6,5502 gold badges13 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to insert a tuple/list into a database using SQLITE3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related