class Yo(db.Model, AutoSerialize):
__tablename__ = 'attr_yo'
year = db.Column(db.Integer, primary_key=True)
origin_id = db.Column(db.String(5),
db.ForeignKey(Country.id),
primary_key=True)
eci = db.Column(db.Float())
neci = db.Column(db.Float())
eci_rank = db.Column(db.Integer)
eci_rank_delta = db.Column(db.Integer)
opp_value = db.Column(db.Float())
population = db.Column(db.Integer)
gdp = db.Column(db.Numeric(16, 2))
gdp_pc_constant = db.Column(db.Numeric(16, 2))
gdp_pc_current = db.Column(db.Numeric(16, 2))
gdp_pc_constant_ppp = db.Column(db.Numeric(16, 2))
gdp_pc_current_ppp = db.Column(db.Numeric(16, 2))
leader = db.Column(db.String(100))
magic = db.Column(db.Float())
pc_constant = db.Column(db.Float())
pc_current = db.Column(db.Float())
notpc_constant = db.Column(db.Float())
def __repr__(self):
return '<Yo %d.%s>' % (self.year, self.origin_id)
class Yd(db.Model, AutoSerialize):
__tablename__ = 'sitc_yd'
year = db.Column(db.Integer, primary_key=True)
dest_id = db.Column(db.String(5),
db.ForeignKey(Country.id),
primary_key=True)
export_val = db.Column(db.Numeric(16, 2))
import_val = db.Column(db.Numeric(16, 2))
def __repr__(self):
return '<Yd %d.%s>' % (self.year, self.dest_id)
class Yp(db.Model, AutoSerialize):
__tablename__ = 'sitc_yp'
year = db.Column(db.Integer, primary_key=True)
sitc_id = db.Column(db.String(8), db.ForeignKey(Sitc.id), primary_key=True)
export_val = db.Column(db.Numeric(16, 2))
import_val = db.Column(db.Numeric(16, 2))
pci = db.Column(db.Float())
pci_rank = db.Column(db.Integer)
pci_rank_delta = db.Column(db.Integer)
top_exporter = db.Column(db.String(5), db.ForeignKey(Country.id))
top_importer = db.Column(db.String(5), db.ForeignKey(Country.id))
def __repr__(self):
return '<Yp %d.%s>' % (self.year, self.sitc_id)
class Yo(db.Model, AutoSerialize):
__tablename__ = 'sitc_yo'
year = db.Column(db.Integer, primary_key=True)
origin_id = db.Column(db.String(5),
db.ForeignKey(Country.id),
primary_key=True)
export_val = db.Column(db.Numeric(16, 2))
import_val = db.Column(db.Numeric(16, 2))
top_export = db.Column(db.String(8), db.ForeignKey(Sitc.id))
top_import = db.Column(db.String(8), db.ForeignKey(Sitc.id))
top_export_dest = db.Column(db.String(5))
top_import_dest = db.Column(db.String(5))
def __repr__(self):
return '<Yo %d.%s>' % (self.year, self.origin_id)
class Yod(db.Model, AutoSerialize):
__tablename__ = 'sitc_yod'
year = db.Column(db.Integer, primary_key=True)
origin_id = db.Column(db.String(5),
db.ForeignKey(Country.id),
primary_key=True)
dest_id = db.Column(db.String(5),
db.ForeignKey(Country.id),
primary_key=True)
export_val = db.Column(db.Numeric(16, 2))
import_val = db.Column(db.Numeric(16, 2))
export_val_growth_pct = db.Column(db.Float())
export_val_growth_pct_5 = db.Column(db.Float())
export_val_growth_val = db.Column(db.Numeric(16, 2))
export_val_growth_val_5 = db.Column(db.Numeric(16, 2))
import_val_growth_pct = db.Column(db.Float())
import_val_growth_pct_5 = db.Column(db.Float())
import_val_growth_val = db.Column(db.Numeric(16, 2))
import_val_growth_val_5 = db.Column(db.Numeric(16, 2))
def __repr__(self):
return '<Yod %d.%s.%s>' % (self.year, self.origin_id, self.dest_id)
class BaseProd(db.Model, AutoSerialize):
__abstract__ = True
year = db.Column(db.Integer(), primary_key=True)
import_val = db.Column(db.Numeric(16, 2))
export_val = db.Column(db.Numeric(16, 2))
export_val_growth_pct = db.Column(db.Float())
export_val_growth_pct_5 = db.Column(db.Float())
export_val_growth_val = db.Column(db.Numeric(16, 2))
export_val_growth_val_5 = db.Column(db.Numeric(16, 2))
import_val_growth_pct = db.Column(db.Float())
import_val_growth_pct_5 = db.Column(db.Float())
import_val_growth_val = db.Column(db.Numeric(16, 2))
import_val_growth_val_5 = db.Column(db.Numeric(16, 2))