def fullList(conditions): torrents= db.conn.cursor() torrents.execute(""" SELECT t_id, torrents.name, torrents.description, license, categories.name FROM torrents INNER JOIN categories USING (c_id) """ + conditions) rows = '' for torrent in torrents: rows += fullListRowTemplate % { 'name_in_url': render.getUrlPrettyName(torrent[1]), 'id': torrent[0], 'name': torrent[1], 'description': render.torrentDescription(torrent[2]), 'license': torrent[3], 'category': torrent[4]} return fullListBodyTemplate % rows
def details(t_id): torrent = db.conn.cursor() torrent.execute(""" SELECT t_id, torrents.name, torrents.description, license, categories.name INNER JOIN categories USING (c_id) WHERE t_id=%s""", (t_id,)) if torrent.rowcount == 0: raise exceptions.Error404() assert torrent.rowcount == 1 torrent = torrent.fetchone() return detailsTemplate % { 'name_in_url': render.getUrlPrettyName(torrent[1]), 'id': torrent[0], 'name': torrent[1], 'description': render.torrentDescription(torrent[2]), 'license': torrent[3], 'category': torrent[4]}