Create Query

We are already familiar with one type of query – it's the query that retrieves all instances from a single table:

python
Copiar código
Author.objects.all()

where Author is our model representing the database table, objects is Django's default manager that facilitates query operations, and all() is a method that retrieves all instances from the 'Author' table, akin to the SQL command SELECT * FROM Author. This QuerySet will be used to check the results of our CREATE operations.

If you work inside IDE, you can repeat all this commands in python environment activated in the terminal. Write:

python
Copiar código
author1 = Author.objects.create(first_name="Ronald", last_name="Tolkien")

This single line both creates and saves a new Author object.

After running this, if we execute Author.objects.all(), we'll now see a QuerySet containing our new author.

This single line both creates and saves a new Author object.

After running this, if we execute Author.objects.all(), we'll now see a QuerySet containing our new author.

Let's add two more authors:

python
Copiar código
9
1
2
3
author2 = Author.objects.create(first_name="Eric", last_name="Blair", pen_name="George Orwel") 
# and 
author3 = Author.objects.create(first_name="James", last_name="Clear")

Each create() call instantly persists these new instances to the database.

Now, Author.objects.all() returns a list with three instances, reflecting our newly created authors in the database.