How to get (Retrieve) data from SQlite database in Flask using sqlalchemy

Question

I have a form in my flask application that collects emails, usernames, and phone numbers. I have stored them all in the SQLite database using flask sqlalchemy. Let's say my database looks like the following:

Email                    Username                     Phone Number
[email protected]           James                          123456789
 [email protected]            Jane                          987654321

I have an HTML file and I would like to display data there. What I have is :

> @app.route("/Display") 
  def Display():
     # Here I want to get all data from the database
     # like this data=get from database 
     return render_template('Display.html', data=data)

I would like to know can anyone tell me how to retrieve data or get the data from database using flask sqlalchemy ORM. I know query.filter_by can be used to filter according to a username or email or phone number. However, how can I get the whole table (like in a form to pass to render_template? like in HTML page I want to loop through data and use data.username or data.email)

DevHyperCoder · Accepted Answer · 2020-04-29 03:42:52Z

2

You can use this code to retrieve everything

data = Model.query.all()

Where model is the name of your model. This returns a list of the objects.

answered Apr 29, 2020 at 3:42

DevHyperCoder

9531 gold badge9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AbeerRao · Accepted Answer · 2020-11-01 12:20:19Z

1

If you want to filter the data by a specific value:

data = Model.query.filter_by(attribute=value)

You can add .all() if you want to get all instances of your Model matching the value.

If you want to filter by the ID of the data:

data = Model.get_or_404(dataID)

answered Nov 1, 2020 at 12:20

AbeerRao

411 silver badge5 bronze badges

Collectives™ on Stack Overflow

How to get (Retrieve) data from SQlite database in Flask using sqlalchemy

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related