Python Index示例

示例#1

class clsXaraCaseProblems(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_CASE_ID',
                               'CASE_ID',
                               unique=True), )

    CASE_ID = db.Column(db.String(255),
                        primary_key=True,
                        autoincrement=False,
                        nullable=False)
    NO_OF_EDGES = db.Column(db.String(255), nullable=True)
    NO_OF_NODES = db.Column(db.String(255), nullable=True)

    N00_NODE_CATEGORY = db.Column(db.String(255), nullable=True)
    N01_NODE_CATEGORY = db.Column(db.String(255), nullable=True)
    N02_NODE_CATEGORY = db.Column(db.String(255), nullable=True)
    N03_NODE_CATEGORY = db.Column(db.String(255), nullable=True)

    E00_EDGE_PREDICATE = db.Column(db.String(255), nullable=True)
    E00_EDGE_ENDS = db.Column(db.String(255), nullable=True)

    E01_EDGE_PREDICATE = db.Column(db.String(255), nullable=True)
    E01_EDGE_ENDS = db.Column(db.String(255), nullable=True)

    E02_EDGE_PREDICATE = db.Column(db.String(255), nullable=True)
    E02_EDGE_ENDS = db.Column(db.String(255), nullable=True)

    ORIGIN = db.Column(db.String(255), nullable=True)

示例#2

class clsXaraCaseSolutions(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_CASE_ID',
                               'CASE_ID',
                               unique=True), )

    SOLUTION_ID = db.Column(db.Integer,
                            primary_key=True,
                            autoincrement=False,
                            nullable=False)
    CASE_ID = db.Column(db.String(255), nullable=True)
    ORIGIN = db.Column(db.String(255), nullable=True)

    SOLUTION_STEPS = db.Column(db.Integer, nullable=True)
    SOLUTION_FIRST_KP_NAME = db.Column(db.String(255), nullable=True)
    SOLUTION_SECOND_KP_NAME = db.Column(db.String(255), nullable=True)

    NODE1_PATH1_CATEGORY = db.Column(db.String(255), nullable=True)
    NODE2_PATH1_CATEGORY = db.Column(db.Float, nullable=True)

    NODE1_PATH2_CATEGORY = db.Column(db.String(255), nullable=True)
    NODE2_PATH2_CATEGORY = db.Column(db.String(255), nullable=True)

    EDGE1_PATH1_PREDICATE = db.Column(db.String(255), nullable=True)
    EDGE1_PATH1_ENDS = db.Column(db.String(255), nullable=True)

    EDGE1_PATH2_PREDICATE = db.Column(db.String(255), nullable=True)
    EDGE1_PATH2_ENDS = db.Column(db.String(255), nullable=True)

示例#3

文件： clsKnowledgeProviders.py 项目： NCATSTranslator/Explanatory-Agent

class clsKnowledgeProviders(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_Name', 'Name', unique=True), )

    Id = db.Column(db.BigInteger, primary_key=True, autoincrement=False)
    Name = db.Column(db.String(255))
    Url = db.Column(db.Text)

示例#4

class clsXaraNodes(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_Node_key',
                               'Node_key',
                               unique=True), )

    Node_key = db.Column(db.Integer,
                         primary_key=True,
                         autoincrement=False,
                         nullable=False)
    Node_Category = db.Column(db.String(255), nullable=True)

示例#5

文件： clsXaraExplanationCaseSolutions.py 项目： tziomics/Explanatory-Agent

class clsXaraExplanationCaseSolutions(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_SOLUTION_ID',
                               'SOLUTION_ID',
                               unique=True), )

    SOLUTION_ID = db.Column(db.Integer(255),
                            primary_key=True,
                            autoincrement=False,
                            nullable=False)
    CASE_ID = db.Column(db.String(255), nullable=False)
    SOLUTION_PROCESSES = db.Column(db.String(255), nullable=True)

示例#6

文件： clsGlobalSimilarity.py 项目： NCATSTranslator/Explanatory-Agent

class clsGlobalSimilarity(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(
        f'uk_{tableName}_Subject_Object_Predicate_CaseId',
        'Subject',
        'Object',
        'Predicate',
        'CaseId',
        unique=True), )

    Id = db.Column(db.BigInteger, primary_key=True, autoincrement=False)
    Subject = db.Column(db.String(255))
    Object = db.Column(db.String(255))
    Predicate = db.Column(db.String(255))
    CaseId = db.Column(db.String(255))
    CaseValue = db.Column(db.Float)

示例#7

文件： clsXaraExplanationCaseProblems.py 项目： tziomics/Explanatory-Agent

class clsXaraExplanationCaseProblems(db.Model):

    __tablename__ = tableName
    __table_args__ = (db.Index(f'uk_{tableName}_CASE_ID',
                               'CASE_ID',
                               unique=True), )

    CASE_ID = db.Column(db.String(255),
                        primary_key=True,
                        autoincrement=False,
                        nullable=False)
    CASE_NAME = db.Column(db.String(255), nullable=True)
    KP_NAME = db.Column(db.String(255), nullable=True)

    SUBJECT_NODE = db.Column(db.String(255), nullable=True)
    OBJECT_NODE = db.Column(db.String(255), nullable=True)
    PREDICATE = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_0 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_0 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_1 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_1 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_2 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_2 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_3 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_3 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_4 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_4 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_5 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_5 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_6 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_6 = db.Column(db.String(255), nullable=True)

    SLOT_LABEL_7 = db.Column(db.String(255), nullable=True)
    SLOT_VALUE_7 = db.Column(db.String(255), nullable=True)