Django models: Reading records from a database

Understanding how to use Django models — the simple way.

What are Django models?

A Django model is a built-in feature that is used to create tables and fields. These tables and fields are used to represent data that can be managed and accessed with Django. Simply put, models define the structure of the data that is stored.

Let’s get started.

So, what we want to understand is how to read records from our table of cars based on our model Car. We will first look at how we can read all the records and then how to read a single record.

1) Reading all the records

To be able to select and read all the records you need to invoke the all() function, which will give you access to all the cars (records) in the cars table.

The code below is how we would read all the records.

# - views.pycars = Car.objects.all()

2) Reading a single record (instance)

Now let’s say that you don’t want to read all the records from Car, but you would rather like to read a single record — perhaps, you want to get your first record that has data about a Ferrari that also happens to be red.

To do this you would need to use the get() function along with one of the car parameters. As you can see we are searching for a record whose id = 1… Which will get a record whose id is equal to 1.

Moreover, the get function will search all the rows in the table and return the first result.

The code below is how we would read a single record.

# views.pycar = Car.objects.objects.get(id=1)

DONE! — We are now able to read records from our table.

A final note…

For those that are interested in learning Django from scratch, feel free to check out my latest course:

Python Django: Ultimate Beginners Course — 2022

Originally published at https://www.cloudwithdjango.com on July 1st, 2022.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arno Pretorius

Arno Pretorius

127 Followers

Hi, I’m Arno… I love cloud computing and django web development and I want to share my knowledge and experiences with you.