class GroceryItem(db.Model): """Grocery Item model.""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items')
class GroceryItem(db.Model): """Grocery Item model.""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column( db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items') # Add created_by field to see the user who added the item created_by_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_by = db.relationship('User') # Add many-to-many relationship between User and GroceryItem users_who_shopped = db.relationship( 'User', secondary='shopping_list', back_populates='shopping_list_items')
class GroceryItem(db.Model): """Grocery Item model.""" __tablename__ = 'grocery_item' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items') created_by_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_by = db.relationship('User') shopping_lists = db.relationship('User', secondary='user_groceryitem_association')
class GroceryItem(db.Model): """Grocery Item model.""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items') created_by = db.relationship("User") created_by_id = db.Column(db.Integer, db.ForeignKey("user.id")) user_shopping_list = db.relationship("User", secondary="shopping_list_table", back_populates="shopping_list_items")
class GroceryItem(db.Model): """Grocery Item model.""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items') """ Foreign Key column (to store the user’s id)""" created_by_id = db.Column(db.Integer, db.ForeignKey('user.id')) """ Relationship (to store the User object itself) """ created_by = db.relationship('User') customer = db.relationship("User", secondary="shopping_list")
class GroceryItem(db.Model): """Grocery Item model.""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(80), nullable=False) price = db.Column(db.Float(precision=2), nullable=False) category = db.Column(db.Enum(ItemCategory), default=ItemCategory.OTHER) photo_url = db.Column(URLType) store_id = db.Column(db.Integer, db.ForeignKey('grocery_store.id'), nullable=False) store = db.relationship('GroceryStore', back_populates='items') created_by_id = db.Column(db.Integer, db.ForeignKey('user.id')) created_by = db.relationship('User') users_cart = db.relationship('User', secondary='shopping_cart', back_populates='cart_items') def __str__(self): return f'<Item: {self.name}>' def __repr__(self): return f'<Item: {self.name}>'