class AutoScale(db.Model):
id_scaling = db.Column(db.Numeric,primary_key=True, default=1)
max_threshold = db.Column(db.DECIMAL(10,2))
min_threshold = db.Column(db.DECIMAL(10,2))
add_ratio = db.Column(db.DECIMAL(10,2))
red_ratio = db.Column(db.DECIMAL(10,2))
auto_toggle = db.Column(db.BOOLEAN)
class Cake(db.Model):
__tablename__ = 'cakes'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
cake_name = db.Column(db.VARCHAR(255), nullable=False)
visitor_price = db.Column(db.DECIMAL(5, 2))
customer_price = db.Column(db.DECIMAL(5, 2))
vip_price = db.Column(db.DECIMAL(5, 2))
photo = db.Column(db.VARCHAR(255))
description = db.Column(db.VARCHAR(255))
rating = db.Column(db.DECIMAL(4, 2))
order_made = db.Column(db.Integer)
drop_amount = db.Column(db.Integer)
store1 = db.Column(db.Integer)
store2 = db.Column(db.Integer)
store3 = db.Column(db.Integer)
store4 = db.Column(db.Integer)
store5 = db.Column(db.Integer)
store6 = db.Column(db.Integer)
store7 = db.Column(db.Integer)
cart = db.relationship("Cart", back_populates="cake")
store1 = db.Column(db.Integer)
def __repr__(self):
return '<Cake: {}, {}, {}, {}>'.format(self.id, self.cake_name,
self.photo, self.description)
class btccash_unconfirmed(db.Model):
__tablename__ = 'btccash_unconfirmed'
__bind_key__ = 'wallet_btc_cash'
__table_args__ = {'useexisting': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
userid = db.Column(db.INTEGER)
unconfirmed1 = db.Column(db.DECIMAL(20, 8))
unconfirmed2 = db.Column(db.DECIMAL(20, 8))
unconfirmed3 = db.Column(db.DECIMAL(20, 8))
unconfirmed4 = db.Column(db.DECIMAL(20, 8))
unconfirmed5 = db.Column(db.DECIMAL(20, 8))
unconfirmed6 = db.Column(db.DECIMAL(20, 8))
unconfirmed7 = db.Column(db.DECIMAL(20, 8))
unconfirmed8 = db.Column(db.DECIMAL(20, 8))
unconfirmed9 = db.Column(db.DECIMAL(20, 8))
unconfirmed10 = db.Column(db.DECIMAL(20, 8))
txid1 = db.Column(db.TEXT)
txid2 = db.Column(db.TEXT)
txid3 = db.Column(db.TEXT)
txid4 = db.Column(db.TEXT)
txid5 = db.Column(db.TEXT)
txid6 = db.Column(db.TEXT)
txid7 = db.Column(db.TEXT)
txid8 = db.Column(db.TEXT)
txid9 = db.Column(db.TEXT)
txid10 = db.Column(db.TEXT)
class TDTCFees(Base):
__tablename__ = 't_tdtc_fees'
id = db.Column(db.Integer, primary_key=True)
fee_no = db.Column(db.String(32), doc=u'费用唯一标识')
year = db.Column(db.String(8), doc=u'学年')
fee_name = db.Column(db.String(32), doc=u'费用名称')
student_no = db.Column(db.String(24), doc=u'学生学号')
amt = db.Column(db.DECIMAL(12, 2), doc=u'欠费金额')
loan_amt = db.Column(db.DECIMAL(12, 2), doc=u'贷款金额')
detect_amt = db.Column(db.DECIMAL(12, 2), doc=u'减免金额')
refund_amt = db.Column(db.DECIMAL(12, 2), doc=u'退款金额')
paid_amt = db.Column(db.DECIMAL(12, 2), doc=u'已缴金额')
fee_desc = db.Column(db.String(128), doc=u'缴费项目说明')
begin_time = Column("begin_time", DATETIME, nullable=True, doc=u'开始缴费时间')
end_time = Column("end_time", DATETIME, nullable=True, doc=u'缴费结束时间')
create_time = Column("create_time",
DATETIME,
nullable=False,
default=datetime.now,
doc=u'创建时间')
update_time = Column("update_time",
DATETIME,
nullable=False,
default=datetime.now,
onupdate=datetime.now,
doc=u'更新时间')
remark = db.Column(db.String(128), doc=u'备注')
class Map(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
type = db.Column(db.Integer) # ('早读','晨跑')
name = db.Column(db.String(255))
latitude = db.Column(db.DECIMAL(10, 6))
longitude = db.Column(db.DECIMAL(10, 6))
def __init__(self, type, name, latitude, longitude):
self.type = type
self.name = name
self.latitude = latitude
self.longitude = longitude
def __repr__(self):
return '<Map latitude:%s latitude:%s %s>' % (self.latitude,
self.longitude,
('早读', '晨跑')[self.type])
def save(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()
class Card(db.Model):
id = db.Column(db.Integer, primary_key=True)
number = db.Column(db.String(8), unique=False)
card_type = db.Column(db.String(50), unique=False)
expire_year = db.Column(db.Integer, unique=False)
expire_month = db.Column(db.Integer, unique=False)
direct_debit = db.Column(db.Boolean, unique=False)
purchase_limit = db.Column(db.DECIMAL(18,2), unique=False)
available_limit = db.Column(db.DECIMAL(18,2), unique=False)
spent = db.Column(db.DECIMAL(18,2), unique=False)
payment_day = db.Column(db.DECIMAL(18,2), unique=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'),
nullable=False)
def __init__(self, number, card_type, expire_year,
expire_month, direct_debit, purchase_limit,
available_limit, spent, payment_day, user_id):
self.number = number
self.card_type = card_type
self.expire_year = expire_year
self.expire_month = expire_month
self.direct_debit = direct_debit
self.purchase_limit = purchase_limit
self.available_limit = available_limit
self.spent = spent
self.payment_day = payment_day
self.user_id = user_id
def __repr__(self):
return '<Card %r>' % self.number
class School(db.Model):
_tablename_ = 'school'
roll_number = db.Column(db.String(50), primary_key=True)
official_school_name = db.Column(db.String(50), nullable=False)
website = db.Column(db.String(100))
address1 = db.Column(db.String(50))
address2 = db.Column(db.String(50))
address3 = db.Column(db.String(50))
address4 = db.Column(db.String(50))
county = db.Column(db.String(50))
eircode = db.Column(db.String(50))
phone = db.Column(db.String(50))
email = db.Column(db.String(50))
principal_name = db.Column(db.String(50))
deis = db.Column(db.Boolean, default=False)
school_gender = db.Column(db.String(50))
pupil_attendance_type = db.Column(db.String(50))
irish_classification = db.Column(db.String(50))
gaeltacht_area_location = db.Column(db.String(50))
fee = db.Column(db.String(50))
religion = db.Column(db.String(50))
open_close_status = db.Column(db.String(50))
total_girl = db.Column(db.Integer)
total_boy = db.Column(db.Integer)
total_pupil = db.Column(db.Integer)
lat = db.Column(db.DECIMAL(10, 5)) #??
lag = db.Column(db.DECIMAL(10, 5)) #??
photo_ref1 = db.Column(db.String(255))
photo_ref2 = db.Column(db.String(255))
photo_ref3 = db.Column(db.String(255))
photo_ref4 = db.Column(db.String(255))
photo_ref5 = db.Column(db.String(255))
photo_ref6 = db.Column(db.String(255))
photo_ref7 = db.Column(db.String(255))
photo_ref8 = db.Column(db.String(255))
photo_ref9 = db.Column(db.String(255))
photo_ref10 = db.Column(db.String(255))
photo_ref11 = db.Column(db.String(255))
photo_ref12 = db.Column(db.String(255))
photo_ref13 = db.Column(db.String(255))
photo_ref14 = db.Column(db.String(255))
photo_ref15 = db.Column(db.String(255))
userlike = db.relationship('User_like',
backref=db.backref('roll_number1'),
lazy='dynamic')
history = db.relationship('History',
backref=db.backref('roll_number2'),
lazy='dynamic')
comments = db.relationship('Comments',
backref=db.backref('roll_number3'),
lazy='dynamic')
pro2015 = db.relationship('Pro2015',
backref=db.backref('roll_number4'),
lazy='select',
uselist=False)
rank2017 = db.relationship('Rank2017',
backref=db.backref('roll_number5'),
lazy='select',
uselist=False)
class ErrorLog(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
latitude = db.Column(db.DECIMAL(10, 6))
longitude = db.Column(db.DECIMAL(10, 6))
time = db.Column(db.DateTime)
map_id = db.Column(db.Integer, db.ForeignKey('map.id'))
map = db.relationship('Map',
backref=db.backref('error_set', lazy='dynamic'))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
user = db.relationship('User',
backref=db.backref('error_set', lazy='dynamic'))
def __init__(self, latitude, longitude, user_id, flag):
self.latitude = latitude
self.longitude = longitude
self.user_id = user_id
self.time = datetime.now()
self.map_id = flag
def save(self):
db.session.add(self)
db.session.commit()
def delete(self):
db.session.delete(self)
db.session.commit()
class Facture(db.Model):
id = db.Column(db.Integer, primary_key=True)
code_commande = db.Column(db.String(128))
valeur = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
premier_payement = db.Column(db.DECIMAL(precision=10,
scale=2,
asdecimal=False),
default=0)
ref_payement_un = db.Column(db.String(200))
deuxieme_payement = db.Column(db.DECIMAL(precision=10,
scale=2,
asdecimal=False),
default=0)
ref_payement_deux = db.Column(db.String(200))
totalite = db.Column(db.Boolean, default=False)
ref_payement_totalite = db.Column(db.String(200))
datecommande = db.Column(db.Date, default=date.today())
statut = db.Column(db.Boolean, default=False)
annul = db.Column(db.Boolean, default=False)
tel = db.Column(db.String(128))
mail = db.Column(db.String(128))
adr = db.Column(db.String(128))
paniers = db.relationship('Panier',
backref='facture_paniers',
lazy='dynamic')
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return ' {} '.format(self.code_commande)
class Landpart2(db.Model):
__bind_key__ = "blbj_crawler"
__tablename__ = "blbj_土地网二层"
地块详情 = db.Column(db.Text, primary_key=True)
地块编号 = db.Column(db.Text)
拍卖开始时间 = db.Column(db.Date)
挂牌起始时间 = db.Column(db.Date)
挂牌截止时间 = db.Column(db.Date)
保证金到账截止时间 = db.Column(db.Date)
起始价 = db.Column(db.DECIMAL(15, 2))
竞得单位 = db.Column(db.Text)
成交时间 = db.Column(db.Date)
成交价 = db.Column(db.DECIMAL(15, 2))
出让面积 = db.Column(db.DECIMAL(10, 2))
所属行政区 = db.Column(db.Text)
出让年限 = db.Column(db.Text)
是否有底价 = db.Column(db.Text)
最高限价 = db.Column(db.DECIMAL(15, 2))
最高报价 = db.Column(db.DECIMAL(15, 2))
最高报价单位 = db.Column(db.Text)
报名开始时间 = db.Column(db.Date)
报名截止时间 = db.Column(db.Date)
竞买人条件 = db.Column(db.Text)
联系人 = db.Column(db.Text)
联系人电话 = db.Column(db.Text)
def __repr__(self):
return "<Landpart2 %r>" % self.地块详情
class RecentTips(db.Model):
__tablename__ = 'tips_stats_recent'
__bind_key__ = 'question'
__table_args__ = {"schema": "public"}
id = db.Column(db.Integer, primary_key=True)
# identify forum, post, and comment
subcommon_id = db.Column(db.Integer,
db.ForeignKey('public.subforum_subforum.id'))
post_id = db.Column(db.Integer)
comment_id = db.Column(db.Integer)
created = db.Column(db.TIMESTAMP(), default=datetime.utcnow())
subcommon_name = db.Column(db.String(140))
created_user_id = db.Column(db.Integer)
created_user_name = db.Column(db.String(140))
recieved_user_id = db.Column(db.Integer)
recieved_user_name = db.Column(db.String(140))
# amounts
currency_type = db.Column(db.Integer)
amount_btc = db.Column(db.DECIMAL(20, 8))
amount_bch = db.Column(db.DECIMAL(20, 8))
amount_xmr = db.Column(db.DECIMAL(20, 12))
amount_usd = db.Column(db.DECIMAL(20, 2))
class OriginalInvoicesHistory(db.Model):
id = db.Column(db.Integer, primary_key=True)
dollar = db.Column(db.DECIMAL(18,2), unique=True)
amount = db.Column(db.DECIMAL(18,2), unique=True)
previous_amount = db.Column(db.DECIMAL(18,2), unique=True)
total_credits = db.Column(db.DECIMAL(18,2), unique=True)
total_debits = db.Column(db.DECIMAL(18,2), unique=True)
payment_date = db.Column(db.DATE, unique=True)
effective_monthly_rate = db.Column(db.DECIMAL(18,2), unique=True)
effective_yearly_rate = db.Column(db.DECIMAL(18,2), unique=True)
rotational_rate = db.Column(db.DECIMAL(18,2), unique=True)
rotational_cash_rate = db.Column(db.DECIMAL(18,2), unique=True)
fine_rate = db.Column(db.DECIMAL(18,2), unique=True)
card_id = db.Column(db.Integer, db.ForeignKey('card.id'),
nullable=False)
def __init__(self, dollar, amount, previous_amount,
total_credits, total_debits, payment_date,
effective_monthly_rate, effective_yearly_rate,
rotational_rate, rotational_cash_rate, fine_rate):
self.dollar = dollar
self.amount = amount
self.previous_amount = previous_amount
self.total_credits = total_credits
self.total_debits = total_debits
self.payment_date = payment_date
self.effective_monthly_rate = effective_monthly_rate
self.effective_yearly_rate = effective_yearly_rate
self.rotational_rate = rotational_rate
self.rotational_cash_rate = rotational_cash_rate
self.fine_rate = fine_rate
def __repr__(self):
return '<OriginalInvoicesHistory %r>' % self.id
class TransactionsBchTest(db.Model):
__tablename__ = 'bch_transactions_test'
__bind_key__ = 'avengers'
__table_args__ = {"schema": "avengers_wallet_bch_test"}
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
category = db.Column(db.INTEGER)
user_id = db.Column(db.INTEGER, db.ForeignKey('avengers_user.users.id'))
senderid = db.Column(db.INTEGER)
confirmations = db.Column(db.INTEGER)
txid = db.Column(db.TEXT)
amount = db.Column(db.DECIMAL(20, 8))
blockhash = db.Column(db.TEXT)
timeoft = db.Column(db.INTEGER)
timerecieved = db.Column(db.INTEGER)
commentbch = db.Column(db.TEXT)
otheraccount = db.Column(db.INTEGER)
address = db.Column(db.TEXT)
fee = db.Column(db.DECIMAL(20, 8))
created = db.Column(db.TIMESTAMP(), default=datetime.utcnow())
balance = db.Column(db.DECIMAL(20, 8))
orderid = db.Column(db.INTEGER)
confirmed = db.Column(db.INTEGER)
confirmed_fee = db.Column(db.DECIMAL(20, 8))
digital_currency = db.Column(db.INTEGER)
class FlaskModel(db.Model):
# Initialize database columns attributes and the data type of the data in the database
db_index = db.Column(db.Integer, primary_key = True)
stock_ticker = db.Column(db.VARCHAR(32))
stock_description = db.Column(db.VARCHAR(128))
current_holding = db.Column(db.DECIMAL(10, 3))
current_stock_price = db.Column(db.DECIMAL(10, 2))
entry_stock_price = db.Column(db.DECIMAL(10, 2))
# Constructor for the Data
def __init__(self, db_index, stock_ticker, stock_description, current_holding,
current_stock_price, entry_stock_price):
self.db_index = db_index
self.stock_ticker = stock_ticker
self.stock_description = stock_description
self.current_holding = current_holding
self.current_stock_price = current_stock_price
self.entry_stock_price = entry_stock_price
pass
# Serialization of the Data for JSON
@property
def serialize(self):
return {
'Stock' : self.stock_ticker,
'Stock Description' : self.stock_description,
'Stock Holdings' : self.current_holding,
'Current Price' : self.current_stock_price,
'Entry Price' : self.entry_stock_price
}
class PayoutSubOwner(db.Model):
__tablename__ = 'avengers_tips_payout_subowner'
__bind_key__ = 'avengers'
__table_args__ = {"schema": "avengers_tips"}
id = db.Column(db.Integer, primary_key=True)
created = db.Column(db.TIMESTAMP(), default=datetime.utcnow())
# identify forum, post, and comment
subcommon_id = db.Column(db.Integer)
subcommon_name = db.Column(db.String(140))
post_id = db.Column(db.Integer)
comment_id = db.Column(db.Integer)
sub_owner_user_id = db.Column(db.Integer)
sub_owner_user_name = db.Column(db.String(140))
tipper_user_id = db.Column(db.Integer)
tipper_user_name = db.Column(db.String(140))
# amounts
currency_type = db.Column(db.Integer)
amount_btc = db.Column(db.DECIMAL(20, 8))
amount_bch = db.Column(db.DECIMAL(20, 8))
amount_xmr = db.Column(db.DECIMAL(20, 12))
amount_usd = db.Column(db.DECIMAL(20, 2))
class Btc_TransactionsBtc(db.Model):
__tablename__ = 'btc_transactions'
__bind_key__ = 'clearnet'
__table_args__ = {"schema": "public"}
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.INTEGER)
category = db.Column(db.INTEGER)
senderid = db.Column(db.INTEGER)
confirmations = db.Column(db.INTEGER)
txid = db.Column(db.TEXT)
amount = db.Column(db.DECIMAL(20, 8))
blockhash = db.Column(db.TEXT)
timeoft = db.Column(db.INTEGER)
timerecieved = db.Column(db.INTEGER)
commentbtc = db.Column(db.TEXT)
otheraccount = db.Column(db.INTEGER)
address = db.Column(db.TEXT)
fee = db.Column(db.DECIMAL(20, 8))
created = db.Column(db.TIMESTAMP(), default=datetime.utcnow())
balance = db.Column(db.DECIMAL(20, 8))
orderid = db.Column(db.INTEGER)
confirmed = db.Column(db.INTEGER)
confirmed_fee = db.Column(db.DECIMAL(20, 8))
digital_currency = db.Column(db.INTEGER)
class LinhasFicha(db.Model):
__tablename__ = 'linhas_ficha'
id = db.Column(db.VARCHAR(36),
primary_key=True,
default=Util.__generate_id__())
ciclo1 = db.Column(db.DECIMAL(precision=5, scale=2), nullable=False)
ciclo2 = db.Column(db.DECIMAL(precision=5, scale=2), nullable=False)
ciclo3 = db.Column(db.DECIMAL(precision=5, scale=2), nullable=False)
ciclo4 = db.Column(db.DECIMAL(precision=5, scale=2), nullable=False)
aparelho_id = db.Column(db.VARCHAR(36),
db.ForeignKey('aparelho.id',
name='FK_linhasficha_aparelho'),
nullable=False)
ficha_id = db.Column(db.VARCHAR(36),
db.ForeignKey('ficha.id',
name='FK_linhasficha_ficha'),
nullable=False)
# Relationship
# one to one
aparelho = db.relationship('Aparelho',
backref=backref('linhas_ficha',
uselist=False,
lazy='joined'))
def __init__(self):
self.id = Util.__generate_id__()
class FutStats(db.Model):
__tablename__ = 'fut_stats'
id = db.Column(db.Integer, primary_key=True, comment="主键ID")
longdate = db.Column(db.Integer, comment="日期")
symbol = db.Column(db.String(64), comment="合约")
cq_stats = db.Column(db.DECIMAL(20, 4), comment="cq占比")
p_value = db.Column(db.DECIMAL(20, 4), comment="P值")
class TransactionsBtccash(db.Model):
__tablename__ = 'transactions_btccash'
__bind_key__ = 'wallet_btc_cash'
__table_args__ = {'useexisting': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
category = db.Column(db.INTEGER)
userid = db.Column(db.INTEGER)
confirmations = db.Column(db.INTEGER)
txid = db.Column(db.Text)
amount = db.Column(db.DECIMAL(20, 8))
blockhash = db.Column(db.Text)
timeoft = db.Column(db.INTEGER)
timerecieved = db.Column(db.INTEGER)
commentbtc = db.Column(db.Text)
otheraccount = db.Column(db.INTEGER)
address = db.Column(db.Text)
fee = db.Column(db.DECIMAL(20, 8))
created = db.Column(db.DATETIME)
balance = db.Column(db.DECIMAL(20, 8))
shard = db.Column(db.INTEGER)
orderid = db.Column(db.INTEGER)
confirmed = db.Column(db.INTEGER)
confirmed_fee = db.Column(db.DECIMAL(20, 8))
digital_currency = db.Column(db.INTEGER)
class Store(db.Model):
storeId = db.Column(db.Integer, autoincrement=True, primary_key=True)
storeName = db.Column(db.String(100), nullable=False)
country = db.Column(db.String(100), nullable=False)
state = db.Column(db.String(100), nullable=False)
city = db.Column(db.String(100), nullable=False)
street = db.Column(db.String(100), nullable=False)
zipCode = db.Column(db.String(10), nullable=False)
latitude = db.Column(db.DECIMAL(12, 9), nullable=False)
longitude = db.Column(db.DECIMAL(12, 9), nullable=False)
__table__args__ = (
db.UniqueConstraint(latitude, longitude)
)
products = db.relationship("Product", secondary="inventory")
creditUsers = db.relationship("User", secondary="credit_scheme")
usersMapped = db.relationship("User", secondary="user_store_map")
prepaidSchemes = db.relationship('PrepaidScheme',
backref=db.backref('store', cascade='all'),
lazy='dynamic')
subInventories = db.relationship('SubInventory',
backref=db.backref('store', cascade='all'),
lazy='dynamic')
paymentProcessings = db.relationship('PaymentProcessing',
backref=db.backref('store', cascade='all'),
lazy='dynamic')
def __repr__(self):
return "<Store {}>".format(self.storeName)
class Agorafeeholdings_btccash(db.Model):
__tablename__ = 'account_fee_holdings'
__bind_key__ = 'Agora_Market'
__table_args__ = {'useexisting': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True)
amount = db.Column(db.DECIMAL(20, 8))
timestamp = db.Column(db.DateTime, index=True)
total = db.Column(db.DECIMAL(20, 8))
class Volume(db.Model):
__tablename__ = 'volume'
id = db.Column(db.Integer, primary_key=True, comment="主键ID")
longdate = db.Column(db.Integer, comment="日期")
product = db.Column(db.String(64), comment="品种")
vol_mm = db.Column(db.Integer, comment="成交量")
vol_market = db.Column(db.DECIMAL(20, 2), comment="市场成交量")
vol_ptg = db.Column(db.DECIMAL(20, 4), comment="成交占比")
class btc_cash_Prices(db.Model):
__tablename__ = 'prices_btc_cash'
__bind_key__ = 'coin_prices'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
currency = db.Column(db.Text)
price = db.Column(db.DECIMAL(50, 2))
currency_id = db.Column(db.INTEGER)
percent_change_twentyfour = db.Column(db.DECIMAL(50, 2))
class Bch_Prices(db.Model):
__tablename__ = 'prices_btc_cash'
__bind_key__ = 'clearnet'
__table_args__ = {"schema": "public", 'extend_existing': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
price = db.Column(db.DECIMAL(50, 2))
currency_id = db.Column(db.INTEGER)
percent_change_twentyfour = db.Column(db.DECIMAL(50, 2))
class Admin_ClearnetFeeHoldingsBCH(db.Model):
__tablename__ = 'account_fee_holdings_btc_cash'
__bind_key__ = 'clearnet'
__table_args__ = {"schema": "public", 'extend_existing': True}
id = db.Column(db.Integer, primary_key=True,
autoincrement=True, unique=True)
amount = db.Column(db.DECIMAL(20, 8))
timestamp = db.Column(db.TIMESTAMP(), index=True)
total = db.Column(db.DECIMAL(20, 8))
class OptStats(db.Model):
__tablename__ = 'opt_stats'
id = db.Column(db.Integer, primary_key=True, comment="主键ID")
longdate = db.Column(db.Integer, comment="日期")
product = db.Column(db.String(64), comment="品种")
cq_stats = db.Column(db.DECIMAL(20, 4), comment="cq占比")
qr_stats = db.Column(db.DECIMAL(20, 4), comment="qr占比")
qr_receive = db.Column(db.Integer, comment="总询价数量")
qr_response = db.Column(db.Integer, comment="有效回应报价数量")
class Panier(db.Model):
id = db.Column(db.Integer, primary_key=True)
quantite = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
prix = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
montant = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
produit_id = db.Column(db.Integer,
db.ForeignKey('produit.id'),
nullable=False)
class Commandes(db.Model):
id = db.Column(db.Integer, primary_key=True)
qte = db.Column(db.Integer)
somme = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
prix_p = db.Column(db.DECIMAL(precision=10, scale=2, asdecimal=False))
produit_id = db.Column(db.Integer,
db.ForeignKey('produit.id'),
nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
class Agoraprofit(db.Model):
__tablename__ = 'account_profit_btc'
__bind_key__ = 'Agora_Market'
__table_args__ = {'useexisting': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True)
amount = db.Column(db.DECIMAL(20, 8))
order = db.Column(db.INTEGER)
timestamp = db.Column(db.DateTime, index=True)
total = db.Column(db.DECIMAL(20, 8))
class AgoraFee(db.Model):
__tablename__ = 'fees'
__bind_key__ = 'Agora_Market'
__table_args__ = {'useexisting': True}
id = db.Column(db.Integer, primary_key=True, autoincrement=True, unique=True)
btctrade = db.Column(db.DECIMAL(20, 8))
btc_cash_trade = db.Column(db.DECIMAL(20, 8))
itempurchase = db.Column(db.DECIMAL(20, 8))
