Homec4science
Diffusion invenio-infoscience (master) Browse

R3600/modules/webcomment/lib/webcomment_model.py
e1388e512fcdmaster

Last Change
Raw File

webcomment_model.py
View Options

# -*- coding: utf-8 -*-
#
## This file is part of Invenio.
## Copyright (C) 2011, 2012 CERN.
##
## Invenio is free software; you can redistribute it and/or
## modify it under the terms of the GNU General Public License as
## published by the Free Software Foundation; either version 2 of the
## License, or (at your option) any later version.
##
## Invenio is distributed in the hope that it will be useful, but
## WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Invenio; if not, write to the Free Software Foundation, Inc.,
## 59 Temple Place, Suite 330, Boston, MA 02D111-1307, USA.
"""
WebComment database models.
"""
# General imports.
from invenio.sqlalchemyutils import db
# Create your models here.
from invenio.bibedit_model import Bibrec
from invenio.websession_model import User
class CmtRECORDCOMMENT(db.Model):
"""Represents a CmtRECORDCOMMENT record."""
__tablename__ = 'cmtRECORDCOMMENT'
id = db.Column(db.Integer(15, unsigned=True), nullable=False,
primary_key=True, autoincrement=True)
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True), db.ForeignKey(Bibrec.id),
nullable=False, server_default='0') # CmtRECORDCINNENT
id_user = db.Column(db.Integer(15, unsigned=True), db.ForeignKey(User.id),
nullable=False, server_default='0')
title = db.Column(db.String(255), nullable=False,
server_default='')
body = db.Column(db.Text, nullable=False)
date_creation = db.Column(db.DateTime, nullable=False,
server_default='0001-01-01 00:00:00')
star_score = db.Column(db.TinyInteger(5, unsigned=True), nullable=False,
server_default='0')
nb_votes_yes = db.Column(db.Integer(10), nullable=False,
server_default='0')
nb_votes_total = db.Column(db.Integer(10, unsigned=True), nullable=False,
server_default='0')
nb_abuse_reports = db.Column(db.Integer(10), nullable=False,
server_default='0')
status = db.Column(db.Char(2), nullable=False, index=True,
server_default='ok')
round_name = db.Column(db.String(255), nullable=False,
server_default='')
restriction = db.Column(db.String(50), nullable=False,
server_default='')
in_reply_to_id_cmtRECORDCOMMENT = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(id), nullable=False, server_default='0')
reply_order_cached_data = db.Column(db.Binary, nullable=True)
bibrec = db.relationship(Bibrec, backref='recordcomments')
user = db.relationship(User, backref='recordcomments')
replies = db.relationship('CmtRECORDCOMMENT',
backref=db.backref('in_reply_to', remote_side=[id]))
__table_args__ = (db.Index('cmtRECORDCOMMENT_reply_order_cached_data',
reply_order_cached_data, mysql_length=[40]),
db.Model.__table_args__)
class CmtACTIONHISTORY(db.Model):
"""Represents a CmtACTIONHISTORY record."""
__tablename__ = 'cmtACTIONHISTORY'
#id = db.Column(db.Integer(15, unsigned=True), nullable=False,
# primary_key=True,
# autoincrement=True)
id_cmtRECORDCOMMENT = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(CmtRECORDCOMMENT.id),
nullable=True,
primary_key=True)
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
nullable=True, primary_key=True)
id_user = db.Column(db.Integer(15, unsigned=True), db.ForeignKey(User.id),
nullable=True, primary_key=True)
client_host = db.Column(db.Integer(10, unsigned=True),
nullable=True)
action_time = db.Column(db.DateTime, nullable=False,
server_default='0001-01-01 00:00:00')
action_code = db.Column(db.Char(1), nullable=False, index=True)
recordcomment = db.relationship(CmtRECORDCOMMENT,
backref='actionhistory')
bibrec = db.relationship(Bibrec)
user = db.relationship(User)
from invenio.webuser_flask import current_user
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='0001-01-01 00:00:00')
bibrec = db.relationship(Bibrec)
user = db.relationship(User, backref='comment_subscriptions')
class CmtCOLLAPSED(db.Model):
"""Represents a CmtCOLLAPSED record."""
__tablename__ = 'cmtCOLLAPSED'
id_bibrec = db.Column(db.MediumInteger(8, unsigned=True),
db.ForeignKey(Bibrec.id),
primary_key=True, nullable=False)
id_cmtRECORDCOMMENT = db.Column(db.Integer(15, unsigned=True),
db.ForeignKey(CmtRECORDCOMMENT.id),
primary_key=True, nullable=False)
id_user = db.Column(db.Integer(15, unsigned=True), db.ForeignKey(User.id),
primary_key=True, nullable=False)
__all__ = ['CmtRECORDCOMMENT',
'CmtACTIONHISTORY',
'CmtSUBSCRIPTION',
'CmtCOLLAPSED']
c4science · Help