def renderGroupId(sid, page=1): group, names, feeds, items_raw, series = get_group_id(sid, page) if group is None: flash(gettext('Group/Translator not found? This is probably a error!')) return redirect(url_for('renderGroupsTable')) try: feed_entries = feeds.paginate(page, app.config['SERIES_PER_PAGE']) except werkzeug.exceptions.NotFound: feed_entries = None try: items = items_raw.paginate(page, app.config['SERIES_PER_PAGE']) except werkzeug.exceptions.NotFound: items = None return render_template('group.html', series = series, releases_sequence_item = items, feed_sequence_item = feed_entries, group = group, wiki = wiki_views.render_wiki("Group", group.name) )
def renderGroupId(sid, page=1): group = Translators.query.filter(Translators.id==sid).scalar() if group is None: flash(gettext('Group/Translator not found? This is probably a error!')) return redirect(url_for('renderGroupsTable')) names = [tmp.name for tmp in group.alt_names] feeds = Feeds.query.options(joinedload('tags')) \ .filter(Feeds.srcname.in_(names)) \ .order_by(desc(Feeds.published)) items = Releases.query.filter(Releases.tlgroup==group.id).order_by(desc(Releases.published)).all() feed_entries = feeds.paginate(page, app.config['SERIES_PER_PAGE']) ids = [] for item in items: ids.append(item.series) series = Series.query.filter(Series.id.in_(ids)).order_by(Series.title).all() return render_template('group.html', series = series, releases = items, sequence_item = feed_entries, group = group, wiki = wiki_views.render_wiki("Group", group.name) )
def renderPublisherId(sid, page=1): pub, series = get_publisher_id(sid) if pub is None: flash(gettext('Tag not found? This is probably a error!')) return redirect(url_for('renderTagTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item = series_entries, page = page, name_key = "title", page_url_prefix = 'series-id', searchTarget = 'Publishers', searchValue = pub.name, wiki = wiki_views.render_wiki("Publisher", pub.name) )
def renderGenreId(sid, page=1): genre, series = get_genre_id(sid) if genre is None: flash(gettext('Genre not found? This is probably a error!')) return redirect(url_for('renderGenreTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item=series_entries, page=page, name_key="title", page_url_prefix='series-id', searchTarget='Genres', searchValue=genre.genre, wiki=wiki_views.render_wiki("Genre", genre.genre))
def renderPublisherId(sid, page=1): pub, series = get_publisher_id(sid) if pub is None: flash(gettext('Tag not found? This is probably a error!')) return redirect(url_for('renderTagTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item=series_entries, page=page, name_key="title", page_url_prefix='series-id', searchTarget='Publishers', searchValue=pub.name, wiki=wiki_views.render_wiki("Publisher", pub.name))
def renderGenreId(sid, page=1): genre, series = get_genre_id(sid) if genre is None: flash(gettext('Genre not found? This is probably a error!')) return redirect(url_for('renderGenreTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item = series_entries, page = page, name_key = "title", page_url_prefix = 'series-id', searchTarget = 'Genres', searchValue = genre.genre, wiki = wiki_views.render_wiki("Genre", genre.genre) )
def renderAuthorId(sid, page=1): author, series = get_author(sid) # print("Author search result: ", author) if author is None: flash(gettext('Author not found? This is probably a error!')) return redirect(url_for('renderAuthorTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item = series_entries, page = page, name_key = "title", page_url_prefix = 'series-id', searchTarget = 'Authors', searchValue = author.name, wiki = wiki_views.render_wiki("Author", author.name) )
def renderAuthorId(sid, page=1): author, series = get_author(sid) # print("Author search result: ", author) if author is None: flash(gettext('Author not found? This is probably a error!')) return redirect(url_for('renderAuthorTable')) series_entries = series.paginate(page, app.config['SERIES_PER_PAGE'], False) return render_template('search_results.html', sequence_item=series_entries, page=page, name_key="title", page_url_prefix='series-id', searchTarget='Authors', searchValue=author.name, wiki=wiki_views.render_wiki("Author", author.name))
def renderGroupId(sid, page=1): group = Translators.query.filter(Translators.id == sid).scalar() if group is None: flash(gettext('Group/Translator not found? This is probably a error!')) return redirect(url_for('renderGroupsTable')) names = [tmp.name for tmp in group.alt_names] feeds = Feeds.query.options(joinedload('tags')) \ .filter(Feeds.srcname.in_(names)) \ .order_by(desc(Feeds.published)) items_raw = Releases.query.filter(Releases.tlgroup == group.id).order_by( desc(Releases.published)) try: feed_entries = feeds.paginate(page, app.config['SERIES_PER_PAGE']) except werkzeug.exceptions.NotFound: feed_entries = None try: items = items_raw.paginate(page, app.config['SERIES_PER_PAGE']) except werkzeug.exceptions.NotFound: items = None subq = Releases.query.with_entities( Releases.series.distinct()).filter(Releases.tlgroup == group.id) print("Subquery: ", subq) seriesq = Series.query.filter(Series.id.in_(subq)).order_by(Series.title) print("Main q: ", seriesq) series = seriesq.all() return render_template('group.html', series=series, releases_sequence_item=items, feed_sequence_item=feed_entries, group=group, wiki=wiki_views.render_wiki("Group", group.name))