# coding: utf-8
from sqlalchemy import create_engine, Column, DateTime, Integer, Text
from sqlalchemy.ext.declarative import declarative_base
import os

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)


if os.path.isfile("db.db"):
    os.remove("db.db")
engine = create_engine('sqlite:///db.db', echo=True)
metadata.create_all(engine)