python Programming Glossary: cursor.execute

How can I profile a SQLAlchemy powered application?

http://stackoverflow.com/questions/1171166/how-can-i-profile-a-sqlalchemy-powered-application

If for example you see all the time being spent within cursor.execute that's the low level DBAPI call to the database and it means.. problems were due to network latency the time spent within cursor.execute as well as all Python methods was very fast whereas the majority..

Parameterized queries with psycopg2 / Python DB-API and PostgreSQL

http://stackoverflow.com/questions/1466741/parameterized-queries-with-psycopg2-python-db-api-and-postgresql

for you. For example the following should be safe and work cursor.execute SELECT FROM student WHERE last_name lname s lname Robert' DROP..

Lost connection to MySQL server during query

http://stackoverflow.com/questions/1884859/lost-connection-to-mysql-server-during-query

def query self sql try cursor self.conn.cursor cursor.execute sql except AttributeError MySQLdb.OperationalError self.connect.. self.connect cursor self.conn.cursor cursor.execute sql return cursor # # db DB sql SELECT bla FROM foo data db.query..

Escape SQL “LIKE” value for Postgres with psycopg2

http://stackoverflow.com/questions/2106207/escape-sql-like-value-for-postgres-with-psycopg2

FROM things WHERE description LIKE like s ESCAPE ' ' cursor.execute sql dict like ' ' term ' ' This works on PostgreSQL MySQL and..

In Python, after I INSERT Into mysqldb, how do I get the “id”?

http://stackoverflow.com/questions/2548493/in-python-after-i-insert-into-mysqldb-how-do-i-get-the-id

mysqldb how do I get the &ldquo id&rdquo The primary key. cursor.execute INSERT INTO mytable height VALUES s height My table has 2 columns..

Generating a WSDL using Python and SOAPpy

http://stackoverflow.com/questions/273002/generating-a-wsdl-using-python-and-soappy

SOAPpy import MySQLdb def getNEXTVAL cursor db.cursor cursor.execute CALL my_stored_procedure # Returns a number result cursor.fetchall..

python list in sql query as parameter

http://stackoverflow.com/questions/283645/python-list-in-sql-query-as-parameter

How to get a row-by-row MySQL ResultSet in python

http://stackoverflow.com/questions/337479/how-to-get-a-row-by-row-mysql-resultset-in-python

a time like this start_row 0 while True cursor conn.cursor cursor.execute SELECT item FROM items LIMIT d 1000 start_row rows cursor.fetchall..

is there a pythonic way to try something up to a maximum number of times?

http://stackoverflow.com/questions/567622/is-there-a-pythonic-way-to-try-something-up-to-a-maximum-number-of-times

host user password database cursor conn.cursor try cursor.execute query rows cursor.fetchall for row in rows # do something with.. cursor conn.cursor attempts 0 while attempts 3 try cursor.execute query rows cursor.fetchall for row in rows # do something with..

imploding a list for use in a python MySQLDB IN clause

http://stackoverflow.com/questions/589284/imploding-a-list-for-use-in-a-python-mysqldb-in-clause

can use the following to get that string into an IN clause cursor.execute DELETE FROM foo.bar WHERE baz IN ' s' foostring What I need.. directly format_strings ' '.join ' s' len list_of_ids cursor.execute DELETE FROM foo.bar WHERE baz IN s format_strings tuple list_of_ids..

Python mysql with variables

http://stackoverflow.com/questions/775296/python-mysql-with-variables

my database. I need to insert 6 variables into the table. cursor.execute INSERT INTO Songs SongName SongArtist SongAlbum SongGenre SongLength.. 'name' 'awesome song' 'artist' 'some band' etc... cursor.execute INSERT INTO Songs SongName SongArtist SongAlbum SongGenre SongLength..

Python: Maximum recursion depth exceeded

http://stackoverflow.com/questions/8177073/python-maximum-recursion-depth-exceeded

cursor db.cursor cursors.DictCursor catResults try cursor.execute query variables for categoryRow in cursor.fetchall catResults.append.. startCategory #print categoryQuery 'title' startCategory cursor.execute categoryQuery 'title' startCategory done False while not done..

How to use variables in SQL statement in Python?

http://stackoverflow.com/questions/902408/how-to-use-variables-in-sql-statement-in-python

experienced in Python. I have the following Python code cursor.execute INSERT INTO table VALUES var1 var2 var3 where var1 is an integer.. the query text python sql share improve this question cursor.execute INSERT INTO table VALUES s s s var1 var2 var3 The database API..