[Modeling-cvs] ProjectModeling/Modeling/tests test_EditingContext_Global.py,1.40,1.41

[<sbi...@us...>]

Update of /cvsroot/modeling/ProjectModeling/Modeling/tests
In directory sc8-pr-cvs1:/tmp/cvs-serv25961/tests

Modified Files:
	test_EditingContext_Global.py 
Log Message:
Added tests for bug #786217

Index: test_EditingContext_Global.py
===================================================================
RCS file: /cvsroot/modeling/ProjectModeling/Modeling/tests/test_EditingContext_Global.py,v
retrieving revision 1.40
retrieving revision 1.41
diff -C2 -d -r1.40 -r1.41
*** test_EditingContext_Global.py	9 Aug 2003 15:07:23 -0000	1.40
--- test_EditingContext_Global.py	10 Aug 2003 12:02:05 -0000	1.41
***************
*** 1221,1226 ****
--- 1221,1246 ----
      res=ec.fetch('Book', 'title like "*abc_d*"')
      self.assertEqual(len(res), 1)
+     self.assertEqual(res[0].getTitle(), "abc_d")
      res=ec.fetch('Book', 'title like "*abc%d*"')
      self.assertEqual(len(res), 1)
+     self.assertEqual(res[0].getTitle(), "abc%d")
+     # TBD: with ILIKE
+     
+   def test_27_like_is_case_sensitive(self):
+     "[EditingContext] check that LIKE is case-sensitive"
+     # bug #786217
+     ec=EditingContext()
+     b1=Book(); b1.setTitle('abcd')
+     b2=Book(); b2.setTitle('aBcd')
+     b3=Book(); b3.setTitle('aBCd')
+     ec.insert(b1); ec.insert(b2); ec.insert(b3)
+     ec.saveChanges()
+ 
+     res=ec.fetch('Book', 'title like "abcd"')
+     self.assertEqual(len(res), 1)
+     self.assertEqual(res[0].getTitle(), "abcd")
+     res=ec.fetch('Book', 'title like "aBCd"')
+     self.assertEqual(len(res), 1)
+     self.assertEqual(res[0].getTitle(), "aBCd")
                  
    def test_999_customSQLQuery(self):