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())
