Flask Get all products from table and iterate over them

Question

I'm writing a website that uses Flask as the backend, and I am trying to add all products from a table into the webpage. I've never used SQLAlchemy or anything like it, so I'm not sure how exactly to get all the products from a database, and then categorize them as I need for the website. Here is the code I'm using in views.py ``` @app.route('/products') def products(): product = [ { 'product_name': 'T-Shirts', 'product_price': '18.00', 'product_img': '', 'product_description': 'A t-shirt.' }, { 'product_name': 'TShirts 2', 'product_price': '25.00', 'product_img': '', 'product_description': 'A t-shirt, again.' }, { 'product_name': 'TShirts 3', 'product_price': '25.00', 'product_img': '', 'product_description': 'A t-shirt, again.' }, { 'product_name': 'TShirts 4', 'product_price': '25.00', 'product_img': '', 'product_description': 'A t-shirt, again.' }, { 'product_name': 'TShirts 5', 'product_price': '25.00', 'product_img': '', 'product_description': 'A t-shirt, again.' }, { 'product_n…

Accepted Answer

If you want to show all products, you need SQLAlchemy's all method.

```
@app.route('/products')
def products():
    products = Product.query.all()
    return render_template("products.html",
                           title="Products",
                           products=products)
```

If you wish to filter by some field, you will want to use SQLAlchemy's filter or filter_by.

```
products = Product.query.filter(Product.product_name == 'TShirts 11').all()

# or

products = Product.query.filter_by(product_name='TShirts 11').all()
```

Flask Get all products from table and iterate over them

Solution

Problem