Mar-12-2020, 03:40 PM
Hi , I want to make a product counter in specific category. I searched but i didn't find. Please help
This is my models.py
This is my models.py
class Products(db.Model): __searchable__ = ["product_name"] id = db.Column(db.Integer, primary_key=True) product_name = db.Column(db.String(20)) product_amount = db.Column(db.Integer) product_price = db.Column(db.Float) category_id = db.Column(db.Integer, db.ForeignKey('category.id')) category = db.relationship('Category', backref="category") def __repr__(self): return f"User('{self.username}' '{self.email}')" class Category(db.Model): id = db.Column(db.Integer, primary_key=True) category_name = db.Column(db.String(80)) def __repr__(self): return f"{self.category_name}"This is my app.py
def categories(): categories = Category.query.all() if request.method == "POST": category_name = request.form["category_name"] category = Category(category_name=category_name) db.session.add(category) db.session.commit() return redirect(url_for("categories")) return render_template("categories.html", categories=categories)Also table
{% for category in categories %} <tr> <th scope="row">{{ category.id }}</th> <th scope="row">{{ category.category_name }}</th> <th scope="row">Product Counter in Specific Category</th> <td><a href="/update_category/{{ category.id }}" class="btn btn-primary ">Update</a></td> <td><a href="/delete_category/{{ category.id }}" class="btn btn-danger">Delete</a></td> </tr> {% endfor %}