class Cookie(db.Model):
id = db.Column(db.Integer, primary_key=True)
cook_id = db.Column(db.String(50), nullable=False)
cart = db.relationship("Cart", backref='cartowner', uselist=False)
def __repr__(self):
return "(cookie: %s)" % (self.cook_id)
class Nex(db.Model):
id = db.Column(db.Integer, primary_key=True)
nex_ap = db.Column(db.String(50), unique=True, nullable=False)
nex_key = db.Column(db.String(50), unique=True, nullable=False)
def __repr__(self):
return "nothing"
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")
class PasswordChange(db.Model):
id = db.Column(db.Integer, primary_key=True)
contact = db.Column(db.String(12), unique=True, nullable=False)
otp = db.Column(db.String(12), unique=True, nullable=False)
expire = db.Column(db.DateTime, nullable=False)
def __repr__(self):
return "(contact: {}, otp: {}, expire{})".format(
self.contact, self.otp, self.expire)
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 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 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 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 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 Checkout(db.Model):
id = db.Column(db.Integer, primary_key=True)
contact = db.Column(db.String(20), unique=False, nullable=False)
reference = db.Column(db.String(10), unique=True, nullable=False)
confirm_address = db.Column(db.String(20), unique=False, default='n')
payment = db.Column(db.String(20), unique=False, default='n')
payment_expire = db.Column(db.DateTime, nullable=True)
payment_complete = db.Column(db.DateTime, nullable=True)
totalprice = db.Column(db.String(20), unique=False, nullable=True)
items = db.relationship("CheckoutItems", backref='Checkout')
shippingaddress = db.relationship("ShipAddress",
backref='CheckoutAddress',
uselist=False)
def __repr__(self):
return "(Name: {})".format(self.contact)
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 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 User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(22), unique=True, nullable=False)
email = db.Column(db.String(40), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
firstname = db.Column(db.String(30), nullable=True)
lastname = db.Column(db.String(40), nullable=True)
contact = db.Column(db.String(12), unique=True, nullable=True)
alter_contact = db.Column(db.String(10), unique=True, nullable=True)
role = db.Column(db.String(6), unique=False, nullable=False)
verified = db.Column(db.String(3),
unique=False,
default='no',
nullable=False)
date_register = db.Column(db.DateTime, unique=False, nullable=False)
minimum_shippingfee = db.Column(db.String(10),
unique=False,
default='1000',
nullable=True)
product = db.relationship("Products", backref="owner_product")
payment_due = db.relationship("PaymentDue", backref="owner_paymentdue")
payment_recieve = db.relationship("PaymentRecieved",
backref="owner_paymentrevieve")
o_profile = db.relationship("Profile",
backref="owner_profile",
uselist=False)
o_blog = db.relationship("Blog", backref="owner_blog")
def __repr__(self):
return "(username: %s)" % (self.username)
class Category(db.Model):
__tablename__ = 'categories'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(32), nullable=False)
meals = db.relationship("Meal", back_populates="category")
# db = SQLAlchemy()
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,
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 MainAddress(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=True, 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)
def __repr__(self):
return "(Name: {} {}, contact: {})".format(self.firstname,
self.lastname, self.contact)
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 Articles(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), unique=True, nullable=False)
sub_title = db.Column(db.Text, nullable=False)
content1 = db.Column(db.Text, nullable=False)
content2 = db.Column(db.Text, nullable=False)
content3 = db.Column(db.Text, nullable=False)
content4 = db.Column(db.Text, nullable=False)
content5 = db.Column(db.Text, nullable=True)
content6 = db.Column(db.Text, nullable=True)
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(100), unique=False, nullable=False)
def __repr__(self):
return "(Article: {}, Author: {}, Publish: {})".format(
self.title, self.author, self.date_publish)
