# coding: utf-8
|
from sqlalchemy import create_engine, Column, DateTime, Integer, Text
|
from sqlalchemy.ext.declarative import declarative_base
|
|
Base = declarative_base()
|
metadata = Base.metadata
|
|
|
class TDataStream(Base):
|
__tablename__ = 't_data_stream'
|
|
C_STREAM_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_STREAM_ID = Column(Text)
|
C_DATA_TYPE = Column(Text)
|
C_STREAM_DIR = Column(Text)
|
C_NAME = Column(Text)
|
C_DESCRIPTION = Column(Text)
|
C_RULE_ID = Column(Text)
|
C_RULE_TYPE = Column(Text)
|
|
|
class TDbversion(Base):
|
__tablename__ = 't_dbversion'
|
|
C_PK = Column(Text, primary_key=True)
|
C_MANIN = Column(Text)
|
C_SECONDARY = Column(Text)
|
C_TIME = Column(Text)
|
|
|
class TDevStream(Base):
|
__tablename__ = 't_dev_stream'
|
|
C_PK = Column(Text, primary_key=True)
|
C_DEV_PK = Column(Text)
|
C_STREAM_PK = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TDevice(Base):
|
__tablename__ = 't_device'
|
|
C_DEV_PK = Column(Text, primary_key=True)
|
C_DEV_ID = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_DEV_NAME = Column(Text)
|
C_DEV_TYPE = Column(Text)
|
C_DLL = Column(Text)
|
|
|
class TEncLinear(Base):
|
__tablename__ = 't_enc_linear'
|
|
C_PK = Column(Text, primary_key=True)
|
C_LINEAR_PK = Column(Text, index=True)
|
C_ENCITEM_PK = Column(Text)
|
C_VALS = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_TYPE = Column(Text)
|
C_FOLDER_PK = Column(Text)
|
|
|
class TExtendInfo(Base):
|
__tablename__ = 't_extend_info'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_PROPERTY_ID = Column(Text)
|
C_PROPERTY_NAME = Column(Text)
|
C_VAL = Column(Text)
|
C_FOREIGN_PK = Column(Text)
|
|
|
class TFolderMap(Base):
|
__tablename__ = 't_folder_map'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PARENT_PK = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_NAME = Column(Text)
|
C_TIME = Column(Text)
|
|
|
class THistoryversion(Base):
|
__tablename__ = 't_historyversion'
|
|
C_PK = Column(Text, primary_key=True)
|
C_MANIN = Column(Text)
|
C_SECONDARY = Column(Text)
|
C_TIME = Column(Text)
|
|
|
class TIdsIn(Base):
|
__tablename__ = 't_ids_ins'
|
|
C_PK = Column(Text, primary_key=True)
|
C_DEV_PK = Column(Text)
|
C_PLUG = Column(Text)
|
C_NODE = Column(Text)
|
C_INS_PK = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TIdsPar(Base):
|
__tablename__ = 't_ids_par'
|
|
C_PK = Column(Text, primary_key=True)
|
C_DEV_PK = Column(Text)
|
C_PLUG = Column(Text)
|
C_NODE = Column(Text)
|
C_PAR_PK = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TInsDef(Base):
|
__tablename__ = 't_ins_def'
|
|
C_PK = Column(Text, primary_key=True)
|
C_INS_FORMAT_PK = Column(Text)
|
C_INS_PK = Column(Text, index=True)
|
C_VALUE = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_BYTES = Column(Text)
|
C_ROOT_FORMAT_PK = Column(Text)
|
|
|
class TInsFormat(Base):
|
__tablename__ = 't_ins_format'
|
|
C_INS_FORMAT_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_PARENT_PK = Column(Text)
|
C_ORDER = Column(Integer)
|
C_AUTOCODE = Column(Text)
|
C_NAME = Column(Text)
|
C_CODE = Column(Text)
|
C_TYPE = Column(Integer)
|
C_DEF = Column(Text)
|
C_BIT_WIDTH = Column(Text)
|
C_BIT_ORDER = Column(Text)
|
C_ATTR = Column(Integer)
|
C_RANGE = Column(Text)
|
C_CONDITION = Column(Text)
|
C_FORMULA = Column(Text)
|
C_NUMBER = Column(Text)
|
|
|
class TInsInput(Base):
|
__tablename__ = 't_ins_input'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_INS_PK = Column(Text)
|
C_INS_DEF_PK = Column(Text)
|
C_INS_FORMAT_PK = Column(Text)
|
C_NAME = Column(Text)
|
C_LENGTH = Column(Text)
|
|
|
class TInsformatRule(Base):
|
__tablename__ = 't_insformat_rule'
|
|
C_PK = Column(Text, primary_key=True)
|
C_RULE_ID = Column(Text)
|
C_INSFORMAT_PK = Column(Text)
|
|
|
class TInstruction(Base):
|
__tablename__ = 't_instruction'
|
|
C_INS_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_INS_CODE = Column(Text)
|
C_INS_NAME = Column(Text)
|
C_SUBSYS = Column(Text)
|
C_INS_TYPE = Column(Text)
|
C_INS_FLAG = Column(Text)
|
|
|
class TIpcId(Base):
|
__tablename__ = 't_ipc_ids'
|
|
C_PK = Column(Text, primary_key=True)
|
C_DEV_PK = Column(Text)
|
C_CARD = Column(Text)
|
C_CHANNEL = Column(Text)
|
C_PLUG = Column(Text)
|
C_NODE = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TIpcIn(Base):
|
__tablename__ = 't_ipc_ins'
|
|
C_PK = Column(Text, primary_key=True)
|
C_IPC_PK = Column(Text)
|
C_CARD = Column(Text)
|
C_CHANNEL = Column(Text)
|
C_INS_PK = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_INS_WORD = Column(Text)
|
C_INS_PULSE = Column(Text)
|
C_INS_ID = Column(Text)
|
|
|
class TIpcPar(Base):
|
__tablename__ = 't_ipc_par'
|
|
C_PK = Column(Text, primary_key=True)
|
C_IPC_PK = Column(Text)
|
C_CARD = Column(Text)
|
C_CHANNEL = Column(Text)
|
C_PAR_PK = Column(Text)
|
C_SIMUVAL = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_PROVAL2SOURCE = Column(Text)
|
C_SOURCE2PROVAL = Column(Text)
|
C_PAR_ID = Column(Text)
|
|
|
class TJudgeRule(Base):
|
__tablename__ = 't_judge_rule'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_INS_PK = Column(Text)
|
C_JUDGE = Column(Text)
|
C_DESCRIPTION = Column(Text)
|
|
|
class TMethod(Base):
|
__tablename__ = 't_method'
|
|
C_METHOD_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_METHOD_ID = Column(Text)
|
C_NAME = Column(Text)
|
C_METHOD_TYPE = Column(Integer)
|
C_DEF = Column(Text)
|
C_DESCRIPTION = Column(Text)
|
|
|
class TParameter(Base):
|
__tablename__ = 't_parameter'
|
|
C_PAR_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_PAR_CODE = Column(Text, index=True)
|
C_PAR_NAME = Column(Text)
|
C_SUBSYS = Column(Text)
|
C_TYPE = Column(Integer)
|
C_UNIT = Column(Text)
|
C_VALUE_RANGE = Column(Text)
|
C_DIS_REQUIRE = Column(Text)
|
C_MODULUS = Column(Text)
|
C_PARAMS = Column(Text)
|
C_PRECISION = Column(Integer)
|
C_REG_PK = Column(Text)
|
C_METHOD_PK = Column(Text)
|
|
|
class TParameterType(Base):
|
__tablename__ = 't_parameter_type'
|
|
C_PK = Column(Text, primary_key=True)
|
C_TYPE_ID = Column(Text)
|
C_TYPE_NAME = Column(Text)
|
C_VALUE = Column(Text)
|
C_DATA_TYPE = Column(Text)
|
C_PAR_PK = Column(Text, index=True)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TProject(Base):
|
__tablename__ = 't_project'
|
|
C_PROJECT_PK = Column(Text, primary_key=True)
|
C_SAT_ID = Column(Text)
|
C_SAT_NAME = Column(Text)
|
C_PROJECT_CODE = Column(Text)
|
C_DESCRIPTION = Column(Text)
|
C_HASH = Column(Text)
|
C_PROJECT_NAME = Column(Text)
|
C_DATETIME = Column(DateTime)
|
C_CREATEOR = Column(Text)
|
|
|
class TProjectTable(Base):
|
__tablename__ = 't_project_table'
|
|
C_TABLE_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_NAME = Column(Text)
|
C_CODE = Column(Text)
|
C_FLAG = Column(Integer)
|
C_HASH = Column(Integer)
|
C_MEMO = Column(Text)
|
C_DATETIME = Column(DateTime)
|
|
|
class TPropertyEnc(Base):
|
__tablename__ = 't_property_enc'
|
|
C_ENCITEM_PK = Column(Text, primary_key=True)
|
C_ENC_PK = Column(Text, index=True)
|
C_SEGMENT_ID = Column(Text, index=True)
|
C_NAME = Column(Text)
|
C_TYPE = Column(Text)
|
C_CONTENT = Column(Text)
|
C_PUBLISH = Column(Integer)
|
C_OFFSET = Column(Text)
|
C_LENGTH = Column(Text)
|
C_MSBFIRST = Column(Integer)
|
C_MASK = Column(Text)
|
C_CONDITION = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_SEQ = Column(Integer)
|
C_REL_ENCITEM_PK = Column(Text)
|
C_PAR_ID = Column(Text)
|
|
|
class TPropertyLinear(Base):
|
__tablename__ = 't_property_linear'
|
|
C_PK = Column(Text, primary_key=True)
|
C_LINEAR_PK = Column(Text, index=True)
|
C_PAR_ID = Column(Text)
|
C_TYPE = Column(Text)
|
C_CONTENT = Column(Text)
|
C_OFFSET = Column(Integer)
|
C_LENGTH = Column(Integer)
|
C_MSBFIRST = Column(Integer)
|
C_MASK = Column(Text)
|
C_CONDITION = Column(Text)
|
C_CALC_EXPR = Column(Text)
|
C_PAR_PK = Column(Text)
|
C_SIMUVAL = Column(Text)
|
C_REG_PAR = Column(Text)
|
C_PARAMS = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_SEQ = Column(Integer)
|
C_REL_PK = Column(Text)
|
|
|
class TPropertyTable(Base):
|
__tablename__ = 't_property_table'
|
|
C_COLUMN_PK = Column(Text, primary_key=True)
|
C_TABLE_PK = Column(Text)
|
C_NAME = Column(Text)
|
C_CODE = Column(Text)
|
C_TYPE = Column(Text)
|
C_LENGTH = Column(Integer)
|
C_FLAG = Column(Integer)
|
C_HASH = Column(Integer)
|
C_MEMO = Column(Text)
|
C_DATETIME = Column(DateTime)
|
C_PROJECT_PK = Column(Text)
|
|
|
class TRegulation(Base):
|
__tablename__ = 't_regulation'
|
|
C_REG_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_REG_CODE = Column(Text)
|
C_REG_TYPE = Column(Text)
|
C_REGWAY = Column(Text)
|
C_DESCRIPTION = Column(Text)
|
C_PAR_PK = Column(Text)
|
C_STDVALUE = Column(Text)
|
|
|
class TRule(Base):
|
__tablename__ = 't_rule'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_RULE_PK = Column(Text)
|
C_RULE_ID = Column(Text)
|
C_RULE_NAME = Column(Text)
|
C_RULE_LENGTH = Column(Text)
|
C_PARENT_PK = Column(Text)
|
C_FLAG = Column(Text)
|
C_ACTUAL_PARENT_PK = Column(Text)
|
|
|
class TRuleEnc(Base):
|
__tablename__ = 't_rule_enc'
|
|
C_ENC_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_ENC_ID = Column(Text)
|
C_NAME = Column(Text)
|
C_ENC_LENGTH = Column(Text)
|
C_KEY = Column(Text)
|
C_CONTENT = Column(Text)
|
C_REL_ENC_PK = Column(Text)
|
|
|
class TRuleIpc(Base):
|
__tablename__ = 't_rule_ipc'
|
|
C_IPC_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_NAME = Column(Text)
|
C_CHANNEL = Column(Integer)
|
C_TYPE = Column(Integer)
|
|
|
class TRuleLinear(Base):
|
__tablename__ = 't_rule_linear'
|
|
C_LINEAR_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_LINEAR_ID = Column(Text)
|
C_NAME = Column(Text)
|
C_LENGTH = Column(Text)
|
C_PACKAGE_TYPE = Column(Text)
|
C_REL_LINEAR_PK = Column(Text)
|
C_CONTENT = Column(Text)
|
|
|
class TRuleStream(Base):
|
__tablename__ = 't_rule_stream'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_RULE_PK = Column(Text)
|
C_STREAM_PK = Column(Text)
|
C_STREAM_ID = Column(Text)
|
C_STREAM_NAME = Column(Text)
|
C_STREAM_DIR = Column(Text)
|
C_PATH = Column(Text)
|
|
|
class TRulekeyInfo(Base):
|
__tablename__ = 't_rulekey_info'
|
|
C_PK = Column(Text, primary_key=True)
|
C_PROJECT_PK = Column(Text)
|
C_RULE_PK = Column(Text)
|
C_RULE_ID = Column(Text)
|
C_RULE_NAME = Column(Text)
|
C_KEY_PK = Column(Text)
|
C_KEY_ID = Column(Text)
|
C_KEY_NAME = Column(Text)
|
C_KEY_VAL = Column(Text)
|
|
|
class TUser(Base):
|
__tablename__ = 't_user'
|
|
C_USERID = Column(Text, primary_key=True)
|
C_USERNAME = Column(Text)
|
C_PASSWORD = Column(Text)
|
C_FULLNAME = Column(Text)
|
C_ENABLE = Column(Integer)
|
C_ISADMIN = Column(Integer)
|
C_TELEPHONE = Column(Text)
|
C_MOBILE = Column(Text)
|
C_EMAIL = Column(Text)
|
|
|
class TUserProject(Base):
|
__tablename__ = 't_user_project'
|
|
C_PK = Column(Text, primary_key=True)
|
C_USERID = Column(Text)
|
C_PROJECT_PK = Column(Text)
|
C_ACCESS = Column(Integer)
|
C_EDIT = Column(Integer)
|
|
|
engine = create_engine('sqlite:///db.db', echo=True)
|
metadata.create_all(engine)
|
