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