F expressions for field comparisons in Django - Mini Project: Build & Apply

F expressions for field comparisons

📖 Scenario: You are building a Django app to manage a bookstore. You want to find all books where the number of copies sold is greater than the number of copies in stock.

🎯 Goal: Create a Django query using F expressions to compare two fields in the Book model and filter books where copies_sold is greater than copies_in_stock.

📋 What You'll Learn

Create a Django model called Book with fields title (CharField), copies_sold (IntegerField), and copies_in_stock (IntegerField).

Create a variable threshold set to 0 (to use later).

Use Django's F expression to filter Book objects where copies_sold is greater than copies_in_stock.

Assign the filtered queryset to a variable called books_sold_more_than_stock.

💡 Why This Matters

🌍 Real World

Comparing fields in database records is common in apps like inventory management, sales tracking, and more.

💼 Career

Understanding F expressions helps you write efficient database queries in Django, a key skill for backend developers.

1

Create the Book model

Create a Django model called Book with fields: title as a CharField with max length 100, copies_sold as an IntegerField, and copies_in_stock as an IntegerField.

Django

# Define the Book model with the specified fields
# Your code here

Hint

Use models.CharField for text and models.IntegerField for numbers.

2

Add a threshold variable

Create a variable called threshold and set it to 0.

Django

from django.db import models

class Book(models.Model):
    title = models.CharField(max_length=100)
    copies_sold = models.IntegerField()
    copies_in_stock = models.IntegerField()

# Create threshold variable
# Your code here

Hint

Just assign 0 to a variable named threshold.

3

Filter books using F expressions

Import F from django.db.models. Use Book.objects.filter() with an F expression to filter books where copies_sold is greater than copies_in_stock. Assign the result to books_sold_more_than_stock.

Django

from django.db import models
from django.db.models import F

class Book(models.Model):
    title = models.CharField(max_length=100)
    copies_sold = models.IntegerField()
    copies_in_stock = models.IntegerField()

threshold = 0

# Filter books where copies_sold > copies_in_stock
# Your code here

Hint

Use copies_sold__gt=F('copies_in_stock') inside filter().

4

Complete the Django query setup

Ensure the import of F from django.db.models is present and the variable books_sold_more_than_stock holds the filtered queryset where copies_sold is greater than copies_in_stock.

Django

from django.db import models
from django.db.models import F

class Book(models.Model):
    title = models.CharField(max_length=100)
    copies_sold = models.IntegerField()
    copies_in_stock = models.IntegerField()

threshold = 0

books_sold_more_than_stock = Book.objects.filter(copies_sold__gt=F('copies_in_stock'))

# Finalize the code if needed
# Your code here

Hint

Check that the import and filter line are exactly as specified.

Practice

1. What is the main purpose of using F expressions in Django ORM?

easy

A. To compare or update model fields directly in the database without fetching data

B. To convert query results into Python dictionaries

C. To create new database tables automatically

D. To write raw SQL queries inside Django models

Solution

1. Step 1: Understand what F expressions do

   F expressions allow referencing model fields directly in queries without loading data into Python.

2. Step 2: Identify the correct use case

   This lets you compare or update fields efficiently in the database, avoiding extra data transfer.

3. Final Answer:

   To compare or update model fields directly in the database without fetching data -> Option A

4. Quick Check:

   F expressions = direct DB field operations [OK]

Hint: F expressions work inside queries without loading data [OK]

Common Mistakes:

• Thinking F expressions convert results to dicts
• Confusing F expressions with migrations
• Assuming F expressions run raw SQL

2. Which of the following is the correct syntax to filter objects where the field score is greater than the field min_score using F expressions?

easy

A. Model.objects.filter(F('score') > F('min_score'))

B. Model.objects.filter(score > F('min_score'))

C. Model.objects.filter(score__gt='min_score')

D. Model.objects.filter(score__gt=F('min_score'))

Solution

1. Step 1: Recall correct filter syntax with F expressions

   Use field lookups like score__gt=F('min_score') to compare fields.

2. Step 2: Check each option

   Model.objects.filter(score__gt=F('min_score')) uses correct Django ORM syntax. Model.objects.filter(score > F('min_score')) uses invalid Python syntax inside filter. Model.objects.filter(score__gt='min_score') compares to string, not field. Model.objects.filter(F('score') > F('min_score')) is invalid syntax.

3. Final Answer:

   Model.objects.filter(score__gt=F('min_score')) -> Option D

4. Quick Check:

   Use field lookups with F('field') [OK]

Hint: Use field lookups like __gt with F('field') [OK]

Common Mistakes:

• Using Python operators inside filter()
• Passing field names as strings instead of F expressions
• Confusing field lookup syntax

3. Given the model Product with fields price and discount_price, what will this query return?

Product.objects.filter(discount_price__lt=F('price')).count()

medium

A. The total number of products in the database

B. The number of products where discount_price is less than price

C. The number of products where discount_price equals price

D. Raises a syntax error

Solution

1. Step 1: Understand the filter condition

   The filter selects products where discount_price is less than price using an F expression.

2. Step 2: Understand the count() method

   It returns the number of records matching the filter condition.

3. Final Answer:

   The number of products where discount_price is less than price -> Option B

4. Quick Check:

   filter with F expression returns matching count [OK]

Hint: F expressions compare fields inside filters correctly [OK]

Common Mistakes:

• Thinking count() returns all products
• Confusing less than with equals
• Assuming syntax error due to F expression

4. Identify the error in this Django query using F expressions:

Order.objects.filter(total__gt=F(total_paid))

medium

A. Missing quotes around the field name in F expression

B. Using __gt instead of __lt for comparison

C. F expressions cannot be used in filters

D. total and total_paid fields must be integers

Solution

1. Step 1: Check F expression syntax

   The field name inside F() must be a string, so it should be F('total_paid').

2. Step 2: Analyze the given query

   The query uses F(total_paid) without quotes, causing a NameError or syntax error.

3. Final Answer:

   Missing quotes around the field name in F expression -> Option A

4. Quick Check:

   F('field_name') requires quotes [OK]

Hint: Always put field names as strings inside F() [OK]

Common Mistakes:

• Omitting quotes inside F()
• Confusing comparison operators
• Believing F expressions can't be in filters

5. You want to update all Employee records to increase their salary by the value in their bonus field using F expressions. Which code snippet correctly performs this update?

hard

A. Employee.objects.update(salary=F('salary' + 'bonus'))

B. Employee.objects.update(salary='salary + bonus')

C. Employee.objects.update(salary=F('salary') + F('bonus'))

D. Employee.objects.update(salary=F('salary') - F('bonus'))

Solution

1. Step 1: Understand how to update fields with F expressions

   You can perform arithmetic operations between fields using F expressions like F('salary') + F('bonus').

2. Step 2: Check each option

   Employee.objects.update(salary=F('salary') + F('bonus')) correctly adds the two fields. Employee.objects.update(salary=F('salary' + 'bonus')) incorrectly concatenates strings inside F(). Employee.objects.update(salary='salary + bonus') assigns a string, not a field operation. Employee.objects.update(salary=F('salary') - F('bonus')) subtracts instead of adding.

3. Final Answer:

   Employee.objects.update(salary=F('salary') + F('bonus')) -> Option C

4. Quick Check:

   Use arithmetic with F('field') for updates [OK]

Hint: Use F('field1') + F('field2') for field arithmetic updates [OK]

Common Mistakes:

• Concatenating field names as strings inside F()
• Assigning string expressions instead of F expressions
• Using wrong arithmetic operator