def test_supports_language_parameter(self):
query = TextItemQuery(TextItem, self.session)
query = query.search(u'orrimorri', language='finnish')
assert "to_tsquery('finnish', :term)" in str(query)
def test_double_quotes(self):
query = TextItemQuery(TextItem, self.session)
query = query.search(u'"orrimorri', language='finnish')
assert query.count() == 1
def test_works_without_tablename_defined(self):
del TextItem.__search_options__
query = TextItemQuery(TextItem, self.session)
assert query.search('content').count()
def test_search_supports_non_english_characters(self):
query = TextItemQuery(TextItem, self.session)
assert query.search(u'ähtäri').count() == 1
query = TextItemQuery(TextItem, self.session)
assert query.search(u'orrimorri').count() == 1
def test_supports_inheritance(self):
assert (TextItemQuery(Article,
self.session).search('content').count() == 2)
def test_term_splitting_supports_multiple_spaces(self):
query = TextItemQuery(TextItem, self.session)
assert query.search('content some').first().name == u'index'
assert query.search('content some').first().name == u'index'
assert query.search(' ').count() == 3
def test_supports_language_parameter(self):
query = TextItemQuery(TextItem, self.session)
query = query.search(u'orrimorri', language='finnish')
assert "to_tsquery('finnish', :term)" in str(query)
def test_double_quotes(self):
query = TextItemQuery(TextItem, self.session)
query = query.search(u'"orrimorri', language='finnish')
assert query.count() == 1
def test_works_without_tablename_defined(self):
del TextItem.__search_options__
query = TextItemQuery(TextItem, self.session)
assert query.search('content').count()
def test_search_supports_non_english_characters(self):
query = TextItemQuery(TextItem, self.session)
assert query.search(u'ähtäri').count() == 1
query = TextItemQuery(TextItem, self.session)
assert query.search(u'orrimorri').count() == 1
def test_search_removes_stopword_characters(self):
assert TextItemQuery(TextItem, self.session).search('@#').count()
def test_search_removes_illegal_characters(self):
assert TextItemQuery(TextItem, self.session).search(':!').count()
def test_term_splitting_supports_multiple_spaces(self):
query = TextItemQuery(TextItem, self.session)
assert query.search('content some').first().name == u'index'
assert query.search('content some').first().name == u'index'
assert query.search(' ').count() == 3
def test_search_supports_term_splitting(self):
assert (TextItemQuery(TextItem,
self.session).search('content').count() == 2)
def test_searches_trhough_all_fulltext_indexed_fields(self):
assert (TextItemQuery(TextItem,
self.session).search('admin').count() == 1)