class PriceChange(base): __tablename__ = 'price_change' id = Column(Integer, primary_key=True, autoincrement=True) house_id = Column(Integer, ForeignKey('house.id')) pre_price = Column(FLOAT(8)) price = Column(FLOAT(8)) change_time = Column(DATETIME)
class ChengJiao(base): __tablename__ = 'cheng_jiao' id = Column(Integer, primary_key=True, autoincrement=True) # 记录之前的id,一遍跟踪之前的价格变化 ori_id = Column(Integer) xiao_qu = Column(Integer, ForeignKey('xiao_qu.id')) title = Column(String(128)) # 成交价 price = Column(FLOAT(8)) gua_pai_jia = Column(FLOAT(8)) unit_price = Column(FLOAT(8)) # 建筑面积 area1 = Column(FLOAT(8)) # 套内面积 area2 = Column(FLOAT(8)) flood = Column(String(32)) hu_xing = Column(String(32)) zhuang_xiu = Column(String(64)) chao_xiang = Column(String(16)) # 交易属性 prop = Column(String(16)) star = Column(Integer) url = Column(String(128), unique=True) zhou_qi = Column(Integer) tiao_jia = Column(Integer) dai_kan = Column(Integer) liu_lan = Column(Integer) nian_dai = Column(Integer) # 房屋年限,满二年、满五年 nian_xian = Column(String(16)) deal_date = Column(DATE)
class PriceChangeNot(base): __tablename__ = 'price_change_not' id = Column(Integer, primary_key=True, autoincrement=True) house_not_id = Column(Integer, ForeignKey('house_not.id')) pre_price = Column(FLOAT(8)) price = Column(FLOAT(8)) change_time = Column(DATETIME) create_time = Column(DATETIME, server_default=func.now())
class Price(Base): __tablename__ = 'price' id = Column(INT, primary_key=True, autoincrement=True) gid = Column(INT) price = Column(FLOAT(precision=12)) common_price = Column(FLOAT(precision=12)) expect_price = Column(FLOAT(precision=12)) date_time = Column(DATETIME)
class ZoneQuality_1(Base): __tablename__ = 'zone_quality_1' id = Column(BIGINT, primary_key=True, autoincrement=True) g_zone = Column(INT) g_name = Column(VARCHAR(10)) date_time = Column(DATETIME) average_speed = Column(FLOAT(precision=12)) density = Column(FLOAT(precision=12)) flow = Column(FLOAT(precision=12))
class Baby(Base): __tablename__ = 'baby' id = Column(INTEGER, primary_key=True, autoincrement=True) birthday = Column(VARCHAR(255)) weight = Column(FLOAT(5, 2)) height = Column(FLOAT(5, 2)) create_time = Column(DATETIME, default=datetime.datetime.now()) def keys(self): return [c.name for c in self.__table__.columns]
class Price(Base): __tablename__ = 'price' id = Column(INT, primary_key=True, autoincrement=True) href = Column(VARCHAR(100)) goods = Column(VARCHAR(20)) price = Column(FLOAT(precision=12)) common_price = Column(FLOAT(precision=12)) expect_price = Column(FLOAT(precision=12)) origin_time = Column(DATETIME) update_time = Column(DATETIME)
def test_float_types(self): specs = [ (DOUBLE_PRECISION(), FLOAT()), # when binary_precision is supported # (DOUBLE_PRECISION(), oracle.FLOAT(binary_precision=126)), (BINARY_DOUBLE(), BINARY_DOUBLE()), (BINARY_FLOAT(), BINARY_FLOAT()), (FLOAT(5), FLOAT()), # when binary_precision is supported # (FLOAT(5), oracle.FLOAT(binary_precision=5),), (FLOAT(), FLOAT()), # when binary_precision is supported # (FLOAT(5), oracle.FLOAT(binary_precision=126),), ] self._run_test(specs, ["precision"])
class ItemCombo(CommonModel): __tablename__ = 'item_combo' item_id = db.Column(UUID(as_uuid=True), ForeignKey("item.id", ondelete="CASCADE")) org_price = db.Column(FLOAT(25, 8), default=0) list_price = db.Column(FLOAT(25, 8), default=0) quantity = db.Column(FLOAT(10, 2), default=0) description = db.Column(Text()) parent_id = db.Column(UUID(as_uuid=True), ForeignKey("item.id", ondelete="CASCADE")) tenant_id = db.Column(String(), ForeignKey("tenant.id", onupdate="RESTRICT", ondelete="RESTRICT"), nullable=False)
class Questao(Base): __tablename__="tb_questao" id_questao = Column(Integer,primary_key=True,autoincrement=True) ano = Column(String(50)) enunciado = Column(String(3500)) img_enunciado = Column(String(500)) discriminacao = Column(FLOAT(15)) url = Column(String(150)) dificuldade = Column(Integer) acerto_casual = Column(FLOAT(15)) media = Column(FLOAT(15)) grupo = Column(String(50)) teste2 = relationship("Idioma") FKid_idioma = Column(Integer,ForeignKey("tb_idioma.id_idioma")) teste4 = relationship("Area") FKid_area = Column(Integer,ForeignKey("tb_area.id_area"))
class PersonaPeso(Base): __tablename__ = 'personaPeso' id = Column(INTEGER, primary_key=True, autoincrement=True) idPersona = Column(INTEGER, ForeignKey(Persona.id)) fecha = Column(DATETIME) peso = Column(FLOAT(5, 2), nullable=False) persona = relationship(Persona)
class AccountBalance(MixIn, MyBase): """账户余额表""" __tablename__ = config.coin_account_balance address = Column(String(128)) coin_type = Column(String(10)) balance = Column(FLOAT(precision="16,9"))
class CarItems(Base): __tablename__ = "car_items" id = Column(INTEGER, primary_key=True) car_id = Column(INTEGER, ForeignKey("cars.id"), nullable=True) car_type_id = Column(INTEGER, ForeignKey("car_types.id"), nullable=True) price_per_day = Column(FLOAT(precision="6,2"), nullable=True) production_year = Column(String(4), nullable=False) engine = Column(String(20)) fuel = Column(String(20), nullable=False) availability = Column(INTEGER, nullable=False, default=1) car = relationship("Cars", back_populates="car_item") car_type = relationship("CarTypes", back_populates="car_item") order = relationship("Orders", back_populates="car_item") @hybrid_property def columns(self) -> List: return [m.key for m in self.__table__.columns] @validates("availability") def validate_availability(self, key, availability): assert int(availability) in (0, 1) return availability def __repr__(self): return f"Car item: {self.id}, brand: {self.car.brand}, model: {self.car.model}, type: {self.car_type.type_name}"
def test_float_types( self, metadata, connection, ): specs = [ (DOUBLE_PRECISION(), DOUBLE_PRECISION()), (Double(), DOUBLE_PRECISION()), (REAL(), REAL()), (BINARY_DOUBLE(), BINARY_DOUBLE()), (BINARY_FLOAT(), BINARY_FLOAT()), (oracle.FLOAT(5), oracle.FLOAT(5)), ( Float(5).with_variant( oracle.FLOAT(binary_precision=16), "oracle" ), oracle.FLOAT(16), ), # using conversion (FLOAT(), DOUBLE_PRECISION()), # from https://docs.oracle.com/cd/B14117_01/server.101/b10758/sqlqr06.htm # noqa: E501 # DOUBLE PRECISION == precision 126 # REAL == precision 63 (oracle.FLOAT(126), DOUBLE_PRECISION()), (oracle.FLOAT(63), REAL()), ] self._run_test(metadata, connection, specs, ["precision"])
class Persona(Base): __tablename__ = 'persona' id = Column(INTEGER, primary_key=True, autoincrement=True) nombre = Column(VARCHAR(30)) fechaNac = Column(DATE) dni = Column(INTEGER, unique=True) altura = Column(FLOAT(3, 2))
class topten_holders_circulat_extdata_dto(Base): __tablename__ = 'finance_system_topten_holders_circulat_extdata' st_code = Column(String(32), primary_key=True) st_name = Column(String(32)) sum_circulat_radio = Column(FLOAT(15, 8))
class House(base): __tablename__ = 'house' id = Column(Integer, primary_key=True, autoincrement=True) title = Column(String(128)) xiao_qu = Column(Integer, ForeignKey('xiao_qu.id')) price = Column(FLOAT(8)) area = Column(FLOAT(8)) unit_price = Column(FLOAT(8)) flood = Column(String(32)) hu_xing = Column(String(32)) zhuang_xiu = Column(String(64)) chao_xiang = Column(String(16)) star = Column(Integer) status = Column(Boolean) url = Column(String(128), unique=True) create_time = Column(DATETIME, server_default=func.now())
class AskFee(MixIn, MyBase): """缴费记录表""" __tablename__ = config.coin_ask_fee txid = Column(String(128)) amount = Column(FLOAT(precision="16,9")) coin_type = Column(String(10)) coin_series = Column(String(10)) from_address = Column(String(128)) to_address = Column(String(128)) source_tag = Column(String(50)) destination_tag = Column(String(50)) fee = Column(FLOAT(precision="16,9")) fee_coin = Column(String(10)) confirmation_count = Column(Integer) status = Column(Enum(AskFeeStatusEnum), default=AskFeeStatusEnum.ASKING) done_at = Column(DateTime)
class Gather(MixIn, MyBase): """资金汇聚表""" __tablename__ = config.coin_gather coin_type = Column(String(10)) coin_series = Column(String(10)) txid = Column(String(128)) amount = Column(FLOAT(precision="16,9"), default=0) fee = Column(FLOAT(precision="16,9")) fee_coin = Column(String(10)) from_address = Column(String(128)) to_address = Column(String(128)) source_tag = Column(String(50)) destination_tag = Column(String(50)) confirmation_count = Column(Integer) status = Column(Enum(GatherStatusEnum), default=GatherStatusEnum.GATHER) done_at = Column(DateTime)
class CurrencyRate(Base): __tablename__ = "currencyRate" rateID = Column(INTEGER(), primary_key=True, comment="key") sourceCode = Column(String(20), comment="数据源") currencyCode = Column(String(20), comment="币种代码") sellPrice = Column(FLOAT(), comment="售汇价") buyPrice = Column(FLOAT(), comment="结汇价") date = Column(DATETIME(), comment="生效日期") createTime = Column(DATETIME(), comment="创建日期") def __init__(self, souceCode='', currencyCode='', sellPrice=0, buyPrice=0, date=datetime.today()): self.sourceCode = souceCode self.currencyCode = currencyCode self.sellPrice = sellPrice self.buyPrice = buyPrice self.date = date self.createTime = datetime.now() def __str__(self): return "rateID:%s souceCode:%s currencyCode:%s sellPrice:%s buyPrice:%s date:%s createTime:%s" % \ (self.rateID,self.sourceCode,self.currencyCode,\ self.sellPrice,self.buyPrice,self.date,self.createTime) @property def serialize(self): """Return object data in easily serializeable format""" return { 'rateID': self.rateID, 'souceCode': self.sourceCode, 'currencyCode': self.currencyCode, 'sellPrice': self.sellPrice, 'buyPrice': self.buyPrice, 'date': '{}-{}-{}'.format(self.date.year, self.date.month, self.date.day) }
class current_table_dto(Base): __tablename__ = 'finance_system_stock_topten_holders_newimport' mainkey = Column(String(32), primary_key=True) rank = Column(String(10)) scode = Column(String(15)) sname = Column(String(30)) rdate = Column(DateTime) sharehdnum = Column(FLOAT(15, 2)) zb = Column(FLOAT(17, 15)) ndate = Column(DateTime) bz = Column(String(10)) bdsum = Column(String(50)) bdbl = Column(String(100)) ltsz = Column(String(50)) sharehdname = Column(String(50)) sharehdtype = Column(String(50))
class stock_set_bid_base_rate_dto(Base): __tablename__ = 'finance_system_stock_set_bid_data_rate' code = Column(String(32), primary_key=True) industry = Column(String(100)) name = Column(String(100)) createtime = Column(DateTime) outstanding = Column(FLOAT(15, 2))
class ItemPriceList(CommonModel): __tablename__ = 'item_price_list' price_list_id = db.Column(UUID(as_uuid=True), ForeignKey("price_list.id", ondelete="CASCADE"), index=True) item_id = db.Column(UUID(as_uuid=True), ForeignKey("item.id", ondelete="CASCADE"), index=True) list_price = db.Column(FLOAT(25, 8), default=0) delivery_price = db.Column(FLOAT(25, 8), default=0) image = db.Column(Text()) variants = db.Column(JSONB()) note = db.Column(Text()) extra_data = db.Column(JSONB()) tenant_id = db.Column(String(), ForeignKey("tenant.id", onupdate="RESTRICT", ondelete="RESTRICT"), nullable=False)
class Item(CommonModel): __tablename__ = 'item' item_no = db.Column(String(40), index=True, nullable=False) # mã item_name = db.Column(String(150), nullable=False) # tên view 1 item_ascii_name = db.Column(String(150)) item_type = db.Column(String(20), default="default", index=True) # loại sản phẩm default/topping/combo item_class = db.Column(String(100)) # nhóm sản phẩm thumbnail = db.Column(Text()) # ảnh view 1 images = db.Column(JSONB()) # ảnh detail brief_desc = db.Column(Text()) # mô tả ngắn gọn view 1 description = db.Column(Text()) # mô tả detail manufacturer = db.Column(String(200), nullable=True) # nhà sản xuất unit_quantity = db.Column(FLOAT(11, 2), nullable=True) # số lượng đơn vị weight = db.Column(FLOAT(11, 2), nullable=True) # cân nặng pack_size = db.Column(Integer(), nullable=True) website = db.Column(String(100)) # sản phẩm liên kết đến đâu is_product = db.Column(Boolean(), default=True) is_raw_material = db.Column(Boolean(), default=False) is_material = db.Column(Boolean(), default=False) is_service = db.Column(Boolean(), default=False) is_combo = db.Column(Boolean(), default=False) is_trending = db.Column(Boolean(), default=False) allow_delivery = db.Column(Boolean(), default=False) active = db.Column(Boolean(), default=True) # sản phẩm còn hoạt động hay ko extra_attributes = db.Column(JSONB()) # dữ liệu thêm # currency_id = db.Column(UUID(as_uuid=True), ForeignKey('currency.id'), nullable=True) price_lists = db.relationship("PriceList", secondary='item_price_list') # variants = db.relationship("ItemCombo") # combos = db.relationship("ItemVariants") categories = db.relationship("ItemCategory", secondary='items_categories') service_id = db.Column(UUID(as_uuid=True), ForeignKey("service.id"), nullable=True) tenant_id = db.Column(String(), ForeignKey("tenant.id", onupdate="RESTRICT", ondelete="RESTRICT"), nullable=False)
class poi(Base): __tablename__ = 'poi' id = Column(Integer, primary_key=True) POIName = Column(String(80)) #sera que tem q ser unique geoLat = Column(FLOAT(50)) #sera que tem q ser unique geoLong = Column(FLOAT(50)) active = Column(Boolean, default=True) #open hours and close hours maybe def __init__(self, POIName, geoLat, geoLong): self.POIName = POIName self.geoLat = geoLat self.geoLong = geoLong self.active = True def __repr__(self): return '<POI %r>' % self.POIName
def test_numerics(self, metadata, connection): m = metadata t1 = Table( "t1", m, Column("intcol", Integer), Column("numericcol", Numeric(precision=9, scale=2)), Column("floatcol1", Float()), Column("floatcol2", FLOAT()), Column("doubleprec1", DOUBLE_PRECISION), Column("doubleprec2", Double()), Column("numbercol1", oracle.NUMBER(9)), Column("numbercol2", oracle.NUMBER(9, 3)), Column("numbercol3", oracle.NUMBER), ) t1.create(connection) connection.execute( t1.insert(), dict( intcol=1, numericcol=5.2, floatcol1=6.5, floatcol2=8.5, doubleprec1=9.5, doubleprec2=14.5, numbercol1=12, numbercol2=14.85, numbercol3=15.76, ), ) m2 = MetaData() t2 = Table("t1", m2, autoload_with=connection) for row in ( connection.execute(t1.select()).first(), connection.execute(t2.select()).first(), ): for i, (val, type_) in enumerate(( (1, int), (decimal.Decimal("5.2"), decimal.Decimal), (6.5, float), (8.5, float), (9.5, float), (14.5, float), (12, int), (decimal.Decimal("14.85"), decimal.Decimal), (15.76, float), )): eq_(row[i], val) assert isinstance(row[i], type_), "%r is not %r" % ( row[i], type_, )
class DraftkingsPlayerSalary(Base): __tablename__ = "draftkings_player_salary" id = Column(INTEGER, primary_key=True) game = Column("game", ForeignKey(Game.id)) player = Column("player", ForeignKey(Player.id)) salary = Column("salary", FLOAT(precision=2)) __table_args__ = (UniqueConstraint( "game", "player", name="custom_uc_draftkigns_player_game"), )
def test_no_decimal_float_precision(self): with expect_raises_message( exc.ArgumentError, "Oracle FLOAT types use 'binary precision', which does not " "convert cleanly from decimal 'precision'. Please specify this " "type with a separate Oracle variant, such as " r"FLOAT\(precision=5\).with_variant\(oracle.FLOAT\(" r"binary_precision=16\), 'oracle'\), so that the Oracle " "specific 'binary_precision' may be specified accurately.", ): FLOAT(5).compile(dialect=oracle.dialect())
class XiaoQu(base): __tablename__ = 'xiao_qu' id = Column(Integer, primary_key=True, autoincrement=True) district = Column(Integer, ForeignKey('district.id')) name = Column(String(64)) average_price = Column(FLOAT(8)) zai_shou = Column(Integer) cheng_jiao_90 = Column(Integer) chu_zu = Column(Integer) nian_dai = Column(Integer) url = Column(String(128), unique=True) status = Column(Boolean)
class Player(Base): __tablename__ = 'player' player_id = Column(INT(), primary_key=True) team_id = Column(INT()) player_name = Column(VARCHAR(255)) height = Column(FLOAT()) def __init__(self, player_id, team_id, player_name, height): self.player_id = player_id self.team_id = team_id self.player_name = player_name self.height = height