class Wld(db.Model, AutoSerialize, BasicAttr):
__tablename__ = 'attrs_wld'
id = db.Column(db.String(5), primary_key=True)
id_2char = db.Column(db.String(2))
id_3char = db.Column(db.String(3))
id_num = db.Column(db.Integer(11))
id_mdic = db.Column(db.Integer(11))
ymw = db.relationship("Ymw", backref='wld', lazy='dynamic')
ympw = db.relationship("Ympw", backref='wld', lazy='dynamic')
ymbw = db.relationship("Ymbw", backref='wld', lazy='dynamic')
ymbpw = db.relationship("Ymbpw", backref='wld', lazy='dynamic')
def icon(self):
if self.id == "all":
return "/static/img/icons/wld/wld_sabra.png"
else:
return "/static/img/icons/wld/wld_%s.png" % (self.id)
def url(self):
if self.id == "sabra":
return "/profiles/bra/all/"
else:
return "/profiles/wld/{}/".format(self.id)
def __repr__(self):
return '<Wld %r>' % (self.id_3char)
class Wld(db.Model, AutoSerialize, Stats):
__tablename__ = 'attrs_wld'
id = db.Column(db.String(5), primary_key=True)
id_2char = db.Column(db.String(2))
id_3char = db.Column(db.String(3))
id_num = db.Column(db.Integer(11))
id_mdic = db.Column(db.Integer(11))
name_en = db.Column(db.String(200))
name_pt = db.Column(db.String(200))
color = db.Column(db.String(7))
gender_pt = db.Column(db.String(1))
plural_pt = db.Column(db.Boolean())
article_pt = db.Column(db.Boolean())
yw = db.relationship("Yw", backref='wld', lazy='dynamic')
ypw = db.relationship("Ypw", backref='wld', lazy='dynamic')
ybw = db.relationship("Ybw", backref='wld', lazy='dynamic')
ybpw = db.relationship("Ybpw", backref='wld', lazy='dynamic')
def name(self):
lang = getattr(g, "locale", "en")
return title_case(getattr(self, "name_" + lang))
def icon(self):
if self.id == "all":
return "/static/img/icons/wld/wld_sabra.png"
else:
return "/static/img/icons/wld/wld_%s.png" % (self.id)
def __repr__(self):
return '<Wld %r>' % (self.id_3char)
class Yc_hedu(Hedu):
__tablename__ = 'hedu_yc'
year = db.Column(db.Integer(4), primary_key=True)
course_hedu_id = db.Column(db.String(6), db.ForeignKey(Course_hedu.id), primary_key=True)
course_hedu_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybc {}.{}.{}>'.format(self.year, self.bra_id, self.course_hedu_id)
class Sc(db.Model, AutoSerialize):
__abstract__ = True
year = db.Column(db.Integer(4), primary_key=True)
age = db.Column(db.Float())
classes = db.Column(db.Integer(11))
enrolled = db.Column(db.Integer(11))
enrolled_growth = db.Column(db.Float())
enrolled_growth_5 = db.Column(db.Float())
class Yb_sc(Sc):
__tablename__ = 'sc_yb'
bra_id = db.Column(db.String(9), db.ForeignKey(Bra.id), primary_key=True)
num_schools = db.Column(db.Integer(11))
bra_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Yb {0}.{1}>'.format(self.year, self.bra_id)
class Yuc(Hedu):
__tablename__ = 'hedu_yuc'
year = db.Column(db.Integer(4), primary_key=True)
university_id = db.Column(db.String(5), db.ForeignKey(University.id), primary_key=True)
course_hedu_id = db.Column(db.Integer(6), db.ForeignKey(Course_hedu.id), primary_key=True)
course_hedu_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Yuc {}.{}.{}>'.format(self.year, self.university_id, self.course_hedu_id)
class Ybu(Hedu):
__tablename__ = 'hedu_ybu'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(9), db.ForeignKey(Bra.id), primary_key=True)
university_id = db.Column(db.String(5), db.ForeignKey(University.id), primary_key=True)
bra_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybu {}.{}.{}>'.format(self.year, self.bra_id, self.university_id)
class Yio(BaseRais, db.Model, AutoSerialize):
__tablename__ = 'rais_yio'
cnae_id = db.Column(db.String(5), db.ForeignKey(Cnae.id), primary_key=True)
cbo_id = db.Column(db.String(6), db.ForeignKey(Cbo.id), primary_key=True)
importance = db.Column(db.Float())
cnae_id_len = db.Column(db.Integer(1))
cbo_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Yio %d.%s.%s>' % (self.year, self.cnae_id, self.cbo_id)
class Ybo(BaseRais, db.Model, AutoSerialize):
__tablename__ = 'rais_ybo'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(8), db.ForeignKey(Bra.id), primary_key=True)
cbo_id = db.Column(db.String(6), db.ForeignKey(Cbo.id), primary_key=True)
bra_id_len = db.Column(db.Integer(1))
cbo_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybo %d.%s.%s>' % (self.year, self.bra_id, self.cbo_id)
class Yb_hedu(Hedu):
__tablename__ = 'hedu_yb'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(9), db.ForeignKey(Bra.id), primary_key=True)
num_universities = db.Column(db.Integer(11))
bra_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Yb {}.{}>'.format(self.year, self.bra_id)
class Ybc_sc(Sc):
__tablename__ = 'sc_ybc'
bra_id = db.Column(db.String(9), db.ForeignKey(Bra.id), primary_key=True)
course_sc_id = db.Column(db.String(5),
db.ForeignKey(Course_sc.id),
primary_key=True)
bra_id_len = db.Column(db.Integer(1))
course_sc_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybc %d.%s.%s>' % (self.year, self.bra_id, self.course_sc_id)
class BaseSecex(db.Model, AutoSerialize):
__abstract__ = True
year = db.Column(db.Integer(4), primary_key=True)
month = db.Column(db.Integer(2), primary_key=True)
import_val = db.Column(db.Numeric(16, 2))
export_val = db.Column(db.Numeric(16, 2))
import_kg = db.Column(db.Integer(11))
export_kg = db.Column(db.Integer(11))
import_val_growth = db.Column(db.Float())
import_val_growth_5 = db.Column(db.Float())
export_val_growth = db.Column(db.Float())
export_val_growth_5 = db.Column(db.Float())
class BaseRais(object):
year = db.Column(db.Integer(4), primary_key=True)
wage = db.Column(db.Numeric(16, 2))
num_emp = db.Column(db.Integer(11))
num_jobs = db.Column(db.Integer(11))
num_est = db.Column(db.Integer(11))
wage_avg = db.Column(db.Numeric(16, 2))
age_avg = db.Column(db.Numeric(16, 2))
wage_growth = db.Column(db.Float())
wage_growth_5 = db.Column(db.Float())
num_emp_growth = db.Column(db.Float())
num_emp_growth_5 = db.Column(db.Float())
class Ybi(BaseRais, db.Model, AutoSerialize):
__tablename__ = 'rais_ybi'
bra_id = db.Column(db.String(8), db.ForeignKey(Bra.id), primary_key=True)
cnae_id = db.Column(db.String(5), db.ForeignKey(Cnae.id), primary_key=True)
rca = db.Column(db.Float())
distance = db.Column(db.Float())
opp_gain = db.Column(db.Float())
bra_id_len = db.Column(db.Integer(1))
cnae_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybi %d.%s.%s>' % (self.year, self.bra_id, self.cnae_id)
class Yo(BaseRais, db.Model, AutoSerialize):
__tablename__ = 'rais_yo'
cbo_id = db.Column(db.String(6), db.ForeignKey(Cbo.id), primary_key=True)
cnae_diversity = db.Column(db.Integer(11))
cnae_diversity_eff = db.Column(db.Float())
bra_diversity = db.Column(db.Integer(11))
bra_diversity_eff = db.Column(db.Float())
cbo_id_len = db.Column(db.Integer(1))
hist = db.Column(db.Text())
gini = db.Column(db.Float())
def __repr__(self):
return '<Yo %d.%s>' % (self.year, self.cbo_id)
class Yb(db.Model, AutoSerialize):
__tablename__ = 'attrs_yb'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(10), db.ForeignKey(Bra.id), primary_key=True)
population = db.Column(db.Integer)
def __repr__(self):
return '<Yb %r.%r>' % (self.year, self.bra_id)
class Yb_secex(db.Model, AutoSerialize):
__tablename__ = 'secex_yb'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(8), db.ForeignKey(Bra.id), primary_key=True)
val_usd = db.Column(db.Numeric(16, 2))
eci = db.Column(db.Float())
hs_diversity = db.Column(db.Integer(11))
hs_diversity_eff = db.Column(db.Float())
wld_diversity = db.Column(db.Integer(11))
wld_diversity_eff = db.Column(db.Float())
val_usd_growth_pct = db.Column(db.Float())
val_usd_growth_pct_5 = db.Column(db.Float())
val_usd_growth_val = db.Column(db.Numeric(16, 2))
val_usd_growth_val_5 = db.Column(db.Numeric(16, 2))
def __repr__(self):
return '<Yb_secex %d.%s>' % (self.year, self.bra_id)
class Yp(db.Model, AutoSerialize):
__tablename__ = 'secex_yp'
year = db.Column(db.Integer(4), primary_key=True)
hs_id = db.Column(db.String(6), db.ForeignKey(Hs.id), primary_key=True)
val_usd = db.Column(db.Numeric(16, 2))
pci = db.Column(db.Float())
bra_diversity = db.Column(db.Integer(11))
bra_diversity_eff = db.Column(db.Float())
wld_diversity = db.Column(db.Integer(11))
wld_diversity_eff = db.Column(db.Float())
rca_wld = db.Column(db.Float())
val_usd_growth_pct = db.Column(db.Float())
val_usd_growth_pct_5 = db.Column(db.Float())
val_usd_growth_val = db.Column(db.Numeric(16, 2))
val_usd_growth_val_5 = db.Column(db.Numeric(16, 2))
def __repr__(self):
return '<Yp %d.%s>' % (self.year, self.hs_id)
class Ybi_reqs(db.Model, AutoSerialize):
__tablename__ = 'rais_ybi_required'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(8), db.ForeignKey(Bra.id), primary_key=True)
cnae_id = db.Column(db.String(5), db.ForeignKey(Cnae.id), primary_key=True)
required_bras = db.Column(db.String(255))
def __repr__(self):
return '<Ybi_reqs %d.%s.%s>' % (self.year, self.bra_id, self.cnae_id)
class Ybs(db.Model, AutoSerialize):
__tablename__ = 'attrs_ybs'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(10), db.ForeignKey(Bra.id), primary_key=True)
stat_id = db.Column(db.String(20),
db.ForeignKey(Stat.id),
primary_key=True)
stat_val = db.Column(db.Float)
def __repr__(self):
return "<Ybs {}.{}.{}>".format(self.year, self.bra_id, self.stat_id)
class Ysc(Sc):
__tablename__ = 'sc_ysc'
school_id = db.Column(db.String(8), primary_key=True)
course_sc_id = db.Column(db.String(5),
db.ForeignKey(Course_sc.id),
primary_key=True)
course_sc_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ysc %d.%s.%s>' % (self.year, self.school_id)
class Ybs(Sc):
__tablename__ = 'sc_ybs'
bra_id = db.Column(db.String(9), db.ForeignKey(Bra.id), primary_key=True)
school_id = db.Column(db.String(8),
db.ForeignKey(School.id),
primary_key=True)
bra_id_len = db.Column(db.Integer(1))
def __repr__(self):
return '<Ybs %d.%s.%s>' % (self.year, self.bra_id, self.school_id)
class Yoo(db.Model, AutoSerialize):
__tablename__ = 'attrs_yoo'
year = db.Column(db.Integer(4), primary_key=True)
cbo_id = db.Column(db.String(6), db.ForeignKey(Cbo.id), primary_key=True)
cbo_id_target = db.Column(db.String(6),
db.ForeignKey(Cbo.id),
primary_key=True)
prox_bra = db.Column(db.Float)
def __repr__(self):
return "<Yoo {}.{}.{}>".format(self.year, self.cbo_id,
self.cbo_id_target)
class Yww(db.Model, AutoSerialize):
__tablename__ = 'attrs_yww'
year = db.Column(db.Integer(4), primary_key=True)
wld_id = db.Column(db.String(5), db.ForeignKey(Wld.id), primary_key=True)
wld_id_target = db.Column(db.String(5),
db.ForeignKey(Wld.id),
primary_key=True)
prox_bra = db.Column(db.Float)
def __repr__(self):
return "<Yww {}.{}.{}>".format(self.year, self.wld_id,
self.wld_id_target)
class Ypp(db.Model, AutoSerialize):
__tablename__ = 'attrs_ypp'
year = db.Column(db.Integer(4), primary_key=True)
hs_id = db.Column(db.String(8), db.ForeignKey(Hs.id), primary_key=True)
hs_id_target = db.Column(db.String(8),
db.ForeignKey(Hs.id),
primary_key=True)
prox_bra = db.Column(db.Float)
def __repr__(self):
return "<Ypp {}.{}.{}>".format(self.year, self.hs_id,
self.hs_id_target)
class Ypw(db.Model, AutoSerialize):
__tablename__ = 'secex_ypw'
year = db.Column(db.Integer(4), primary_key=True)
hs_id = db.Column(db.String(6), db.ForeignKey(Hs.id), primary_key=True)
wld_id = db.Column(db.String(5), db.ForeignKey(Wld.id), primary_key=True)
val_usd = db.Column(db.Numeric(16, 2))
val_usd_growth_pct = db.Column(db.Float())
val_usd_growth_pct_5 = db.Column(db.Float())
val_usd_growth_val = db.Column(db.Numeric(16, 2))
val_usd_growth_val_5 = db.Column(db.Numeric(16, 2))
def __repr__(self):
return '<Ypw %d.%s.%s>' % (self.year, self.hs_id, self.wld_id)
class Yuu(db.Model, AutoSerialize):
__tablename__ = 'attrs_yuu'
year = db.Column(db.Integer(4), primary_key=True)
university_id = db.Column(db.String(6),
db.ForeignKey(Cbo.id),
primary_key=True)
university_id_target = db.Column(db.String(6),
db.ForeignKey(Cbo.id),
primary_key=True)
prox_course_hedu = db.Column(db.Float)
def __repr__(self):
return "<Yuu {}.{}.{}>".format(self.year, self.cbo_id,
self.cbo_id_target)
class Hedu(db.Model, AutoSerialize):
__abstract__ = True
enrolled = db.Column(db.Integer(11))
graduates = db.Column(db.Integer(11))
entrants = db.Column(db.Integer(11))
# students = db.Column(db.Integer(11))
morning = db.Column(db.Integer(11))
afternoon = db.Column(db.Integer(11))
night = db.Column(db.Integer(11))
full_time = db.Column(db.Integer(11))
age = db.Column(db.Float())
graduates_growth = db.Column(db.Float())
enrolled_growth = db.Column(db.Float())
class Ybb(db.Model, AutoSerialize):
__tablename__ = 'attrs_ybb'
year = db.Column(db.Integer(4), primary_key=True)
bra_id = db.Column(db.String(10), db.ForeignKey(Bra.id), primary_key=True)
bra_id_target = db.Column(db.String(10),
db.ForeignKey(Bra.id),
primary_key=True)
prox_cnae = db.Column(db.Float)
prox_cbo = db.Column(db.Float)
prox_hs = db.Column(db.Float)
prox_wld = db.Column(db.Float)
def __repr__(self):
return "<Ybb {}.{}.{}>".format(self.year, self.bra_id,
self.bra_id_target)
class School(db.Model, AutoSerialize, ExpandedAttr):
__tablename__ = 'attrs_school'
id = db.Column(db.String(8), primary_key=True)
is_vocational = db.Column(db.Integer(1))
school_type_id = db.Column(db.String(1))
school_type_en = db.Column(db.String(32))
school_type_pt = db.Column(db.String(32))
is_vocational = db.Column(db.Integer)
def icon(self):
return "/static/img/icons/school/school_{}.png".format(
self.school_type_id.lower())
def url(self):
return "/profiles/school/{}/".format(self.id)
def __repr__(self):
return '<School %r>' % (self.name_en)
