class Products(db.Model):
id = db.Column(db.Integer, primary_key=True)
date_add = db.Column(db.DateTime, unique=False, nullable=False)
productcode = db.Column(db.String(50), unique=True, nullable=False)
title = db.Column(db.String(35), unique=False, nullable=False)
price = db.Column(db.String(7), unique=False, nullable=False)
shipping_fee = db.Column(db.String(5), unique=False, nullable=False)
promotion = db.Column(db.String(6), unique=False, nullable=True, default=0)
promotion_expire = db.Column(db.DateTime, unique=False, nullable=True)
imgfile1 = db.Column(db.String(50), unique=True, nullable=False)
imgfile2 = db.Column(db.String(50), unique=True, nullable=True)
imgfile3 = db.Column(db.String(50), unique=True, nullable=True)
imgfile4 = db.Column(db.String(50), unique=True, nullable=True)
quantity = db.Column(db.Integer, unique=False, nullable=False, default=0)
category = db.Column(db.String(20),
unique=False,
nullable=False,
default='Category')
tag = db.Column(db.String(50), unique=False, nullable=True, default='tag')
description = db.Column(db.Text, nullable=True)
view = db.Column(db.Integer, unique=False, nullable=False, default=0)
number_bought = db.Column(db.Integer,
unique=False,
nullable=False,
default=0)
owner_id = db.Column(db.Integer, db.ForeignKey('user.id'))
review = db.relationship("Reviews", backref='product_review')
def __repr__(self):
return "(title: %s)" % (self.title)
class Cart(db.Model):
id = db.Column(db.Integer, primary_key=True)
cartcode = db.Column(db.String(50), unique=True, nullable=False)
date_create = db.Column(db.DateTime, nullable=False)
date_expire = db.Column(db.DateTime, nullable=False)
owner = db.Column(db.Integer, db.ForeignKey('cookie.id'))
items = db.relationship("CartItems", backref='cart')
def __repr__(self):
return "(CartCode: %s)" % (self.cartcode)
class Profile(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(30), nullable=False)
content = db.Column(db.Text, nullable=False)
image1 = db.Column(db.String(50), unique=True, nullable=True)
icon = db.Column(db.String(50), unique=True, nullable=True)
profile_owner = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return "(Profile: {})".format(self.title)
class Reviews(db.Model):
id = db.Column(db.Integer, primary_key=True)
star_rating = db.Column(db.Integer, unique=False, nullable=False)
messages = db.Column(db.String(100), nullable=True)
review_by = db.Column(db.String(12), nullable=False)
review_date = db.Column(db.DateTime, nullable=False)
product_id = db.Column(db.Integer, db.ForeignKey('products.id'))
def __repr__(self):
return "(star_rating: {}, by: {})".format(self.star_rating,
self.review_by)
class CartItems(db.Model):
id = db.Column(db.Integer, primary_key=True)
product = db.Column(db.String(50), unique=False, nullable=False)
img = db.Column(db.String(50), unique=False, nullable=False)
quantity = db.Column(db.Integer, unique=False, nullable=False, default=1)
price = db.Column(db.String(7), unique=False, nullable=False)
seller = db.Column(db.String(22), unique=False, nullable=False)
cartid = db.Column(db.Integer, db.ForeignKey('cart.id'))
def __repr__(self):
return "(Product: %s)" % (self.product)
class Order(db.Model):
__tablename__ = 'orders'
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime, nullable=False)
summ = db.Column(db.Integer, nullable=False)
status = db.Column(db.String, nullable=False)
meals = db.relationship("Meal",
secondary=meals_orders_association,
back_populates="orders")
user_id = db.Column(db.Integer, db.ForeignKey("users.id"))
user = db.relationship("User", back_populates="orders")
class Meal(db.Model):
__tablename__ = 'meals'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(), nullable=False)
price = db.Column(db.Integer, nullable=False)
description = db.Column(db.String(), nullable=False)
picture = db.Column(db.String(), nullable=False)
category_id = db.Column(db.Integer, db.ForeignKey("categories.id"))
category = db.relationship("Category", back_populates="meals")
orders = db.relationship("Order",
secondary=meals_orders_association,
back_populates="meals")
class PaymentRecieved(db.Model):
id = db.Column(db.Integer, primary_key=True)
buyer_firstname = db.Column(db.String(30), unique=False, nullable=True)
buyer_lastname = db.Column(db.String(30), unique=False, nullable=True)
item = db.Column(db.String(50), unique=False, nullable=False)
order_no = db.Column(db.String(10), unique=False, nullable=False)
paid_on = db.Column(db.DateTime, nullable=True)
recieve_date = db.Column(db.DateTime, nullable=True)
amount = db.Column(db.String(7), unique=False, nullable=False)
recipient = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return "(เลขที่: {})".format(self.id)
class Blog(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(30), unique=True, nullable=False)
sub_title = db.Column(db.Text, nullable=False)
content = db.Column(db.Text, nullable=False)
image1 = db.Column(db.String(50), unique=True, nullable=True)
image2 = db.Column(db.String(50), unique=True, nullable=True)
image3 = db.Column(db.String(50), unique=True, nullable=True)
date_publish = db.Column(db.DateTime, nullable=False)
author = db.Column(db.String(10), unique=False, nullable=False)
blog_owner = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return "(Blog: {}, Author: {}, Publish: {})".format(
self.title, self.author, self.date_publish)
class ShipAddress(db.Model):
id = db.Column(db.Integer, primary_key=True)
firstname = db.Column(db.String(30), unique=False, nullable=False)
lastname = db.Column(db.String(30), unique=False, nullable=False)
contact = db.Column(db.String(20), unique=False, nullable=False)
homeaddress = db.Column(db.String(40), unique=False, nullable=False)
housename = db.Column(db.String(30), unique=False, nullable=True)
street = db.Column(db.String(40), unique=False, nullable=True)
sub_street = db.Column(db.String(50), unique=False, nullable=True)
subdistrict = db.Column(db.String(30), unique=False, nullable=False)
district = db.Column(db.String(30), unique=False, nullable=False)
province = db.Column(db.String(30), unique=False, nullable=False)
country = db.Column(db.String(34), unique=False, nullable=False)
postcode = db.Column(db.Integer, unique=False, nullable=False)
ccheckout_address = db.Column(db.Integer, db.ForeignKey('checkout.id'))
def __repr__(self):
return "(Name: {} {})".format(self.firstname, self.lastname)
class CheckoutItems(db.Model):
id = db.Column(db.Integer, primary_key=True)
product = db.Column(db.String(50), unique=False, nullable=False)
img = db.Column(db.String(50), unique=False, nullable=False)
quantity = db.Column(db.Integer, unique=False, nullable=False, default=1)
price = db.Column(db.String(7), unique=False, nullable=False)
seller_price = db.Column(db.String(7), unique=False, nullable=False)
seller = db.Column(db.String(22), unique=False, nullable=False)
status = db.Column(db.String(20),
unique=False,
nullable=False,
default='รอการชำระเงิน')
ship_date = db.Column(db.DateTime, nullable=True)
tracking = db.Column(db.String(100), unique=False, nullable=True)
checkoutid = db.Column(db.Integer, db.ForeignKey('checkout.id'))
def __repr__(self):
return "(Product: %s)" % (self.product)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(32), nullable=False)
mail = db.Column(db.String(55), nullable=False, unique=True)
password_hash = db.Column(db.String(128), nullable=False)
address = db.Column(db.String(100))
orders = db.relationship("Order", back_populates="user")
meals_orders_association = db.Table(
"meals_orders", db.Column("meal_id", db.Integer,
db.ForeignKey("meals.id")),
db.Column("order_id", db.Integer, db.ForeignKey("orders.id")))
class Meal(db.Model):
__tablename__ = 'meals'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(), nullable=False)
price = db.Column(db.Integer, nullable=False)
description = db.Column(db.String(), nullable=False)
picture = db.Column(db.String(), nullable=False)
category_id = db.Column(db.Integer, db.ForeignKey("categories.id"))
category = db.relationship("Category", back_populates="meals")
orders = db.relationship("Order",
secondary=meals_orders_association,