def execute(query, *args): logger.writeln('execute', query, '%', args) connection = connections.get_con() cursor = DictCursor(connection) cursor.execute(query, args) results = tuple(_results_gen(cursor)) cursor.close() connections.release_con(connection) if len(results) == 1: return results[0] else: return results
def callproc(name, *args): logger.writeln('callproc', name, '%', args) connection = connections.get_con() cursor = DictCursor(connection) cursor.callproc(name, args) results = tuple(_results_gen(cursor)) cursor.close() connections.release_con(connection) if len(results) == 1: return results[0] else: return results
def close(self): DictCursor.close(self)
import twik.db as db import config_db_con from MySQLdb.cursors import DictCursor con = db.connections.get_con() cur = DictCursor(con) cur.callproc('user_data_byemail', ('*****@*****.**',)) r = cur.fetchall() print r cur.close() db.connections.release_con(con)