Skip to content

xref_source_db_model

python.ensembl.xrefs.xref_source_db_model

Xref Source database ORM.

Base = declarative_base() module-attribute

ChecksumXref

Bases: Base

Source code in src/python/ensembl/xrefs/xref_source_db_model.py 
26
27
28
29
30
31
32
33
class ChecksumXref(Base):
    __tablename__ = "checksum_xref"
    __table_args__ = (Index("checksum_idx", "checksum", mysql_length=10), {"mysql_engine": "MyISAM"})

    checksum_xref_id: Column = Column(INTEGER, primary_key=True, autoincrement=True)
    source_id: Column = Column(INTEGER, nullable=False)
    accession: Column = Column(VARCHAR(14), nullable=False)
    checksum: Column = Column(VARCHAR(32), nullable=False)

accession = Column(VARCHAR(14), nullable=False) class-attribute instance-attribute

checksum = Column(VARCHAR(32), nullable=False) class-attribute instance-attribute

checksum_xref_id = Column(INTEGER, primary_key=True, autoincrement=True) class-attribute instance-attribute

source_id = Column(INTEGER, nullable=False) class-attribute instance-attribute

Source

Bases: Base

Source code in src/python/ensembl/xrefs/xref_source_db_model.py 
36
37
38
39
40
41
class Source(Base):
    __tablename__ = "source"

    source_id: Column = Column(INTEGER(10), primary_key=True, autoincrement=True)
    name: Column = Column(VARCHAR(128), index=True, unique=True)
    parser: Column = Column(VARCHAR(128))

name = Column(VARCHAR(128), index=True, unique=True) class-attribute instance-attribute

parser = Column(VARCHAR(128)) class-attribute instance-attribute

source_id = Column(INTEGER(10), primary_key=True, autoincrement=True) class-attribute instance-attribute

Version

Bases: Base

Source code in src/python/ensembl/xrefs/xref_source_db_model.py 
44
45
46
47
48
49
50
51
52
53
54
class Version(Base):
    __tablename__ = "version"
    __table_args__ = (Index("version_idx", "source_id", "revision"),)

    version_id: Column = Column(INTEGER(10), primary_key=True, autoincrement=True)
    source_id: Column = Column(INTEGER(10), ForeignKey("source.source_id"))
    revision: Column = Column(VARCHAR(255))
    priority: Column = Column(INTEGER(10), nullable=False)
    file_path: Column = Column(VARCHAR(255))
    db: Column = Column(VARCHAR(255))
    clean_path: Column = Column(VARCHAR(255))

clean_path = Column(VARCHAR(255)) class-attribute instance-attribute

db = Column(VARCHAR(255)) class-attribute instance-attribute

file_path = Column(VARCHAR(255)) class-attribute instance-attribute

priority = Column(INTEGER(10), nullable=False) class-attribute instance-attribute

revision = Column(VARCHAR(255)) class-attribute instance-attribute

source_id = Column(INTEGER(10), ForeignKey('source.source_id')) class-attribute instance-attribute

version_id = Column(INTEGER(10), primary_key=True, autoincrement=True) class-attribute instance-attribute