class Cart(mysql_db.Model): __tablename__ = 'carts' c_id = mysql_db.Column(mysql_db.String(20), primary_key=True) quantity = mysql_db.Column(mysql_db.Integer()) total_cost = mysql_db.Column(mysql_db.Integer()) def __init__(self, c_id, quantity, total_cost): self.c_id = c_id self.quantity = quantity self.total_cost = total_cost def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return { "c_id": self.c_id, "quantity": self.quantity, "total_cost": self.total_cost } def __repr__(self): return '<Cart %r, %r, %r>' % (self.c_id, self.quantity, self.total_cost)
class User(UserMixin, mysql_db.Model): __tablename__ = 'users' id = mysql_db.Column(mysql_db.Integer, primary_key=True) email = mysql_db.Column(mysql_db.String(64), unique=False, index=True) username = mysql_db.Column(mysql_db.String(64), unique=False, index=True) password_hash = mysql_db.Column(mysql_db.String(128)) balance = mysql_db.Column(mysql_db.Float) def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __init__(self, username, email, password_hash, balance): self.username = username self.email = email self.password_hash = password_hash self.balance = balance def __repr__(self): return '<User %r,%r,%r,%r,%r>' % (self.username, self.email, self.username, self.password_hash, self.balance) def verify(self, input_password): return self.password_hash == input_password
class Product(mysql_db.Model): __tablename__ = 'products' p_id = mysql_db.Column(mysql_db.String(20), primary_key=True) p_name = mysql_db.Column(mysql_db.String(20)) p_price = mysql_db.Column(mysql_db.String(30)) p_description = mysql_db.Column(mysql_db.String(500)) p_location = mysql_db.Column(mysql_db.String(50)) c_id = mysql_db.Column(mysql_db.String(20)) img_url = mysql_db.Column(mysql_db.String(100)) catagory_code = mysql_db.Column(mysql_db.String(20)) shop_id = mysql_db.Column(mysql_db.String(20)) def __init__(self, p_name="", p_price=0, p_description="", p_location="", c_id="", img_url="", catagory_code="", shop_id=""): self.p_name = p_name self.p_price = p_price self.p_description = p_description self.p_location = p_location self.c_id = c_id self.catagory_code = catagory_code self.shop_id = shop_id self.img_url = img_url def create(self): now = datetime.datetime.now() self.p_id = "pro" + now.strftime("%H%M%S%m%d%Y") mysql_db.session.add(self) mysql_db.session.commit() return self def delete(self): mysql_db.session.delete(self) mysql_db.session.commit() return self def to_json(self): return { "p_id": self.p_id, "p_name": self.p_name, "p_price": self.p_price, "p_description": self.p_description, "p_location": self.p_location, "c_id": self.c_id, "img_url": self.img_url, "catagory_id": self.catagory_code, "shop_id": self.shop_id } def __repr__(self): return '<Product %r, %r, %r, %r, %r, %r, %r, %r, %r>' % ( self.p_id, self.p_name, self.p_price, self.p_description, self.p_location, self.c_id, self.img_url, self.catagory_code, self.shop_id)
class Bank_Account(mysql_db.Model): __tablename__ = 'bank_accounts' id = mysql_db.Column(mysql_db.Integer, primary_key=True) student_id = mysql_db.Column(mysql_db.String(20)) balance = mysql_db.Column(mysql_db.Integer) def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<Bank_Account %r>' % self.id
class Role(mysql_db.Model): __tablename__ = 'roles' id = mysql_db.Column(mysql_db.Integer, primary_key=True) name = mysql_db.Column(mysql_db.String(64), unique=True) role_value = mysql_db.Column(mysql_db.Integer) def __init__(self,name,role_value): self.name = name self.role_value = role_value def __repr__(self): return '<Role %r>' % self.name
class Model(mysql_db.Model): __tablename__ = 'models' id = mysql_db.Column(mysql_db.String(20),primary_key = True) create_date = mysql_db.Column(mysql_db.String(100)) def __init__(self,create_date): x = datetime.datetime.now() self.create_date = x.strftime("%H%M%S%d%m%Y") def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self
class Tution(mysql_db.Model): __tablename__ = 'tutions' id = mysql_db.Column(mysql_db.Integer, primary_key=True) student_id = mysql_db.Column(mysql_db.String(20)) fee = mysql_db.Column(mysql_db.Integer) def __init__(self,student_id,fee=0): self.student_id = student_id self.fee = fee def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<Tution %r>' % self.id
class Partner(mysql_db.Model): __tablename__ = 'partners' partner_id = mysql_db.Column(mysql_db.String(20), primary_key=True) user_id = mysql_db.Column(mysql_db.String(64)) status = mysql_db.Column(mysql_db.String(50)) def __init__(self, partner_id, user_id): self.partner_id = partner_id self.user_id = user_id def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<Partner %r, %r, %r>' % (self.partner_id, self.user_id, self.status)
class Shipping(mysql_db.Model): __tablename__ = 'shippings' shop_id = mysql_db.Column(mysql_db.String(20), primary_key=True) product_id = mysql_db.Column(mysql_db.String(20), primary_key=True) create_date = mysql_db.Column(mysql_db.String(30)) cost = mysql_db.Column(mysql_db.Integer()) def __init__(self, shop_id, product_id, cost): self.shop_id = shop_id self.product_id = product_id self.cost = cost def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<Shipping %r, %r, %r, %r>' % (self.shop_id, self.product_id, self.create_date, self.cost)
class His(mysql_db.Model): __tablename__ = 'history' id = mysql_db.Column(mysql_db.Integer, primary_key=True) studentId = mysql_db.Column(mysql_db.String(20)) datetime = mysql_db.Column(mysql_db.String(20)) amount = mysql_db.Column(mysql_db.Float) payment_user = mysql_db.Column(mysql_db.String(50)) paymentId = mysql_db.Column(mysql_db.String(20)) def __init__(self, studentId, datetime, payment_user, paymentId, amount=0): self.studentId = studentId self.datetime = datetime self.amount = amount self.payment_user = payment_user self.paymentId = paymentId def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<His %r, %r, %r, %r, %r, %r>' % ( self.id, self.studentId, self.datetime, self.amount, self.payment_user, self.paymentId)
class Student(mysql_db.Model): __tablename__ = 'students' id = mysql_db.Column(mysql_db.Integer, primary_key=True) studentId = mysql_db.Column(mysql_db.String(20), unique=True) fname = mysql_db.Column(mysql_db.String(20)) phone = mysql_db.Column(mysql_db.String(20)) email = mysql_db.Column(mysql_db.String(64)) fee = mysql_db.Column(mysql_db.Float) def __init__(self, studentId, fname, phone="", email="", fee=0): self.studentId = studentId self.fname = fname self.phone = phone self.email = email self.fee = fee def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return { "fname": self.fname, "phone": self.phone, "email": self.email, "studentId": self.studentId } def __repr__(self): return '<Student %r, %r, %r, %r, %r, %r>' % (self.id, self.studentId, self.fname, self.phone, self.email, self.fee)
class Catagory(mysql_db.Model): __tablename__ = 'catagories' catagory_code = mysql_db.Column(mysql_db.String(20), primary_key=True) catagory_name = mysql_db.Column(mysql_db.String(50)) catagory_des = mysql_db.Column(mysql_db.String(100)) def __init__(self, catagory_code, catagory_name, catagory_des): self.catagory_code = catagory_code self.catagory_name = catagory_name self.catagory_des = catagory_des def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return {} def __repr__(self): return '<Catagory %r, %r, %r>' % ( self.catagory_code, self.catagory_name, self.catagory_des)
class Location(mysql_db.Model): __tablename__ = 'locations' loc_code = mysql_db.Column(mysql_db.String(20),primary_key = True) loc_name = mysql_db.Column(mysql_db.String(50)) loc_des = mysql_db.Column(mysql_db.String(100)) def __init__(self,loc_code,loc_name,loc_des): self.loc_code = loc_code self.loc_name = loc_name self.loc_des = loc_des def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return { } def __repr__(self): return '<Location %r, %r, %r>' % (self.loc_code, self.loc_name, self.loc_des)
class Shop(mysql_db.Model): __tablename__ = 'shops' shop_id = mysql_db.Column(mysql_db.String(20), primary_key=True) owner_id = mysql_db.Column(mysql_db.String(64), unique=True) shop_name = mysql_db.Column(mysql_db.String(100)) create_date = mysql_db.Column(mysql_db.String(100)) def __init__(self, owner_id, shop_name, create_date): now = datetime.datetime.now() self.shop_id = "pro" + now.strftime("%H%M%S%m%d%Y") self.owner_id = owner_id self.shop_name = shop_name self.create_date = create_date def create(self): mysql_db.session.add(self) mysql_db.session.commit() return self def __repr__(self): return '<Shop %r, %r, %r, %r>' % (self.shop_id, self.owner_id, self.shop_name, self.create_date)
class Order_Detail(mysql_db.Model): __tablename__ = 'order_detail' p_id = mysql_db.Column(mysql_db.String(20), primary_key=True) order_id = mysql_db.Column(mysql_db.String(20), primary_key=True) shop_id = mysql_db.Column(mysql_db.String(20), primary_key=False) amount = mysql_db.Column(mysql_db.Integer()) status_shipping = mysql_db.Column(mysql_db.String(20), server_default='wait') order_user_email = mysql_db.Column(mysql_db.String(100)) ibanking_payment_email = mysql_db.Column( mysql_db.String(100), server_default='COD' ) #thanh toán ibanking thì lưu mail, mặc định là COD: thu tiền tiền mặt paymentId = mysql_db.Column(mysql_db.String(100)) def __init__(self, p_id, shop_id, amount, status_shipping, order_user_email, ibanking_payment_email, paymentId): self.p_id = p_id self.shop_id = shop_id self.amount = amount self.status_shipping = status_shipping self.order_user_email = order_user_email self.ibanking_payment_email = ibanking_payment_email self.paymentId = paymentId def create(self): now = datetime.datetime.now() self.order_id = "order" + now.strftime("%H%M%S%d%m%Y") mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return { "p_id": self.p_id, "order_id": self.order_id, "shop_id": self.shop_id, "amount": self.amount, "status_shipping": self.status_shipping, "ibanking_payment_email": self.status_payment, "paymentId": self.paymentId, } def __repr__(self): return '<Order_Detail %r, %r, %r, %r, %r, %r, %r, %r>' % ( self.p_id, self.order_id, self.shop_id, self.amount, self.status_shipping, self.order_user_email, self.ibanking_payment_email, self.paymentId)
class Order(mysql_db.Model): __tablename__ = 'orders' order_id = mysql_db.Column(mysql_db.String(20), primary_key=True) status_shipping = mysql_db.Column(mysql_db.String(20)) status_payment = mysql_db.Column(mysql_db.String(20)) create_dt = mysql_db.Column(mysql_db.String(100)) user_do_order = mysql_db.Column(mysql_db.String(20)) ship_fee = mysql_db.Column(mysql_db.Float()) total_product = mysql_db.Column(mysql_db.Float()) def __init__(self, status_shipping, status_payment, user_do_order, ship_fee, total_product): self.status_shipping = status_shipping self.status_payment = status_payment self.user_do_order = user_do_order self.ship_fee = ship_fee self.total_product = total_product def create(self): now = datetime.datetime.now() self.order_id = "order" + now.strftime("%H%M%S%d%m%Y") self.create_dt = now mysql_db.session.add(self) mysql_db.session.commit() return self def to_json(self): return { "order_id": self.order_id, "status_shipping": self.status_shipping, "status_payment": self.status_payment, "create_dt": self.create_dt, "user_do_order": self.user_do_order, "ship_fee": self.ship_fee, "total_product": self.total_product, } def __repr__(self): return '<Order %r, %r, %r, %r, %r, %r, %r>' % ( self.order_id, self.status_shipping, self.status_payment, self.create_dt, self.user_do_order, self.ship_fee, self.total_product)