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
