class Product(db.Model):
__tablename__ = 'product'
Id = db.Column(db.INTEGER, primary_key=True)
title = db.Column(db.String(255), nullable=False)
group = db.Column(db.String(255), nullable=False)
salesrank = db.Column(db.INTEGER, nullable=False)
ASIN = db.Column(db.String(255), nullable=False)
categories = db.relationship("Category", backref="product")
items = db.relationship("Item", backref="product")
reviews = db.relationship("Review", backref="product")
similar = db.relationship("Similar", backref="product")
def __init__(self, Id, title, group, salesrank, ASIN):
self.Id = Id
self.title = title
self.group = group
self.salesrank = salesrank
self.ASIN = ASIN
def __str__(self):
return str(self.title) + '_' + str(self.group) + '_' + str(
self.salesrank) + '_' + str(self.ASIN)
def __repr__(self):
return '<Product %r>' % self.title
class Similar(db.Model):
__tablename__ = 'similar'
Id = db.Column(db.INTEGER, primary_key=True)
product_Id = db.Column(db.Integer, db.ForeignKey("product.Id"))
ASIN = db.Column(db.String(255), nullable=False)
def __str__(self):
return str(self.product_Id) + " " + str(self.Id) + " " + str(self.ASIN)
class Category(db.Model):
__tablename__ = 'categories'
Id = db.Column(db.INTEGER, primary_key=True)
name = db.Column(db.String(255), nullable=False)
product_Id = db.Column(db.Integer, db.ForeignKey("product.Id"))
def __str__(self):
return str(self.name)
class Samples(db.Model):
__tablename__ = 'samples'
product_Id = db.Column(db.INTEGER, primary_key=True)
vector = db.Column(db.String(255), nullable=False)
score = db.Column(db.INTEGER)
def __str__(self):
return str(self.product_Id) + " " + str(self.vector) + " " + str(
self.score)
class Review(db.Model):
__tablename__ = 'reviews'
Id = db.Column(db.INTEGER, primary_key=True)
product_Id = db.Column(db.Integer, db.ForeignKey("product.Id"))
total = db.Column(db.INTEGER)
downloaded = db.Column(db.INTEGER)
avg_rating = db.Column(db.INTEGER)
def __str__(self):
return str(self.Id) + '_' + str(self.product_Id) + '_' + str(
self.total) + '_' + str(self.downloaded) + '_' + str(
self.avg_rating)
class Item(db.Model):
__tablename__ = 'items'
Id = db.Column(db.INTEGER, primary_key=True)
product_Id = db.Column(db.Integer, db.ForeignKey("product.Id"))
create_time = db.Column(db.DateTime)
cutomer_Id = db.Column(db.String(255))
rating = db.Column(db.INTEGER)
votes = db.Column(db.INTEGER)
helpful = db.Column(db.INTEGER)