class VocTermHandler(Handler):
DATA_TYPE = "VocTerm"
MODEL = VocTerm
COLUMNS = [ColumnDef(VocTerm._term_key, updatable=False),
ColumnDef(VocTerm.term),
ColumnDef(VocTerm.primaryid, updatable=False),
ColumnDef(VocTerm._vocab_key, updatable=False),
ColumnDef(VocTerm.vocabname, updatable=False,
foreignColumn=VocTerm._vocab_key,
foreignInsert=Vocab._vocab_key,
foreignMapping=Vocab.name
),
ColumnDef(VocTerm.isobsolete),
ColumnDef(VocTerm._createdby_key),
ColumnDef(VocTerm._modifiedby_key),
ColumnDef(VocTerm.modification_date)]
UNIQUE_KEYS = [
('_term_key'),
('term', '_vocab_key'),
('term', 'vocabname'),
('primaryid'),
]
class AccessionReferenceHandler(Handler):
DATA_TYPE = "AccessionReference"
MODEL = AccessionReference
COLUMNS = [
ColumnDef(AccessionReference._accession_key, updatable=False),
ColumnDef(AccessionReference._refs_key, updatable=False)
]
UNIQUE_KEYS = [
('_accession_key', '_refs_key'),
]
class MarkerTypeHandler(Handler):
DATA_TYPE = "MarkerType"
MODEL = MarkerType
COLUMNS = [
ColumnDef(MarkerType._marker_type_key, updatable=False),
ColumnDef(MarkerType.name)
]
UNIQUE_KEYS = [
('_marker_type_key'),
('name'),
]
class VocabHandler(Handler):
DATA_TYPE = "Vocab"
MODEL = Vocab
COLUMNS = [
ColumnDef(Vocab._vocab_key, updatable=False),
ColumnDef(Vocab.name),
ColumnDef(Vocab._refs_key, default=-1),
ColumnDef(Vocab._logicaldb_key, default=-1)
]
UNIQUE_KEYS = [
('_vocab_key'),
('name', '_refs_key', '_logicaldb_key'),
]
class VocAnnotHandler(Handler):
DATA_TYPE = "VocAnnot"
MODEL = VocAnnot
COLUMNS = [
ColumnDef(VocAnnot._annot_key, updatable=False),
ColumnDef(VocAnnot._annottype_key),
ColumnDef(VocAnnot._object_key),
ColumnDef(VocAnnot._term_key),
ColumnDef(VocAnnot._qualifier_key),
]
UNIQUE_KEYS = [
('_annot_key'),
('_annottype_key', '_object_key', '_term_key', '_qualifier_key'),
]
class VocEvidenceHandler(Handler):
DATA_TYPE = "VocEvidence"
MODEL = VocEvidence
COLUMNS = [
ColumnDef(VocEvidence._annotevidence_key, updatable=False),
ColumnDef(VocEvidence._annot_key),
ColumnDef(VocEvidence._refs_key),
ColumnDef(VocEvidence._evidenceterm_key),
ColumnDef(VocEvidence._modifiedby_key)
]
UNIQUE_KEYS = [
('_annotevidence_key'),
('_annot_key', '_refs_key', '_evidenceterm_key'),
]
class VocEvidencePropertyHandler(Handler):
DATA_TYPE = "VocEvidenceProperty"
MODEL = VocEvidenceProperty
COLUMNS = [
ColumnDef(VocEvidenceProperty._evidenceproperty_key, updatable=False),
ColumnDef(VocEvidenceProperty._annotevidence_key),
ColumnDef(VocEvidenceProperty._propertyterm_key),
ColumnDef(VocEvidenceProperty.value),
ColumnDef(VocEvidenceProperty.stanza, default=1),
ColumnDef(VocEvidenceProperty.sequencenum, default=1),
ColumnDef(VocEvidenceProperty._modifiedby_key)
]
UNIQUE_KEYS = [
('_evidenceproperty_key'),
('_annotevidence_key', '_propertyterm_key', 'stanza', 'sequencenum'),
]
class AccessionHandler(Handler):
DATA_TYPE = "Accession"
MODEL = Accession
COLUMNS = [
ColumnDef(Accession._accession_key, updatable=False),
ColumnDef(Accession.accid),
ColumnDef(Accession.prefixpart),
ColumnDef(Accession.numericpart),
ColumnDef(Accession._object_key),
ColumnDef(Accession._mgitype_key),
ColumnDef(Accession._logicaldb_key),
ColumnDef(Accession.private),
ColumnDef(Accession.preferred),
ColumnDef(Accession._createdby_key),
ColumnDef(Accession._modifiedby_key)
]
UNIQUE_KEYS = [
('_accession_key'),
('accid', '_object_key', '_mgitype_key', '_logicaldb_key'),
]