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)