Django Shell

python manage.py shell

# Import models
from tasks.models import Task, Project
from django.contrib.auth.models import User

# Creating objects
user = User.objects.create_user('testuser', password='pass123')
project = Project.objects.create(name='My Project')
task = Task.objects.create(title='First Task', owner=user, project=project)

# Reading
Task.objects.all()
Task.objects.filter(status='todo')
task = Task.objects.get(pk=1)

# Updating
task.status = 'done'
task.save()

# Deleting
task.delete()

from django.db import connection

Task.objects.all()
print(connection.queries)  # list of executed SQL queries

# Check business logic
task = Task.objects.first()
print(task.get_status_display())
print(str(task))

# Inspect a queryset
qs = Task.objects.select_related('project').filter(owner__username='testuser')
print(qs.query)  # show the SQL

pip install ipython
python manage.py shell  # automatically uses IPython

pip install django-extensions ipython

# settings.py
INSTALLED_APPS = [
    ...,
    'django_extensions',
]

python manage.py shell_plus
# Automatically imports ALL models!

from tasks.models import Task, Project
from django.contrib.auth.models import User
# and every other model from every app

python manage.py shell_plus --ipython

In [1]: Task?           # class help
In [2]: Task.objects.   # Tab to autocomplete methods
In [3]: print(Task.objects.all().query)  # inspect generated SQL
In [4]: %run script.py            # load a script

python manage.py shell_plus --notebook

python manage.py graph_models -a -o models.png   # diagram of all models
python manage.py show_urls                         # list all URLs
python manage.py runserver_plus                    # werkzeug debugger
python manage.py create_command myapp              # scaffold a management command

python manage.py shell < script.py
# or
python manage.py shell -c "from tasks.models import Task; print(Task.objects.count())"