class Category(db.Model):
__tablename__ = "category"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode, unique=True)
def __repr__(self):
return self.email
class Address(db.Model):
__tablename__ = "address"
id = db.Column("id", db.Integer, primary_key=True)
zip = db.Column("zip", db.Unicode)
country = db.Column("country", db.Unicode)
address = db.Column("address", db.Unicode)
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.id"))
user = db.relationship("User", foreign_keys=user_id)
class User(db.Model):
__tablename__ = "user"
id = db.Column("id", db.Integer, primary_key=True)
email = db.Column("email", db.Unicode, unique=True, nullable=False)
passwd = db.Column("passwd", db.Unicode)
admin = db.Column("admin", db.Boolean)
def __repr__(self):
return self.email
class Address(db.Model):
__tablename__ = "address"
id = db.Column('id', db.Integer, primary_key=True)
zip = db.Column('zip', db.Unicode)
country = db.Column('country', db.Unicode)
address = db.Column('address', db.Unicode)
user_id = db.Column('user_id', db.Integer, db.ForeignKey('user.id'))
user = db.relationship('User', foreign_keys=user_id)
class OrderItems(db.Model):
__tablename__ = "order_items"
order_id = db.Column('order_id', db.Integer, db.ForeignKey('order.id'))
items_id = db.Column('items_id', db.Integer, db.ForeignKey('items.id'))
quant = db.Column('quant', db.Integer)
id = db.Column('id', db.Integer, primary_key=True)
order = db.relationship('Order', foreign_keys=order_id)
items = db.relationship('Items', foreign_keys=items_id)
class OrderItems(db.Model):
__tablename__ = "order_items"
id = db.Column("id", db.Integer, primary_key=True)
amount = db.Column("amount", db.Integer)
items_id = db.Column("items_id", db.Integer, db.ForeignKey("items.id"))
order_id = db.Column("order_id", db.Integer, db.ForeignKey("order.id"))
items = db.relationship("Items", foreign_keys=items_id)
order = db.relationship("Order", foreign_keys=order_id)
class User(db.Model):
__tablename__ = "user"
id = db.Column('id', db.Integer, primary_key=True)
email = db.Column('email', db.Unicode, unique=True)
passwd = db.Column('passwd', db.Unicode)
admin = db.Column('admin', db.Boolean)
def __repr__(self):
return self.email
class Store(db.Model):
__tablename__ = "store"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode)
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.id"))
category_id = db.Column("category_id", db.Integer,
db.ForeignKey("category.id"))
active = db.Column("active", db.Boolean)
user = db.relationship("User", foreign_keys=user_id)
category = db.relationship("Category", foreign_keys=category_id)
class OrderItems(db.Model):
__tablename__ = "order_items"
order_id = db.Column("order_id", db.Integer,
db.ForeignKey("order.created_at"))
items_id = db.Column("items_id", db.Integer, db.ForeignKey("items.name"))
quant = db.Column("quant", db.Integer)
id = db.Column("id", db.Integer, primary_key=True)
order = db.relationship("Order", foreign_keys=order_id)
items = db.relationship("Items", foreign_keys=items_id)
class Store(db.Model):
__tablename__ = "store"
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.Unicode)
user_id = db.Column('user_id', db.Integer, db.ForeignKey('user.id'))
category_id = db.Column('category_id', db.Integer,
db.ForeignKey('category.id'))
active = db.Column("active", db.Boolean)
user = db.relationship('User', foreign_keys=user_id)
category = db.relationship('Category', foreign_keys=category_id)
class Store(db.Model):
__tablename__ = "store"
id = db.Column("id", db.Integer, primary_key=True)
name_store = db.Column("name_store", db.String, unique=True)
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.email"))
category_id = db.Column("category_id", db.Integer,
db.ForeignKey("category.name"))
active = db.Column("active", db.Boolean, default=False)
user = db.relationship("User", foreign_keys=user_id)
category = db.relationship("Category", foreign_keys=category_id)
def __repr__(self):
return self.name_store
class User(db.Model, UserMixin):
__tablename__ = "user"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode)
email = db.Column("email", db.Unicode, unique=True)
password = db.Column("password", db.Unicode)
admin = db.Column("admin", db.Boolean)
def get_id(self):
return str(self.id)
def auth(self, email: str, password: str) -> bool:
user = self.query.filter_by(email=email).first()
if not user:
return False
if not check_password_hash(user.password, password):
return False
return user
def __repr__(self):
return self.email
class Checkout(db.Model):
__tablename__ = "checkout"
id = db.Column("id", db.Integer, primary_key=True)
payment = db.Column("payment", db.Unicode)
total = db.Column("total", db.Numeric)
created_at = db.Column("created_at", db.DateTime)
completed = db.Column("completed", db.Boolean)
order_id = db.Column("order_id", db.Integer, db.ForeignKey("order.id"))
order = db.relationship("Order", foreign_keys=order_id)
class Items(db.Model):
__tablename__ = "items"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode)
image = db.Column("image", db.LargeBinary)
price = db.Column("price", db.Numeric)
available = db.Column("available", db.Boolean)
store_id = db.Column("store_id", db.Integer, db.ForeignKey("store.id"))
store = db.relationship("Store", foreign_keys=store_id)
class Checkout(db.Model):
__tablename__ = "checkout"
id = db.Column('id', db.Integer, primary_key=True)
payment = db.Column('payment', db.Unicode)
total = db.Column('total', db.Numeric)
created_at = db.Column('created_at', db.DateTime)
completed = db.Column('completed', db.Boolean)
order_id = db.Column('order_id', db.Integer, db.ForeignKey('order.id'))
order = db.relationship('Order', foreign_keys=order_id)
class Items(db.Model):
__tablename__ = "items"
id = db.Column('id', db.Integer, primary_key=True)
name = db.Column('name', db.Unicode)
image = db.Column('image', db.Unicode)
price = db.Column('price', db.Numeric)
store_id = db.Column('store_id', db.Integer, db.ForeignKey('store.id'))
available = db.Column('available', db.Boolean)
store = db.relationship('Store', foreign_keys=store_id)
class Address(db.Model):
__tablename__ = "address"
id = db.Column("id", db.Integer, primary_key=True)
zip_code = db.Column("zip_code", db.Unicode)
state = db.Column("country", db.Unicode)
city = db.Column("city", db.Unicode)
address = db.Column("address", db.Unicode)
number_house = db.Column("number_house", db.Unicode)
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.email"))
user = db.relationship("User", foreign_keys=user_id)
def __repr__(self):
return self.zip_code
class Order(db.Model):
__tablename__ = "order"
id = db.Column("id", db.Integer, primary_key=True)
created_at = db.Column("created_at", db.DateTime)
completed = db.Column("completed", db.Boolean)
address_id = db.Column("address_id", db.Integer, db.ForeignKey("address.id"))
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.id"))
store_id = db.Column("store_id", db.Integer, db.ForeignKey("store.id"))
address = db.relationship("Address", foreign_keys=address_id)
user = db.relationship("User", foreign_keys=user_id)
store = db.relationship("Store", foreign_keys=store_id)
class Items(db.Model):
__tablename__ = "items"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode)
quantity = db.Column("quantity", db.Integer)
price = db.Column("price", db.Float(asdecimal=True,
decimal_return_scale=2))
description = db.Column("description", db.Text(length=None))
store_id = db.Column("store_id", db.Integer,
db.ForeignKey("store.name_store"))
available = db.Column("available", db.Boolean)
store = db.relationship("Store", foreign_keys=store_id)
def __repr__(self):
return self.name
class Order(db.Model):
__tablename__ = "order"
id = db.Column('id', db.Integer, primary_key=True)
created_at = db.Column('created_at', db.DateTime)
completed = db.Column('completed', db.Boolean)
user_id = db.Column('user_id', db.Integer, db.ForeignKey('user.id'))
store_id = db.Column('store_id', db.Integer, db.ForeignKey('store.id'))
address_id = db.Column('address_id', db.Integer,
db.ForeignKey('address.id'))
user = db.relationship('User', foreign_keys=user_id)
store = db.relationship('Store', foreign_keys=store_id)
address = db.relationship('Address', foreign_keys=address_id)
class Order(db.Model):
__tablename__ = "order"
id = db.Column("id", db.Integer, primary_key=True)
created_at = db.Column("created_at", db.DateTime)
completed = db.Column("completed", db.Boolean)
user_id = db.Column("user_id", db.Integer, db.ForeignKey("user.email"))
store_id = db.Column("store_id", db.Integer,
db.ForeignKey("store.name_store"))
address_id = db.Column("address_id", db.Integer,
db.ForeignKey("address.zip_code"))
user = db.relationship("User", foreign_keys=user_id)
store = db.relationship("Store", foreign_keys=store_id)
address = db.relationship("Address", foreign_keys=address_id)
def __repr__(self):
return f'{self.user_id} {self.created_at}'
class User(db.Model):
__tablename__ = "user"
id = db.Column("id", db.Integer, primary_key=True)
email = db.Column("email", db.Unicode, unique=True)
passwd = db.Column("passwd", db.Unicode)
admin = db.Column("admin", db.Boolean)
class Category(db.Model):
__tablename__ = "category"
id = db.Column("id", db.Integer, primary_key=True)
name = db.Column("name", db.Unicode, unique=True)
on_menu = db.Column("on_menu", db.Boolean)