[server/test] update to deal with lgdb sqlserver fix stable
authorJulien Cristau <julien.cristau@logilab.fr>
Wed, 23 Apr 2014 17:21:07 +0200
branchstable
changeset 9678 c34f0cee89b7
parent 9566 cc7e0f4eb10f
child 9731 027bfc467a46
[server/test] update to deal with lgdb sqlserver fix See https://www.logilab.org/ticket/235748
server/test/unittest_rql2sql.py
--- a/server/test/unittest_rql2sql.py	Wed Mar 12 14:08:51 2014 +0100
+++ b/server/test/unittest_rql2sql.py	Wed Apr 23 17:21:07 2014 +0200
@@ -1952,12 +1952,12 @@
         for t in self._parse([("Any X WHERE X creation_date TODAY, X is Affaire",
                         '''SELECT _X.cw_eid
 FROM cw_Affaire AS _X
-WHERE DATE(_X.cw_creation_date)=CURRENT_DATE'''),
+WHERE DATE(_X.cw_creation_date)=%s''' % self.dbhelper.sql_current_date()),
 
                        ("Personne P where not P datenaiss TODAY",
                         '''SELECT _P.cw_eid
 FROM cw_Personne AS _P
-WHERE NOT (DATE(_P.cw_datenaiss)=CURRENT_DATE)'''),
+WHERE NOT (DATE(_P.cw_datenaiss)=%s)''' % self.dbhelper.sql_current_date()),
                        ]):
             yield t