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