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')
def download(self): return render('/download.mako')