def secex_ybp(**kwargs): kwargs["join"] = [{ "table": Yp, "columns": ["pci"], "on": ["year", "hs_id"] }] return make_response(make_query(Ybp, request.args, g.locale, **kwargs))
def rais_ybo(**kwargs): kwargs["join"] = [{ "table": Yo, "columns": ["isic_diversity","isic_diversity_eff"], "on": ["year", "cbo_id"] }] return make_response(make_query(Ybo, request.args, g.locale, **kwargs))
def rais_ybo(**kwargs): kwargs["join"] = [{ "table": Yo, "columns": ["isic_diversity", "isic_diversity_eff"], "on": ["year", "cbo_id"] }] return make_response(make_query(Ybo, request.args, g.locale, **kwargs))
def data(year=None,type="bra",depth=None): g.json = True args = {} args["{0}_id".format(type)] = u"show.{0}".format(depth) args["year"] = year request_args = dict(request.args) request_args = {x:request_args[x][0] for x in request_args} if type == "bra": request_args["excluding"] = {"bra_id": "xx"} request_args["cols"] = ["bra_id","id_ibge","name","wage","wage_avg","val_usd","population","hs_diversity","hs_diversity_eff","isic_diversity","isic_diversity_eff"] args["join"] = [{ "table": Yb, "columns": ["population"], "on": ["year","bra_id"] }] if int(year) > 2001: args["join"].append({ "table": Yb_rais, "columns": ["wage","wage_avg","isic_diversity","isic_diversity_eff"], "on": ["year","bra_id"] }) table = Yb_secex elif type == "isic": request_args["excluding"] = {"isic_id": "xx"} request_args["cols"] = ["isic_id","name","wage","wage_avg","num_emp","num_emp_est","cbo_diversity","cbo_diversity_eff"] table = Yi elif type == "cbo": request_args["excluding"] = {"cbo_id": "xx"} request_args["cols"] = ["cbo_id","name","wage","wage_avg","num_emp","num_emp_est","isic_diversity","isic_diversity_eff"] table = Yo elif type == "hs": request_args["excluding"] = {"hs_id": "xx"} request_args["cols"] = ["hs_id","name","val_usd","pci","wld_diversity","wld_diversity_eff"] table = Yp elif type == "wld": request_args["excluding"] = {"wld_id": "xx"} request_args["cols"] = ["wld_id","id_mdic","name","val_usd","hs_diversity","hs_diversity_eff"] table = Yw return make_response(make_query(table, request_args, g.locale, **args))
def data(year=None, type="bra", depth=None): g.json = True args = {} args["{0}_id".format(type)] = u"show.{0}".format(depth) args["year"] = year request_args = dict(request.args) request_args = {x:request_args[x][0] for x in request_args} if type == "bra": request_args["excluding"] = {"bra_id": "xx"} request_args["cols"] = ["bra_id","id_ibge","name","wage","wage_avg","export_val","import_val","population","eci","hs_diversity","hs_diversity_eff","cnae_diversity","cnae_diversity_eff"] args["join"] = [] ry = [int(y) for y in __year_range__["rais"]] ry = range(ry[0], ry[1]+1) if int(year) in ry: args["join"].append({ "table": Yb_rais, "columns": ["wage","wage_avg","cnae_diversity","cnae_diversity_eff"], "on": ["year","bra_id"] }) py = [int(y) for y in __year_range__["population"]] py = range(py[0], py[1]+1) if int(year) in py: args["join"].append({ "table": Yb, "columns": ["population"], "on": ["year","bra_id"] }) table = Ymb elif type == "cnae": request_args["excluding"] = {"cnae_id": "xx"} request_args["cols"] = ["cnae_id","name","wage","wage_avg","num_jobs","num_jobs_est","cbo_diversity","cbo_diversity_eff"] table = Yi elif type == "cbo": request_args["excluding"] = {"cbo_id": "xx"} request_args["cols"] = ["cbo_id","name","wage","wage_avg","num_jobs","num_jobs_est","cnae_diversity","cnae_diversity_eff"] table = Yo elif type == "hs": request_args["excluding"] = {"hs_id": "xx"} request_args["cols"] = ["hs_id","name","export_val","import_val","pci","wld_diversity","wld_diversity_eff"] table = Ymp elif type == "wld": request_args["excluding"] = {"wld_id": "xx"} request_args["cols"] = ["wld_id","id_mdic","name","export_val","import_val","hs_diversity","hs_diversity_eff"] table = Ymw elif type == "university": request_args["excluding"] = {} request_args["cols"] = ["university_id","name","enrolled","graduates","entrants"] table = Yu elif type == "course_hedu": request_args["excluding"] = {"course_hedu_id": "00"} request_args["cols"] = ["course_hedu_id","name","enrolled","graduates","entrants"] table = Yc_hedu elif type == "course_sc": request_args["excluding"] = {"course_sc_id": "00"} request_args["cols"] = ["course_sc_id","name","enrolled","classes","age"] table = Yc_sc return make_response(make_query(table, request_args, g.locale, **args))
def secex_ybpw(**kwargs): return make_response(make_query(Ybpw, request.args, g.locale, **kwargs))
def data(year=None, type="bra", depth=None): g.json = True args = {} args["{0}_id".format(type)] = u"show.{0}".format(depth) args["year"] = year request_args = dict(request.args) request_args = {x: request_args[x][0] for x in request_args} if type == "bra": request_args["excluding"] = {"bra_id": "xx"} request_args["cols"] = [ "bra_id", "id_ibge", "name", "wage", "wage_avg", "val_usd", "population", "hs_diversity", "hs_diversity_eff", "isic_diversity", "isic_diversity_eff" ] args["join"] = [{ "table": Yb, "columns": ["population"], "on": ["year", "bra_id"] }] if int(year) > 2001: args["join"].append({ "table": Yb_rais, "columns": ["wage", "wage_avg", "isic_diversity", "isic_diversity_eff"], "on": ["year", "bra_id"] }) table = Yb_secex elif type == "isic": request_args["excluding"] = {"isic_id": "xx"} request_args["cols"] = [ "isic_id", "name", "wage", "wage_avg", "num_emp", "num_emp_est", "cbo_diversity", "cbo_diversity_eff" ] table = Yi elif type == "cbo": request_args["excluding"] = {"cbo_id": "xx"} request_args["cols"] = [ "cbo_id", "name", "wage", "wage_avg", "num_emp", "num_emp_est", "isic_diversity", "isic_diversity_eff" ] table = Yo elif type == "hs": request_args["excluding"] = {"hs_id": "xx"} request_args["cols"] = [ "hs_id", "name", "val_usd", "pci", "wld_diversity", "wld_diversity_eff" ] table = Yp elif type == "wld": request_args["excluding"] = {"wld_id": "xx"} request_args["cols"] = [ "wld_id", "id_mdic", "name", "val_usd", "hs_diversity", "hs_diversity_eff" ] table = Yw return make_response(make_query(table, request_args, g.locale, **args))
def data(year=None, type="bra", depth=None): g.json = True args = {} args["{0}_id".format(type)] = u"show.{0}".format(depth) args["year"] = year request_args = dict(request.args) request_args = {x: request_args[x][0] for x in request_args} if type == "bra": request_args["excluding"] = {"bra_id": "xx"} request_args["cols"] = [ "bra_id", "id_ibge", "name", "wage", "wage_avg", "export_val", "import_val", "population", "eci", "hs_diversity", "hs_diversity_eff", "cnae_diversity", "cnae_diversity_eff" ] args["join"] = [] ry = [int(y) for y in __year_range__["rais"]] ry = range(ry[0], ry[1] + 1) if int(year) in ry: args["join"].append({ "table": Yb_rais, "columns": ["wage", "wage_avg", "cnae_diversity", "cnae_diversity_eff"], "on": ["year", "bra_id"] }) py = [int(y) for y in __year_range__["population"]] py = range(py[0], py[1] + 1) if int(year) in py: args["join"].append({ "table": Yb, "columns": ["population"], "on": ["year", "bra_id"] }) table = Ymb elif type == "cnae": request_args["excluding"] = {"cnae_id": "xx"} request_args["cols"] = [ "cnae_id", "name", "wage", "wage_avg", "num_jobs", "num_jobs_est", "cbo_diversity", "cbo_diversity_eff" ] table = Yi elif type == "cbo": request_args["excluding"] = {"cbo_id": "xx"} request_args["cols"] = [ "cbo_id", "name", "wage", "wage_avg", "num_jobs", "num_jobs_est", "cnae_diversity", "cnae_diversity_eff" ] table = Yo elif type == "hs": request_args["excluding"] = {"hs_id": "xx"} request_args["cols"] = [ "hs_id", "name", "export_val", "import_val", "pci", "wld_diversity", "wld_diversity_eff" ] table = Ymp elif type == "wld": request_args["excluding"] = {"wld_id": "xx"} request_args["cols"] = [ "wld_id", "id_mdic", "name", "export_val", "import_val", "hs_diversity", "hs_diversity_eff" ] table = Ymw elif type == "university": request_args["excluding"] = {} request_args["cols"] = [ "university_id", "name", "enrolled", "graduates", "entrants" ] table = Yu elif type == "course_hedu": request_args["excluding"] = {"course_hedu_id": "00"} request_args["cols"] = [ "course_hedu_id", "name", "enrolled", "graduates", "entrants" ] table = Yc_hedu elif type == "course_sc": request_args["excluding"] = {"course_sc_id": "00"} request_args["cols"] = [ "course_sc_id", "name", "enrolled", "classes", "age" ] table = Yc_sc return make_response(make_query(table, request_args, g.locale, **args))
def rais_ybio(**kwargs): return make_response(make_query(Ybio, request.args, g.locale, **kwargs))