[Erp5-report] r19668 - /erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py
nobody at svn.erp5.org
nobody at svn.erp5.org
Tue Mar 4 16:33:06 CET 2008
Author: jerome
Date: Tue Mar 4 16:33:05 2008
New Revision: 19668
URL: http://svn.erp5.org?rev=19668&view=rev
Log:
More tests for keyword search keys with spaces, - and %
Modified:
erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py
Modified: erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py
URL: http://svn.erp5.org/erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py?rev=19668&r1=19667&r2=19668&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py (original)
+++ erp5/trunk/products/ZSQLCatalog/tests/testZSQLCatalog.py Tue Mar 4 16:33:05 2008
@@ -243,6 +243,30 @@
datetime_search_keys = [],
full_text_search_keys=[]))
+ def testQueryKeywordSearchKeyWithPercent(self):
+ q = Query(title='F%o')
+ self.assertEquals(dict(where_expression="((((title LIKE '%F%o%'))))",
+ select_expression_list=[]),
+ q.asSQLExpression(keyword_search_keys=['title'],
+ datetime_search_keys = [],
+ full_text_search_keys=[]))
+
+ def testQueryKeywordSearchKeyWithMinus(self):
+ q = Query(title='F-o')
+ self.assertEquals(dict(where_expression="((((title LIKE '%F-o%'))))",
+ select_expression_list=[]),
+ q.asSQLExpression(keyword_search_keys=['title'],
+ datetime_search_keys = [],
+ full_text_search_keys=[]))
+
+ def testQueryKeywordSearchKeyWithSpace(self):
+ q = Query(title='F o')
+ self.assertEquals(dict(where_expression="((((title LIKE '%F o%'))))",
+ select_expression_list=[]),
+ q.asSQLExpression(keyword_search_keys=['title'],
+ datetime_search_keys = [],
+ full_text_search_keys=[]))
+
def testNegatedQuery(self):
q1 = Query(title='Foo')
q = NegatedQuery(q1)
More information about the Erp5-report
mailing list