question about deleting records from mysql

[nephish]

Hey there,
sorry , second question in as many days.
i am trying to do some stuff with MySQLdb and the thing is, i can
select records and such, but when i try to delete them, they dont
really go away.

like this
0L

so it looks like it worked, but when i use something else to look at
the
table (phpmyadmin, mysql-query-browser, knoda) the records are still
there!

what do i do?

 

[Simon Brunning]

Hey there,
sorry , second question in as many days.
i am trying to do some stuff with MySQLdb and the thing is, i can
select records and such, but when i try to delete them, they dont
really go away.

A fiver says you need to commit your changes.

 

[nephish]

A fiver says you need to commit your changes.

ok, do i do that with cursor.commit() ?
thanks

 

[Mage]

Simon Brunning wrote:



ok, do i do that with cursor.commit() ?
thanks

Yes, or maybe you should write a lightweight layer between the dbapi and
your program which can turn on and off the autocommit by calling
"commit" and "begin" as query. I did this in my pgsql layer. Using
transactions every time is almost as bad as never using them.

Mage

 

[nephish]

ok. did this

i got an AttributeError 'Cursor' object has no attribute 'commit'

hmm. what should i do now?
the stuff about writing a lightweight layer between the dbapi and the
program shot right over my head. sorry, but thanks

 

[Roman Neuhauser]

# (e-mail address removed) / 2005-07-27 05:12:46 -0700:

ok. did this


i got an AttributeError 'Cursor' object has no attribute 'commit'

hmm. what should i do now?

RTFM, e. g. here:

http://cvs.sourceforge.net/viewcvs.py/mysql-python/MySQLdb/doc/MySQLdb.txt?rev=1.1&view=auto

 

[Rowdy]

ok. did this




i got an AttributeError 'Cursor' object has no attribute 'commit'

hmm. what should i do now?
the stuff about writing a lightweight layer between the dbapi and the
program shot right over my head. sorry, but thanks

IIRC it is the connection that can commit(), not the cursor.

Rowdy

 

[nephish]

Man, thanks for the link. and the tip. i am testing
the db.commit() and printing the doc right now.
thanks again.

 

[Cantankerous Old Git]

Man, thanks for the link. and the tip. i am testing
the db.commit() and printing the doc right now.
thanks again.

If it's any help, using

cursor.execute("set autocommit = 1")

before doing anything else works nicely unless you actually need
transactions.

The Cog