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 Log(Base): __tablename__ = 'logs' id = Column(Integer, primary_key=True) # auto incrementing logger = Column(String(256)) # the name of the logger. level = Column(String(50)) # info, debug, or error? trace = Column(LONGTEXT()) # the full traceback printout msg = Column(LONGTEXT()) # any custom log you may have included path = Column(String(64)) ip = Column(String(32)) method = Column(String(64)) created_at = Column(DateTime, default=func.now()) # the current timestamp def __init__(self, logger=None, level=None, trace=None, msg=None, path=None, ip=None, method=None): self.logger = logger self.level = level self.trace = trace self.msg = msg self.path = path self.ip = ip self.method = method def __unicode__(self): return self.__repr__() def __repr__(self): return "<Log: %s - %s>" % (self.created_at.strftime('%m/%d/%Y-%H:%M:%S'), self.msg[:50])
class APIHTMLText(Base): __tablename__ = 'java_api_html_text' id = Column(Integer, primary_key=True, autoincrement=True) api_id = Column(Integer, ForeignKey('java_all_api_entity.id'), nullable=False) html = Column(LONGTEXT(), nullable=False) clean_text = Column(LONGTEXT(), nullable=True) # text with no html tags reserve_part_tag_text = Column(LONGTEXT(), nullable=True) # text with only code tags text html_type = Column(Integer, nullable=True) __table_args__ = (Index('api_id_text_type_index', api_id, html_type), { "mysql_charset": "utf8", }) HTML_TYPE_UNKNOWN = 0 HTML_TYPE_API_DECLARATION = 1 HTML_TYPE_API_SHORT_DESCRIPTION = 2 HTML_TYPE_API_DETAIL_DESCRIPTION = 3 HTML_TYPE_METHOD_RETURN_VALUE_DESCRIPTION = 4 def __init__(self, api_id, html, html_type=HTML_TYPE_UNKNOWN): self.api_id = api_id self.html = html self.html_type = html_type def create(self, session, autocommit=True): session.add(self) if autocommit: session.commit() return self
class Removed(db.Model): id = db.Column(db.Integer, primary_key=True) pmid = db.Column(LONGTEXT()) abstract = db.Column(LONGTEXT()) def __repr__(self): return f'<{self.pmid}>'
class testinfo(Base): __tablename__ = 'test_info' __table_args__ = (schema.UniqueConstraint('uuid', name='uniq_test0uuid'), table_args()) uuid = Column(String(64), primary_key=True) subject = Column(String(64)) status = Column(String(64)) testinfo_result = Column(LONGTEXT()) testinfo_request = Column(LONGTEXT())
class Contract(BaseModel): __tablename__ = 'data_contract' code_hash = sa.Column(sa.String(64), primary_key=True) bytecode = sa.Column(LONGTEXT()) source = sa.Column(LONGTEXT()) abi = sa.Column(sa.JSON(), default=None, server_default=None, nullable=True) compiler = sa.Column(sa.String(64)) created_at_block = sa.Column(sa.Integer(), nullable=False) created_at_extrinsic = sa.Column(sa.Integer()) created_at_event = sa.Column(sa.Integer())
class Departure(Base): _base_airport = sa.Column(String(10), index=True) _query_time = sa.Column(sa.SMALLINT(), index=True) flight = sa.Column(String(10), index=True) carrier = sa.Column(String(50), index=True) destination = sa.Column(String(50)) departure = sa.Column(String(20)) status = sa.Column(String(30)) fs_url = sa.Column(LONGTEXT()) fs_api = sa.Column(LONGTEXT()) track_url = sa.Column(LONGTEXT())
class InvReports(CommonBase): __tablename__ = 'mp_inv_reports' rid = Column(BigInteger, primary_key=True, autoincrement=True) name = Column(String(255), nullable=False) owner = Column(String(255), nullable=False) scope = Column(INTEGER(1, unsigned=True), server_default='0') rtable = Column(String(255), nullable=False) rcolumns = Column(LONGTEXT()) rquery = Column(LONGTEXT()) cdate = Column(DateTime, server_default='1970-01-01 00:00:00') mdate = Column(DateTime, server_default='1970-01-01 00:00:00')
class Arrival(Base): _base_airport = sa.Column(String(10), index=True) _query_time = sa.Column(sa.SMALLINT(), index=True) flight = sa.Column( String(10), index=True, ) carrier = sa.Column(String(50), index=True) origin = sa.Column(String(50)) arrival = sa.Column(String(20)) status = sa.Column(String(30)) fs_url = sa.Column(LONGTEXT()) fs_api = sa.Column(LONGTEXT()) track_url = sa.Column(LONGTEXT())
class Questions(Base): __tablename__ = 'Questions' id = Column(Integer, primary_key=True) teacher_id = Column(Integer) time = Column(Integer) duration = Column(Integer) question = Column(LONGTEXT()) def __init__(self, teacher_id, time=0, duration=0, question=None): self.teacher_id = teacher_id self.time = time self.duration = duration self.question = question def insert(self): Base.metadata.create_all(engine) c1 = Questions(teacher_id=self.teacher_id, time=self.time, duration=self.duration, question=self.question) session.add(c1) session.commit() self.display() return 1 def delete(self, id): #det=session.query(Questions).get(id) #session.delete(det) session.query(Questions).delete() session.commit() def display(self): dis = session.query(Questions).all() for i in dis: print('q', i.teacher_id, i.question)
class ProjectReport(db.Model): __table_args__ = ({'mysql_engine': 'InnoDB', 'mysql_charset': 'utf8'}) id = db.Column('project_report_id', db.Integer, primary_key=True, nullable=False, autoincrement=True) user_id = db.Column(db.Integer, nullable=False) project_id = db.Column(db.Integer, nullable=False) name = db.Column('project_report_name', db.VARCHAR(255, collation='utf8_unicode_ci'), nullable=False) detail = db.Column('project_report_detail', LONGTEXT(collation='utf8_unicode_ci'), nullable=False) approval = db.Column('project_report_approval', TINYINT(1), nullable=False, default=0) accessible = db.Column('project_report_accessible', db.VARCHAR(20), nullable=False, default='all') reg_datetime = db.Column('project_report_reg_datetime', db.DATETIME, default=datetime.now) mod_datetime = db.Column('project_report_mod_datetime', db.DATETIME, default=datetime.now, onupdate=datetime.now)
class WikipediaDocument(Base): __tablename__ = 'wiki_pedia' id = Column(Integer, primary_key=True, autoincrement=True) doc_id = Column(Integer, autoincrement=True) url = Column(String(256), index=True, nullable=False) title = Column(String(128), index=True, nullable=False) content = Column(LONGTEXT()) __table_args__ = ({ "mysql_charset": "utf8", }) def __init__(self, doc_id, url, content): self.doc_id = doc_id self.url = url self.content = content @staticmethod def get_document_by_wikipedia_title(session, title): try: return session.query(WikipediaDocument).filter_by( title=func.binary(title)).first() except Exception: traceback.print_exc() return None
class EmailData(DeclarativeBase): __tablename__ = 'emaildata' id = Column(Integer, primary_key=True) imei = Column(Unicode(16), default=u'') time_stamp = Column(DateTime, default=datetime.utcnow) email_id = Column(Unicode(255), default=u'') data = Column(LONGTEXT(), default=u'')
class DocumentText(Base): __tablename__ = 'java_api_document_text' id = Column(Integer, primary_key=True, autoincrement=True) html_text_id = Column(Integer, ForeignKey('java_api_html_text.id'), unique=True, nullable=False) text = Column(LONGTEXT(), nullable=True) # text with no html tags __table_args__ = (Index('api_id_text_type_index', html_text_id), { "mysql_charset": "utf8", }) def __init__(self, html_text_id, text): self.html_text_id = html_text_id self.text = text def create(self, session, autocommit=True): session.add(self) if autocommit: session.commit() return self @staticmethod def get_doc_id_list(session): try: doc_id_list = session.query(DocumentText.id).all() return doc_id_list except Exception: traceback.print_exc() return None
def upgrade(): op.create_table('raw_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created_ts', sa.TIMESTAMP(), default=datetime.datetime.utcnow), sa.Column('updated_ts', sa.TIMESTAMP(), onupdate=datetime.datetime.utcnow), sa.Column('domain', sa.String(length=100), nullable=False, index=True), sa.Column('url', sa.String(length=255), nullable=False), sa.Column('depth', sa.SMALLINT(), nullable=False), sa.Column('http_status', sa.String(3), nullable=True, index=True), sa.Column('html', LONGTEXT(), nullable=True), sa.Column('parsed_as_entry', sa.Boolean(), default=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('url'), mysql_charset='utf8', mysql_engine='InnoDB') pass
def create_tables(self): """ 存放的是一些需要去执行的表结构,针对的是MySQL,其余数据库可能微调 """ qy_info = Table( "qym_erp_info", self.metadata, Column('pk_md5', String(32), primary_key=True), Column('erp_code', String(150)), Column('taxpayers_code', String(100)), Column('registration_number', String(100)), Column('organization_code', String(100)), Column('name', String(100)), Column('legal_representative', String(200)), Column('erp_type', String(200)), Column('erp_status', String(50)), Column('registered_cap', String(50)), Column('establish_date', String(20)), Column('region', String(50)), Column('approved_date', String(50)), Column('business_scope', String(50)), Column('industry', String(255)), Column('forward_label', String(255)), Column('exhibition_label', String(255)), Column('source_link_url', String(255)), Column('html_body', LONGTEXT()), Column('insert_time', DateTime, nullable=False, server_default=text("CURRENT_TIMESTAMP")), Column('update_time', DateTime, server_default=text("CURRENT_TIMESTAMP")))
class MethodCode(FullText, Base): __tablename__ = 'method_code' __fulltext_columns__ = ('code', ) id = Column(Integer, primary_key=True, autoincrement=True) method_id = Column(Integer, nullable=False) code = Column(LONGTEXT(), nullable=True) __table_args__ = {"mysql_charset": "utf8"} def __init__(self, method_id, code=None): self.method_id = method_id self.code = code def find_or_create(self, session, autocommit=True): remote_instance = self.get_remote_object(session) if not remote_instance: session.add(self) if autocommit: session.commit() return self else: return remote_instance def get_remote_object(self, session): if self.id: return self else: try: return session.query(MethodCode).filter_by( method_id=self.method_id).first() except Exception: # traceback.print_exc() return None
def get_string_type(col_type, params): """Create a string type column. Args: col_type (string): Type of the column. params (object): Additional parameters. Returns: sqlalchemy.types.TypeEngine: String type like char or text """ if col_type == 'char': return CHAR(params.get('length')) elif col_type == 'json': return ( JSON(none_as_null=True) .with_variant(JSONB(none_as_null=True), 'postgresql') .with_variant(Text(), 'sqlite') ) elif col_type == 'long_text': return LONGTEXT().with_variant(Text(), 'sqlite') elif col_type == 'medium_text': return MEDIUMTEXT().with_variant(Text(), 'sqlite') elif col_type == 'string': return String(length=params.get('length')) elif col_type == 'text': return Text()
class MpSoftwareTasksData(CommonBase): __tablename__ = 'mp_software_tasks_data' rid = Column(BigInteger, primary_key=True, autoincrement=True) gid = Column(String(50), nullable=False) gDataHash = Column(String(50), nullable=False) gData = Column(LONGTEXT(), nullable=False) mdate = Column(DateTime, server_default='1970-01-01 00:00:00')
class Article(db.Model): id = db.Column(db.Integer, primary_key=True) pmid = db.Column(db.Integer, index=True) mesh = db.Column(db.Text) doi = db.Column(db.String(256), index=True) pii = db.Column(db.String(256), index=True) abstract = db.Column(LONGTEXT(charset='utf8mb4')) title = db.Column(LONGTEXT()) date = db.Column(db.String(16)) volume = db.Column(db.Integer) authors = db.Column(LONGTEXT(charset='utf8mb4')) journal = db.Column(db.String(512), index=True) mesh_qualifier = db.Column(LONGTEXT()) #databases = db.relationship('Database', secondary='article_database') search_id = db.Column(db.Integer, db.ForeignKey('search.id')) def __repr__(self): return '<Article: {}>'.format(self.title)
class MpPatchGroupData(CommonBase): __tablename__ = 'mp_patch_group_data' rid = Column(BigInteger, primary_key=True, nullable=False, autoincrement=True) pid = Column(String(50), primary_key=True, nullable=False) hash = Column(String(50), nullable=False) rev = Column(BigInteger, server_default="-1") data = Column(LONGTEXT(), nullable=False) data_type = Column(String(4), server_default="") mdate = Column(DateTime, server_default='1970-01-01 00:00:00')
class AspSolution(db.Model): __tablename__ = 'aspsolution' id = db.Column(db.Integer, primary_key=True, nullable=True) loaddate = db.Column(db.DateTime) status = db.Column(db.Enum('New','In process','Completed','Error')) input = db.Column(LONGTEXT()) output = db.Column(LONGTEXT()) comment = db.Column(LONGTEXT()) #cohorts = db.relationship('Cohort', secondary=jt_cohort_course, backref='courses') def __init__(self, id=None, loaddate=datetime.datetime.utcnow(), status='New', input=None, output=None, comment=None): self.id = id self.loaddate = loaddate self.status = status self.input = input self.output = output self.comment = comment __mapper_args__ = { 'order_by' : (id.desc()) }
class Nsentence(db.Model): id = db.Column(db.Integer, primary_key=True) sentence = db.Column(LONGTEXT()) label = db.Column(db.Boolean, default=False, server_default=expression.false(), nullable=False) response_id = db.Column(db.Integer, db.ForeignKey('response.id', ondelete='CASCADE')) def __repr__(self): return f'<Source ID: {self.abstract_id}; Content: {self.sentence}; Label: {self.label}>'
class Search(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(256), index=True, unique=True) citation_list = db.Column(LONGTEXT()) search_string = db.Column(db.String(512), index=True, unique=True) citations = db.relationship('Article', backref='base_search', lazy='dynamic') results = db.relationship('Result', backref='search') def __repr__(self): return '<Search Identifier: {}>'.format(self.name)
class Followees(BASE): __tablename__ = 'followees' uid = Column('uid', VARCHAR(60), primary_key=True) name = Column('status_id', VARCHAR(60), primary_key=True) creation_time = Column('creation_time', DATETIME, nullable=False, default=datetime.datetime.utcnow) last_update_time = Column('last_update_time', DATETIME, nullable=False, default=datetime.datetime.utcnow) last_update_status = Column('last_update_status', LONGTEXT(collation='utf8_bin'), nullable=True, default=None) followers_count = Column('followers_count', INTEGER) followees_count = Column('followees_count', INTEGER) status_count = Column('status_count', INTEGER)
class Board(Base): __tablename__ = 'boards' __table_args__ = {'mysql_collate': 'utf8_general_ci'} id = Column(Integer, primary_key=True, index=True) member_id = Column(Integer, ForeignKey(Member.id)) title = Column(VARCHAR(50), nullable=False) content = Column(LONGTEXT()) regdate = Column(DateTime, default=datetime.datetime.now()) def __repr__(self): return 'Board(board_id={}, member_id={}, title={}, content={}, regdate={})'.format( self.id, self.member_id, self.title, self.content, self.regdate)
class GymDetails(db.Model): __tablename__ = 'gymdetails' gym_id = db.Column(db.String(length=50, collation='utf8mb4_unicode_ci'), db.ForeignKey('gym.gym_id', name='fk_gd_gym_id'), primary_key=True) name = db.Column(db.String(length=191, collation='utf8mb4_unicode_ci'), nullable=False) description = db.Column(LONGTEXT(collation='utf8mb4_unicode_ci')) url = db.Column(db.String(length=191, collation='utf8mb4_unicode_ci'), nullable=False) last_scanned = db.Column(db.DateTime, default=datetime.utcnow(), nullable=False)
class Pclause(db.Model): id = db.Column(db.Integer, primary_key=True) clause = db.Column(LONGTEXT()) label = db.Column(db.Boolean, default=True, server_default=expression.true(), nullable=False) response_id = db.Column(db.Integer, db.ForeignKey('response.id', ondelete='CASCADE')) #sentence = db.relationship('Psentence', backref='source') def __repr__(self): return f'<Source ID: {self.sentence_id}; Content: {self.clause}; Label: {self.label}>'
class Cards(db.Model): __tablename__ = "cards" id = db.Column(db.Integer, primary_key=True, autoincrement=True) listId = db.Column(db.Integer, db.ForeignKey("lists.id", ondelete='CASCADE'), nullable=False) text = db.Column(db.String(255), nullable=False) order = db.Column(db.Integer, nullable=False) description = db.Column(LONGTEXT(charset='latin1')) members = db.Column(db.String(255)) code = db.Column(db.String(255)) labels = db.Column(db.String(255)) cover = db.Column(db.String(255)) created_at = db.Column(db.DateTime(timezone=True), server_default=func.now()) updated_at = db.Column(db.DateTime(timezone=True), onupdate=func.now()) cardId = db.relationship('CardMembers', backref='cards', lazy=True, uselist=False, cascade="all, delete-orphan", passive_deletes=True) cardId = db.relationship('CardLabels', backref='cards', lazy=True, uselist=False, cascade="all, delete-orphan", passive_deletes=True) response_fields = { 'id': fields.Integer, 'listId': fields.Integer, 'text': fields.String, 'order': fields.Integer, 'members': fields.String, 'code': fields.String, 'labels': fields.String, 'cover': fields.String, } def __init__(self, listId, text, order, code): self.listId = listId self.text = text self.order = order self.code = code def __repr__(self): return '<Cards %r>' % self.id
class ip_data(Base): #表名: __tablename__ = 'ip_data' #表结构: id = Column(Integer, autoincrement=True, primary_key=True, nullable=False) url = Column(String(200)) ip = Column(String(100)) iporigin = Column(String(100)) port = Column(String(100)) httpcode = Column(String(20)) webcode = Column(LONGTEXT()) title = Column(String(1000)) webtype = Column(String(100)) charsetcode = Column(String(100))