Can't execute mysql insert using pythons mysqldb

Question

This is my first question on stackoverflow! I'm currently programming a steamcommunity crawler, which crawls through the steam profiles and saves things like owned games, steamname, friends, ... But when I try to run the insert command it just does NOTHING.

 if not self.check_user('games', id):
  print "insert"
  self.cursor.execute("INSERT INTO games (userid) VALUES(%s);" % id)

The program displays "insert" but the execute command does neither throw an exception, nor inserts something to the database. In addition, an eventualy happening exception is not caught. When I forexample change the query towards "INSERT INTO games (useridd)", the program quits and I see the exception.

The application is multithreaded but acquired before executing, so I can't see any issue in that.

wind · Accepted Answer · 2011-08-09 13:44:58Z

6

add "COMMIT" at the end of command

for example:

cursor.execute("INSERT INTO games (userid) VALUES(%s);COMMIT;" % id)

set autocommit by add the second line

db = MySQLdb.connect(user='username', db=dbName,) # exmaple
db.autocommit(1) # enable auto commit

add commit() after transaction
```
db.commit()
```

edited Aug 9, 2011 at 13:44

answered Aug 9, 2011 at 13:01

wind

612 bronze badges

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

Comments

Ignacio Vazquez-Abrams · Accepted Answer · 2011-07-17 20:28:56Z

5

You forgot to commit the transaction.

answered Jul 17, 2011 at 20:28

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Collectives™ on Stack Overflow

Can't execute mysql insert using pythons mysqldb

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related