def get_related(table, attr, title): if attr == "bra": data_attr = category else: data_attr = attr if data_attr == "hs" or data_attr == "wld": dataset = "secex" elif data_attr == "cnae" or data_attr == "cbo": dataset = "rais" elif data_attr == "university" or data_attr == "course_hedu": dataset = "hedu" elif data_attr == "course_sc": dataset = "sc" else: return q = table.query.filter(getattr(table, "{}_id".format(category)) == id) \ .filter(getattr(table, "year") == parse_year(__year_range__[dataset][1])) if category in ("bra"): q = q.filter(not_(getattr(table, "{}_id_target".format(category)).startswith("0xx"))) elif category in ("cnae", "cbo", "wld"): q = q.filter(not_(getattr(table, "{}_id_target".format(category)).startswith("xx"))) elif category in ("hs"): q = q.filter(not_(getattr(table, "{}_id_target".format(category)).startswith("22"))) elif category in ("course_hedu", "course_sc"): q = q.filter(not_(getattr(table, "{}_id_target".format(category)).startswith("00"))) q = q.order_by(getattr(table, "prox_{}".format(attr)).desc()).limit(40).all() if len(q) > 0: m = globals()[category.capitalize()] q = [(m.query.get(getattr(a, "{}_id_target".format(category))), getattr(a, "prox_{}".format(attr))) for a in q] related.append({"title": title, "pages": q})
def index(): profile_types = [] # Bra most_recent_year = parse_year(__year_range__["secex"][-1]) top = Ymb.query.filter_by(year=most_recent_year, month=0, bra_id_len=9).order_by( Ymb.export_val.desc()).limit(5).all() top = [t.bra for t in top] profile_types.append({ "summary": gettext( "Showing exports, employment and education data, statistics and visualizations about the chosen Brazilian location." ), "top": top, "title": gettext(u"Brazilian Locations"), "type": "bra" }) # Occupations most_recent_year = parse_year(__year_range__["rais"][-1]) top = Yo.query.filter_by(year=most_recent_year, cbo_id_len=4).order_by( Yo.num_jobs.desc()).limit(5).all() top = [t.cbo for t in top] profile_types.append({ "summary": gettext( "Showing industries and locations that employ the selected occupation." ), "top": top, "title": gettext(u"Occupations"), "type": "cbo" }) # Industries top = Yi.query.filter_by(year=most_recent_year, cnae_id_len=6).order_by( Yi.num_jobs.desc()).limit(5).all() top = [t.cnae for t in top] profile_types.append({ "summary": gettext( "Showing the occupations and locations with jobs in the selected industry." ), "top": top, "title": gettext(u"Industries"), "type": "cnae" }) # Prods most_recent_year = parse_year(__year_range__["secex"][-1]) top = Ymp.query.filter_by(year=most_recent_year, month=0, hs_id_len=6).order_by( Ymp.export_val.desc()).limit(5).all() top = [t.hs for t in top] profile_types.append({ "summary": gettext( "Showing locations in Brazil that export and import the selected product and their destinations and origins." ), "top": top, "title": gettext(u"Products"), "type": "hs" }) # Countries top = Ymw.query.filter_by(year=most_recent_year, month=0, wld_id_len=5).order_by( Ymw.export_val.desc()).limit(5).all() top = [t.wld for t in top] profile_types.append({ "summary": gettext( "Showing locations in brazil that trade with the selected country and the products they export and import from them." ), "top": top, "title": gettext(u"Trade Partners"), "type": "wld" }) # Universities most_recent_year = parse_year(__year_range__["hedu"][-1]) top = Yu.query.filter_by(year=most_recent_year).order_by( Yu.enrolled.desc()).limit(5).all() top = [t.university for t in top] profile_types.append({ "summary": gettext("Showing the majors found in the selected univserity."), "top": top, "title": gettext(u"Universities"), "type": "university" }) # Majors top = Yc_hedu.query.filter_by(year=most_recent_year).order_by( Yc_hedu.enrolled.desc()).limit(5).all() top = [t.course_hedu for t in top] profile_types.append({ "summary": gettext( "Showing the university and locations in Brazil where the selected major is found." ), "top": top, "title": gettext(u"Majors"), "type": "course_hedu" }) # Vocations most_recent_year = parse_year(__year_range__["sc"][-1]) top = Yc_sc.query.filter_by( year=most_recent_year, course_sc_id_len=5).order_by(Yc_sc.enrolled.desc()).filter( ~Yc_sc.course_sc_id.startswith('xx')).limit(5).all() top = [t.course_sc for t in top] profile_types.append({ "summary": gettext( "Showing the locations and schools in which these basic courses are taught." ), "top": top, "title": gettext(u"Basic Courses"), "type": "course_sc" }) return render_template("profiles/index.html", profile_types=profile_types)
def index(): profile_types = [] # Bra most_recent_year = parse_year(__year_range__["secex"][-1]) top = Ymb.query.filter_by(year=most_recent_year, month=0, bra_id_len=9).order_by(Ymb.export_val.desc()).limit(5).all() top = [t.bra for t in top] profile_types.append({ "summary": gettext("Showing exports, employment and education data, statistics and visualizations about the chosen Brazilian location."), "top": top, "title": gettext(u"Brazilian Locations"), "type": "bra" }) # Occupations most_recent_year = parse_year(__year_range__["rais"][-1]) top = Yo.query.filter_by(year=most_recent_year, cbo_id_len=4).order_by(Yo.num_jobs.desc()).limit(5).all() top = [t.cbo for t in top] profile_types.append({ "summary": gettext("Showing industries and locations that employ the selected occupation."), "top": top, "title": gettext(u"Occupations"), "type": "cbo" }) # Industries top = Yi.query.filter_by(year=most_recent_year, cnae_id_len=6).order_by(Yi.num_jobs.desc()).limit(5).all() top = [t.cnae for t in top] profile_types.append({ "summary": gettext("Showing the occupations and locations with jobs in the selected industry."), "top": top, "title": gettext(u"Industries"), "type": "cnae" }) # Prods most_recent_year = parse_year(__year_range__["secex"][-1]) top = Ymp.query.filter_by(year=most_recent_year, month=0, hs_id_len=6).order_by(Ymp.export_val.desc()).limit(5).all() top = [t.hs for t in top] profile_types.append({ "summary": gettext("Showing locations in Brazil that export and import the selected product and their destinations and origins."), "top": top, "title": gettext(u"Products"), "type": "hs" }) # Countries top = Ymw.query.filter_by(year=most_recent_year, month=0, wld_id_len=5).order_by(Ymw.export_val.desc()).limit(5).all() top = [t.wld for t in top] profile_types.append({ "summary": gettext("Showing locations in brazil that trade with the selected country and the products they export and import from them."), "top": top, "title": gettext(u"Trade Partners"), "type": "wld" }) # Universities most_recent_year = parse_year(__year_range__["hedu"][-1]) top = Yu.query.filter_by(year=most_recent_year).order_by(Yu.enrolled.desc()).limit(5).all() top = [t.university for t in top] profile_types.append({ "summary": gettext("Showing the majors found in the selected univserity."), "top": top, "title": gettext(u"Universities"), "type": "university" }) # Majors top = Yc_hedu.query.filter_by(year=most_recent_year).order_by(Yc_hedu.enrolled.desc()).limit(5).all() top = [t.course_hedu for t in top] profile_types.append({ "summary": gettext("Showing the university and locations in Brazil where the selected major is found."), "top": top, "title": gettext(u"Majors"), "type": "course_hedu" }) # Vocations most_recent_year = parse_year(__year_range__["sc"][-1]) top = Yc_sc.query.filter_by(year=most_recent_year, course_sc_id_len=5).order_by(Yc_sc.enrolled.desc()).filter(~Yc_sc.course_sc_id.startswith('xx')).limit(5).all() top = [t.course_sc for t in top] profile_types.append({ "summary": gettext("Showing the locations and schools in which these basic courses are taught."), "top": top, "title": gettext(u"Basic Courses"), "type": "course_sc" }) return render_template("profiles/index.html", profile_types=profile_types)