[gozerbot] push by bthate - fix karma .. use the db version not the json one on 2011-10-10 20:43 GMT

[goze...@googlecode.com]

Revision: 85f9105fc61a
Author: Bart Thate <bth...@gmail.com>
Date: Mon Oct 10 13:42:19 2011
Log: fix karma .. use the db version not the json one
http://code.google.com/p/gozerbot/source/detail?r=85f9105fc61a

Modified:
/gplugs/olddb/karma.py

=======================================
--- /gplugs/olddb/karma.py Mon Aug 29 13:35:15 2011
+++ /gplugs/olddb/karma.py Mon Oct 10 13:42:19 2011
@@ -286,12 +286,9 @@
def get(self, item):
""" get karma of item """
item = item.lower()
- value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, \
-item)
- if value:
- return value[0][0]
- else:
- return 0
+ value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, item)
+ if value: return value[0][0]
+ else: return 0

def delete(self, item):
""" delete karma item """
@@ -302,130 +299,103 @@
def addwhy(self, item, updown, reason):
""" add why of karma up/down """
item = item.lower()
- result = db.execute(""" INSERT INTO whykarma(item, updown, why) \
-VALUES (%s, %s, %s) """, (item, updown, reason))
+ result = db.execute(""" INSERT INTO whykarma(item, updown, why)
VALUES (%s, %s, %s) """, (item, updown, reason))
return result

def upitem(self, item, reason=None):
""" up a karma item with/without reason """
item = item.lower()
- value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, \
-item)
- try:
- val = value[0][0]
+ value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, item)
+ try: val = value[0][0]
except (TypeError, IndexError):
- result = db.execute(""" INSERT INTO karma(item, value) VALUES \
-(%s, 1) """, item)
- if reason:
- self.addwhy(item, 'up', reason.strip())
+ result = db.execute(""" INSERT INTO karma(item, value) VALUES
(%s, 1) """, item)
+ if reason: self.addwhy(item, 'up', reason.strip())
return result
val += 1
- result = db.execute(""" UPDATE karma SET value = %s WHERE item
= %s \
-""", (val, item))
- if reason:
- self.addwhy(item, 'up', reason.strip())
+ result = db.execute(""" UPDATE karma SET value = %s WHERE item
= %s """, (val, item))
+ if reason: self.addwhy(item, 'up', reason.strip())
return result

def down(self, item, reason=None):
""" lower a karma item with/without reason """
item = item.lower()
- value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, \
-item)
- try:
- val = value[0][0]
+ value = db.execute(""" SELECT value FROM karma WHERE item
= %s """, item)
+ try: val = value[0][0]
except (TypeError, IndexError):
- result = db.execute(""" INSERT INTO karma(item, value) VALUES \
-(%s, -1) """, item)
- if reason:
- self.addwhy(item, 'down', reason.strip())
+ result = db.execute(""" INSERT INTO karma(item, value) VALUES
(%s, -1) """, item)
+ if reason: self.addwhy(item, 'down', reason.strip())
return result
val -= 1
- result = db.execute(""" UPDATE karma SET value = %s WHERE item
= %s \
-""", (val, item))
- if reason:
- self.addwhy(item, 'down', reason.strip())
+ result = db.execute(""" UPDATE karma SET value = %s WHERE item
= %s """, (val, item))
+ if reason: self.addwhy(item, 'down', reason.strip())
return result

def whykarmaup(self, item):
""" get why of karma ups """
item = item.lower()
- result = db.execute(""" SELECT why FROM whykarma WHERE \
-item = %s AND updown = 'up' """, item)
+ result = db.execute(""" SELECT why FROM whykarma WHERE item = %s
AND updown = 'up' """, item)
res = []
if result:
- for i in result:
- res.append(i[0])
+ for i in result: res.append(i[0])
return res

def whykarmadown(self, item):
""" get why of karma downs """
item = item.lower()
- result = db.execute(""" SELECT why FROM whykarma WHERE \
-item = %s AND updown = 'down' """, item)
+ result = db.execute(""" SELECT why FROM whykarma WHERE item = %s
AND updown = 'down' """, item)
res = []
if result:
- for i in result:
- res.append(i[0])
+ for i in result: res.append(i[0])
return res

def setwhoup(self, item, nick):
""" set who upped a karma item """
item = item.lower()
nick = nick.lower()
- result = db.execute(""" INSERT INTO whokarma(item, nick, updown) \
-VALUES(%s, %s, %s) """, (item, nick, 'up'))
+ result = db.execute(""" INSERT INTO whokarma(item, nick, updown)
VALUES(%s, %s, %s) """, (item, nick, 'up'))
return result

