def datenspur(web, id, mode, errors=[]): try: # FIXME wrap db queries into one episodes = Episode.find().filter(Episode.category.endswith(id)).\ order_by(Episode.date).all() episodes.reverse() comments_count = [ Comment.find().filter_by(episode = e.id).count() for e in episodes ] ratings = [ do_the_ratings(web, "", Rating.find().\ filter_by(episode = e.id).all())['rating'] for e in episodes ] episode = Episode.find().filter_by(link = id).one() for ep in episodes: ep.has_screen = True ep.files = File.find().filter_by(episode = ep.id).all() ep.preview = get_preview(Preview.find().\ filter_by(episode = episode.id).all(), ep.files) comments = Comment.find().filter_by(episode = episode.id).all() rating = Rating.find().filter_by(episode = episode.id).all() except Exception as e: return notfound(str(e)) if mode is None: mode = "" if len(mode): mode = mode[1:] opts = {} opts.update(create_session(web, mode)) opts.update(do_the_comments(web, mode, comments)) opts.update(do_the_ratings(web, mode, rating)) return template("datenspuren.tpl", errors = errors, css = "episode", episodepage = zip(episodes, comments_count, ratings), site = "datenspuren", full_site = "datenspuren/" + id, episode = episode, **opts )
def episode(web, site, id, mode, errors=[]): try: # FIXME wrap db queries into one episode = Episode.find().filter_by(link = id).one() files = File.find().filter_by(episode = episode.id).all() links = Link.find().filter_by(episode = episode.id).all() comments = Comment.find().filter_by(episode = episode.id).\ order_by(Comment.date).all() ratings = Rating.find().filter_by(episode = episode.id).all() trackbacks = Trackback.find().filter_by(episode = episode.id).\ order_by(Trackback.date).all() except Exception as e: return notfound(str(e)) if mode is None: mode = "" if len(mode): mode = mode[1:] opts = {} opts.update(create_session(web, mode)) opts.update(do_the_comments(web, mode, comments)) opts.update(do_the_ratings(web, mode, ratings)) return template("episode.tpl", errors = errors, css = "episode", episode = episode, episodes = {episode.id: episode}, site = site, trackbacks = trackbacks, files = files, links = links, csss = [ "../lib/audio-js/audio-js", "../lib/audio-js/skins/vim", "vim"], **opts )
def datenspuren(web, errors=[]): try: # FIXME wrap db queries into one episodes = Episode.find().filter(Episode.category.startswith("ds")).\ order_by(Episode.date).all() episodes.reverse() comments_count, ratings = [], [] for episode in episodes: ids = list(map(lambda e:e.id, Episode.find(Episode.id).\ filter_by(category = "file/{0}/{1}".\ format(episode.category, episode.link)).all())) f_rts = Rating.find().filter(Rating.episode.in_(ids)).all() e_rts = Rating.find().filter_by(episode = episode.id).all() ratings += [ do_the_ratings(web, "", e_rts + f_rts)['rating'] ] comments_count += [ Comment.find().filter(Comment.episode.in_(ids)).count() + Comment.find().filter_by( episode = episode.id).count() ] count = File.find().filter_by(episode = episode.id).count() episode.filescount = "// {0} File{1}".format(count, count != 1 and "s" or "") except Exception as e: return notfound(str(e)) return template("episodes.tpl", errors = errors, css = "episode", episodepage = zip(episodes, comments_count, ratings), site = "datenspuren" )
def rating_per_episode(web, episode, ratings, site, mode): opts = do_the_ratings(web, mode, ratings) opts.update( rating_form = False, site = site, episode = episode) if mode == "json": if web.input('html'): html = template("rating.inner_html.tpl", isjson = True, **opts) return template_json(web, { "html" : html.body, "new_link" : "/{0}/{1}/ratings/rate#new".format(site, episode.link) }) return template_json(web ,{ "rating": opts['rating'], "new_link": "/{0}/{1}/ratings/rate#new".format(episode.category, episode.link) }) else: return notfound("Type not supported.")
def main(web, site, errors=[]): try: # FIXME wrap db queries into one episodes = Episode.find().filter_by(category=site).\ order_by(Episode.date).all() episodes.reverse() comments_count = [ Comment.find().filter_by(episode = e.id).count() for e in episodes ] ratings = [ do_the_ratings(web, "", Rating.find().\ filter_by(episode = e.id).all())['rating'] for e in episodes ] except Exception as e: return notfound(str(e)) return template("episodes.tpl", errors = errors, css = "episode", episodepage = zip(episodes, comments_count, ratings), site = site )
def datenspur_file(web, id, filename, mode, errors=[]): try: # FIXME wrap db queries into one episode = Episode.find().filter_by(link = filename).\ filter(Episode.category.endswith(id)).\ order_by(Episode.date).one() comments = Comment.find().filter_by(episode = episode.id).all() files = File.find().filter_by(episode = episode.id).all() ratings = Rating.find().filter_by(episode = episode.id).all() previews = Preview.find().filter_by(episode = episode.id).all() trackbacks = Trackback.find().filter_by(episode = episode.id).\ order_by(Trackback.date).all() except Exception as e: return notfound(str(e)) episode.files = files if mode is None: mode = "" if len(mode): mode = mode[1:] opts = {} opts.update(create_session(web, mode)) opts.update(do_the_comments(web, mode, comments)) opts.update(do_the_ratings(web, mode, ratings)) preview = get_preview(previews, files) csss = [ "../lib/video-js/video-js", "../lib/video-js/skins/vim", "vim"] if episode.isaudio(): csss = list(map(lambda s:s.replace("video", "audio"), csss)) return template("datenspur.tpl", errors = errors, css = "episode", episode = episode, episodes = {episode.id: episode}, site = "datenspuren", full_site = "datenspuren/" + id, trackbacks = trackbacks, files = files, preview = preview, csss = csss, **opts )