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