def setwhodown(self, item, nick):
""" set who lowered a karma item """
item = item.lower()
nick = nick.lower()
- result = db.execute(""" INSERT INTO whokarma(item, nick, updown) \
-VALUES(%s, %s, %s) """, (item, nick, 'down'))
+ result = db.execute(""" INSERT INTO whokarma(item, nick, updown)
VALUES(%s, %s, %s) """, (item, nick, 'down'))
return result

def getwhoup(self, item):
""" get list of who upped a karma item """
item = item.lower()
- result = db.execute(""" SELECT nick FROM whokarma WHERE item = %s \
-AND updown = 'up' """, item)
+ result = db.execute(""" SELECT nick FROM whokarma WHERE item = %s
AND updown = 'up' """, item)
res = []
if result:
- for i in result:
- res.append(i[0])
+ for i in result: res.append(i[0])
return res

def getwhodown(self, item):
""" get list of who downed a karma item """
item = item.lower()
- result = db.execute(""" SELECT nick FROM whokarma WHERE item = %s \
-AND updown = 'down' """, item)
+ result = db.execute(""" SELECT nick FROM whokarma WHERE item = %s
AND updown = 'down' """, item)
res = []
if result:
- for i in result:
- res.append(i[0])
+ for i in result: res.append(i[0])
return res

def search(self, item):
""" search for matching karma item """
item = item.lower()
- result = db.execute(""" SELECT item,value FROM karma WHERE item
LIKE \
-%s """, '%%%s%%' % item)
+ result = db.execute(""" SELECT item,value FROM karma WHERE item
LIKE %s """, '%%%s%%' % item)
res = []
if result:
- for i in result:
- res.append(i)
+ for i in result: res.append(i)
return res

def good(self, limit=10):
""" show top 10 of karma items """
statdict = Statdict()
result = db.execute(""" SELECT item, value FROM karma """)
- if not result:
- return []
+ if not result: return []
for i in result:
- if i[0].startswith('quote '):
- continue
+ if i[0].startswith('quote '): continue
statdict.upitem(i[0], value=i[1])
return statdict.top(limit=limit)

@@ -433,11 +403,9 @@
""" show lowest 10 of negative karma items """
statdict = Statdict()
result = db.execute(""" SELECT item, value FROM karma """)
- if not result:
- return []
+ if not result: return []
for i in result:
- if i[0].startswith('quote '):
- continue
+ if i[0].startswith('quote '): continue
statdict.upitem(i[0], value=i[1])
return statdict.down(limit=limit)

@@ -445,11 +413,9 @@
""" show top 10 of karma items """
statdict = Statdict()
result = db.execute(""" SELECT item, value FROM karma """)
- if not result:
- return []
+ if not result: return []
for i in result:
- if not i[0].startswith('quote '):
- continue
+ if not i[0].startswith('quote '): continue
statdict.upitem(i[0], value=i[1])
return statdict.top(limit=limit)

@@ -457,11 +423,9 @@
""" show lowest 10 of negative karma items """
statdict = Statdict()
result = db.execute(""" SELECT item, value FROM karma """)
- if not result:
- return []
+ if not result: return []
for i in result:
- if not i[0].startswith('quote '):
- continue
+ if not i[0].startswith('quote '): continue
statdict.upitem(i[0], value=i[1])
return statdict.down(limit=limit)

@@ -469,27 +433,23 @@
""" show what items are upped by nick """
nick = nick.lower()
statdict = Statdict()
- result = db.execute(""" SELECT item FROM whokarma WHERE nick = %s \
-AND updown = 'up' """, nick)
- if not result:
- return []
- for i in result:
- statdict.upitem(i[0])
+ result = db.execute(""" SELECT item FROM whokarma WHERE nick = %s
AND updown = 'up' """, nick)
+ if not result: return []
+ for i in result: statdict.upitem(i[0])
return statdict.top()

def whatdown(self, nick):
""" show what items are lowered by nick """
nick = nick.lower()
statdict = Statdict()
- result = db.execute(""" SELECT item FROM whokarma WHERE nick = %s \
-AND updown = 'down' """, nick)
+ result = db.execute(""" SELECT item FROM whokarma WHERE nick = %s
AND updown = 'down' """, nick)
if not result:
return []
for i in result:
statdict.upitem(i[0])
return statdict.top()

-if config['dbenable']:
+if not config['nodb']:
karma = KarmaDb()
else:
karma = Karma(datadir)