# HG changeset patch
# User Alexandre Fayolle <alexandre.fayolle@logilab.fr>
# Date 1323094821 -3600
# Node ID 67d540b7f8c8cb3bc6060d8894c4361c3c69bf79
# Parent  7980b36fb1aa7aabad5811d03af72889f8db220b
fix tests broken by lgdb update

diff -r 7980b36fb1aa -r 67d540b7f8c8 server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Mon Dec 05 13:37:40 2011 +0100
+++ b/server/test/unittest_rql2sql.py	Mon Dec 05 15:20:21 2011 +0100
@@ -19,7 +19,7 @@
 
 import sys
 import os
-
+from datetime import date
 from logilab.common.testlib import TestCase, unittest_main, mock_object
 
 from rql import BadRQLQuery
@@ -1747,7 +1747,7 @@
 class SqlServer2005SQLGeneratorTC(PostgresSQLGeneratorTC):
     backend = 'sqlserver2005'
     def _norm_sql(self, sql):
-        return sql.strip().replace(' SUBSTR', ' SUBSTRING').replace(' || ', ' + ').replace(' ILIKE ', ' LIKE ').replace('TRUE', '1').replace('FALSE', '0')
+        return sql.strip().replace(' SUBSTR', ' SUBSTRING').replace(' || ', ' + ').replace(' ILIKE ', ' LIKE ').replace('TRUE', '1').replace('FALSE', '0').replace('CURRENT_DATE', str(date.today()))
 
     def test_has_text(self):
         for t in self._parse(HAS_TEXT_LG_INDEXER):