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
