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

    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 = Column(VARCHAR(14), nullable=False) class-attribute instance-attribute

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

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

source_id: Column = 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
42
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)
    active: Column = Column(BOOLEAN, nullable=False, server_default=text("1"))
    parser: Column = Column(VARCHAR(128))

active: Column = Column(BOOLEAN, nullable=False, server_default=text('1')) class-attribute instance-attribute

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

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

source_id: Column = 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 
45
46
47
48
49
50
51
52
53
54
55
56
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))
    count_seen: Column = Column(INTEGER(10), nullable=False)
    uri: Column = Column(VARCHAR(255))
    index_uri: Column = Column(VARCHAR(255))
    clean_uri: Column = Column(VARCHAR(255))
    preparse: Column = Column(BOOLEAN, nullable=False, server_default=text("0"))

clean_uri: Column = Column(VARCHAR(255)) class-attribute instance-attribute

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

index_uri: Column = Column(VARCHAR(255)) class-attribute instance-attribute

preparse: Column = Column(BOOLEAN, nullable=False, server_default=text('0')) class-attribute instance-attribute

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

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

uri: Column = Column(VARCHAR(255)) class-attribute instance-attribute

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