How to insert values from input list into table in database?

Question

Write a function named "add_list" that takes a list as a parameter where each value is itself a list containing 3 strings. This function doesn't return a value. There is a database saved in a file named "rarely.db" containing a table named "big" with columns "ought", "spray", and "courtroom". Insert each value from the input list into this table using the 3 strings in each list as the values for the three columns.

import sqlite3
    def add_list(lista):
        conn=sqlite3.connect('rarely.db')
        c=conn.cursor()
        ought1 = c.execute('SELECT ought FROM big').fetchall() 
        spray1 = c.execute('SELECT spray FROM big').fetchall() 
        courtroom1 = c.execute('SELECT courtroom FROM big').fetchall()
        insert = c.execute('INSERT INTO big VALUES(?)', (lista))
        conn.commit()
        conn.close()

Here is my attempt at it. What am I doing wrong?

Ajax1234 · Accepted Answer · 2018-11-24 03:29:24Z

1

You can use executemany:

import sqlite3
def add_list(lista):
   conn=sqlite3.connect('rarely.db')
   c=conn.cursor()
   insert = c.executemany('INSERT INTO big VALUES (?, ?, ?)', lista)
   conn.commit()
   conn.close()

answered Nov 24, 2018 at 3:29

Ajax1234

71.7k9 gold badges67 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

How to insert values from input list into table in database?

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