def exec_updsql(self, strsql):
try:
cur = self._conn.cursor()
#strsql = "%s\ncommit;" % (strsql)
strsql = "%s\n;" % (strsql)
cur.execute(strsql)
cur.close()
except:
cf.log(strsql)
cur.close()
def exec_selsql(self, strsql):
try:
cur = self._conn.cursor()
cur.execute(strsql)
result = self.cur2arr(cur)
cur.close()
return result
except:
cf.log(strsql)
cur.close()
def exec_updsql(self, strsql):
try:
cursor = self.conn.cursor()
cursor.execute(strsql)
cursor.close()
self.conn.commit()
except MySQLdb.Error, e:
f.log(strsql)
cursor.close()
raise Exception("SQL ERROR %d: %s" % (e.args[0], e.args[1]))
def exec_selsql(self, strsql):
try:
cursor = self.conn.cursor()
cursor.execute(strsql)
result = self.cur2arr(cursor)
cursor.close()
return result
except MySQLdb.Error, e:
f.log(strsql)
cursor.close()
raise Exception("SQL ERROR %d: %s" % (e.args[0], e.args[1]))
def exec_selsqlh(self, strsql):
try:
cursor = self.conn.cursor()
cursor.execute(strsql)
body = map(list, list(cursor.fetchall()))
desc = [d[0] for d in cursor.description]
data = []
header = {}
i = 0
for h in desc:
header[h.lower()] = i
i = i + 1
data.append(header)
data.append(body)
cursor.close()
return data
except MySQLdb.Error, e:
f.log(strsql)
cursor.close()
raise Exception("SQL ERROR %d: %s" % (e.args[0], e.args[1]))
