Example #1
0
class Yodp(db.Model, AutoSerialize):

    __tablename__ = 'sitc_yodp'

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

    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 '<Yodp %d.%s.%s.%s>' % (self.year, self.origin_id, self.dest_id,
                                       self.sitc_id)
Example #2
0
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))
Example #3
0
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)
Example #4
0
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)
Example #5
0
class Sitc(ProdAttr):
    __tablename__ = 'attr_sitc'
    sitc = db.Column(db.String(6))
    pini = db.Column(db.Float())
    pini_class = db.Column(db.Integer)

    name = db.relationship("Sitc_name", backref="sitc", lazy="dynamic")
    yodp_product = db.relationship("db_data.sitc_models.Yodp",
                                   backref='product',
                                   lazy='dynamic')
    yop_product = db.relationship("db_data.sitc_models.Yop",
                                  backref='product',
                                  lazy='dynamic')
    yp_product = db.relationship("db_data.sitc_models.Yp",
                                 backref='product',
                                 lazy='dynamic')
    classification = "sitc"
Example #6
0
class Pci(object):
    pci = db.Column(db.Float())
    pci_rank = db.Column(db.Integer)
    pci_rank_delta = db.Column(db.Integer)
Example #7
0
class Rca(object):
    export_rca = db.Column(db.Float())
    import_rca = db.Column(db.Float())