Merge branch 'tutorial6'

1 files changed, 179 insertions, 0 deletions

diff --git a/tutorial_6_django_shell_queries/slides.md b/tutorial_6_django_shell_queries/slides.md
new file mode 100644
index 0000000..954cbff
--- /dev/null
+++ b/tutorial_6_django_shell_queries/slides.md
@@ -0,0 +1,179 @@
+Tutorial: Django Shell and Django Database Query
+=====================================
+[Demonstration time: 7 mins 0 secs (0.8333 ~ 83%) | Total time: 8 mins 24 s]
+------------
+
+Slide 1 [00:00 | 00:08]
+------------
+Title Slide
+**Django Shell and Creating Django Database Query**
+
+Slide 2 [00:08 | 00:16]
+--------------
+
+**Learning Objectives**
+
+In this tutorial, we will learn to;
+  - Use the django shell
+  - Create a django query
+
+Slide 3 [00:08 | 00:24]
+---------------
+
+**System Requirements**
+  - Ubuntu 16.10
+  - Python 3.5 or higher version
+  - python3.4-venv
+  
+Slide 4 [00:08 | 00:32]
+---------------
+
+**Pre-requisites**
+
+In order to follow this tutorial, you need to know;
+  - how to create models in django
+  - If not, see the relevant django tutorial on http://spoken-tutorial.org
+  
+Slide 5 [00:12 | 00:44]
+------------
+
+**What is the Django Shell**
+
+ - The Django shell is a Python shell configured for our Django Project.
+ - We can execute our project code in this shell.
+ - We can manipulate our app models in this shell
+
+Demonstration [03:00 | 3:44]
+------------
+
+**Start the Django Shell**
+
+In the terminal, run the command
+
+*python manage.py shell*
+
+(For script creator: Here there will be certain flow, i.e activating virtual env and cd to the project directory etc..
+ Also, flow will be better if before starting any activity we have an initial statement like: Let us now create/see/run....etc..)
+
+(For script creator: small description why this command and not python.)
+
+Run the following Django Query
+
+    >>> from blog.models import Blog, Article
+    >>> Blog.objects.all()
+    >>> <QuerySet [<Blog: Blog object>]> # Output
+  
+Explanation: This django query returns all the instances of the Blog model.
+Returns a QuerySet similar to a list
+
+Now let's add a new blog
+
+    >>> from django.utils import timezone
+    >>> b = Blog(name='My Second Blog', created_on=timezone.now())
+    >>> b.save()
+
+Explanation:
+- We create an instance of Blog and add values to it's fields (name and creation date)
+- We then save the object, which means Django writes this information to the database table 'Blog'
+
+Now we access model field values via Python attributes.
+
+    >>> b.id
+    >>> b.name
+    >>> b.created_on
+
+Change values
+
+    >>> b.name = 'This is a blog from shell!'
+    >>> b.save()
+    >>> b.name
+
+    >>> Blog.objects.all()
+
+In output we see, <QuerySet [<Blog: Blog object>....]>
+  -  Blog object in the output is not a good representation for the object.
+
+Let us fix this in the models.py
+ - Add \__str__() method to the models
+
+       class Blog(models.model):
+        .
+        .
+          def __str__(self):
+             return self.name
+
+       class Article(models.model):
+           .
+           .
+           def __str__(self):
+               return self.title
+
+
+Lets add a custom method to the blog model
+
+    class Blog(models.model):
+    .
+    .
+       def was_created_recently(self):
+           return self.created_on >= timezone.now() - datetime.timedelta(days=1)
+
+In the shell:
+
+    >>> b.was_created_recently()
+
+Demonstration [01:30 | 05:14]
+--------------
+
+**Filtering Entries with Django Queries**
+
+    >>> from blog.models import Blog, Article
+    >>> b2 = Blog.objects.filter(id=2)
+    >>> b2
+  
+Explanation: This query will give all the Blog instances with id 1, since the id is unique we get only one result. You can make sure that the id is 2 by running
+
+    >>> b2[0].id
+    >>> 2 # Output
+  
+Try sorting the Blog objects based on created_on year
+
+    >>> current_year = timezone.now().year
+    >>> Blog.objects.filter(created_on__year=current_year)
+
+Explanation: This query will give all the blog instances with created_on the current year
+
+
+Demonstration [01:00 | 06:14]
+-------------
+** methods for queryset returned**
+
+    >>> blogs =  Blog.objects.all()
+    >>> blogs.count()
+    >>> blogs. <press TAB here to show > available methods
+
+Demonstration [01:30 | 07:44]
+-----------------
+
+**Queries for related Objects**
+
+    >>> b1 = Blog.objects.get(id=1)
+    >>> b1.articles_set.all()
+  
+  Show output
+  
+Explanation: Since every article is related to a Blog (because of the ForeignKey relationship), we can always get all Articles related to a particular blog by using the "_set" suffix
+
+    >>> a1 = Article.objects.get(id=1)
+    >>> b = a1.blog
+    >>> b.id
+
+Explanation: You can always access the information of the Blog object through it's related Article object as shown above
+
+You can also delete objects from shell
+
+    >>> b2.delete()
+    
+(For script creator: Now again we can do a filter or get with id =2, get will throw an Exception that Blog.DoesNotExists)
+
+Remaining conluding slides with the Assignment [00:40 | 8:24]
+----------------------------------------------