X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=m_librarian%2Fdb.py;h=064ca9a0d8a75cd89667feaddfecc9be450ff358;hb=f3860aa18c077dbffc5fcc876f0f2aba49509305;hp=0c41d4b7c9e70eb675bce95661576509688eab83;hpb=8fdf6aab492482fcacad9ce2ec764bdc5bf76590;p=m_librarian.git diff --git a/m_librarian/db.py b/m_librarian/db.py index 0c41d4b..064ca9a 100755 --- a/m_librarian/db.py +++ b/m_librarian/db.py @@ -2,9 +2,11 @@ from __future__ import print_function import os + from sqlobject import SQLObject, StringCol, UnicodeCol, IntCol, BoolCol, \ ForeignKey, DateCol, DatabaseIndex, RelatedJoin, \ connectionForURI, sqlhub, SQLObjectNotFound, dberrors + from .compat import string_type from .config import get_config @@ -72,6 +74,38 @@ class Book(SQLObject): date_idx = DatabaseIndex(date) language_idx = DatabaseIndex(language) + @property + def author1(self): + return self.authors[0].fullname + + @property + def author_list(self): + return u', '.join([a.fullname for a in self.authors]) + + @property + def genre1name(self): + return self.genres[0].name + + @property + def genre1title(self): + return self.genres[0].title + + @property + def genre_name_list(self): + return u', '.join([g.name for g in self.genres]) + + @property + def genre_title_list(self): + return u', '.join([g.title for g in self.genres]) + + @property + def ext(self): + return self.extension.name + + @property + def lang(self): + return self.language.name + class BookGenre(SQLObject): class sqlmeta: