def log(self, printto, txt): """ do the actual logging """ try: res = db.execute("""INSERT into tcplog(time,printto,txt) values(%s,%s,%s) """, (time.time(), printto, txt)) except Exception, ex: rlog(10, 'tcp', 'failed to log to db: %s' % str(ex))
def handle_quotesdb(event): """ show all database quotes """ result = [] dbresult = db.execute(""" SELECT indx, quote FROM quotes """) if not dbresult: return ['no quotes', ] for i in dbresult: result.append("[%s] %s" % (i[0], i[1])) return result
def handle_karmadb(event): """ show all database karma items """ result = [] dbresult = db.execute(""" SELECT item, value FROM karma ORDER BY \ value DESC""") if not dbresult: return ['no karma items', ] for i in dbresult: result.append("%s = %s" % (i[0], i[1])) return result
def handle_karmadb(event): """ show all database karma items """ result = [] dbresult = db.execute(""" SELECT item, value FROM karma ORDER BY \ value DESC""") if not dbresult: return [ 'no karma items', ] for i in dbresult: result.append("%s = %s" % (i[0], i[1])) return result
def handle_infoitemsdb(event): """ show database pickle items """ dbresult = db.execute(""" SELECT item, description FROM infoitems """) if not dbresult: return ['no infoitems', ] resultdict = {} result = [] for i in dbresult: if not resultdict.has_key(i[0]): resultdict[i[0]] = [i[1], ] else: resultdict[i[0]].append(i[1]) for i, j in resultdict.iteritems(): result.append("%s ==> %s" % (i, ' .. '.join(j))) return result
def handle_infoitemsdb(event): """ show database pickle items """ dbresult = db.execute(""" SELECT item, description FROM infoitems """) if not dbresult: return [ 'no infoitems', ] resultdict = {} result = [] for i in dbresult: if not resultdict.has_key(i[0]): resultdict[i[0]] = [ i[1], ] else: resultdict[i[0]].append(i[1]) for i, j in resultdict.iteritems(): result.append("%s ==> %s" % (i, ' .. '.join(j))) return result