¡@

Home 

python Programming Glossary: self.cursor.execute

Trouble using South with Django and Heroku

http://stackoverflow.com/questions/10135656/trouble-using-south-with-django-and-heroku

django db backends util.py line 34 in execute return self.cursor.execute sql params File app lib python2.7 site packages django db backends.. postgresql_psycopg2 base.py line 44 in execute return self.cursor.execute query args django.db.utils.DatabaseError relation notecards_semester..

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

self.cursor self.conn.cursor def _doQuery self query self.cursor.execute query self.conn.commit def vacuum self query VACUUM FULL self._doQuery..

Python MySQLdb update query fails

http://stackoverflow.com/questions/1028671/python-mysqldb-update-query-fails

the part of the SQL class def execute self query try self.cursor.execute query return True except MySQLdb.ProgrammingError as error print..

Why is the same SQLite query being 30 times slower when fetching only twice as many results?

http://stackoverflow.com/questions/10531898/why-is-the-same-sqlite-query-being-30-times-slower-when-fetching-only-twice-as-m

is 1 2 and 3 from the 3 samples used. self.cursor.execute 'begin' self.cursor.execute EXPLAIN QUERY PLAN SELECT precursor_id.. and 3 from the 3 samples used. self.cursor.execute 'begin' self.cursor.execute EXPLAIN QUERY PLAN SELECT precursor_id feature_table_id FROM.. ' print self.cursor.fetchall import time time0 time.time self.cursor.execute SELECT precursor_id feature_table_id FROM `MSMS_precursor`..

Warning raised by inserting 4-byte unicode to mysql

http://stackoverflow.com/questions/10798605/warning-raised-by-inserting-4-byte-unicode-to-mysql

x9F x91 x8A xF0 x9F...' for column 't_content' at row 1 n self.cursor.execute self.sql item 'topic' item 'url' item 'content' The string '..

Django auto_now and auto_now_add

http://stackoverflow.com/questions/1737017/django-auto-now-and-auto-now-add

cannot be null Sun Nov 15 02 18 12 2009 error return self.cursor.execute query args the relevant part of my db is `created` datetime..

Gracefully handling “MySQL has gone away”

http://stackoverflow.com/questions/1987701/gracefully-handling-mysql-has-gone-away

select self query params try self.cursor self.cxn.cursor self.cursor.execute query params except MySQLdb.OperationalError e if e 0 2006 .. self.cxn self.db._get_cxn self.cursor self.cxn.cursor self.cursor.execute query params print self.cxn return self.cursor.fetchall Next.. File home swoods dev adp database.py line 96 in select self.cursor.execute query params File usr lib pymodules python2.6 MySQLdb cursors.py..

SQLite parameter substitution problem

http://stackoverflow.com/questions/228912/sqlite-parameter-substitution-problem

For example when I use for item in self.inventory_names self.cursor.execute SELECT weight FROM Equipment WHERE name item self.cursor.close.. works just fine. Like so for item in self.inventory_names self.cursor.execute SELECT weight FROM Equipment WHERE name ' s' item self.cursor.close.. to be 8 characters long. Use the following form instead self.cursor.execute SELECT weight FROM Equipment WHERE name item Python library..

Merge SQLite files into one db file, and 'begin/commit' question

http://stackoverflow.com/questions/3689694/merge-sqlite-files-into-one-db-file-and-begin-commit-question

. # run command def runCommand self command self.cursor.execute command self.connector.commit # same error even though I delete.. as follows def runCommand self sql params commit True self.cursor.execute sql params if commit self.connector.commit now you can not commit..

Creating a logging handler to connect to Oracle?

http://stackoverflow.com/questions/935930/creating-a-logging-handler-to-connect-to-oracle

else record.exc_text sql self.SQL record.__dict__ self.cursor.execute sql self.conn.commit except import traceback ei sys.exc_info..