+# -*- coding: utf-8 -*-
+
+import os
+
from sqlobject.sqlbuilder import CONCAT
-from bottle import cheetah_view, redirect, request, route
+from bottle import cheetah_view, redirect, request, route, static_file
-from m_librarian.db import Author, open_db
+from m_librarian.config import get_config
+from m_librarian.db import Author, Book
+from m_librarian.download import download
from m_librarian.search import search_authors
CONCAT(Author.q.surname, ' ', Author.q.name, ' ', Author.q.misc_name),
decode(value)
)]
- open_db()
authors = search_authors(search_type, case_sensitive, {}, expressions,
orderBy=('surname', 'name', 'misc_name'))
return {
'search_type': search_type,
'case_sensitive': case_sensitive,
}
+
+
+@route('/books-by-author/<id:int>/', method='GET')
+@cheetah_view('books_by_author.tmpl')
+def books_by_author(id):
+ return {
+ 'author': Author.get(id),
+ 'books': Book.select(
+ Book.j.authors & (Author.q.id == id),
+ orderBy=['series', 'ser_no', 'title'],
+ )
+ }
+
+
+@route('/static/<filename:path>')
+def send_static(filename):
+ return static_file(
+ filename, root=os.path.join(
+ os.path.dirname(__file__),
+ 'static'
+ )
+ )
+
+
+@route('/download/<id:int>/', method='GET')
+@cheetah_view('download.tmpl')
+def download_book(id):
+ book = Book.get(id)
+ download(book, get_config().get('download', 'path'))
+ return {
+ 'message': u'Книга сохранена',
+ }