Insert values from list into table (Python, sqlite3)

Question

I have this simple code which I can't make work.

import sqlite3

conn = sqlite3.connect('db\\books')
c = conn.cursor()

col = []

title = input('title')
text = input('text')
tags = input('tags')

col.append(title)
col.append(text)
col.append(tags)

c.executescript("INSERT INTO books (title,text,tags) "
                "VALUES (col[0],col[1],col[2])")

The db code (connection and normal insert) works but the problem rise when I want to do what you see above.

The goal I would like to achieve is to let the user insert the data into db (all strings). I don't know if this is the right way to do this...

How can I do this ?

Thanks

sjw · Accepted Answer · 2018-03-01 16:32:41Z

3

One option is to change your last line to:

c.execute("INSERT INTO books (title,text,tags) VALUES (?,?,?)", (col[0], col[1], col[2]))

And then commit and close the connection if you're done making changes:

conn.commit()
conn.close()

answered Mar 1, 2018 at 16:32

sjw

6,5512 gold badges30 silver badges41 bronze badges

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

4 Comments

lucians Over a year ago

TypeError: function takes exactly 1 argument (2 given)

sjw Over a year ago

c.execute() definitely takes two arguments, as per the docs. Adrian Tam's example looks good to me too. Are you sure you're calling the correct function?

lucians Over a year ago

In fact, the error comes out using c.executescript(). Using c.execute shows no error but it don't do anything...

lucians Over a year ago

Understood the error...I didn't copied conn.commit(). Thanks to all.

adrtam · Accepted Answer · 2018-03-01 16:31:52Z

3

This line:

c.executescript("INSERT INTO books (title,text,tags) "
                "VALUES (col[0],col[1],col[2])")

Is not a valid SQL. Now since c is defined as a cursor, you can run execute from it directly instead of executescript, which the latter is suppose to create a cursor from a connection and execute a SQL. Just replace that line with the following should work:

c.execute("INSERT INTO books (title,text,tags) "
          "VALUES (?,?,?)", col)

The SQL above uses a "qmark style" placeholder, which takes actual value from the parameter list that follows it.

answered Mar 1, 2018 at 16:31

adrtam

7,2712 gold badges15 silver badges28 bronze badges

1 Comment

lucians Over a year ago

TypeError: function takes exactly 1 argument (2 given)

Collectives™ on Stack Overflow

Insert values from list into table (Python, sqlite3)

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related