def handle_item(self, user, item, raw_item):
key = 'history:%s' % user.username
if key not in cache:
result = yield dbpool.runQuery("SELECT item, watch_date FROM history WHERE user = ?", (user.username, ))
cache[key] = dict((r['item'], r['watch_date']) for r in result)
history = cache[key]
item['watched'] = item['name'] in history
defer.returnValue(item)
def listing_result_item(self, section, user, path, item):
key = 'history:%s' % user.username
if item['rel'] == 'file':
if key not in cache:
result = yield dbpool.runQuery("SELECT item, watch_date FROM history WHERE user = ?", (user.username, ))
cache[key] = dict((r['item'], r['watch_date']) for r in result)
history = cache[key]
item['watched'] = item['name'] in history
defer.returnValue(item)
