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