class Role(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) role = db.Column(db.String(20), unique=False, nullable=False) user = db.relationship('User', backref='role') def __repr__(self): return f"User('{self.role}')"
class Food(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) food_name = db.Column(db.String(20), unique=False, nullable=False) price = db.Column(db.String(20), unique=False, nullable=False) food = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return f"User('{self.food_name}', '{self.price}')"
class Restaurant(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) rest_name = db.Column(db.String(20), unique=False, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) dishes = db.relationship('Food', secondary=meals, backref=db.backref('meals', lazy='dynamic')) def __repr__(self): return f"User('{self.rest_name}')"
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=False, nullable=False) email = db.Column(db.String(20), unique=False, nullable=False) password = db.Column(db.String(20), unique=False, nullable=False) role_id = db.Column(db.Integer, db.ForeignKey('role.id')) restaurant = db.relationship('Restaurant', backref='user') food = db.relationship('Food', backref='user') order = db.relationship('meals', secondary=orders, backref=db.backref('customer', lazy='dynamic')) def __repr__(self): return f"User('{self.username}', '{self.email}')"
from efoods import db, login_manager from flask_login import UserMixin @login_manager.user_loader def load_user(user_id): return User.query.get(int(user_id)) meals = db.Table('meals', db.Column('id', db.Integer, primary_key=True), db.Column('restaurant_id', db.Integer, db.ForeignKey('restaurant.id')), db.Column('food_id', db.Integer, db.ForeignKey('food.id')) ) orders = db.Table('orders', db.Column('user_id', db.Integer, db.ForeignKey('user.id')), db.Column('meals_id', db.Integer, db.ForeignKey('meals.id')) ) class Role(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) role = db.Column(db.String(20), unique=False, nullable=False) user = db.relationship('User', backref='role') def __repr__(self): return f"User('{self.role}')" class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=False, nullable=False) email = db.Column(db.String(20), unique=False, nullable=False) password = db.Column(db.String(20), unique=False, nullable=False)