class TempFileList(Base): __tablename__ = 'tempfilelist' key = Column(CHAR(40, collation='utf8_unicode_ci'), primary_key=True) filename = Column(TEXT(charset='utf8'), nullable=False) content_type = Column(TEXT(charset='utf8'), nullable=False) created = Column(TIMESTAMP, default=datetime.utcnow) author_key = Column(CHAR(40, collation='utf8_unicode_ci'), nullable=False) def __init__(self, key, filename, content_type, author_key, **kwargs): self.key = key self.filename = filename self.content_type = content_type self.author_key = author_key def __repr__(self): return 'TempFileList(%s ,%s)' % \ (self.key,self.filename) @classmethod def by_key(cls, key, sql_session): q = sql_session.query(cls) return q.filter(cls.key == key) def to_dict(self): return { 'key': self.key, 'filename': self.filename, 'path': self.key, 'filetype': 'file', }
class OTP(Base): __tablename__ = 'otp' id = Column(INTEGER, primary_key=True, autoincrement=True) otp = Column(TEXT(255)) user_id = Column(INTEGER, ForeignKey('users.user_id')) purpose = Column(TEXT(255)) data = Column(TEXT(255)) timestamp = Column(BIGINT)
class caseStep(mysqlpool.Model): __tablename__ = "caseStep" # 定义column id = mysqlpool.Column( name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) caseId = mysqlpool.Column( name="caseId", type_=TINYINT(4), nullable=False ) content = mysqlpool.Column( name="content", type_=TEXT(1000), nullable=True ) expectation = mysqlpool.Column( name="expectation", type_=TEXT(1000), nullable=True ) status = mysqlpool.Column( name="status", type_=TINYINT(4), nullable=False ) userId = mysqlpool.Column( name="userId", type_=TINYINT(4), nullable=False ) createTime = mysqlpool.Column( name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) updateUserId = mysqlpool.Column( name="updateUserId", type_=TINYINT(4), nullable=True ) updateTime = mysqlpool.Column( name="updateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now )
class SocialLogin(Base): __tablename__ = 'social_logins' id = Column(INTEGER, primary_key=True, autoincrement=True) user_id = Column(INTEGER, ForeignKey('users.user_id'), nullable=False) # facebook provider_id = Column(TEXT(255), nullable=False) # result.user.id provider_user_id = Column(TEXT(255), nullable=False) # result.user.email # result.user.credentials.token access_token = Column(TEXT(255))
class UserInfo(db.Model): id = db.Column(INTEGER(unsigned=True), primary_key=True) sign = db.Column(TEXT(), nullable=False, default='') intro = db.Column(TEXT(), nullable=False, default='') address = db.Column(VARCHAR(length=255), nullable=False, default='') birthday = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) avatar = db.Column(VARCHAR(length=255), nullable=False, default='') state = db.Column(TINYINT(), nullable=False, default=1) user_id = db.Column(INTEGER(unsigned=True), db.ForeignKey('user.id'), nullable=False) def __str__(self): return '<UserInfo {0}>'.format(self.user.id)
class MpSoftware(CommonBase): __tablename__ = 'mp_software' rid = Column(BigInteger, primary_key=True, nullable=False, autoincrement=True) suuid = Column(String(50), primary_key=True, nullable=False, info="Software ID") patch_bundle_id = Column(String(100), info="Patch Bundle ID") auto_patch = Column(Integer, nullable=False, server_default='0', info="Auto Patch") sState = Column(Integer, server_default='0', info="State", doc=70) sName = Column(String(255), nullable=False, info="Name") sVendor = Column(String(255), info="Vendor") sVersion = Column(String(40), nullable=False, info="Version") sDescription = Column(String(255), info="Description") sVendorURL = Column(String(255), info="Vendor URL") sReboot = Column(Integer, server_default='1', info="Reboot") sw_type = Column(String(10), info="SW Type") sw_path = Column(String(255), info="Patch") sw_url = Column(String(255), info="URL") sw_size = Column(BigInteger, server_default='0', info="Size") sw_hash = Column(String(50), info="Hash") sw_pre_install_script = Column(LONGTEXT(), info="Preinstall Script") sw_post_install_script = Column(LONGTEXT(), info="Postinstall Script") sw_uninstall_script = Column(LONGTEXT(), info="Uninstall Script") sw_env_var = Column(String(255), info="Install ENV") cdate = Column(DateTime, server_default='1970-01-01 00:00:00', info="Create Date", doc=99) mdate = Column(DateTime, server_default='1970-01-01 00:00:00', info="Mod Date", doc=98) sw_img_path = Column(TEXT(), info="SW Icon")
class ServiceEvent(Base): __tablename__ = 'serviceEvent' id = Column(u'ServiceID', INTEGER(), primary_key=True) host_id = Column(u'HostID', INTEGER(), ForeignKey('hosts.HostID', ondelete='cascade')) app_id = Column( u'app_id', SMALLINT(), ForeignKey('app_definitions.AppID'), ) # This is deliberately _not_ linked to the hosts table; we want to record # the hostname at the time of the event and not have it change later. hostname = Column(String(length=30)) username = Column(String(length=30)) control_host = Column(String(length=30)) event = Column(Enum(u'RMA', u'commission', u'decommission')) service_status = Column(u'serviceStatus', String(length=100)) comments = Column(TEXT()) service_date = Column(u'serviceDate', TIMESTAMP(), nullable=False, default=func.current_timestamp(), onupdate=func.current_timestamp(), server_onupdate=func.current_timestamp())
class Rewrite(Base): __tablename__ = "rewrites" id = Column(BIGINT(unsigned=True), primary_key=True, nullable=False) article_id = Column(BIGINT(unsigned=True), index=True, nullable=False) rewrite_type = Column(Enum(RewriteType), index=True, nullable=False) status = Column("status", INTEGER(unsigned=True), unique=False, index=True, nullable=False, server_default=text("0")) error = Column("error", TEXT(), index=False, unique=False, nullable=True, default=None) created_at = Column("created_at", TIMESTAMP, unique=False, nullable=False, server_default=text("CURRENT_TIMESTAMP")) updated_at = Column( "updated_at", TIMESTAMP, unique=False, nullable=False, index=True, server_default=text("CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP"), server_onupdate=text("CURRENT_TIMESTAMP")) __table_args__ = (UniqueConstraint('article_id', 'rewrite_type', name='article_id__rewrite_type_UIX'), )
class FundingRound(Base): __tablename__ = 'crunchbase_funding_rounds' funding_round_id = Column(VARCHAR(36), primary_key=True) company_name = Column(VARCHAR(200)) location_id = Column(VARCHAR(400, collation='utf8mb4_unicode_ci'), index=True) country = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) state_code = Column(VARCHAR(2)) region = Column(VARCHAR(100, collation='utf8mb4_unicode_ci')) city = Column(VARCHAR(100, collation='utf8mb4_unicode_ci')) investment_type = Column(VARCHAR(30)) announced_on = Column(DATE) raised_amount_usd = Column(BIGINT) raised_amount = Column(BIGINT) raised_amount_currency_code = Column(VARCHAR(3)) post_money_valuation_usd = Column(BIGINT) post_money_valuation = Column(BIGINT) post_money_currency_code = Column(VARCHAR(3)) investor_count = Column(BIGINT) cb_url = Column(TEXT) company_id = Column(VARCHAR(36)) created_at = Column(DATETIME) updated_at = Column(DATETIME) investor_names = Column(TEXT(collation='utf8mb4_unicode_ci')) investor_ids = Column(TEXT)
class ShareObject(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255)) description = db.Column(TEXT(charset='latin1')) #Check this Mike link = db.Column(db.String(255)) downloaded = db.Column(db.Integer) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) reader = db.Column(db.String(45)) speed = db.Column(db.String(5))
class Content(db.Model): id = db.Column(db.Integer, primary_key=True) #autoincrement id ranking = db.Column(db.FLOAT, unique=False, nullable=False) # the ranking content = db.Column(LONGTEXT, unique=False, nullable=False) # the content of the page we found reference = db.Column(TEXT(65535), unique=False, nullable=False) # the url of the page search_id = db.Column(db.String(255), db.ForeignKey('searches.id')) # this is the foreign key to our search param def __repr__(self): return '<Content {}>'.format(self.id)
class caseEditLog(mysqlpool.Model): __tablename__ = "caseEditLog" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=TINYINT(4), nullable=False) type = mysqlpool.Column(name="type", type_=TINYINT(4), nullable=False) before = mysqlpool.Column(name="before", type_=TEXT(1000), nullable=True) after = mysqlpool.Column(name="after", type_=TEXT(1000), nullable=True) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class Group(Base): __tablename__ = 'meetup_groups' id = Column(BIGINT(20), primary_key=True, autoincrement=False) urlname = Column(VARCHAR(200), unique=True) category_name = Column(VARCHAR(50)) category_shortname = Column(VARCHAR(50)) city = Column(VARCHAR(100)) country = Column(VARCHAR(100)) created = Column(BIGINT(20)) description = Column(TEXT(collation="utf8mb4_unicode_ci")) lat = Column(DECIMAL(6, 3)) lon = Column(DECIMAL(6, 3)) members = Column(INT) name = Column(TEXT(collation="utf8mb4_unicode_ci")) topics = Column(JSON) category_id = Column(INT) country_name = Column(VARCHAR(100)) timestamp = Column(TIMESTAMP)
class MessagingPlatform(Base): __tablename__ = 'messaging_platforms' id = Column(INTEGER, primary_key=True, autoincrement=True) # user_id = Column(INTEGER, ForeignKey('users.user_id')) username = Column(TEXT(255)) platform_id = Column(SMALLINT(unsigned=True)) timestamp = Column(BIGINT) image_id = Column(INTEGER) text = Column(TEXT)
class DailyReport(Base): __tablename__ = 'daily_report' id = Column(BIGINT, primary_key=True, autoincrement=True) # 主键 date = Column(VARCHAR(32), nullable=True) # 施工日期 photos = Column(TEXT(), nullable=True) # 施工照片 content = Column(VARCHAR(600), nullable=True) # 施工内容 principal = Column(VARCHAR(32), nullable=True) # 项目负责人 work_status = Column(CHAR(1)) # 施工状态 0:停工 1:进行中 2:完工 stop_reason = Column(VARCHAR(600)) # 停工原因 cs_id = Column(BIGINT, nullable=True) # 工地id
class Organization(Base): __tablename__ = 'crunchbase_organizations' id = Column(VARCHAR(50), primary_key=True) company_name = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) roles = Column(VARCHAR(50)) permalink = Column(VARCHAR(200)) domain = Column(TEXT) homepage_url = Column(TEXT) location_id = Column(VARCHAR(400, collation='utf8mb4_unicode_ci'), index=True) country = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) state_code = Column(VARCHAR(2)) region = Column(VARCHAR(100, collation='utf8mb4_unicode_ci')) city = Column(VARCHAR(100, collation='utf8mb4_unicode_ci')) address = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) status = Column(VARCHAR(9)) short_description = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) funding_rounds = Column(INT) funding_total_usd = Column(BIGINT) founded_on = Column(DATE) last_funding_on = Column(DATE) closed_on = Column(DATE) employee_count = Column(VARCHAR(20)) email = Column(VARCHAR(200, collation='utf8mb4_unicode_ci')) phone = Column(TEXT) facebook_url = Column(TEXT) linkedin_url = Column(TEXT) cb_url = Column(TEXT) logo_url = Column(TEXT) twitter_url = Column(TEXT) aliases = Column(TEXT(collation='utf8mb4_unicode_ci')) created_at = Column(DATETIME) updated_at = Column(DATETIME) primary_role = Column(VARCHAR(50)) type = Column(VARCHAR(50)) long_description = Column(TEXT(collation='utf8mb4_unicode_ci')) parent_id = Column(VARCHAR(50)) is_health = Column(BOOLEAN) mesh_terms = Column(TEXT) categories = relationship('CategoryGroup', secondary='crunchbase_organizations_categories')
class Step(Base): __tablename__ = 'step' id = Column(Integer, primary_key=True, nullable=False, autoincrement=True) recipe_id = Column(ForeignKey(u'recipe.id'), primary_key=True, nullable=False, index=True) description = Column(TEXT(charset='latin1'), nullable=False) recipe = relationship(u'Recipe')
class Blog(db.Model): id = db.Column(INTEGER(unsigned=True), primary_key=True) title = db.Column(VARCHAR(length=255), index=True, nullable=False) subtitle = db.Column(VARCHAR(length=255), nullable=False) intro = db.Column(TEXT(), nullable=False, default='') content = db.Column(TEXT(), nullable=False, default='') logo = db.Column(VARCHAR(length=255), nullable=False, default='') update_time = db.Column(db.DateTime, nullable=False, index=True, default=datetime.utcnow) create_time = db.Column(db.DateTime, nullable=False, index=True, default=datetime.utcnow) user_id = db.Column(INTEGER(unsigned=True), db.ForeignKey('user.id'), nullable=False)
class User(Base): __tablename__ = 'users' user_id = Column(INTEGER, primary_key=True, autoincrement=True) username = Column(TEXT(30)) email = Column(TEXT(255)) email_verified = Column(BOOLEAN, default=False) password_hash = Column(TEXT(255)) first_name = Column(TEXT(255), nullable=False) last_name = Column(TEXT(255)) mobile_num = Column(TEXT(255)) profile_pic_id = Column(INTEGER) whatsapp = Column(TEXT(255)) whatsapp_verified = Column(BOOLEAN, default=False) line = Column(TEXT(255)) line_verified = Column(BOOLEAN, default=False) wechat = Column(TEXT(255)) wechat_verified = Column(BOOLEAN, default=False) time_joined = Column(BIGINT) active = Column(BOOLEAN) default_homepage = Column(INTEGER) default_login = Column(TEXT(16)) social_logins = relationship("SocialLogin") clients = relationship("ClientTrainer", foreign_keys="ClientTrainer.trainer_id", lazy="select") trainers = relationship("ClientTrainer", foreign_keys="ClientTrainer.client_id", lazy="select") profile_pic = relationship( "FileIndex", primaryjoin='User.profile_pic_id==FileIndex.file_id', foreign_keys="FileIndex.file_id", remote_side="User.profile_pic_id", lazy="select") def hash_password(self, password): self.password_hash = argon2.hash(password) def verify_password(self, password): return argon2.verify(password, self.password_hash)
class OnlineSQL(MaintenanceBase): """ 一个商户在线上的存储过程 """ __tablename__ = 'online_sqls' id = Column(Integer, autoincrement=True, nullable=False, primary_key=True) org_code = Column(String(32), nullable=False) file_name = Column(VARCHAR(length=64), nullable=False) sql_content = Column(TEXT(), default="", server_default="", nullable=False) sql_sha1 = Column(VARCHAR(128))
class ModelRecord(Base): __tablename__ = 'Records' number_record = Column(String(100), primary_key=True, unique = True, index = True) record_categoty = Column(String(100)) title = Column(String(100)) price = Column(String(50)) description = Column(TEXT()) date_publish = Column(String(100)) views = Column(String(100)) name_user = Column(String(100)) phone = Column(String(100)) image_href = Column(String(100)) record_url = Column(String(2000))
class Paper(Base): __tablename__ = 'mag_papers' id = Column(BIGINT, primary_key=True, autoincrement=False) title = Column(TEXT(collation='utf8_bin')) citation_count = Column(INTEGER) created_date = Column(DATE) doi = Column(VARCHAR(200)) book_title = Column(VARCHAR(200)) _languages = relationship('PaperLanguage') languages = association_proxy('_languages', 'language', creator=lambda l: PaperLanguage(language=l)) fields_of_study = relationship('PaperFieldsOfStudy', back_populates='paper') authors = relationship('PaperAuthor', back_populates='paper')
class AttachmentList(Base): __tablename__ = 'attachmentlist' key = Column(CHAR(40, collation='utf8_unicode_ci'), primary_key=True) ann_id = Column(INTEGER, nullable=False) content_type = Column(TEXT(charset='utf8'), nullable=False) filename = Column(TEXT(charset='utf8'), nullable=False) def __init__(self, key, ann_id, content_type, filename, **kwargs): self.key = key self.ann_id = ann_id self.content_type = content_type self.filename = filename def __repr__(self): return 'AttachmentList(%s ,%s)' % \ (self.ann_id,self.filename) @classmethod def by_key(cls, key, sql_session): q = sql_session.query(cls) return q.filter(cls.key == key) @classmethod def by_ann_id(cls, ann_id, sql_session): q = sql_session.query(cls) return q.filter(cls.ann_id == ann_id) def to_dict(self): _filetype = mimetypes.guess_extension(self.content_type) _filetype = _filetype if _filetype else '' return { 'key': self.key, 'filename': self.filename, 'path': self.key + '/' + self.filename, 'filetype': _filetype[1:], }
class TaskHistory(Base): __tablename__ = "tb_task_history" __table_args__ = {'extend_existing': True} id = Column('id', INTEGER(11), primary_key=True) mr_task_id = Column('mr_task_id', INTEGER(11), ForeignKey("tb_mr_task.id")) table_stage_info = Column('table_stage_info', TEXT()) create_time = Column('create_time', DATETIME(), server_default=func.now()) update_time = Column('update_time', DATETIME()) begin_time = Column('begin_time', DATETIME()) end_time = Column('end_time', DATETIME()) result_status = Column('result_status', TINYINT(1), default=0) result = Column('result', TEXT()) parent = relationship("MRTask", back_populates="history_child") @hybrid_property def table_stage_list(self): # unmarsh the table_stage_info into python object # return StageToProcess list if self.table_stage_info: return CommonUtil.decodeTableStageInfo(self.table_stage_info) else: return []
class System(Base): __tablename__ = 'system' key = Column(VARCHAR(40, collation='utf8_unicode_ci'), primary_key=True) value = Column(TEXT(charset='utf8'), nullable=False) def __init__(self, key, value): self.key = key self.value = value @classmethod def by_key(cls, key, sql_session): q = sql_session.query(cls) q = q.filter(cls.key == key) return q
class CalorieEntry(Base): __tablename__ = 'calorie_entries' id = Column(INTEGER, primary_key=True, autoincrement=True) user_id = Column(INTEGER, ForeignKey('users.user_id')) food_name = Column(TEXT(255)) timestamp = Column(BIGINT) image_id = Column(INTEGER) client_comment = Column(TEXT) calories = Column(SMALLINT(unsigned=True)) carb = Column(SMALLINT(unsigned=True)) protein = Column(SMALLINT(unsigned=True)) fat = Column(SMALLINT(unsigned=True)) trainer_comment = Column(TEXT) reviewed = Column(BOOLEAN, default=False)
def test_column_datatype_to_string(self): test_cases = ( (DATE(), "DATE"), (VARCHAR(length=255), "VARCHAR(255)"), ( VARCHAR(length=255, charset="latin1", collation="utf8mb4_general_ci"), "VARCHAR(255)", ), (NVARCHAR(length=128), "NATIONAL VARCHAR(128)"), (TEXT(), "TEXT"), ) for original, expected in test_cases: actual = MySQLEngineSpec.column_datatype_to_string( original, mysql.dialect() ) self.assertEqual(actual, expected)
class ImageSubmission(db.Model): id = db.Column(db.Integer, primary_key=True) time = db.Column(db.DateTime(), nullable=False) game_id = db.Column(db.Integer, db.ForeignKey('game.id')) player_id = db.Column(db.Integer, db.ForeignKey('player.id')) player = db.relationship(Player, lazy='joined') image = db.Column(TEXT(MAX_IMAGE_LENGTH), nullable=False) def __init__(self, player, image): self.time = datetime.now() self.player = player self.image = image def get_player(self): return self.player def get_image(self): return self.image
class VTableModel(Base): __tablename__ = 'vtable' id = Column('id', INTEGER(display_width=11, unsigned=True), primary_key=True, nullable=False) name = Column('name', VARCHAR(length=255), nullable=False) ds_id = Column('ds_id', INTEGER(display_width=11, unsigned=True), nullable=False) table_json = Column('query', TEXT(), nullable=False) user_id = Column('user_id', INTEGER(display_width=11), nullable=False) ctime = Column('ctime', TIMESTAMP(), nullable=False, server_default=DefaultClause(text('CURRENT_TIMESTAMP'))) utime = Column('utime', TIMESTAMP(), nullable=False, server_default=DefaultClause(text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'))) is_del = Column('is_del', TINYINT(display_width=4, unsigned=True), nullable=False, server_default=DefaultClause(text('0'))) @hybrid_property def query(self): return json.loads(self.table_json) @query.setter def query(self, value): self.table_json = json.dumps(value)
class HostDeployment(Base): __tablename__ = 'host_deployments' id = Column(u'HostDeploymentID', INTEGER(), primary_key=True) deployment_id = Column(u'DeploymentID', INTEGER(), ForeignKey('deployments.DeploymentID', ondelete='cascade'), nullable=False) deployment = relationship("Deployment", uselist=False) host_id = Column(u'HostID', INTEGER(), ForeignKey('hosts.HostID', ondelete='cascade'), nullable=False) host = relationship("Host", uselist=False) package_id = Column(INTEGER(), ForeignKey('packages.package_id', ondelete='cascade'), nullable=False) package = relationship( "Package", uselist=False, back_populates='host_deployments', ) user = Column(String(length=32), nullable=False) status = Column(Enum( 'failed', 'inprogress', 'ok', 'pending', ), nullable=False) realized = Column(TIMESTAMP(), nullable=False, server_default=func.current_timestamp()) created_at = synonym('realized') duration = Column(FLOAT(), nullable=False, server_default="0") deploy_result = Column(TEXT()) __table_args__ = (UniqueConstraint(u'package_id', u'HostID', u'realized'), )