database.py

from openedoo_project import db
from openedoo_project import config


class EclassSchema(db.Model):
    """Eclass database schema

    :id integer: The Eclass id
    :name varchar: The Eclass name
    :course varchar: The course where Eclass belongs to
    :university varchar: The university where Eclass belongs to
    :privilege varchar: The Eclass privilege, public or private
    """

    __tablename__ = 'eclass'
    __table_args__ = {'extend_existing': True}
    id = db.Column(db.Integer, primary_key=True, nullable=False)
    name = db.Column(db.VARCHAR(50), nullable=False)
    course = db.Column(db.VARCHAR(50))
    university = db.Column(db.VARCHAR(50))
    privilege = db.Column(db.VARCHAR(8), default="private")


class EclassPostsSchema(db.Model):
    """Eclass posts database schema.

    :id integer: The Post id
    :class_id integer: The Eclass id
    :description text: The post's description
    :reply text: The post's reply
    :attachment text: The post's file attachment
    :created datetime: Time when The post is created
    :edited datetime: Time when The post is edited
    """

    __tablename__ = 'eclass_discussion'
    __table_args__ = {'extend_existing': True}
    id = db.Column(db.Integer, primary_key=True, nullable=False)
    class_id = db.Column(db.Integer, nullable=False)
    description = db.Column(db.Text)
    reply = db.Column(db.UnicodeText())
    attachment = db.Column(db.Text)
    created = db.Column(db.DateTime)
    edited = db.Column(db.DateTime)


class EclassMemberSchema(db.Model):
    """Eclass member database schema.

    :id integer: The membership id
    :class_id integer: The eclass id
    :user_id integer: The user id
    :is_creator integer: (bool) The creator flag
    """

    __tablename__ = 'eclass_member'
    __table_args__ = {'extend_existing': True}
    id = db.Column(db.Integer, primary_key=True, nullable=False)
    class_id = db.Column(db.Integer, nullable=False)
    user_id = db.Column(db.Integer, nullable=False)
    is_creator = db.Column(db.SmallInteger, nullable=False, default=0)