Django Insert Data

The Members table created in the previous chapter is empty. We will use the Python interpreter (Python shell) to add some members to it. To open a Python shell, type this command: python manage.py shell Now we are in the shell, the result should be something like this:

Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> At the bottom, after the three >>> write the following: >>> from members.models import Member Hit [enter] and write this to look at the empty Member table: >>> Member.objects.all() This should give you an empty QuerySet object, like this: <QuerySet []> A QuerySet is a collection of data from a database.

Django QuerySet chapter. Add a record to the table, by executing these two lines:

>>> member.save() Execute this command to see if the Member table got a member: >>> Member.objects.all().values() Hopefully, the result will look like this:

You can add multiple records by making a list of Member objects, and execute.save() on each entry:

>>> members_list = [member1, member2, member3, member4, member5] >>> for x in members_list:... x.save()... >>> Hit [enter] one more time at the end to exit the for loop. Now, if you run this command: >>> Member.objects.all().values() you will see that there are 6 members in the Member table: