[Erp5-report] r33661 vincent - /erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py

[nobody at svn.erp5.org]

Author: vincent
Date: Thu Mar 11 17:09:47 2010
New Revision: 33661

URL: http://svn.erp5.org?rev=33661&view=rev
Log:
Add test for fulltext operator-generated ORDER BY expression.

Fulltext operator (MatchComparisonOperator) is special because it generates
ORDER BY expression, which is to be used only if caller tells catalog to sort
on the fulltext column. This code tests just that.

Modified:
    erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py

Modified: erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py
URL: http://svn.erp5.org/erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py?rev=33661&r1=33660&r2=33661&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py [utf8] (original)
+++ erp5/trunk/products/ZSQLCatalog/tests/testSQLCatalog.py [utf8] Thu Mar 11 17:09:47 2010
@@ -551,6 +551,15 @@
     self.assertTrue(self._catalog.hasColumn('uid'))
     self.assertFalse(self._catalog.hasColumn('foobar'))
 
+  def test_fulltextOrderBy(self):
+    # No order_by_list, resulting "ORDER BY" must be empty.
+    sql_expression = self.asSQLExpression({'fulltext': 'foo'})
+    self.assertEqual(sql_expression.getOrderByExpression(), '')
+    # order_by_list on fulltext column, resulting "ORDER BY" must be non-empty.
+    sql_expression = self.asSQLExpression({'fulltext': 'foo',
+      'order_by_list': [('fulltext', ), ]})
+    self.assertNotEqual(sql_expression.getOrderByExpression(), '')
+
 ##return catalog(title=Query(title='a', operator='not'))
 #return catalog(title={'query': 'a', 'operator': 'not'})
 #return catalog(title={'query': ['a', 'b'], 'operator': 'not'})