def get_list_of_filtered_books(languages, formats, only_books=[]): if len(formats): qs = Book.select().join(BookFormat) \ .join(Format) \ .where(Format.mime << [FORMAT_MATRIX.get(f) for f in formats]) \ .group_by(Book.id) else: qs = Book.select() if len(only_books): print(only_books) qs = qs.where(Book.id << only_books) if len(languages): qs = qs.where(Book.language << languages) return qs
def get_list_of_all_languages(): return list(set(list([b.language for b in Book.select(Book.language)])))