010-Django Insert Data

Objectives: Django Insert Data

Django Insert Data

Inserting Data in Django

1. Open Python Shell

To add records to the Members table, open the Python shell:

python manage.py shell

You should see something like:

Python 3.13.2 (tags/v3.13.2:4f8bb39, Feb 4 2025, 15:23:48) [MSC v.1942 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>>

2. Import the Model

>>> from members.models import Member

3. Check Existing Records

>>> Member.objects.all()

If empty, you’ll see:

<QuerySet []>

Note: A QuerySet is a collection of data from a database.

Real-life Example:

Think of a QuerySet like a list of all students in a class. Right now, the list is empty because no student has been added yet.

4. Add a Single Record

>>> member = Member(firstname='Emil', lastname='Refsnes')
>>> member.save()

Check if it was saved:

>>> Member.objects.all().values()
<QuerySet [{'id': 1, 'firstname': 'Emil', 'lastname': 'Refsnes'}]>

5. Add Multiple Records

>>> member1 = Member(firstname='Tobias', lastname='Refsnes')
>>> member2 = Member(firstname='Linus', lastname='Refsnes')
>>> member3 = Member(firstname='Lene', lastname='Refsnes')
>>> member4 = Member(firstname='Stale', lastname='Refsnes')
>>> member5 = Member(firstname='Jane', lastname='Doe')
>>> members_list = [member1, member2, member3, member4, member5]
>>> for x in members_list:
...     x.save()
...

Verify all records:

>>> Member.objects.all().values()
<QuerySet [{'id': 1, 'firstname': 'Emil', 'lastname': 'Refsnes'},
{'id': 2, 'firstname': 'Tobias', 'lastname': 'Refsnes'},
{'id': 3, 'firstname': 'Linus', 'lastname': 'Refsnes'},
{'id': 4, 'firstname': 'Lene', 'lastname': 'Refsnes'},
{'id': 5, 'firstname': 'Stale', 'lastname': 'Refsnes'},
{'id': 6, 'firstname': 'Jane', 'lastname': 'Doe'}]>

Real-life Example:

Adding records is like enrolling students in a class. Each student is added one by one or in batches to the class list.

Advice:

Always check your QuerySet after adding records to ensure data was saved correctly. Typos in field names can prevent saving.

Exercise:

Question: How would you add a new member named Alice Smith to the Members table using the Python shell?

Answer:

>>> member = Member(firstname='Alice', lastname='Smith')
>>> member.save()

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