class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
role = db.Column(db.String(150))
email = db.Column(db.String(150), unique=True)
password = db.Column(db.String(150))
firstName = db.Column(db.String(150))
settings = db.Column(JSON)
value = db.Column(DECIMAL(38, 15))
change24h = db.Column(DECIMAL(16, 4))
change7d = db.Column(DECIMAL(16, 4))
change30d = db.Column(DECIMAL(16, 4))
currencies = db.relationship('Currency', backref=db.backref('user'))
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
class Ingredient(Base):
__tablename__ = 'ingredients'
id = Column(INTEGER(11), primary_key=True)
description = Column(VARCHAR(256), nullable=False)
stock = Column(DECIMAL(precision=10, scale=2, unsigned=True,
zerofill=True),
nullable=False)
unit = Column(VARCHAR(50), nullable=False)
cost = Column(DECIMAL(precision=10, scale=2, unsigned=True, zerofill=True),
nullable=False)
low_threshold = Column(INTEGER(3), nullable=False)
def __init__(self,
description='New Item',
stock=0.0,
unit='oz',
cost=0.00,
low_threshold=100):
self.description = description
self.stock = stock
self.unit = unit
self.cost = cost
self.low_threshold = low_threshold
def __repr__(self):
return '<Ingredient %r>' % (self.description)
class STK_SHAREHOLDER_TOP10(Base):
__tablename__ = 'STK_SHAREHOLDER_TOP10'
id = Column(Integer, primary_key=True)
company_name = Column(String(100), nullable=False, comment="公司名称")
company_id = Column(Integer, nullable=False, comment="公司ID")
code = Column(String(12), nullable=False, comment="股票代码")
end_date = Column(Date, nullable=False, comment="截止日期")
pub_date = Column(Date, nullable=False, comment="公告日期")
change_reason_id = Column(Integer, comment="变动原因编码")
change_reason = Column(String(120), comment="变动原因")
shareholder_rank = Column(Integer, nullable=False, comment="股东名次")
shareholder_name = Column(String(200), comment="股东名称")
shareholder_name_en = Column(String(200), comment="股东名称(英文)")
shareholder_id = Column(Integer, comment="股东ID")
shareholder_class_id = Column(Integer, comment="股东编码类别")
shareholder_class = Column(String(150), comment="股东类别")
share_number = Column(DECIMAL(20, 4), comment="持股数量(股)")
share_ratio = Column(DECIMAL(10, 4), comment="持股比例(%)")
sharesnature_id = Column(Integer, comment="股份性质编码")
sharesnature = Column(String(120), comment="股份性质")
share_pledge_freeze = Column(DECIMAL(10, 4), comment="股份质押冻结数量")
share_pledge = Column(DECIMAL(10, 4), comment="股份质押数量")
share_freeze = Column(DECIMAL(10, 4), comment="股份冻结数量")
class MAC_INDUSTRY_AREA_AGR_OUTPUT_VALUE_QUARTER(Base):
"""
分地区农林牧渔业总产值表(季度累计)
"""
__tablename__ = "MAC_INDUSTRY_AREA_AGR_OUTPUT_VALUE_QUARTER"
id = Column(Integer, primary_key=True)
stat_quarter = Column(String(20), nullable=False)
area_code = Column(String(20), nullable=False)
area_name = Column(String(100), nullable=False)
total = Column(DECIMAL(20, 4))
farming = Column(DECIMAL(20, 4))
forestry = Column(DECIMAL(20, 4))
animal_husbandry = Column(DECIMAL(20, 4))
fishery = Column(DECIMAL(20, 4))
status = Column(TINYINT(display_width=4), default=0)
addtime = Column(TIMESTAMP, default=datetime.datetime.now)
modtime = Column(TIMESTAMP)
@property
def update_keys(self):
return ["total", "farming", "forestry", "animal_husbandry", "fishery"]
@property
def filter_keys(self):
return ["stat_quarter", "area_code"]
class ComponentsComponent(Base):
__tablename__ = 'components_component'
id = Column(INTEGER(11), primary_key=True, index=True)
category = Column(VARCHAR(50))
code = Column(VARCHAR(50), unique=True)
compoosition = Column(VARCHAR(50))
description = Column(LONGTEXT)
image = Column(VARCHAR(100))
measure_unit = Column(VARCHAR(50))
name = Column(VARCHAR(140))
name_de = Column(VARCHAR(140))
name_en = Column(VARCHAR(140))
name_es = Column(VARCHAR(140))
name_fr = Column(VARCHAR(140))
name_it = Column(VARCHAR(140))
name_pl = Column(VARCHAR(140))
name_pt = Column(VARCHAR(140))
name_ru = Column(VARCHAR(140))
position = Column(VARCHAR(50))
price = Column(DECIMAL(10, 4))
price_insystem = Column(DECIMAL(10, 4))
product = Column(VARCHAR(50))
weight = Column(DECIMAL(10, 4))
is_active = Column(TINYINT(1))
name_ko = Column(VARCHAR(140))
is_reportable = Column(TINYINT(1))
is_saleable = Column(TINYINT(1))
class STK_SHARES_FROZEN(Base):
__tablename__ = 'STK_SHARES_FROZEN'
id = Column(Integer, primary_key=True)
company_id = Column(Integer, nullable=False, comment="公司ID")
company_name = Column(String(100), nullable=False, comment="公司名称")
pub_date = Column(Date, nullable=False, comment="公告日期")
code = Column(String(12), nullable=False, comment="股票代码")
frozen_person_id = Column(Integer, comment="被冻结当事人ID")
frozen_person = Column(String(100), comment="被冻结当事人")
frozen_reason = Column(String(600), comment="冻结事项")
frozen_share_nature_id = Column(Integer, comment="被冻结股份性质编码")
frozen_share_nature = Column(String(120), comment="被冻结股份性质")
frozen_number = Column(DECIMAL(20, 4), comment="冻结数量")
frozen_total_ratio = Column(DECIMAL(10, 4), comment="占总股份比例")
freeze_applicant = Column(String(100), comment="冻结申请人")
freeze_executor = Column(String(100), comment="冻结执行人")
change_reason_id = Column(Integer, comment="变动原因编码")
change_reason = Column(String(120), comment="变动原因")
start_date = Column(Date, comment="冻结起始日")
end_date = Column(Date, comment="冻结终止日")
unfrozen_date = Column(Date, comment="解冻日期")
unfrozen_number = Column(DECIMAL(20, 4), comment="累计解冻数量")
unfrozen_detail = Column(String(1000), comment="解冻处理说明")
class city(Base):
# 指定表名称
__tablename__ = "city"
# 主键
id = Column(INTEGER, primary_key=True, autoincrement=True)
#省份名称
province_name = Column(VARCHAR(64), comment='省份名称')
# 省份名称
city_name = Column(VARCHAR(64), comment='城市名称')
#今日新增加
today_confirm = Column(INTEGER, comment='今日新增加')
#累计确诊
total_confirm = Column(INTEGER, comment='累计确诊')
# 每日新增现有疑似
suspect = Column(INTEGER, comment="现有疑似")
# 累计死亡
dead = Column(INTEGER, comment="累计死亡")
#当前死亡率
deadRate = Column(DECIMAL(5, 2), comment='当前死亡率')
# 累计治愈
heal = Column(INTEGER, comment="累计治愈")
#治愈率
healRate = Column(DECIMAL(5, 2), comment='治愈率')
# 更新时间
create_dt = Column(DATETIME, comment="更新时间")
class WorldbankCountry(Base):
__tablename__ = 'worldbank_countries'
# Metadata
id = Column(VARCHAR(3), primary_key=True)
capitalCity = Column(VARCHAR(19))
incomeLevel = Column(VARCHAR(19))
iso2Code = Column(VARCHAR(2), index=True)
latitude = Column(DECIMAL(6, 4), index=True)
longitude = Column(DECIMAL(6, 4), index=True)
year = Column(INTEGER, primary_key=True)
lendingType = Column(VARCHAR(14))
name = Column(VARCHAR(54))
region = Column(VARCHAR(26), index=True)
adminregion = Column(VARCHAR(26))
# Data (note that long names have been truncated to 64 chars in line with MySQL rules)
age_dependency_ratio_pc_of_working_age_population = Column(FLOAT)
barro_lee_perce_of_popul_age_25_with_tertia_school_comple_tertia = Column(
FLOAT)
barro_lee_percentage_of_population_age_25_with_no_education = Column(FLOAT)
gdp_constant_2010_us_millions_seas_adj = Column(FLOAT)
gini_index_world_bank_estimate = Column(FLOAT)
life_expectancy_at_birth_total_years = Column(FLOAT)
mortality_rate_infant_per_1_000_live_births = Column(FLOAT)
population_total = Column(FLOAT)
poverty_headcoun_ratio_at_national_poverty_lines_pc_of_populatio = Column(
FLOAT)
rural_population_pc_of_total_population = Column(FLOAT)
urban_population_pc_of_total = Column(FLOAT)
class PhotoModel(db.Model):
__tablename__ = 'photos'
id = db.Column(BIGINT(20, unsigned=True), primary_key=True, index=True)
title = db.Column(db.String(80), unique=True, nullable=False)
# 위도 경도 고도 표시
captured_latitude = db.Column(DECIMAL(10, 7))
captured_longitude = db.Column(DECIMAL(10, 7))
captured_date = db.Column(DATE, nullable=False)
create_date = db.Column(TIMESTAMP,
default=datetime.datetime.utcnow,
server_default=text('CURRENT_TIMESTAMP'))
updated_date = db.Column(
TIMESTAMP,
default=datetime.datetime.utcnow,
server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'))
# join할 것
user_id = db.Column(BIGINT(20, unsigned=True),
db.ForeignKey('users.id'),
nullable=False)
def __init__(self, title, captured_latitude, captured_longitude,
captured_date, user_id):
self.title = title
self.captured_latitude = captured_latitude
self.captured_longitude = captured_longitude
self.captured_date = captured_date
self.user_id = user_id
class SubscribeServiceSnapshot(Base, BaseModelMixin):
__tablename__ = 'subscribe_service_snapshot'
__comment__ = '订购学术服务交易快照'
trade_order_uuid = Column(VARCHAR(36), nullable=False, comment='交易订单UUID')
user_uuid = Column(VARCHAR(36), nullable=False, comment='订购人UUID')
service_password = Column(VARCHAR(64), nullable=False, comment='初始服务密码')
auto_renew = Column(TINYINT,
nullable=False,
default=0,
comment='是否自动续费：0 - 否，1 - 是')
service_template_uuid = Column(VARCHAR(36),
nullable=False,
comment='学术服务模板UUID')
type = Column(TINYINT, nullable=False, comment='0 - 包月套餐，1 - 流量套餐')
title = Column(VARCHAR(64), nullable=False, comment='套餐名')
subtitle = Column(VARCHAR(64), nullable=False, comment='副标题')
description = Column(TEXT, nullable=False, comment='套餐描述')
package = Column(BIGINT, nullable=False, comment='总流量')
price = Column(DECIMAL(12, 2), nullable=False, comment='价格')
initialization_fee = Column(DECIMAL(12, 2), nullable=False, comment='初装费')
class STATUS(object):
# 初始化
INITIALIZATION = 0
# 有效
ACTIVATED = 1
# 已删除
DELETED = 2
class TYPE(object):
# 包月
MONTHLY = 0
# 流量
DATA = 1
def __init__(self, trade_order_uuid: str, user_uuid: str,
service_password: str, auto_renew: int,
service_template_uuid: str, service_type: int, title: str,
subtitle: str, description: str, package: int, price: float,
initialization_fee: float, *args, **kwargs):
super().__init__(*args, **kwargs)
self.trade_order_uuid = trade_order_uuid
self.user_uuid = user_uuid
self.service_password = service_password
self.auto_renew = auto_renew
self.service_template_uuid = service_template_uuid
self.type = service_type
self.title = title
self.subtitle = subtitle
self.description = description
self.package = package
self.price = price
self.initialization_fee = initialization_fee
self.status = 1
class Swap(Base):
__tablename__= "swap"
id = Column(BIGINT,primary_key=True)
percent = Column(DECIMAL(6,2))
total = Column(DECIMAL(8,2))
free = Column(DECIMAL(8,2))
create_date = Column(DATE)
create_time = Column(TIME)
create_dt = Column(DATETIME)
class Swap(Base):
__tablename__ = "swap" #指定表名称
id = Column(BIGINT,primary_key=True)
percent = Column(DECIMAL(6,2)) #内存使用百分比
total = Column(DECIMAL(8,2)) #内存总量
used = Column(DECIMAL(8,2)) #已使用内存
free = Column(DECIMAL(8, 2)) # 剩余内存
create_date = Column(DATE)
create_time = Column(TIME)
create_dt = Column(DATETIME)
def mapping_df_types(df):
type_dict = {}
for i, j in zip(df.columns, df.dtypes):
if "object" in str(j):
type_dict.update({i: VARCHAR(length=512)})
if "float" in str(j):
type_dict.update({i: DECIMAL(19, 2)})
if "int" in str(j):
type_dict.update({i: DECIMAL(19)})
return type_dict
class Mem(Base):
__tablename__ = "mem" # 表名称
id = Column(BIGINT, primary_key=True) # 主键编号
percent = Column(DECIMAL(6, 2)) # 内存使用率
total = Column(DECIMAL(8, 2)) # 内存总量
used = Column(DECIMAL(8, 2)) # 内存使用量
free = Column(DECIMAL(8, 2)) # 内存剩余量
create_date = Column(DATE) # 创建日期
create_time = Column(TIME) # 创建时间
create_dt = Column(DATETIME) # 创建日期时间
class Mem(Base):
__tablename__ = 'mem' # 指定表名
id = Column(BIGINT, primary_key=True)
percent = Column(DECIMAL(6, 2))
total = Column(DECIMAL(8, 2))
used = Column(DECIMAL(8, 2))
free = Column(DECIMAL(8, 2))
create_date = Column(DATE)
create_time = Column(TIME)
create_dt = Column(DATETIME)
class Swap(Base):
__tablename__ = "swap" # 表名称
id = Column(BIGINT, primary_key=True) # 主键编号
percent = Column(DECIMAL(6, 2)) # 交换分区使用率
total = Column(DECIMAL(8, 2)) # 交换分区总量
used = Column(DECIMAL(8, 2)) # 交换分区使用量
free = Column(DECIMAL(8, 2)) # 交换分区剩余量
create_date = Column(DATE) # 创建日期
create_time = Column(TIME) # 创建时间
create_dt = Column(DATETIME) # 创建日期时间
class MAC_GOLD_FOREIGN_RESERVE(Base):
"""
黄金和外汇储备
"""
__tablename__ = "MAC_GOLD_FOREIGN_RESERVE"
id = Column(Integer, primary_key=True)
stat_date = Column(String(10), nullable=False)
gold = Column(DECIMAL(10, 4))
foreign = Column(DECIMAL(10, 4))
class MAC_INDUSTRY_FIXED_INVEST(Base):
"""
分行业固定资产投资情况
"""
__tablename__ = "MAC_INDUSTRY_FIXED_INVEST"
id = Column(Integer, primary_key=True)
stat_month = Column(String(20), nullable=False)
item_name = Column(String(100), nullable=False)
investment_value = Column(DECIMAL(20, 4))
investment_perc = Column(DECIMAL(10, 4))
class MAC_REGISTERED_FIXED_INVESTMENT(Base):
"""
按注册类型登记分固定资产投资
"""
__tablename__ = "MAC_REGISTERED_FIXED_INVESTMENT"
id = Column(Integer, primary_key=True)
stat_month = Column(String(20), nullable=False)
item_name = Column(String(100), nullable=False)
investment_value = Column(DECIMAL(20, 4))
investment_perc = Column(DECIMAL(10, 4))
class MAC_RESOURCES_WATER_ENVIRONMENT(Base):
"""
水环境情况信息表
"""
__tablename__ = "MAC_RESOURCES_WATER_ENVIRONMENT"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
waste_water_discharge = Column(DECIMAL(20, 4))
COD_discharge = Column(DECIMAL(20, 4))
NH3_N2_discharge = Column(DECIMAL(20, 4))
class MAC_CONSUMER_BOOM_IDX(Base):
"""
消费者景气指数
"""
__tablename__ = "MAC_CONSUMER_BOOM_IDX"
id = Column(Integer, primary_key=True)
stat_month = Column(String(20), nullable=False)
expectation_idx = Column(DECIMAL(10, 4))
satisfaction_idx = Column(DECIMAL(10, 4))
confidence_idx = Column(DECIMAL(10, 4))
class Currency(db.Model):
id = db.Column(db.Integer, primary_key=True)
last_update = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
coin_id = db.Column(db.String(150))
name = db.Column(db.String(150))
symbol = db.Column(db.String(150))
quantity = db.Column(DECIMAL(38, 15))
value = db.Column(DECIMAL(38, 15))
cache_id = db.Column(db.Integer)
user_id = db.Column(db.Integer, db.ForeignKey(User.id))
class MAC_FISCAL_TOTAL_YEAR(Base):
"""
国家财政收支总额及增长速度表（年度）
"""
__tablename__ = "MAC_FISCAL_TOTAL_YEAR"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
revenue = Column(DECIMAL(20, 4))
expense = Column(DECIMAL(20, 4))
revenue_yoy = Column(DECIMAL(10, 4))
expense_yoy = Column(DECIMAL(10, 4))
class OrganisationLocation(Base):
"""This table is not in the orginal data. It contains all organisations and location
details where it has been possible to ascertain them."""
__tablename__ = "gtr_organisations_locations"
id = Column(VARCHAR(36), primary_key=True)
country_name = Column(VARCHAR(200))
country_alpha_2 = Column(VARCHAR(2))
country_alpha_3 = Column(VARCHAR(3))
country_numeric = Column(VARCHAR(3))
continent = Column(VARCHAR(2))
latitude = Column(DECIMAL(precision=8, scale=6))
longitude = Column(DECIMAL(precision=9, scale=6))
class MAC_ECONOMIC_BOOM_IDX(Base):
"""
宏观经济景气指数
"""
__tablename__ = "MAC_ECONOMIC_BOOM_IDX"
id = Column(Integer, primary_key=True)
stat_month = Column(String(20), nullable=False)
early_warning_idx = Column(DECIMAL(10, 4))
consistency_idx = Column(DECIMAL(10, 4))
leading_idx = Column(DECIMAL(10, 4))
lagging_idx = Column(DECIMAL(10, 4))
class MAC_RESOURCES_WATER_RESOURCES_YEAR(Base):
"""
全国水资源量年度信息表
"""
__tablename__ = "MAC_RESOURCES_WATER_RESOURCES_YEAR"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
total_amount = Column(DECIMAL(20, 4))
surface = Column(DECIMAL(20, 4))
ground = Column(DECIMAL(20, 4))
duplicated_measurement = Column(DECIMAL(10, 4))
per_amount = Column(DECIMAL(20, 4))
class Geographic(Base):
__tablename__ = 'geographic_data'
id = Column(VARCHAR(400, collation='utf8_bin'), primary_key=True) # composite key of city & country
city = Column(VARCHAR(200))
country = Column(VARCHAR(200))
country_alpha_2 = Column(VARCHAR(2))
country_alpha_3 = Column(VARCHAR(3))
country_numeric = Column(VARCHAR(3))
continent = Column(VARCHAR(2))
latitude = Column(DECIMAL(precision=8, scale=6))
longitude = Column(DECIMAL(precision=9, scale=6))
done = Column(BOOLEAN, default=False)
class MAC_TRADE_VALUE_LOCATION_YEAR(Base):
"""
各地区按经营单位所在地分货物进出口总额表(年度)
"""
__tablename__ = "MAC_TRADE_VALUE_LOCATION_YEAR"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
area_code = Column(String(20), nullable=False)
area_name = Column(String(100), nullable=False)
total_dollar = Column(DECIMAL(20, 4))
export_dollar = Column(DECIMAL(20, 4))
import_dollar = Column(DECIMAL(20, 4))
class MAC_AREA_UNEMPLOY(Base):
"""
分地区城镇登记失业率
"""
__tablename__ = "MAC_AREA_UNEMPLOY"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
area_code = Column(String(20), nullable=False)
area_name = Column(String(100), nullable=False)
unemploy = Column(DECIMAL(20, 4))
unemploy_rate = Column(DECIMAL(10, 4))
class MAC_RESOURCES_ECOLOGICAL_ENVIRONMENT(Base):
"""
生态环境情况信息表
"""
__tablename__ = "MAC_RESOURCES_ECOLOGICAL_ENVIRONMENT"
id = Column(Integer, primary_key=True)
stat_year = Column(String(4), nullable=False)
forest_area = Column(DECIMAL(20, 4))
forest_cover_rate = Column(DECIMAL(10, 4))
man_made_forest_area = Column(DECIMAL(20, 4))
nature_reserves_num = Column(DECIMAL(20, 4))
nature_reserves_area = Column(DECIMAL(20, 4))
