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

cursor.execute("DELETE FROM table WHERE autoinc > 1000") 240L cursor.execute("SELECT * FROM table WHERE autoinc > 1000")

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]

On 27 Jul 2005 04:29:33 -0700, ne*****@xit.net <ne*****@xit.net> wrote:

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.

--
Cheers,
Simon B,
si***@brunningonline.net,
http://www.brunningonline.net/simon/blog/

[nephish]

Simon Brunning wrote:

On 27 Jul 2005 04:29:33 -0700, ne*****@xit.net <ne*****@xit.net> wrote:

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.

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

[Mage]

nephish wrote:

Simon Brunning wrote:

On 27 Jul 2005 04:29:33 -0700, ne*****@xit.net <ne*****@xit.net> wrote:

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.

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

cursor.execute("DELETE FROM table WHERE autoinc > 1000") 245L cursor.commit()

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]

# ne*****@xit.net / 2005-07-27 05:12:46 -0700:

ok. did this

cursor.execute("DELETE FROM table WHERE autoinc > 1000") 245L cursor.commit()

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.p...=1.1&view=auto

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991

[Rowdy]

ne*****@xit.net wrote:

ok. did this

cursor.execute("DELETE FROM table WHERE autoinc > 1000")
245L
cursor.commit()

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.
On 07/27/2005 07:43:24 AM, Rowdy wrote:

ne*****@xit.net wrote:

ok. did this

> cursor.execute("DELETE FROM table WHERE autoinc > 1000")

245L

> cursor.commit()

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

[Cantankerous Old Git]

nephish wrote:

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