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