Q objects for complex queries in Django - Mini Project: Build & Apply

Using Q Objects for Complex Queries in Django

📖 Scenario: You are building a simple Django app to manage a bookstore's inventory. You want to find books based on multiple search conditions, such as books by a certain author or books priced below a certain amount.

🎯 Goal: Learn how to use Django's Q objects to create complex database queries that combine multiple conditions with OR and AND logic.

📋 What You'll Learn

Create a Django model dictionary representing books with fields: title, author, and price

Set a price threshold variable to filter books cheaper than this value

Use Q objects to find books by a specific author or cheaper than the price threshold

Complete the query to return the filtered books

💡 Why This Matters

🌍 Real World

Filtering database records with complex conditions is common in web apps, like searching products or users.

💼 Career

Understanding Q objects helps you write flexible and efficient queries in Django, a popular web framework.

1

Create the initial book data dictionary

Create a dictionary called books with these exact entries: 'Django for Beginners': {'author': 'William S. Vincent', 'price': 30}, 'Two Scoops of Django': {'author': 'Daniel Roy Greenfeld', 'price': 45}, 'Lightweight Django': {'author': 'Julia Elman', 'price': 25}

Django

# Create the books dictionary with exact entries
# Your code here

Need a hint?

Use a dictionary with book titles as keys and another dictionary for author and price as values.

2

Set the price threshold variable

Create a variable called max_price and set it to 30 to filter books cheaper than this price

Django

books = {
    'Django for Beginners': {'author': 'William S. Vincent', 'price': 30},
    'Two Scoops of Django': {'author': 'Daniel Roy Greenfeld', 'price': 45},
    'Lightweight Django': {'author': 'Julia Elman', 'price': 25}
}
# Set max_price to 30
# Your code here

Need a hint?

Just create a variable named max_price and assign it the number 30.

3

Use Q objects to filter books by author or price

Import Q from django.db.models. Then create a variable called filtered_books that uses Q(author='William S. Vincent') | Q(price__lt=max_price) to filter the books dictionary items.

Django

from django.db.models import Q

books = {
    'Django for Beginners': {'author': 'William S. Vincent', 'price': 30},
    'Two Scoops of Django': {'author': 'Daniel Roy Greenfeld', 'price': 45},
    'Lightweight Django': {'author': 'Julia Elman', 'price': 25}
}
max_price = 30

# Use Q objects to filter books by author or price
# Your code here

Need a hint?

Use a dictionary comprehension with Q objects combined by | for OR logic.

4

Complete the query to return filtered books

Add a final line to convert filtered_books keys to a list called result that holds the titles of the filtered books.

Django

from django.db.models import Q

books = {
    'Django for Beginners': {'author': 'William S. Vincent', 'price': 30},
    'Two Scoops of Django': {'author': 'Daniel Roy Greenfeld', 'price': 45},
    'Lightweight Django': {'author': 'Julia Elman', 'price': 25}
}
max_price = 30

filtered_books = {title: info for title, info in books.items() if Q(author=info['author']) | Q(price__lt=max_price)}

# Create a list called result with the titles of filtered_books
# Your code here

Need a hint?

Use list() on filtered_books.keys() to get the titles.