SQLite

[Matthias Huening]

Hi,

This is probably trivial, but I cannot find a solution right now.
With MySQLdb, I could test the success of a deleting action like this:

sql = "DELETE FROM table WHERE name='xxx'"
res = cur.execute(sql)
if res == 1:
print 'Okay'
else:
print 'nothing deleted'


This seems not to work with sqlite3. How can I test whether deletion was
sussessful or not?

Thanks,
Matthias

 

[gordyt]

Howdy Matthias!

The delete operation will set the rowcount member of your cursor.
Let's assume you have an sqlite3 database with a table called 'test'
with an id column. It does have a record with id=1. It does not have
a record with id=2.


--gordy

 

[Petite Abeille]

This seems not to work with sqlite3.

Before going any further... make sure that SQLite's count_change is
enabled:

PRAGMA count_changes
PRAGMA count_changes = 0 | 1

"Query or change the count-changes flag. Normally, when the count-
changes flag is not set, INSERT, UPDATE and DELETE statements return
no data. When count-changes is set, each of these commands returns a
single row of data consisting of one integer value - the number of
rows inserted, modified or deleted by the command. "

http://www.sqlite.org/pragma.html

Cheers,

 

[Matthias Huening]

Thanks!
cursor.rowcount does exactly what I need.

Before going any further... make sure that SQLite's count_change is
enabled:

PRAGMA count_changes
PRAGMA count_changes = 0 | 1

"Query or change the count-changes flag. Normally, when the
count-changes flag is not set, INSERT, UPDATE and DELETE statements
return no data. When count-changes is set, each of these commands
returns a single row of data consisting of one integer value - the
number of rows inserted, modified or deleted by the command. "

Looks like this is not really necessary. My database hat count_changes
disabled, but rowcount seems to work anyway. Are there any pitfalls?

Matthias