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 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 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))
def rais_ybio(**kwargs):
return make_response(make_query(Ybio, request.args, g.locale, **kwargs))
