def mysql_changeDb(dbName): global prefix, conn, cursor try: conn.select_db(prefix + '_' + dbName) except: errorMsg('Could not switch to database ' + dbName) return False cursor = conn.cursor() return True
def mysql_changeDb(dbName): global prefix, conn, cursor try: conn.select_db(prefix + '_' + dbName) except: errorMsg('Could not switch to database '+dbName) return False cursor = conn.cursor() return True
def runQuery(sqlQuery, failureMessage='Query failed.'): if cavatDebug.debug: print sqlQuery try: cursor.execute(sqlQuery) except Exception, e: errorMsg(failureMessage) errorMsg("SQL was: \t" + str(sqlQuery)) errorMsg("SQL error: \t" + str(e)) return False
def runQuery(sqlQuery, failureMessage = 'Query failed.'): if cavatDebug.debug: print sqlQuery try: cursor.execute(sqlQuery) except Exception, e: errorMsg(failureMessage) errorMsg("SQL was: \t" + str(sqlQuery)) errorMsg("SQL error: \t"+ str(e)) return False