Db Model

from _datetime import datetime

from app.db.base_db import db


class Users(db.Model):
    __tablename__ = 'users'
    uid = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), unique=True)
    password = db.Column(db.String(70))
    email = db.Column(db.String(50), unique=True)

    def __init__(self, username, password, email):
        self.username = username
        self.password = password
        self.email = email

    pass


class Deals(db.Model):
    __tablename__ = 'deals'
    did = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50))
    title = db.Column(db.String(100))
    description = db.Column(db.String(1000))
    actual_price = db.Column(db.Integer(15))
    disc_price = db.Column(db.Integer(15))
    category_id = db.Column(db.Integer, db.ForeignKey('category.cid'))
    category = db.relationship('Category',
                               backref=db.backref('category', lazy='dynamic'))

    store_id = db.Column(db.Integer, db.ForeignKey('stores.sid'))
    store = db.relationship('Stores',
                            backref=db.backref('store', lazy='dynamic'))
    active = db.Column(db.Boolean)
    posted = db.Column(db.DateTime)
    expired = db.Column(db.DateTime)
    thumbnail = db.Column(db.String(1000))

    def __init__(self, username, title, description, actual_price, disc_price, category, store, active, expired,
                 thumbnail, posted=None):
        self.username = username
        self.title = title
        self.description = description
        self.actual_price = actual_price
        self.disc_price = disc_price
        category = db.relationship('Category',
                                   backref=db.backref('category', lazy='dynamic'))

        store_id = db.Column(db.Integer, db.ForeignKey('stores.sid'))
        store = db.relationship('Stores',
                                backref=db.backref('store', lazy='dynamic'))
        self.active = active
        if posted is None:
            posted = datetime.utcnow()
        self.expired = expired
        self.thumbnail = thumbnail


class Coupons(db.Model):
    __tablename__ = 'coupons'
    cid = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50))
    title = db.Column(db.String(100))
    description = db.Column(db.String(1000))
    actual_price = db.Column(db.Integer(15))
    disc_price = db.Column(db.Integer(15))
    category = db.Column(db.String(50))
    store = db.Column(db.String(50))
    active = db.Column(db.Boolean)
    posted = db.Column(db.DateTime)
    expired = db.Column(db.DateTime)
    code = db.Column(db.String(100))
    thumbnail = db.Column(db.String(1000))

    def __init__(self, username, title, description, actual_price, disc_price, category, store, active, expired,
                 code, thumbnail, posted=None):
        self.username = username
        self.title = title
        self.description = description
        self.actual_price = actual_price
        self.disc_price = disc_price
        self.category = category
        self.store = store
        self.active = active
        if posted is None:
            posted = datetime.utcnow()
        self.expired = expired
        self.code = code
        self.thumbnail = thumbnail


class Category(db.Model):
    __tablename__ = 'categories.html'
    cid = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)
    active = db.Column(db.Boolean)

    def __init__(self, name, active):
        self.name = name
        self.active = active


class Stores(db.Model):
    __tablename__ = 'stores'
    sid = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)
    active = db.Column(db.Boolean)

    def __init__(self, name, active):
        self.name = name
        self.active = active