def index(request): subreddits = session.query(Subreddit)\ .filter(Subreddit.subscribers>100)\ .filter(Subreddit.fp_submissions==50)\ .filter(Subreddit.all_age_latest<31)\ .filter(Subreddit.over18==False)\ .order_by(sql_random()).limit(30).all() logos = session.query(Subreddit)\ .filter(Subreddit.logo==True)\ .filter(Subreddit.all_age_latest<90)\ .filter(Subreddit.over18==False)\ .filter(Subreddit.subscribers>100)\ .order_by(sql_random()).limit(30).all() return serve_response('index.html', subreddits=subreddits, logos=logos)
def index(request): subreddits = ( session.query(Subreddit) .filter(Subreddit.subscribers > 100) .filter(Subreddit.fp_submissions == 50) .filter(Subreddit.all_age_latest < 31) .filter(Subreddit.over18 == False) .order_by(sql_random()) .limit(30) .all() ) logos = ( session.query(Subreddit) .filter(Subreddit.logo == True) .filter(Subreddit.all_age_latest < 90) .filter(Subreddit.over18 == False) .filter(Subreddit.subscribers > 100) .order_by(sql_random()) .limit(30) .all() ) return serve_response("index.html", subreddits=subreddits, logos=logos)
def logos(request, view='random'): per_page = 30 query = session.query(Subreddit).filter(Subreddit.logo == True) if view == 'all': page = int(request.args.get('page', 1)) query = query.filter(Subreddit.over18 == False).order_by( Subreddit.subscribers.desc()) pagination = Pagination(query, per_page, page, 'logos') return serve_response('logos.html', pagination=pagination, view='all') elif view == 'over18': page = int(request.args.get('page', 1)) query = query.filter(Subreddit.over18 == True).order_by( Subreddit.subscribers.desc()) pagination = Pagination(query, per_page, page, 'logos') return serve_response('logos.html', pagination=pagination, view='over18') else: logos = query.filter(Subreddit.over18 == False).filter( Subreddit.subscribers > 100).order_by( sql_random()).limit(per_page).all() return serve_response('logos.html', logos=logos, view='random')
def logos(request, view="random"): per_page = 30 query = session.query(Subreddit).filter(Subreddit.logo == True) if view == "all": page = int(request.args.get("page", 1)) query = query.filter(Subreddit.over18 == False).order_by(Subreddit.subscribers.desc()) pagination = Pagination(query, per_page, page, "logos") return serve_response("logos.html", pagination=pagination, view="all") elif view == "over18": page = int(request.args.get("page", 1)) query = query.filter(Subreddit.over18 == True).order_by(Subreddit.subscribers.desc()) pagination = Pagination(query, per_page, page, "logos") return serve_response("logos.html", pagination=pagination, view="over18") else: logos = ( query.filter(Subreddit.over18 == False) .filter(Subreddit.subscribers > 100) .order_by(sql_random()) .limit(per_page) .all() ) return serve_response("logos.html", logos=logos, view="random")