exclude() for negation in Django - Mini Project: Build & Apply

Using Django's exclude() for Negation Filtering

📖 Scenario: You are building a simple Django app to manage a library's book collection. You want to show only the books that are not in a specific genre.

🎯 Goal: Create a Django queryset that excludes books of the genre 'Science Fiction' using the exclude() method.

📋 What You'll Learn

Create a Django model queryset variable named books containing all Book objects

Create a variable named excluded_genre set to the string 'Science Fiction'

Use exclude() on books to filter out books with genre equal to excluded_genre

Assign the filtered queryset to a variable named non_scifi_books

💡 Why This Matters

🌍 Real World

Filtering data in Django apps is common when you want to show users only relevant information, like excluding certain categories or statuses.

💼 Career

Knowing how to use Django querysets and methods like <code>exclude()</code> is essential for backend developers working with databases and building efficient web applications.

1

Set up the initial queryset

Create a variable called books that contains all Book objects using Book.objects.all().

Django

from library.models import Book
# Create a variable called books with all Book objects
# Your code here

Need a hint?

Use Book.objects.all() to get all books.

2

Define the genre to exclude

Create a variable called excluded_genre and set it to the string 'Science Fiction'.

Django

from library.models import Book

books = Book.objects.all()
# Define excluded_genre as 'Science Fiction'
# Your code here

Need a hint?

Just assign the string 'Science Fiction' to excluded_genre.

3

Filter out books of the excluded genre

Use exclude() on books to remove books where genre equals excluded_genre. Assign the result to non_scifi_books.

Django

from library.models import Book

books = Book.objects.all()

excluded_genre = 'Science Fiction'
# Use exclude() to filter out books with genre equal to excluded_genre
# Your code here

Need a hint?

Use books.exclude(genre=excluded_genre) to get books not in that genre.

4

Complete the queryset for use

Add a comment above non_scifi_books explaining that this queryset excludes Science Fiction books.

Django

from library.models import Book

books = Book.objects.all()

excluded_genre = 'Science Fiction'

# Your code here

Need a hint?

Add a clear comment describing the purpose of non_scifi_books.