class VoicemailMessage(Base): __tablename__ = 'voicemail_messages' __table_args__ = (Index('index', 'mailboxuser', 'mailboxcontext', 'read'), ) id = Column(BIGINT(20), primary_key=True, unique=True) msgnum = Column(INTEGER(4), nullable=False) dir = Column(String(128), nullable=False, index=True) context = Column(String(80), nullable=False) macrocontext = Column(String(80)) callerid = Column(String(40), nullable=False) origtime = Column(String(40), nullable=False) duration = Column(String(20), nullable=False) mailboxuser = Column(INTEGER(11), nullable=False) mailboxcontext = Column(String(80), nullable=False) recording = Column(MEDIUMBLOB, nullable=False) content = Column(MEDIUMTEXT) label = Column(String(30), nullable=False) read = Column(TINYINT(1), nullable=False) answered = Column(TINYINT(1), nullable=False) flag = Column(String(10), nullable=False) deleted = Column(TINYINT(1), nullable=False) voicemail_messagescol = Column(String(45)) msg_id = Column(String(40))
class MAC_PARAMETER(Base): """ 宏观经济数据-编码表 """ __tablename__ = "MAC_PARAMETER" id = Column(Integer, primary_key=True) class_code = Column(Integer, nullable=False) class_name = Column(String(100), nullable=False) parameter_code = Column(Integer, nullable=False) parameter_name = Column(String(100), nullable=False) description = Column(String(200)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
class CobraTaskInfo(db.Model): """ Tasks for project """ __tablename__ = 'tasks' __table_args__ = ({"mysql_charset": "utf8mb4"}) id = db.Column(INTEGER(unsigned=True), primary_key=True, autoincrement=True, nullable=False) target = db.Column(db.String(255), nullable=False, default=None) branch = db.Column(db.String(64), nullable=False, default=None) scan_way = db.Column(SMALLINT(6), nullable=False, default=None) new_version = db.Column(db.String(40), nullable=False, default=None) old_version = db.Column(db.String(40), nullable=False, default=None) time_consume = db.Column(db.Integer, nullable=False, default=None) time_start = db.Column(db.Integer, nullable=False, default=None) time_end = db.Column(db.Integer, nullable=False, default=None) file_count = db.Column(db.Integer, nullable=False, default=None) code_number = db.Column(db.Integer, nullable=False, default=None) status = db.Column(TINYINT(4), nullable=False, default=0, index=True) created_at = db.Column(db.DateTime, nullable=False, default=None) updated_at = db.Column(db.DateTime, nullable=False, default=None) def __init__(self, target, branch, scan_way, new_version, old_version, time_consume, time_start, time_end, file_count, code_number, status, created_at=None, updated_at=None): self.target = target self.branch = branch self.scan_way = scan_way self.new_version = new_version self.old_version = old_version self.time_consume = time_consume self.time_start = time_start self.time_end = time_end self.file_count = file_count self.code_number = code_number self.status = status self.created_at = created_at self.updated_at = updated_at current_time = time.strftime('%Y-%m-%d %X', time.localtime()) if created_at is None: self.created_at = current_time else: self.created_at = created_at if updated_at is None: self.updated_at = current_time else: self.updated_at = updated_at def __repr__(self): return '<task_info %r - %r>' % (self.id, self.target)
class Index(db.Model): __tablename__ = 'indexs' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64)) url = db.Column(db.String(255)) html = db.Column(LONGTEXT) status = db.Column(TINYINT(3), default=0) dateline = db.Column(db.DateTime(), default=datetime.utcnow) lists = db.relationship('List', backref='list', lazy='dynamic') @staticmethod def index_add(name): collect = create_collect(name) url = collect.base_url html = collect.spi.get_source(url) if html: index_list = collect.spi.get_index_list(html) # print(index_list) for url, name in index_list: real_url = collect.base_url + url index = Index.query.filter_by(url=real_url).first() if index is None: index = Index(name=name, url=real_url) db.session.add(index) db.session.commit() print('index_add: Success.') else: print('index_add: Html is None.') @staticmethod def index_edit(name): collect = create_collect(name) index_list = Index.query.filter_by(status=0).all() # print(index_list) if index_list: for index in index_list: html = collect.spi.get_source(index.url) if html: index.html = html index.status = 1 db.session.add(index) db.session.commit() print('index_edit: Success.') else: print('index_edit: Index_list is None.') def __repr__(self): return '<Index %r>' % self.name
class HtAdmin(Base): __tablename__ = 'ht_admin' id = Column(INTEGER(11), primary_key=True) role_id = Column(INTEGER(11), nullable=False, server_default=text("'0'"), comment='角色ID') name = Column(String(30), nullable=False, server_default=text("''"), comment='admin888') pwd = Column(CHAR(32), nullable=False, server_default=text("''"), comment='admin') mobile = Column(String(20), nullable=False, server_default=text("''"), comment='手机号') email = Column(String(30), nullable=False, server_default=text("''"), comment='邮箱') avatar = Column(String(150), nullable=False, server_default=text("''"), comment='头像') status = Column(TINYINT(1), nullable=False, server_default=text("'0'"), comment='用户状态 0:正常; 1:禁用 ;2:未验证') login_time = Column(INTEGER(11), nullable=False, server_default=text("'0'"), comment='登录时间') add_time = Column(INTEGER(11), nullable=False, server_default=text("'0'"), comment='添加时间') update_time = Column(INTEGER(11), nullable=False, server_default=text("'0'"), comment='更新时间') delete_time = Column(INTEGER(11), nullable=False, server_default=text("'0'"), comment='删除时间')
class MAC_RESOURCES_AREA_WASTE_GAS_EMISSION(Base): """ 各地区废气排放及处理情况表 """ __tablename__ = "MAC_RESOURCES_AREA_WASTE_GAS_EMISSION" 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) SO2_discharged = Column(DECIMAL(20, 4)) NO_discharged = Column(DECIMAL(20, 4)) soot_discharged = Column(DECIMAL(20, 4)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
class PaymentHistory(db.Model): __table_args__ = ({'mysql_engine': 'InnoDB', 'mysql_charset': 'utf8'}) gmo_credit_id = db.Column(db.Integer, primary_key=True, autoincrement=False) gmo_credit_mod_datetime = db.Column(db.DATETIME, primary_key=True) payment_datetime = db.Column(db.DATETIME, nullable=False) member_id = db.Column(db.VARCHAR(20), nullable=False) user_id = db.Column(db.Integer, nullable=False) device = db.Column(db.VARCHAR(10), nullable=False, default='Others') project_id = db.Column(db.Integer, nullable=False) item_id = db.Column(db.Integer, nullable=False) payment_type = db.Column(db.Integer, nullable=False) changed_status = db.Column(TINYINT(1), nullable=False, default=0) amount = db.Column(db.Integer, nullable=False) reg_datetime = db.Column(db.DATETIME, default=datetime.now)
class Books(Base): __tablename__ = "books" id_ = Column('id', Integer, primary_key=True) name = Column('name', String(255)) volume = Column('volume', String(255)) author = Column('author', String(255)) publisher = Column('publisher', String(255)) memo = Column('memo', Text()) create_date = Column('create_date', DATETIME, server_default=text('NOW()'), nullable=False) delFlg = Column('del', TINYINT(4), server_default=text('0'), nullable=False)
class T2ProcessedSighting(Base): __tablename__ = 't2_processed_sighting' __table_args__ = (Index('survey_id_taxon_id', 'survey_id', 'taxon_id'), ) id = Column(Integer, primary_key=True) survey_id = Column(ForeignKey('t2_processed_survey.id', ondelete='CASCADE'), nullable=False) taxon_id = Column(ForeignKey('taxon.id'), nullable=False, index=True) count = Column(Float(asdecimal=True), nullable=False) unit_id = Column(ForeignKey('unit.id'), nullable=False, index=True) pseudo_absence = Column(TINYINT(1), nullable=False) survey = relationship('T2ProcessedSurvey') taxon = relationship('Taxon') unit = relationship('Unit')
class WalletEosGatherModel(BaseModel): __tablename__ = "wallet_eos_gather" sub_index = Column(BigInteger, nullable=False, comment="归集账户 子钱包索引") sub_public_address = Column(String(128), unique=True, nullable=False, server_default="", comment="归集账户 子地址") change_index = Column(String(255), nullable=False, server_default="", comment="归集账户 change index") acct_public_key_aes = Column(String(255), nullable=False, server_default="", comment="归集账户 主公钥AES加密防止以后有多个助记词生成主秘钥同时使用") coin_id = Column(String(128), nullable=False, server_default="", comment="归集账户 货币id") account_id = Column(String(64), nullable=False, server_default="", comment="归集账户 主账户ID") status = Column(TINYINT(1), nullable=False, server_default="1", comment="归集账户 状态") amount = Column(Numeric(36, 18), default=get_decimal('0', 18), nullable=False, server_default="0.000000000000000000", comment="地址上的钱") amount_change = Column(Numeric(36, 18), default=get_decimal('0', 18), nullable=False, server_default="0.000000000000000000", comment="待找零金额") amount_frozen = Column(Numeric(36, 18), default=get_decimal('0', 18), nullable=False, server_default="0.000000000000000000", comment="已支付未确认到账") desc = Column(String(255), nullable=False, server_default="", comment="归集账户 描述") def __init__(self, *args, **kwargs): super().__init__(*args, **kwargs)
class BuoyStatusInfo(Base): __tablename__ = 'nt_plfbztxxb' ID = Column(BigInteger, primary_key=True, autoincrement=True) PLFBQZH = Column(Unicode(64), nullable=False) GCRQSJ = Column(DateTime) JMZT = Column(SMALLINT(unsigned=True)) ZBWD = Column(DOUBLE) DYDY = Column(DOUBLE) ZTHGJD = Column(DOUBLE) ZTFYJD = Column(DOUBLE) ZTFWJD = Column(DOUBLE) CXCQW = Column(TINYINT(unsigned=True)) KMGGLW = Column(TINYINT(unsigned=True)) ZTSJJSW = Column(TINYINT(unsigned=True)) ZTSJYXW = Column(TINYINT(unsigned=True)) GPSSJJSW = Column(TINYINT(unsigned=True)) GPSJSSJYXW = Column(TINYINT(unsigned=True)) GPSDWSJYXW = Column(TINYINT(unsigned=True)) YXJSWXS = Column(TINYINT(unsigned=True)) JD = Column(DOUBLE) WD = Column(DOUBLE) __table_args__ = (UniqueConstraint(PLFBQZH, GCRQSJ, name="station_sampling_process"), ) @classmethod def get_unique(cls, session, override=False, **fieldnames): cache = session._unique_cache = getattr(session, '_unique_cache', {}) key = (cls, fieldnames['PLFBQZH'], fieldnames['GCRQSJ']) o = cache.get(key) if o is None: if override: session.query(cls).filter( cls.PLFBQZH == fieldnames['PLFBQZH'], cls.GCRQSJ == fieldnames['GCRQSJ']).delete() o = cls(**fieldnames) session.add(o) else: o = session.query(cls).filter_by( PLFBQZH=fieldnames['PLFBQZH'], GCRQSJ=fieldnames['GCRQSJ']).first() if o is None: o = cls(**fieldnames) session.add(o) cache[key] = o
class MAC_LIFE_EXPECT(Base): """ 各地区人口平均预期寿命表 """ __tablename__ = "MAC_LIFE_EXPECT" 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) life_expect = Column(DECIMAL(20, 8)) male_life_expect = Column(DECIMAL(20, 8)) female_life_expect = Column(DECIMAL(20, 8)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
class FileActionRequest(Base): __tablename__ = 'file_action_request' id = Column(INTEGER(11), primary_key=True) data_product_id = Column(ForeignKey('data_product.id', onupdate='CASCADE'), nullable=False, index=True) action_id = Column(ForeignKey('file_action.id', onupdate='CASCADE'), nullable=False, index=True) requested_at = Column(DateTime, nullable=False) completed_at = Column(DateTime) success = Column(TINYINT(1), nullable=False) action = relationship('FileAction') data_product = relationship('DataProduct')
class NHMInstallationFacility(Base): __tablename__ = 'NHM_Installation_Facilities' Installation_Description = Column(Text) Installation_Short_Name = Column( ForeignKey('Infrastructures_Installations.Installation_Short_Name'), index=True) Facility_ID = Column(Integer, primary_key=True) Response_Type = Column(String(255)) Category_ID = Column(ForeignKey('NHM_Facility_Categories.Category_ID'), index=True) Help = Column(Text) facility_closed = Column(TINYINT(1)) NHM_Facility_Category = relationship('NHMFacilityCategory') Infrastructures_Installation = relationship('InfrastructuresInstallation')
class MAC_AREA_CPI_MONTH(Base): """ 分地区居民消费价格指数 """ __tablename__ = "MAC_AREA_CPI_MONTH" id = Column(Integer, primary_key=True) stat_month = Column(String(20), nullable=False) area_code = Column(String(20), nullable=False) area_name = Column(String(100), nullable=False) item_name = Column(String(128), nullable=False) item_value = Column(DECIMAL(10, 4)) status = Column(TINYINT(display_width=4), default=0) addTime = Column(TIMESTAMP, default=datetime.datetime.now) modTime = Column(TIMESTAMP)
class CO2EIIPUBLISHING(Base): __tablename__ = "CO2EII_PUBLISHING" __table_args__ = ( Index("SETTLEMENTDATE_2", "SETTLEMENTDATE", "REGIONID", unique=True), ) id = Column(INTEGER(11), primary_key=True) CONTRACTYEAR = Column(SMALLINT(6), index=True) WEEKNO = Column(TINYINT(4), index=True) SETTLEMENTDATE = Column(DateTime, index=True) REGIONID = Column(ForeignKey("nemweb_meta.REGIONID.id"), index=True) TOTAL_SENT_OUT_ENERGY = Column(DECIMAL(14, 8)) TOTAL_EMISSIONS = Column(DECIMAL(14, 8)) CO2E_INTENSITY_INDEX = Column(DECIMAL(5, 4)) REGIONID1 = relationship("REGIONID")
class User(db.Model): __tablename__ = f"{Base.DATABASE_TABLE_PREFIX}user" user_id = db.Column(INTEGER(10, unsigned=True), primary_key=True) login = db.Column(db.String(50), unique=True, nullable=False) password = db.Column(db.String(100), nullable=False) salt = db.Column(db.String(100), nullable=False) name = db.Column(db.String(100), nullable=False) email = db.Column(db.String(255), unique=True, nullable=False) website = db.Column(db.String(255), nullable=True) timezone = db.Column(db.String(50), nullable=True) lastlogin = db.Column(db.TIMESTAMP, nullable=True) lastloginattempt = db.Column(db.TIMESTAMP, nullable=True) failedloginattempts = db.Column(INTEGER(11), nullable=False, server_default=text("0")) remembertoken = db.Column(db.String(100), nullable=True) voided = db.Column(TINYINT(1), nullable=False, server_default=text("0"))
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)) status = Column(TINYINT(display_width=4), default=0) addTime = Column(TIMESTAMP, default=datetime.datetime.now) modTime = Column(TIMESTAMP)
class QqmusicSong(Base): __tablename__ = 'qqmusic_song' __table_args__ = (Index('i_', 'id', 'epoch'), ) id = Column(String(64), primary_key=True, index=True) epoch = Column(String(32)) web_id = Column(BIGINT(22)) web_mid = Column(String(60)) rank_list_id = Column(String(32)) star = Column(BIGINT(20)) bullet_num = Column(BIGINT(40)) comment_num = Column(BIGINT(40), server_default=text("'0'")) status = Column(TINYINT(4)) createtime = Column( TIMESTAMP, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"))
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)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
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)) status = Column(TINYINT(display_width=4), default=0) addTime = Column(TIMESTAMP, default=datetime.datetime.now) modTime = Column(TIMESTAMP)
def get_user_fans_table(user_id): shard_id = int(user_id) / constants.DB_USER_RELATION_SHARD_NUM table = user_fans_tables.get(shard_id) if table is None: table = Table('user_fans_%d' % shard_id, meta, Column('id', Integer, primary_key=True), Column('user_id', BigInteger, nullable=False), Column('fans_user_id', BigInteger, nullable=False), Column('created', DateTime, nullable=False), Column('parent_id', BigInteger, nullable=False, server_default="0"), Column('notification', TINYINT(1), nullable=False, default=1), UniqueConstraint('user_id', 'fans_user_id', name='unique_2_user_id'), mysql_engine='InnoDB') table.create(checkfirst=True) user_fans_tables[shard_id] = table return table
class DataForm(Base): __tablename__ = 'data_forms' id = Column(BigInteger, nullable=False, server_default=text("'0'")) order_num = Column(BigInteger, server_default=text("'0'")) table_name = Column(String(255)) form_name = Column(String(250), primary_key=True) description = Column(Text) selected = Column(TINYINT) val_start_position = Column(BigInteger, server_default=text("'0'")) val_end_position = Column(BigInteger, server_default=text("'0'")) elem_code_location = Column(String(255)) sequencer = Column(String(50)) entry_mode = Column(TINYINT(2), nullable=False, server_default=text("'00'"))
class MAC_FISCAL_CENTRAL_REVENUE_YEAR(Base): """ 中央和地方财政主要收入项目情况表(年度) """ __tablename__ = "MAC_FISCAL_CENTRAL_REVENUE_YEAR" id = Column(Integer, primary_key=True) stat_year = Column(String(4), nullable=False) item_id = Column(String(10), nullable=False) item_name = Column(String(128), nullable=False) revenue = Column(DECIMAL(20, 4)) central_revenue = Column(DECIMAL(20, 4)) local_revenue = Column(DECIMAL(20, 4)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
class T2Sighting(Base): __tablename__ = 't2_sighting' id = Column(Integer, primary_key=True) survey_id = Column(ForeignKey('t2_survey.id', ondelete='CASCADE'), nullable=False, index=True) taxon_id = Column(ForeignKey('taxon.id'), nullable=False, index=True) count = Column(Float(asdecimal=True)) unit_id = Column(ForeignKey('unit.id'), index=True) breeding = Column(TINYINT(1)) comments = Column(Text) survey = relationship('T2Survey') taxon = relationship('Taxon') unit = relationship('Unit')
class TblLadderSeason(BaseModel): __tablename__ = 'tblLadderSeason' ladder_id = Column(ForeignKey('tblLadder.ladder_id'), nullable=False, index=True, primary_key=True) season = Column(INTEGER(6), nullable=False, index=True) active = Column(TINYINT(1), server_default=text("'1'")) cat_id = Column(ForeignKey('tblClassification.cat_id'), nullable=False, index=True) overall_validity = Column(Enum('all', 'ftv', 'round'), nullable=False, server_default=text("'ftv'")) validity_param = Column(Float, nullable=False)
class T2UltrataxonSighting(Base): __tablename__ = 't2_ultrataxon_sighting' sighting_id = Column(ForeignKey('t2_sighting.id', ondelete='CASCADE'), primary_key=True, nullable=False) taxon_id = Column(ForeignKey('taxon.id'), primary_key=True, nullable=False, index=True) range_id = Column(ForeignKey('range.id'), nullable=False, index=True) generated_subspecies = Column(TINYINT(1), nullable=False) range = relationship('Range') sighting = relationship('T2Sighting') taxon = relationship('Taxon')
class EventsNotificationRules(db.Model): __tablename__ = 'events_notification_rules' id = db.Column(db.Integer, primary_key=True, autoincrement=True) notification_id = db.Column(TINYINT(11), primary_key=True) # rule_condition = db.Column(db.Integer, db.ForeignKey('events_notification_conditions_data.condition_id'), primary_key=True) rule_condition = db.Column(db.Integer, primary_key=True) rule_operator = db.Column(db.Text) rule_value = db.Column(db.Text) notify_data = db.relationship('EventsNotificationData') conditions = db.relationship('EventsNotificationConditions') def __repr__(self): return '[notification_id] %r, [rule_condition] %r, [rule_operator] %r, [rule_value] %r, [notify_data] %r' \ % (self.notification_id,self.rule_condition,self.rule_operator,self.rule_value,self.notify_data)
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)) status = Column(TINYINT(display_width=4), default=0) addtime = Column(TIMESTAMP, default=datetime.datetime.now) modtime = Column(TIMESTAMP)
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)) status = Column(TINYINT(display_width=4), default=0) addTime = Column(TIMESTAMP, default=datetime.datetime.now) modTime = Column(TIMESTAMP)