From 23868831c777bb7fce75e2d24d20a6659d4f04d5 Mon Sep 17 00:00:00 2001
From: hardythe1
Date: Tue, 30 Sep 2014 17:31:54 +0530
Subject: reverting back to order_by

---
 tbc/views.py | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'tbc')

diff --git a/tbc/views.py b/tbc/views.py
index 21f059c..47637ad 100755
--- a/tbc/views.py
+++ b/tbc/views.py
@@ -451,8 +451,7 @@ def BookDetails(request, book_id=None):
         else:
             context['user'] = request.user
     book = Book.objects.get(id=book_id)
-    query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
-    chapters = Chapters.objects.raw(query)
+    chapters = Chapters.objects.filter(book=book).order_by('name')
     images = ScreenShots.objects.filter(book=book)
     context['chapters'] = chapters
     context['images'] = images
@@ -465,8 +464,7 @@ def BookReview(request, book_id=None):
     if is_reviewer(request.user):
         if book_id:
             book = Book.objects.get(id=book_id)
-            query = 'SELECT * from tbc_chapters where book_id = (SELECT id from tbc_book where id='+book_id+') ORDER BY LENGTH(name), name;'
-            chapters = Chapters.objects.raw(query)
+            chapters = Chapters.objects.filter(book=book).order_by('name')
             images = ScreenShots.objects.filter(book=book)
             context['chapters'] = chapters
             context['images'] = images
-- 
cgit