def update(table,args,id):
sql = "update %s set %s where id='%s'"%(table,','.join(args),id)
try:
logutil.writelog('db').info("sql: %s"%sql)
cur.execute(sql)
except:
logutil.writelog('db').error("Exec: %s,Error: %s"% (sql,traceback.format_exc()))
def add(table,args):
sql = 'insert into %s set %s'%(table,','.join(args))
try:
logutil.writelog('db').info("sql: %s"%sql)
cur.execute(sql)
except:
logutil.writelog('db').error("Exec: %s,Error: %s"% (sql,traceback.format_exc()))
def delete(table,id):
sql = "delete from %s where id='%s'"%(table,id)
try:
logutil.writelog('db').info("sql: %s"%sql)
cur.execute(sql)
except:
logutil.writelog('db').error("Exec: %s,Error: %s"% (sql,traceback.format_exc()))
def list(table, fields, id=None):
users = []
if not id:
sql = "select %s from %s" % (','.join(fields), table)
try:
logutil.writelog('db').info("sql: %s" % sql)
cur.execute(sql)
result = cur.fetchall()
for row in result:
user = {}
for i, k in enumerate(fields):
user[k] = row[i]
users.append(user)
logutil.writelog('sys').info("user: %s" % (user))
return users
except:
logutil.writelog('db').error("Exec: %s,Error: %s" %
(sql, traceback.format_exc()))
else:
sql = "select %s from %s where id='%s'" % (','.join(fields), table,
id)
try:
logutil.writelog('db').info("sql: %s" % sql)
cur.execute(sql)
result = cur.fetchone()
user = {}
for i, k in enumerate(fields):
user[k] = result[i]
return user
except:
logutil.writelog('db').error("Exec: %s,Error: %s" %
(sql, traceback.format_exc()))