class Good(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(128))
    desc = db.Column(db.Text)
    price = db.Column(db.Float)
    quantity = db.Column(db.Integer)
    slug = db.Column(db.String(64))
    imgsrc =  db.Column(db.String(128))

    category_id = db.Column(db.Integer, db.ForeignKey('category.id'))

    order_id = db.Column(db.Integer, db.ForeignKey('order.id'))

    def __init__(self, *args, **kwargs):
        super(Good, self).__init__(*args, **kwargs)
        self.generate_slug()


    def generate_slug(self):
        if self.title:
            self.slug = slugify(self.title)


    def __repr__(self):
        return "<id : {}, title : {}>".format(self.id , self.title)

    def __unicode__(self):
        return self.title

class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(64), index=True)
    email = db.Column(db.String(120), index=True, unique=True)
    password = db.Column(db.String(128))

    orders = db.relationship('Order', backref='user', lazy='dynamic')

class Order(db.Model):
     id = db.Column(db.Integer, primary_key=True)
     user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
     goods = db.relationship('Good', backref='order',lazy='dynamic')