X-Git-Url: https://git.phdru.name/?a=blobdiff_plain;f=m_librarian%2Fsearch.py;h=7572287759616f11cb2c7353dbc3779cabc6e61c;hb=5126c1afb98575a2430d188ad20a6cc6d5627acb;hp=c4b53256d59ce17e12844fc36f31b7f16503e2d7;hpb=cd508a983971cb2d185c7839e7238c44aa0d871e;p=m_librarian.git diff --git a/m_librarian/search.py b/m_librarian/search.py index c4b5325..7572287 100644 --- a/m_librarian/search.py +++ b/m_librarian/search.py @@ -1,5 +1,6 @@ __all__ = [ + 'mk_search_conditions', 'search_authors', 'search_books', 'search_extensions', 'search_genres', 'search_languages', ] @@ -8,8 +9,10 @@ from sqlobject.sqlbuilder import AND, func from .db import Author, Book, Extension, Genre, Language -def _search_with_operator(table, case_sensitive, comparison_op, values, - expressions): +def _mk_search_conditions_with_operator(table, case_sensitive, comparison_op, + values, expressions): + if expressions is None: + expressions = [] _expressions = [] if case_sensitive: for column, value in values.items(): @@ -26,52 +29,55 @@ def _search_with_operator(table, case_sensitive, comparison_op, values, for expr, value in expressions: _expressions.append( getattr(func.lower(expr), comparison_op)(value.lower())) - return AND(*_expressions) + return _expressions -def _search_exact(table, case_sensitive, values, expressions): - return _search_with_operator(table, case_sensitive, '__eq__', values, - expressions) +_search_conditions_dict = { + 'start': 'startswith', + 'substring': 'contains', + 'full': '__eq__', +} -def _search_start(table, case_sensitive, values, expressions): - return _search_with_operator(table, case_sensitive, 'startswith', values, - expressions) - - -def _search_substring(table, case_sensitive, values, expressions): - return _search_with_operator(table, case_sensitive, 'contains', values, - expressions) +def mk_search_conditions(table, search_type, case_sensitive, values, + expressions=None, join_expressions=None): + if join_expressions is None: + join_expressions = [] + return _mk_search_conditions_with_operator( + table, case_sensitive, _search_conditions_dict[search_type], + values, expressions) + join_expressions def _search(table, search_type, case_sensitive, values, - expressions, orderBy=None): - _search_f = globals()['_search_%s' % search_type] - conditions = _search_f(table, case_sensitive, values, expressions) - return table.select(conditions, orderBy=orderBy) + expressions=None, join_expressions=None, orderBy=None): + conditions = mk_search_conditions( + table, search_type, case_sensitive, values, expressions=expressions, + join_expressions=join_expressions) + return table.select(AND(*conditions), orderBy=orderBy) def search_authors(search_type, case_sensitive, values, - expressions, orderBy=None): + expressions=None, orderBy=None): return _search(Author, search_type, case_sensitive, values, - expressions, orderBy) + expressions=None, orderBy=orderBy) -def search_books(search_type, case_sensitive, values, orderBy=None): +def search_books(search_type, case_sensitive, values, join_expressions=None, + orderBy=None): return _search(Book, search_type, case_sensitive, values, - [], orderBy) + join_expressions=join_expressions, orderBy=orderBy) def search_extensions(search_type, case_sensitive, values, orderBy=None): return _search(Extension, search_type, case_sensitive, values, - [], orderBy) + orderBy=orderBy) def search_genres(search_type, case_sensitive, values, orderBy=None): return _search(Genre, search_type, case_sensitive, values, - [], orderBy) + orderBy=orderBy) def search_languages(search_type, case_sensitive, values, orderBy=None): return _search(Language, search_type, case_sensitive, values, - [], orderBy) + orderBy=orderBy)