class CrcBORROWER(db.Model):
"""Represents a CrcBORROWER record."""
def __init__(self):
pass
__tablename__ = 'crcBORROWER'
id = db.Column(db.Integer(15, unsigned=True),
nullable=False,
primary_key=True,
autoincrement=True)
ccid = db.Column(db.Integer(15, unsigned=True),
nullable=True,
unique=True,
server_default=None)
name = db.Column(db.String(255),
nullable=False,
server_default='',
index=True)
email = db.Column(db.String(255),
nullable=False,
server_default='',
index=True)
phone = db.Column(db.String(60), nullable=True)
address = db.Column(db.String(60), nullable=True)
mailbox = db.Column(db.String(30), nullable=True)
borrower_since = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
borrower_until = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
notes = db.Column(db.Text, nullable=True)
class CmtSUBSCRIPTION(db.Model):
"""Represents a CmtSUBSCRIPTION record."""
__tablename__ = 'cmtSUBSCRIPTION'
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
nullable=False,
primary_key=True)
id_user = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(User.id),
nullable=False,
primary_key=True)
creation_time = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
bibrec = db.relationship(Bibrec)
user = db.relationship(User, backref='comment_subscriptions')
user_commented_records = db.relationship(
Bibrec,
backref='user_comment_subscritions',
primaryjoin=lambda: db.and_(
CmtSUBSCRIPTION.id_bibrec == Bibrec.id, CmtSUBSCRIPTION.id_user ==
current_user.get_id()),
viewonly=True)
class Bibdocfsinfo(db.Model):
"""Represents a Bibdocfsinfo record."""
__tablename__ = 'bibdocfsinfo'
id_bibdoc = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Bibdoc.id),
primary_key=True,
nullable=False,
autoincrement=False)
version = db.Column(db.TinyInteger(4, unsigned=True),
primary_key=True,
nullable=False,
autoincrement=False)
format = db.Column(db.String(50),
primary_key=True,
nullable=False,
index=True)
last_version = db.Column(db.Boolean, nullable=False, index=True)
cd = db.Column(db.DateTime, nullable=False, index=True)
md = db.Column(db.DateTime, nullable=False, index=True)
checksum = db.Column(db.Char(32), nullable=False)
filesize = db.Column(db.BigInteger(15, unsigned=True),
nullable=False,
index=True)
mime = db.Column(db.String(100), nullable=False, index=True)
master_format = db.Column(db.String(50))
class CollectionExternalcollection(db.Model):
"""Represents a CollectionExternalcollection record."""
__tablename__ = 'collection_externalcollection'
id_collection = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Collection.id),
primary_key=True,
server_default='0')
id_externalcollection = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Externalcollection.id),
primary_key=True,
server_default='0')
type = db.Column(db.TinyInteger(4, unsigned=True),
server_default='0',
nullable=False)
def _collection_type(type):
return db.relationship(
Collection,
primaryjoin=lambda: db.and_(
CollectionExternalcollection.id_collection == Collection.id,
CollectionExternalcollection.type == type),
backref='_externalcollections_' + str(type))
collection_0 = _collection_type(0)
collection_1 = _collection_type(1)
collection_2 = _collection_type(2)
externalcollection = db.relationship(Externalcollection)
class RnkMETHODDATA(db.Model):
"""Represents a RnkMETHODDATA record."""
__tablename__ = 'rnkMETHODDATA'
id_rnkMETHOD = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(RnkMETHOD.id),
primary_key=True)
relevance_data = db.Column(db.iLargeBinary, nullable=True)
class FieldTag(db.Model):
"""Represents a FieldTag record."""
__tablename__ = 'field_tag'
id_field = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey('field.id'),
nullable=False,
primary_key=True)
id_tag = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey('tag.id'),
nullable=False,
primary_key=True)
score = db.Column(db.TinyInteger(4, unsigned=True),
nullable=False,
server_default='0')
tag = db.relationship(Tag, backref='fields', order_by=score)
field = db.relationship(Field, backref='tags', order_by=score)
def __init__(self, score=None, tup=None, *args, **kwargs):
if score is not None:
self.score = score
if tup is not None:
self.tag = Tag(tup)
super(FieldTag, self).__init__(*args, **kwargs)
@property
def as_tag(self):
""" Returns Tag record directly."""
return self.tag
class AccAuthorization(db.Model):
"""Represents a AccAssociation record."""
__tablename__ = 'accROLE_accACTION_accARGUMENT'
id_accROLE = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AccROLE.id),
nullable=True,
autoincrement=False,
primary_key=True,
index=True)
id_accACTION = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(AccACTION.id),
nullable=True,
autoincrement=False,
primary_key=True,
index=True)
id_accARGUMENT = db.Column(
db.Integer(15), # , unsigned=True),
db.ForeignKey(AccARGUMENT.id),
nullable=True,
primary_key=True,
autoincrement=False,
index=True)
argumentlistid = db.Column(db.MediumInteger(8),
nullable=True,
autoincrement=False,
primary_key=True)
role = db.relationship(AccROLE, backref='authorizations')
action = db.relationship(AccACTION, backref='authorizations')
argument = db.relationship(AccARGUMENT, backref='authorizations')
class PidLog(db.Model):
"""
Audit log of actions happening to persistent identifiers.
This model is primarily used through PersistentIdentifier.log and rarely
created manually.
"""
__tablename__ = 'pidLOG'
__table_args__ = (db.Index('idx_action', 'action'), )
id = db.Column(db.Integer(15, unsigned=True), primary_key=True)
""" Id of persistent identifier entry """
id_pid = db.Column(
db.Integer(15, unsigned=True),
db.ForeignKey(PersistentIdentifier.id),
nullable=True,
)
""" PID """
timestamp = db.Column(db.DateTime(), nullable=False, default=datetime.now)
""" Creation datetime of entry """
action = db.Column(db.String(10), nullable=False)
""" Action identifier """
message = db.Column(db.Text(), nullable=False)
""" Log message """
class Example(db.Model):
"""Represents a Example record."""
__tablename__ = 'example'
id = db.Column(db.MediumInteger(9, unsigned=True),
primary_key=True,
autoincrement=True)
type = db.Column(db.Text, nullable=False)
body = db.Column(db.Text, nullable=False)
class Portalbox(db.Model):
"""Represents a Portalbox record."""
__tablename__ = 'portalbox'
id = db.Column(db.MediumInteger(9, unsigned=True),
autoincrement=True,
primary_key=True)
title = db.Column(db.Text, nullable=False)
body = db.Column(db.Text, nullable=False)
class WebQuery(db.Model):
"""Represents a WebQuery record."""
__tablename__ = 'query'
id = db.Column(db.Integer(15, unsigned=True),
primary_key=True,
autoincrement=True)
type = db.Column(db.Char(1), nullable=False, server_default='r')
urlargs = db.Column(db.Text(100), nullable=False, index=True)
class Goto(db.Model):
"""Represents a Goto record."""
__tablename__ = 'goto'
label = db.Column(db.String(150), primary_key=True)
plugin = db.Column(db.String(150), nullable=False)
parameters = db.Column(db.Text, nullable=False)
creation_date = db.Column(db.DateTime, nullable=False, index=True)
modification_date = db.Column(db.DateTime, nullable=False, index=True)
class RnkRECORDSCACHE(db.Model):
"""Represents a RnkRECORDSCACHE record."""
__tablename__ = 'rnkRECORDSCACHE'
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
nullable=True,
primary_key=True)
authorid = db.Column(db.BigInteger(10), primary_key=True, nullable=False)
class AutocompletionCache(db.Model):
"""Stores the pre-calculated most popular authors and subjects for each collection"""
__tablename__ = 'autocompletion_cache'
id_collection = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Collection.id),
primary_key=True,
nullable=False)
subjects = db.Column(db.PickleType())
authors = db.Column(db.PickleType())
class RnkCITATIONDATA(db.Model):
"""Represents a RnkCITATIONDATA record."""
__tablename__ = 'rnkCITATIONDATA'
id = db.Column(db.MediumInteger(8, unsigned=True), primary_key=True)
object_name = db.Column(db.String(20), unique=True, nullable=False)
object_value = db.Column(db.iLargeBinary, nullable=True)
last_updated = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
class RnkWORD01F(db.Model):
"""Represents a RnkWORD01F record."""
__tablename__ = 'rnkWORD01F'
id = db.Column(db.MediumInteger(9, unsigned=True),
nullable=False,
primary_key=True,
autoincrement=True)
term = db.Column(db.String(50), nullable=True, unique=True)
hitlist = db.Column(db.iLargeBinary, nullable=True)
class WapCACHE(db.Model):
"""Represents a WapCACHE record."""
__tablename__ = 'wapCACHE'
object_name = db.Column(db.String(120), primary_key=True, nullable=False)
object_key = db.Column(db.String(120), primary_key=True, nullable=False)
object_value = db.Column(db.Text) #FIXME LongText
object_status = db.Column(db.String(120), index=True)
last_updated = db.Column(db.DateTime, nullable=False, index=True)
class LnkADMINURL(db.Model):
"""Represents a LnkADMINURL record."""
__tablename__ = 'lnkADMINURL'
id = db.Column(db.Integer(15, unsigned=True),
primary_key=True,
nullable=False)
url = db.Column(db.String(100), nullable=False, unique=True)
list = db.Column(db.String(30), nullable=False, index=True)
class RnkSELFCITES(db.Model):
"""Represents a RnkSELFCITES record."""
__tablename__ = 'rnkSELFCITES'
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
nullable=True,
primary_key=True)
count = db.Column(db.Integer(10, unsigned=True), nullable=False)
references = db.Column(db.Text, nullable=False)
last_updated = db.Column(db.DateTime, nullable=False)
class XtrJOB(db.Model):
"""Represents a XtrJOB record."""
def __init__(self):
pass
__tablename__ = 'xtrJOB'
id = db.Column(db.TinyInteger(4), primary_key=True, nullable=False)
name = db.Column(db.String(30), nullable=False)
last_updated = db.Column(db.DateTime, nullable=False)
class Fieldname(db.Model):
"""Represents a Fieldname record."""
__tablename__ = 'fieldname'
id_field = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Field.id),
primary_key=True)
ln = db.Column(db.Char(5), primary_key=True, server_default='')
type = db.Column(db.Char(3), primary_key=True, server_default='sn')
value = db.Column(db.String(255), nullable=False)
field = db.relationship(Field, backref='names')
class BsrMETHOD(db.Model):
"""Represents a BsrMETHOD record."""
__tablename__ = 'bsrMETHOD'
id = db.Column(db.MediumInteger(9, unsigned=True),
primary_key=True,
nullable=False)
name = db.Column(db.String(20), nullable=False, unique=True)
definition = db.Column(db.String(255), nullable=False)
washer = db.Column(db.String(255), nullable=False)
class Collectiondetailedrecordpagetabs(db.Model):
"""Represents a Collectiondetailedrecordpagetabs record."""
__tablename__ = 'collectiondetailedrecordpagetabs'
id_collection = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(Collection.id),
nullable=False,
primary_key=True)
tabs = db.Column(db.String(255), nullable=False, server_default='')
collection = db.relationship(Collection,
backref='collectiondetailedrecordpagetabs')
class RnkMETHODNAME(db.Model):
"""Represents a RnkMETHODNAME record."""
__tablename__ = 'rnkMETHODNAME'
id_rnkMETHOD = db.Column(db.MediumInteger(9, unsigned=True),
db.ForeignKey(RnkMETHOD.id),
primary_key=True)
ln = db.Column(db.Char(5), primary_key=True, server_default='')
type = db.Column(db.Char(3), primary_key=True, server_default='sn')
value = db.Column(db.String(255), nullable=False)
method = db.relationship(RnkMETHOD, backref='names')
class AccROLE(db.Model):
"""Represents a AccROLE record."""
__tablename__ = 'accROLE'
id = db.Column(db.Integer(15, unsigned=True),
primary_key=True,
autoincrement=True)
name = db.Column(db.String(32), unique=True, nullable=True)
description = db.Column(db.String(255), nullable=True)
firerole_def_ser = db.Column(db.iBinary, nullable=True)
firerole_def_src = db.Column(db.Text, nullable=True)
class CrcLOANREQUEST(db.Model):
"""Represents a CrcLOANREQUEST record."""
def __init__(self):
pass
__tablename__ = 'crcLOANREQUEST'
id = db.Column(db.Integer(15, unsigned=True), nullable=False,
primary_key=True,
autoincrement=True)
id_crcBORROWER = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(CrcBORROWER.id), nullable=False, server_default='0')
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
nullable=False, server_default='0')
barcode = db.Column(db.String(30), db.ForeignKey(CrcITEM.barcode), nullable=False,
server_default='')
period_of_interest_from = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
period_of_interest_to = db.Column(db.DateTime,
nullable=False,
server_default='1900-01-01 00:00:00')
status = db.Column(db.String(20), nullable=False,
server_default='')
notes = db.Column(db.Text, nullable=True)
request_date = db.Column(db.DateTime, nullable=False,
server_default='1900-01-01 00:00:00')
borrower = db.relationship(CrcBORROWER, backref='loanrequests')
bibrec = db.relationship(Bibrec, backref='loanrequests')
item = db.relationship(CrcITEM, backref='loanrequests')
class AccARGUMENT(db.Model):
"""Represents a AccARGUMENT record."""
__tablename__ = 'accARGUMENT'
id = db.Column(
db.Integer(15), # , unsigned=True),
primary_key=True,
autoincrement=True)
keyword = db.Column(db.String(32), nullable=True)
value = db.Column(db.String(255), nullable=True)
__table_args__ = (db.Index('KEYVAL', keyword,
value), db.Model.__table_args__)
class UserExpJOB(db.Model):
"""Represents a UserExpJOB record."""
__tablename__ = 'user_expJOB'
id_user = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(User.id),
nullable=False,
primary_key=True)
id_expJOB = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(ExpJOB.id),
nullable=False,
primary_key=True)
class Fieldvalue(db.Model):
"""Represents a Fieldvalue record."""
def __init__(self):
pass
__tablename__ = 'fieldvalue'
id = db.Column(db.MediumInteger(9, unsigned=True),
primary_key=True,
autoincrement=True)
name = db.Column(db.String(255), nullable=False)
value = db.Column(db.Text, nullable=False)
class JrnJOURNAL(db.Model):
"""Represents a JrnJOURNAL record."""
__tablename__ = 'jrnJOURNAL'
id = db.Column(db.MediumInteger(9, unsigned=True),
nullable=False,
primary_key=True,
autoincrement=True)
name = db.Column(db.String(50),
nullable=False,
unique=True,
server_default='')
