apps/catalogue/views.py

   1 # -*- coding: utf-8 -*-
   2 # This file is part of Wolnelektury, licensed under GNU Affero GPLv3 or later.
   3 # Copyright © Fundacja Nowoczesna Polska. See NOTICE for more information.
   4 #
   5 import tempfile
   6 import zipfile
   7 import sys
   8 import pprint
   9 import traceback
  10 import re
  11
  12 from django.conf import settings
  13 from django.template import RequestContext
  14 from django.shortcuts import render_to_response, get_object_or_404
  15 from django.http import HttpResponse, HttpResponseRedirect, Http404
  16 from django.core.urlresolvers import reverse
  17 from django.db.models import Q
  18 from django.contrib.auth.decorators import login_required, user_passes_test
  19 from django.utils.datastructures import SortedDict
  20 from django.views.decorators.http import require_POST
  21 from django.contrib import auth
  22 from django.contrib.auth.forms import UserCreationForm, AuthenticationForm
  23 from django.utils import simplejson
  24 from django.utils.functional import Promise
  25 from django.utils.encoding import force_unicode
  26 from django.utils.http import urlquote_plus
  27 from django.views.decorators import cache
  28 from django.utils.translation import ugettext as _
  29 from django.views.generic.list_detail import object_list
  30
  31 from catalogue import models
  32 from catalogue import forms
  33 from catalogue.utils import split_tags
  34 from newtagging import views as newtagging_views
  35
  36
  37 staff_required = user_passes_test(lambda user: user.is_staff)
  38
  39
  40 class LazyEncoder(simplejson.JSONEncoder):
  41     def default(self, obj):
  42         if isinstance(obj, Promise):
  43             return force_unicode(obj)
  44         return obj
  45
  46
  47 def main_page(request):
  48     if request.user.is_authenticated():
  49         shelves = models.Tag.objects.filter(category='set', user=request.user)
  50         new_set_form = forms.NewSetForm()
  51     extra_where = "NOT catalogue_tag.category = 'set'"
  52     tags = models.Tag.objects.usage_for_model(models.Book, counts=True, extra={'where': [extra_where]})
  53     fragment_tags = models.Tag.objects.usage_for_model(models.Fragment, counts=True,
  54         extra={'where': ["catalogue_tag.category = 'theme'"] + [extra_where]})
  55     categories = split_tags(tags)
  56
  57     form = forms.SearchForm()
  58     return render_to_response('catalogue/main_page.html', locals(),
  59         context_instance=RequestContext(request))
  60
  61
  62 def book_list(request):
  63     books = models.Book.objects.all()
  64     form = forms.SearchForm()
  65
  66     books_by_first_letter = SortedDict()
  67     for book in books:
  68         books_by_first_letter.setdefault(book.title[0], []).append(book)
  69
  70     return render_to_response('catalogue/book_list.html', locals(),
  71         context_instance=RequestContext(request))
  72
  73
  74 def tagged_object_list(request, tags=''):
  75     # Prevent DoS attacks on our database
  76     if len(tags.split('/')) > 6:
  77         raise Http404
  78
  79     try:
  80         tags = models.Tag.get_tag_list(tags)
  81     except models.Tag.DoesNotExist:
  82         raise Http404
  83
  84     if len([tag for tag in tags if tag.category == 'book']):
  85         raise Http404
  86
  87     theme_is_set = [tag for tag in tags if tag.category == 'theme']
  88     shelf_is_set = len(tags) == 1 and tags[0].category == 'set'
  89     my_shelf_is_set = shelf_is_set and request.user.is_authenticated() and request.user == tags[0].user
  90
  91     objects = only_author = pd_counter = categories = None
  92
  93     if theme_is_set:
  94         shelf_tags = [tag for tag in tags if tag.category == 'set']
  95         fragment_tags = [tag for tag in tags if tag.category != 'set']
  96         fragments = models.Fragment.tagged.with_all(fragment_tags)
  97
  98         if shelf_tags:
  99             books = models.Book.tagged.with_all(shelf_tags).order_by()
 100             l_tags = [models.Tag.objects.get(slug = 'l-' + book.slug) for book in books]
 101             fragments = models.Fragment.tagged.with_any(l_tags, fragments)
 102
 103         # newtagging goes crazy if we just try:
 104         #related_tags = models.Tag.objects.usage_for_queryset(fragments, counts=True,
 105         #                    extra={'where': ["catalogue_tag.category != 'book'"]})
 106         fragment_keys = [fragment.pk for fragment in fragments]
 107         if fragment_keys:
 108             related_tags = models.Fragment.tags.usage(counts = True,
 109                                 filters = {'pk__in': fragment_keys},
 110                                 extra={'where': ["catalogue_tag.category != 'book'"]})
 111             related_tags = (tag for tag in related_tags if tag not in fragment_tags)
 112             categories = split_tags(related_tags)
 113
 114             objects = fragments
 115     else:
 116         books = models.Book.tagged.with_all(tags).order_by()
 117         l_tags = [models.Tag.objects.get(slug = 'l-' + book.slug) for book in books]
 118         book_keys = [book.pk for book in books]
 119         # newtagging goes crazy if we just try:
 120         #related_tags = models.Tag.objects.usage_for_queryset(books, counts=True,
 121         #                    extra={'where': ["catalogue_tag.category NOT IN ('set', 'book', 'theme')"]})
 122         if book_keys:
 123             related_tags = models.Book.tags.usage(counts=True,
 124                                 filters={'pk__in': book_keys},
 125                                 extra={'where': ["catalogue_tag.category NOT IN ('set', 'book', 'theme')"]})
 126             categories = split_tags(related_tags)
 127
 128             fragment_keys = [fragment.pk for fragment in models.Fragment.tagged.with_any(l_tags)]
 129             if fragment_keys:
 130                 categories['theme'] = models.Fragment.tags.usage(counts=True,
 131                                     filters={'pk__in': fragment_keys},
 132                                     extra={'where': ["catalogue_tag.category = 'theme'"]})
 133
 134             books = books.exclude(parent__in = book_keys)
 135             objects = books
 136
 137     if not objects:
 138         only_author = len(tags) == 1 and tags[0].category == 'author'
 139         pd_counter = only_author and tags[0].goes_to_pd()
 140         objects = models.Book.objects.none()
 141
 142     return object_list(
 143         request,
 144         objects,
 145         template_name='catalogue/tagged_object_list.html',
 146         extra_context = {
 147             'categories': categories,
 148             'shelf_is_set': shelf_is_set,
 149             'only_author': only_author,
 150             'pd_counter': pd_counter,
 151             'user_is_owner': my_shelf_is_set,
 152             'formats_form': forms.DownloadFormatsForm(),
 153
 154             'tags': tags,
 155         }
 156     )
 157
 158
 159 def book_fragments(request, book_slug, theme_slug):
 160     book = get_object_or_404(models.Book, slug=book_slug)
 161     book_tag = get_object_or_404(models.Tag, slug='l-' + book_slug)
 162     theme = get_object_or_404(models.Tag, slug=theme_slug)
 163     fragments = models.Fragment.tagged.with_all([book_tag, theme])
 164
 165     form = forms.SearchForm()
 166     return render_to_response('catalogue/book_fragments.html', locals(),
 167         context_instance=RequestContext(request))
 168
 169
 170 def book_detail(request, slug):
 171     try:
 172         book = models.Book.objects.get(slug=slug)
 173     except models.Book.DoesNotExist:
 174         return book_stub_detail(request, slug)
 175
 176     book_tag = get_object_or_404(models.Tag, slug = 'l-' + slug)
 177     tags = list(book.tags.filter(~Q(category='set')))
 178     categories = split_tags(tags)
 179     book_children = book.children.all().order_by('parent_number')
 180     extra_where = "catalogue_tag.category = 'theme'"
 181     book_themes = models.Tag.objects.related_for_model(book_tag, models.Fragment, counts=True, extra={'where': [extra_where]})
 182     extra_info = book.get_extra_info_value()
 183
 184     form = forms.SearchForm()
 185     return render_to_response('catalogue/book_detail.html', locals(),
 186         context_instance=RequestContext(request))
 187
 188
 189 def book_stub_detail(request, slug):
 190     book = get_object_or_404(models.BookStub, slug=slug)
 191     pd_counter = book.pd
 192     form = forms.SearchForm()
 193
 194     return render_to_response('catalogue/book_stub_detail.html', locals(),
 195         context_instance=RequestContext(request))
 196
 197
 198 def book_text(request, slug):
 199     book = get_object_or_404(models.Book, slug=slug)
 200     book_themes = {}
 201     for fragment in book.fragments.all():
 202         for theme in fragment.tags.filter(category='theme'):
 203             book_themes.setdefault(theme, []).append(fragment)
 204
 205     book_themes = book_themes.items()
 206     book_themes.sort(key=lambda s: s[0].sort_key)
 207     return render_to_response('catalogue/book_text.html', locals(),
 208         context_instance=RequestContext(request))
 209
 210
 211 # ==========
 212 # = Search =
 213 # ==========
 214
 215 def _no_diacritics_regexp(query):
 216     """ returns a regexp for searching for a query without diacritics
 217
 218     should be locale-aware """
 219     names = {
 220         u'a':u'aąĄ', u'c':u'cćĆ', u'e':u'eęĘ', u'l': u'lłŁ', u'n':u'nńŃ', u'o':u'oóÓ', u's':u'sśŚ', u'z':u'zźżŹŻ',
 221         u'ą':u'ąĄ', u'ć':u'ćĆ', u'ę':u'ęĘ', u'ł': u'łŁ', u'ń':u'ńŃ', u'ó':u'óÓ', u'ś':u'śŚ', u'ź':u'źŹ', u'ż':u'żŻ'
 222         }
 223     def repl(m):
 224         l = m.group()
 225         return u"(%s)" % '|'.join(names[l])
 226     return re.sub(u'[%s]'%(u''.join(names.keys())), repl, query)
 227
 228 def unicode_re_escape(query):
 229     """ Unicode-friendly version of re.escape """
 230     return re.sub('(?u)(\W)', r'\\\1', query)
 231
 232 def _word_starts_with(name, prefix):
 233     """returns a Q object getting models having `name` contain a word
 234     starting with `prefix`
 235
 236     We define word characters as alphanumeric and underscore, like in JS.
 237
 238     Works for MySQL, PostgreSQL, Oracle.
 239     For SQLite, _sqlite* version is substituted for this.
 240     """
 241     kwargs = {}
 242
 243     prefix = _no_diacritics_regexp(unicode_re_escape(prefix))
 244     # can't use [[:<:]] (word start),
 245     # but we want both `xy` and `(xy` to catch `(xyz)`
 246     kwargs['%s__iregex' % name] = u"(^|[^[:alnum:]_])%s" % prefix
 247
 248     return Q(**kwargs)
 249
 250
 251 def _sqlite_word_starts_with(name, prefix):
 252     """ version of _word_starts_with for SQLite
 253
 254     SQLite in Django uses Python re module
 255     """
 256     kwargs = {}
 257     prefix = _no_diacritics_regexp(unicode_re_escape(prefix))
 258     kwargs['%s__iregex' % name] = ur"(^|(?<=[^\wąćęłńóśźżĄĆĘŁŃÓŚŹŻ]))%s" % prefix
 259     return Q(**kwargs)
 260
 261
 262 if settings.DATABASE_ENGINE == 'sqlite3':
 263     _word_starts_with = _sqlite_word_starts_with
 264
 265
 266 def _tags_starting_with(prefix, user):
 267     prefix = prefix.lower()
 268     book_stubs = models.BookStub.objects.filter(_word_starts_with('title', prefix))
 269     books = models.Book.objects.filter(_word_starts_with('title', prefix))
 270     book_stubs = filter(lambda x: x not in books, book_stubs)
 271     tags = models.Tag.objects.filter(_word_starts_with('name', prefix))
 272     if user.is_authenticated():
 273         tags = tags.filter(~Q(category='book') & (~Q(category='set') | Q(user=user)))
 274     else:
 275         tags = tags.filter(~Q(category='book') & ~Q(category='set'))
 276
 277     return list(books) + list(tags) + list(book_stubs)
 278
 279
 280
 281 def _get_result_link(match, tag_list):
 282     if isinstance(match, models.Book) or isinstance(match, models.BookStub):
 283         return match.get_absolute_url()
 284     else:
 285         return reverse('catalogue.views.tagged_object_list',
 286             kwargs={'tags': '/'.join(tag.slug for tag in tag_list + [match])}
 287         )
 288
 289 def _get_result_type(match):
 290     if isinstance(match, models.Book) or isinstance(match, models.BookStub):
 291         type = 'book'
 292     else:
 293         type = match.category
 294     return dict(models.TAG_CATEGORIES)[type]
 295
 296
 297
 298 def find_best_matches(query, user):
 299     """ Finds a Book, Tag or Bookstub best matching a query.
 300
 301     Returns a with:
 302       - zero elements when nothing is found,
 303       - one element when a best result is found,
 304       - more then one element on multiple exact matches
 305
 306     Raises a ValueError on too short a query.
 307     """
 308
 309     query = query.lower()
 310     if len(query) < 2:
 311         raise ValueError("query must have at least two characters")
 312
 313     result = tuple(_tags_starting_with(query, user))
 314     exact_matches = tuple(res for res in result if res.name.lower() == query)
 315     if exact_matches:
 316         return exact_matches
 317     else:
 318         return result[:1]
 319
 320
 321 def search(request):
 322     tags = request.GET.get('tags', '')
 323     prefix = request.GET.get('q', '')
 324
 325     try:
 326         tag_list = models.Tag.get_tag_list(tags)
 327     except:
 328         tag_list = []
 329
 330     try:
 331         result = find_best_matches(prefix, request.user)
 332     except ValueError:
 333         return render_to_response('catalogue/search_too_short.html', {'tags':tag_list, 'prefix':prefix},
 334             context_instance=RequestContext(request))
 335
 336     if len(result) == 1:
 337         return HttpResponseRedirect(_get_result_link(result[0], tag_list))
 338     elif len(result) > 1:
 339         return render_to_response('catalogue/search_multiple_hits.html',
 340             {'tags':tag_list, 'prefix':prefix, 'results':((x, _get_result_link(x, tag_list), _get_result_type(x)) for x in result)},
 341             context_instance=RequestContext(request))
 342     else:
 343         return render_to_response('catalogue/search_no_hits.html', {'tags':tag_list, 'prefix':prefix},
 344             context_instance=RequestContext(request))
 345
 346
 347 def tags_starting_with(request):
 348     prefix = request.GET.get('q', '')
 349     # Prefix must have at least 2 characters
 350     if len(prefix) < 2:
 351         return HttpResponse('')
 352
 353     return HttpResponse('\n'.join(tag.name for tag in _tags_starting_with(prefix, request.user)))
 354
 355
 356 # ====================
 357 # = Shelf management =
 358 # ====================
 359 @login_required
 360 @cache.never_cache
 361 def user_shelves(request):
 362     shelves = models.Tag.objects.filter(category='set', user=request.user)
 363     new_set_form = forms.NewSetForm()
 364     return render_to_response('catalogue/user_shelves.html', locals(),
 365             context_instance=RequestContext(request))
 366
 367 @cache.never_cache
 368 def book_sets(request, slug):
 369     book = get_object_or_404(models.Book, slug=slug)
 370     user_sets = models.Tag.objects.filter(category='set', user=request.user)
 371     book_sets = book.tags.filter(category='set', user=request.user)
 372
 373     if not request.user.is_authenticated():
 374         return HttpResponse(_('<p>To maintain your shelves you need to be logged in.</p>'))
 375
 376     if request.method == 'POST':
 377         form = forms.ObjectSetsForm(book, request.user, request.POST)
 378         if form.is_valid():
 379             old_shelves = list(book.tags.filter(category='set'))
 380             new_shelves = [models.Tag.objects.get(pk=id) for id in form.cleaned_data['set_ids']]
 381
 382             for shelf in [shelf for shelf in old_shelves if shelf not in new_shelves]:
 383                 shelf.book_count -= 1
 384                 shelf.save()
 385
 386             for shelf in [shelf for shelf in new_shelves if shelf not in old_shelves]:
 387                 shelf.book_count += 1
 388                 shelf.save()
 389
 390             book.tags = new_shelves + list(book.tags.filter(~Q(category='set') | ~Q(user=request.user)))
 391             if request.is_ajax():
 392                 return HttpResponse(_('<p>Shelves were sucessfully saved.</p>'))
 393             else:
 394                 return HttpResponseRedirect('/')
 395     else:
 396         form = forms.ObjectSetsForm(book, request.user)
 397         new_set_form = forms.NewSetForm()
 398
 399     return render_to_response('catalogue/book_sets.html', locals(),
 400         context_instance=RequestContext(request))
 401
 402
 403 @login_required
 404 @require_POST
 405 @cache.never_cache
 406 def remove_from_shelf(request, shelf, book):
 407     book = get_object_or_404(models.Book, slug=book)
 408     shelf = get_object_or_404(models.Tag, slug=shelf, category='set', user=request.user)
 409
 410     if shelf in book.tags:
 411         models.Tag.objects.remove_tag(book, shelf)
 412
 413         shelf.book_count -= 1
 414         shelf.save()
 415
 416         return HttpResponse(_('Book was successfully removed from the shelf'))
 417     else:
 418         return HttpResponse(_('This book is not on the shelf'))
 419
 420
 421 def collect_books(books):
 422     """
 423     Returns all real books in collection.
 424     """
 425     result = []
 426     for book in books:
 427         if len(book.children.all()) == 0:
 428             result.append(book)
 429         else:
 430             result += collect_books(book.children.all())
 431     return result
 432
 433
 434 @cache.never_cache
 435 def download_shelf(request, slug):
 436     """"
 437     Create a ZIP archive on disk and transmit it in chunks of 8KB,
 438     without loading the whole file into memory. A similar approach can
 439     be used for large dynamic PDF files.
 440     """
 441     shelf = get_object_or_404(models.Tag, slug=slug, category='set')
 442
 443     formats = []
 444     form = forms.DownloadFormatsForm(request.GET)
 445     if form.is_valid():
 446         formats = form.cleaned_data['formats']
 447     if len(formats) == 0:
 448         formats = ['pdf', 'odt', 'txt', 'mp3', 'ogg']
 449
 450     # Create a ZIP archive
 451     temp = tempfile.TemporaryFile()
 452     archive = zipfile.ZipFile(temp, 'w')
 453
 454     for book in collect_books(models.Book.tagged.with_all(shelf)):
 455         if 'pdf' in formats and book.pdf_file:
 456             filename = book.pdf_file.path
 457             archive.write(filename, str('%s.pdf' % book.slug))
 458         if 'odt' in formats and book.odt_file:
 459             filename = book.odt_file.path
 460             archive.write(filename, str('%s.odt' % book.slug))
 461         if 'txt' in formats and book.txt_file:
 462             filename = book.txt_file.path
 463             archive.write(filename, str('%s.txt' % book.slug))
 464         if 'mp3' in formats and book.mp3_file:
 465             filename = book.mp3_file.path
 466             archive.write(filename, str('%s.mp3' % book.slug))
 467         if 'ogg' in formats and book.ogg_file:
 468             filename = book.ogg_file.path
 469             archive.write(filename, str('%s.ogg' % book.slug))
 470     archive.close()
 471
 472     response = HttpResponse(content_type='application/zip', mimetype='application/x-zip-compressed')
 473     response['Content-Disposition'] = 'attachment; filename=%s.zip' % shelf.sort_key
 474     response['Content-Length'] = temp.tell()
 475
 476     temp.seek(0)
 477     response.write(temp.read())
 478     return response
 479
 480
 481 @cache.never_cache
 482 def shelf_book_formats(request, shelf):
 483     """"
 484     Returns a list of formats of books in shelf.
 485     """
 486     shelf = get_object_or_404(models.Tag, slug=shelf, category='set')
 487
 488     formats = {'pdf': False, 'odt': False, 'txt': False, 'mp3': False, 'ogg': False}
 489
 490     for book in collect_books(models.Book.tagged.with_all(shelf)):
 491         if book.pdf_file:
 492             formats['pdf'] = True
 493         if book.odt_file:
 494             formats['odt'] = True
 495         if book.txt_file:
 496             formats['txt'] = True
 497         if book.mp3_file:
 498             formats['mp3'] = True
 499         if book.ogg_file:
 500             formats['ogg'] = True
 501
 502     return HttpResponse(LazyEncoder().encode(formats))
 503
 504
 505 @login_required
 506 @require_POST
 507 @cache.never_cache
 508 def new_set(request):
 509     new_set_form = forms.NewSetForm(request.POST)
 510     if new_set_form.is_valid():
 511         new_set = new_set_form.save(request.user)
 512
 513         if request.is_ajax():
 514             return HttpResponse(_('<p>Shelf <strong>%s</strong> was successfully created</p>') % new_set)
 515         else:
 516             return HttpResponseRedirect('/')
 517
 518     return HttpResponseRedirect('/')
 519
 520
 521 @login_required
 522 @require_POST
 523 @cache.never_cache
 524 def delete_shelf(request, slug):
 525     user_set = get_object_or_404(models.Tag, slug=slug, category='set', user=request.user)
 526     user_set.delete()
 527
 528     if request.is_ajax():
 529         return HttpResponse(_('<p>Shelf <strong>%s</strong> was successfully removed</p>') % user_set.name)
 530     else:
 531         return HttpResponseRedirect('/')
 532
 533
 534 # ==================
 535 # = Authentication =
 536 # ==================
 537 @require_POST
 538 @cache.never_cache
 539 def login(request):
 540     form = AuthenticationForm(data=request.POST, prefix='login')
 541     if form.is_valid():
 542         auth.login(request, form.get_user())
 543         response_data = {'success': True, 'errors': {}}
 544     else:
 545         response_data = {'success': False, 'errors': form.errors}
 546     return HttpResponse(LazyEncoder(ensure_ascii=False).encode(response_data))
 547
 548
 549 @require_POST
 550 @cache.never_cache
 551 def register(request):
 552     registration_form = UserCreationForm(request.POST, prefix='registration')
 553     if registration_form.is_valid():
 554         user = registration_form.save()
 555         user = auth.authenticate(
 556             username=registration_form.cleaned_data['username'],
 557             password=registration_form.cleaned_data['password1']
 558         )
 559         auth.login(request, user)
 560         response_data = {'success': True, 'errors': {}}
 561     else:
 562         response_data = {'success': False, 'errors': registration_form.errors}
 563     return HttpResponse(LazyEncoder(ensure_ascii=False).encode(response_data))
 564
 565
 566 @cache.never_cache
 567 def logout_then_redirect(request):
 568     auth.logout(request)
 569     return HttpResponseRedirect(urlquote_plus(request.GET.get('next', '/'), safe='/?='))
 570
 571
 572
 573 # =========
 574 # = Admin =
 575 # =========
 576 @login_required
 577 @staff_required
 578 def import_book(request):
 579     """docstring for import_book"""
 580     book_import_form = forms.BookImportForm(request.POST, request.FILES)
 581     if book_import_form.is_valid():
 582         try:
 583             book_import_form.save()
 584         except:
 585             info = sys.exc_info()
 586             exception = pprint.pformat(info[1])
 587             tb = '\n'.join(traceback.format_tb(info[2]))
 588             _('Today is %(month)s, %(day)s.') % {'month': m, 'day': d}
 589             return HttpResponse(_("An error occurred: %(exception)s\n\n%(tb)s") % {'exception':exception, 'tb':tb}, mimetype='text/plain')
 590         return HttpResponse(_("Book imported successfully"))
 591     else:
 592         return HttpResponse(_("Error importing file: %r") % book_import_form.errors)
 593
 594
 595
 596 def clock(request):
 597     """ Provides server time for jquery.countdown,
 598     in a format suitable for Date.parse()
 599     """
 600     from datetime import datetime
 601     return HttpResponse(datetime.now().strftime('%Y/%m/%d %H:%M:%S'))