def popular():
"""Returns the most popular recent tags"""
log.info('*******popular method called in Tag class******')
ntags = int(config.get('ntags', 20))
hours = int(config.get('popular_tags_window', 72))
s = text('''
select lower, count(*) tagcount from tag
where created > now() - interval :hours hour
group by lower order by tagcount desc, lower
limit :limit
''')
tags = Session.execute(s, dict(limit=ntags,hours=hours)).fetchall()
return tags
def index(self, format='html', page=0, tag=None):
cols = entry_table.c
query = select([
cols.id,
cols.title,
cols.url,
cols.tags,
cols.pubtime,
cols.host,
cols.feed_title
])
order_by = cols.pubtime.desc()
query = query.limit(c.pagesize).offset(c.slicestart)
query = query.order_by(order_by)
c.links = Session.execute(query).fetchall()
c.view = 'latest'
return render('/links_960.mako')
def tag(self, keyword, format='html', page=0):
j = tag_table.join(entry_table, tag_table.c.entry_id==entry_table.c.id)
cols = entry_table.c
query = select([
cols.id,
cols.title,
cols.url,
cols.tags,
cols.pubtime,
cols.host,
cols.feed_title
], from_obj=j)
query = query.where(tag_table.c.lower==keyword.lower())
query = query.limit(c.pagesize)
query = query.offset(c.slicestart)
query = query.order_by(cols.pubtime.desc())
c.links = Session.execute(query).fetchall()
c.view = 'tag/%s' % keyword
return render('/links_960.mako')
