Primary key behavior in Django - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a primary key field in a Django model.

Django

class Product(models.Model):
    id = models.[1](primary_key=True)

Drag options to blanks, or click blank then click option'

ACharField

BTextField

CForeignKey

DAutoField

Attempts:

3 left

💡 Hint

Common Mistakes

Using CharField or TextField as primary key without unique constraints.

Using ForeignKey instead of a primary key field.

The AutoField is used to create an auto-incrementing primary key in Django models.

2fill in blank

medium

Complete the code to set a custom field as the primary key in a Django model.

Django

class Employee(models.Model):
    employee_id = models.[1](primary_key=True, max_length=10)

Drag options to blanks, or click blank then click option'

AIntegerField

BCharField

CDateField

DBooleanField

Attempts:

3 left

💡 Hint

Common Mistakes

Using IntegerField without auto-increment for string IDs.

Forgetting to set primary_key=True.

To use a string as a primary key, CharField with primary_key=True is used.

3fill in blank

hard

Fix the error in the model definition to correctly define a primary key.

Django

class Order(models.Model):
    order_number = models.IntegerField()
    [1] = models.AutoField(primary_key=True)

Drag options to blanks, or click blank then click option'

Apk

Border_id

Cid

Dorder_number

Attempts:

3 left

💡 Hint

Common Mistakes

Using the same name for two fields causes errors.

Not defining a primary key when needed.

The primary key field should have a valid variable name like id to avoid conflicts and follow Django conventions.

4fill in blank

hard

Fill both blanks to create a model with a custom primary key and a regular field.

Django

class Category(models.Model):
    [1] = models.[2](primary_key=True, max_length=20)
    name = models.CharField(max_length=100)

Drag options to blanks, or click blank then click option'

Acode

BCharField

CIntegerField

Did

Attempts:

3 left

💡 Hint

Common Mistakes

Using id when a custom key is intended.

Using IntegerField for string keys.

Using code as the field name and CharField with primary_key=True defines a custom string primary key.

5fill in blank

hard

Fill all three blanks to create a model with an auto-increment primary key, a foreign key, and a text field.

Django

class Comment(models.Model):
    [1] = models.[2](primary_key=True)
    post = models.[3]('Post', on_delete=models.CASCADE)
    content = models.TextField()

Drag options to blanks, or click blank then click option'

Aid

BAutoField

CForeignKey

Dcomment_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong field types for primary key or foreign key.

Forgetting to set primary_key=True on the key field.

The id field uses AutoField as primary key. The post field is a ForeignKey to the Post model.

Practice

1. What does Django do if you do not specify a primary key in your model?

easy

A. Uses the first field defined as the primary key.

B. Automatically adds an id field as the primary key.

C. Raises an error and refuses to create the model.

D. Requires you to manually add a primary key later.

Solution

1. Step 1: Understand Django's default behavior

   Django automatically adds an id field as a primary key if none is specified.

2. Step 2: Confirm no error or manual step needed

   No error is raised and no manual primary key is required by default.

3. Final Answer:

   Automatically adds an id field as the primary key. -> Option B

4. Quick Check:

   Default primary key = id field [OK]

Hint: Remember: Django adds id automatically if no primary key [OK]

Common Mistakes:

• Thinking Django raises an error without a primary key
• Assuming first field is primary key by default
• Believing manual primary key is always required

2. Which of the following is the correct way to set a field as the primary key in a Django model?

easy

A. name = models.CharField(max_length=100, primary_key=True)

B. name = models.CharField(max_length=100, key_primary=True)

C. name = models.CharField(max_length=100, primary=True)

D. name = models.CharField(max_length=100, is_primary=True)

Solution

1. Step 1: Identify correct keyword argument

   The correct argument to set a primary key is primary_key=True.

2. Step 2: Match with options

   Only name = models.CharField(max_length=100, primary_key=True) uses primary_key=True correctly.

3. Final Answer:

   name = models.CharField(max_length=100, primary_key=True) -> Option A

