Python sqlite3 cursor has no attribute commit

Question

When I run this code:

path = '~/Scripts/wallpapers/single.png'
conn = sqlite3.connect('/Users/Heaven/Library/Application Support/Dock/desktoppicture.db')
cur = conn.cursor();
cur.execute("insert into data values ('" + path + "');")
cur.commit()

I receive the following error

AttributeError: 'sqlite3.Cursor' object has no attribute 'commit'

and I have absolutely no idea why.

That is entirely correct. Did you meant conn.commit() instead? :-) — Martijn Pieters
– Martijn Pieters, Commented Dec 31, 2013 at 16:25
Please use cur.execute("insert into data values(?)", path), or do really trust that filenames will never contain a ' character? (Users can be tricky…) — Donal Fellows
– Donal Fellows, Commented Jan 1, 2014 at 18:14
This will show you the possible commands for connection and cursor. Check that you did not misspell or mix them: print("Connection functions:",dir(sqlite3.connect('::memory::'))) print("\n\n") print("Cursor functions:",dir(sqlite3.connect('::memory::').cursor())) — Punnerud
– Punnerud, Commented Mar 19, 2019 at 7:40

Alan W. Smith · Accepted Answer · 2021-04-19 17:32:42Z

25

commit() is a member method of sqlite3.Connection not sqlite3.Cursor. Here it is in the docs.

edited Apr 19, 2021 at 17:32

Alan W. Smith

25.6k5 gold badges73 silver badges101 bronze badges

answered Dec 31, 2013 at 16:22

Charlie Andrews

1,47720 silver badges29 bronze badges

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

Comments

NumesSanguis · Accepted Answer · 2014-07-22 20:05:28Z

13

From the answer from sir_charles804 (sorry not enough points to add this as comment) follows it should be:

conn.commit()

instead of

cur.commit()

answered Jul 22, 2014 at 20:05

NumesSanguis

6,45210 gold badges47 silver badges82 bronze badges

Comments

score 11 · Accepted Answer · 2013-12-31 16:32:43Z

11

It's

conn.commit()
conn.close() //if you intend to close it afterwards

Explanation: The cursor is only used to pass instructions to sqlite, while you have to commit or close with the instance you've made to connect to your database.

edited Dec 31, 2013 at 16:32

answered Dec 31, 2013 at 16:23

user1508332

1 Comment

Donal Fellows Over a year ago

Technically, it's because transactions are a feature of the connection overall, and not a cursor. There are cases where it makes sense to have multiple cursors open at once within a single transaction.

Collectives™ on Stack Overflow

Python sqlite3 cursor has no attribute commit

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related