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 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 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 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 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 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 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_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 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 Ybp(db.Model, AutoSerialize): __tablename__ = 'secex_ybp' year = db.Column(db.Integer(4), primary_key=True) bra_id = db.Column(db.String(8), db.ForeignKey(Bra.id), 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)) rca = db.Column(db.Float()) rca_wld = db.Column(db.Float()) distance = db.Column(db.Float()) distance_wld = db.Column(db.Float()) opp_gain = db.Column(db.Float()) opp_gain_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 '<Ybp %d.%s.%s>' % (self.year, self.bra_id, self.hs_id)
class Search(db.Model): __tablename__ = 'attrs_search' id = db.Column(db.String(9), primary_key=True) kind = db.Column(db.String(9), primary_key=True) weight = db.Column(db.Float()) name_en = db.Column(db.String(200)) name_pt = db.Column(db.String(200)) color = db.Column(db.String(7)) def serialize(self, pt=False): return { "color": self.color, "content_type": self.kind, "id": self.id, "name": self.name_en if not pt else self.name_pt } def __repr__(self): return "<SearchAttr {} {}>".format(self.id, self.kind)
class Distances(db.Model): __tablename__ = 'attrs_bb' bra_id_origin = db.Column(db.String(10), db.ForeignKey(Bra.id), primary_key=True) bra_id_dest = db.Column(db.String(10), db.ForeignKey(Bra.id), primary_key=True) distance = db.Column(db.Float()) def __repr__(self): return '<Bra_Dist %r-%r:%g>' % (self.bra_id_origin, self.bra_id_dest, self.distance) def serialize(self): return { "bra_id_origin": self.bra_id_origin, "bra_id_dest": self.bra_id_dest, "distance": self.distance }
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 WldDiversity(object): wld_diversity = db.Column(db.Integer(11)) wld_diversity_eff = db.Column(db.Float())
class BraDiversity(object): bra_diversity = db.Column(db.Integer(11)) bra_diversity_eff = db.Column(db.Float())
class Ymp(BaseSecex, HsId, BraDiversity, WldDiversity, Rca_wld): __tablename__ = "secex_ymp" pci = db.Column(db.Float())
class Eci(object): eci = db.Column(db.Float())
class Rcd(object): rcd = db.Column(db.Float())
class Rca_wld(object): rca_wld = db.Column(db.Float())
class Rca(object): rca = db.Column(db.Float())
class OppGain(object): opp_gain = db.Column(db.Float()) opp_gain_wld = db.Column(db.Float())
class Distance(object): distance = db.Column(db.Float()) distance_wld = db.Column(db.Float())
class HsDiversity(object): hs_diversity = db.Column(db.Integer(11)) hs_diversity_eff = db.Column(db.Float())