4. Quick Check:

   Use primary_key=True to set primary key [OK]

Hint: Use primary_key=True exactly to set primary key [OK]

Common Mistakes:

• Using incorrect argument names like primary=True
• Confusing primary_key with other flags
• Misspelling primary_key

3. Given this model:

class Product(models.Model):
    sku = models.CharField(max_length=20, primary_key=True)
    name = models.CharField(max_length=100)

p = Product(sku='X123', name='Widget')
p.save()
print(Product.objects.get(pk='X123').name)

What will be printed?

medium

A. None

B. X123

C. Error: No primary key field found

D. Widget

Solution

1. Step 1: Understand primary key usage

   The sku field is set as primary key, so pk='X123' looks up by sku.

2. Step 2: Trace the query result

   The object with sku 'X123' has name 'Widget', so printing .name outputs 'Widget'.

3. Final Answer:

   Widget -> Option D

4. Quick Check:

   Primary key lookup returns object name [OK]

Hint: pk uses the primary key field, here sku, to find object [OK]

Common Mistakes:

• Assuming pk means id field always
• Expecting error because id field missing
• Confusing printed value with primary key value

4. What is wrong with this model definition?

class Customer(models.Model):
    id = models.IntegerField(primary_key=True)
    id = models.CharField(max_length=10, primary_key=True)

medium

A. You must use AutoField for primary keys, not IntegerField or CharField.

B. Primary keys cannot be named 'id'.

C. You cannot have two fields with primary_key=True in the same model.

D. The model is missing a Meta class to define primary key.

Solution

1. Step 1: Check primary key uniqueness in model

   A Django model can have only one primary key field.

2. Step 2: Identify duplicate primary_key=True fields

   Here, two fields named 'id' are declared with primary_key=True, which is invalid.

3. Final Answer:

   You cannot have two fields with primary_key=True in the same model. -> Option C

4. Quick Check:

   Only one primary key allowed per model [OK]

Hint: Only one field can have primary_key=True in a model [OK]

Common Mistakes:

• Thinking multiple primary keys are allowed
• Believing primary key must be AutoField
• Assuming primary key name restrictions

5. You want to create a Django model where the email field uniquely identifies each user and acts as the primary key. Which is the best way to define this model?

hard

A. class User(models.Model):
email = models.EmailField(primary_key=True)
name = models.CharField(max_length=100)

B. class User(models.Model):
email = models.EmailField(unique=True)
name = models.CharField(max_length=100)

C. class User(models.Model):
id = models.AutoField(primary_key=True)
email = models.EmailField(unique=True)
name = models.CharField(max_length=100)

D. class User(models.Model):
email = models.EmailField()
name = models.CharField(max_length=100)
class Meta:
primary_key = 'email'

Solution

1. Step 1: Understand primary key vs unique

   Primary key uniquely identifies records and is used as the main identifier.

2. Step 2: Check options for setting email as primary key

   class User(models.Model):
       email = models.EmailField(primary_key=True)
       name = models.CharField(max_length=100)

   sets email as primary key directly, which is correct.

   class User(models.Model):
       email = models.EmailField(unique=True)
       name = models.CharField(max_length=100)

   only makes it unique but not primary key.

   class User(models.Model):
       id = models.AutoField(primary_key=True)
       email = models.EmailField(unique=True)
       name = models.CharField(max_length=100)

   keeps default id as primary key.

   class User(models.Model):
       email = models.EmailField()
       name = models.CharField(max_length=100)
       class Meta:
           primary_key = 'email'

   uses invalid Meta syntax.

3. Final Answer:

   Define email with primary_key=True in the model field. -> Option A

4. Quick Check:

   Set primary_key=True on email field to make it primary key [OK]

Hint: Use primary_key=True on email field to make it primary key [OK]

Common Mistakes:

• Using unique=True instead of primary_key=True
• Keeping default id field as primary key
• Trying to set primary key in Meta class