Lecture 31:

1. Customizing filtering

2. searching

3. Sorting capabilities

4. Configuring throttling policies

5. Testing throttling policies

6. Understanding filtering, searching and ordering classes

7. Configuring filtering, searching and ordering for views

8. Testing filtering, searching and ordering

Lecture 26: Configured permission policies

Lecture 25:

1. Customizing permission class
2. Listing all users
3. Retrieving details for single user

1. Designed RESTFul API to Interact with simple SQLite database
2. Defined requirements for our API
3. Set up a virtual environment with Django REST Framework
4. Created model to represent and persist game information
5. Executed migrations in Django
6. Managed serialization and de-serialization of game instances

1. pip freeze > requirements.txt

1. python manage.py test -v 2
2. coverage report -m
3. coverage html

1. psql -U postgres
2. create database <NAME_OF_DATABASE>

1. create role <NAME_OF_USER> with login password '<PASSWORD_FOR_USER>';
2. to list users : use command '\du'
3. to grant privileges to user 'grant all privileges on database games to test1;'
4. Use '\l' to verify privileges

1. python /Scripts/<PROJECT_NAME>/manage.py makemigrations
2. python /Scripts/<PROJECT_NAME>/manage.py migrate
3. to check tables use 'psql --username=test1 --dbname=games --command="\dt"'

1. Create Folder
2. Navigate to folder in command prompt/terminal
3. Create virtual environment with the command 'python -m venv'
4. Navigate to /Scripts created in step 3 above
5. Execute activate/activate.bat to start virtual environment
6. Execute command 'pip install django' to install django
7. Execute command 'pip install djangorestframework' to install Django REST framework
8. Execute command 'python /Scripts/django-admin.py startproject <NAME_OF_PROJECT_HERE>'
9. Navigate to the <NAME_OF_PROJECT> folder generated in step 9
10. Execute command 'python manage.py startapp <NAME_OF_APP>' this will create <NAME_OF_PROJECT>/<NAME_OF_APP> and rest of framework files and folders