python Programming Glossary: self.conn.cursor
PostgreSQL - how to run VACUUM from code outside transaction block? http://stackoverflow.com/questions/1017463/postgresql-how-to-run-vacuum-from-code-outside-transaction-block s password s dbname host port user password self.cursor self.conn.cursor def _doQuery self query self.cursor.execute query self.conn.commit..
Lost connection to MySQL server during query http://stackoverflow.com/questions/1884859/lost-connection-to-mysql-server-during-query MySQLdb.cursors.SSCursor def query self sql try cursor self.conn.cursor cursor.execute sql except AttributeError MySQLdb.OperationalError.. MySQLdb.OperationalError self.connect cursor self.conn.cursor cursor.execute sql return cursor # # db DB sql SELECT bla FROM..
How to delete a row from a listbox in TKinter and SQLite3 http://stackoverflow.com/questions/19738499/how-to-delete-a-row-from-a-listbox-in-tkinter-and-sqlite3 open database self.conn sqlite3.connect 'phonebook1.db' c self.conn.cursor # create table c.execute '''CREATE TABLE IF NOT EXISTS people.. 0 END self.fbField.delete 0 END # add to database c self.conn.cursor c.execute INSERT INTO people VALUES item1 item2 item3 item4.. ACTIVE name person 0 # delete in database c self.conn.cursor c.execute DELETE FROM people WHERE name name self.conn.commit..
How to enable MySQL client auto re-connect with MySQLdb? http://stackoverflow.com/questions/207981/how-to-enable-mysql-client-auto-re-connect-with-mysqldb self.conn MySQLdb.connect def query self sql try cursor self.conn.cursor cursor.execute sql except AttributeError MySQLdb.OperationalError.. MySQLdb.OperationalError self.connect cursor self.conn.cursor cursor.execute sql return cursor db DB sql SELECT FROM foo cur..
Creating a logging handler to connect to Oracle? http://stackoverflow.com/questions/935930/creating-a-logging-handler-to-connect-to-oracle d msecs d ' exc_text s' ' thread s' self.cursor self.conn.cursor def formatDBTime self record record.dbtime time.strftime # m..
|