[pywin32-checkins] pywin32/win32/test test_odbc.py,1.2,1.3

[Mark H. <mha...@us...>]

Update of /cvsroot/pywin32/pywin32/win32/test
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv643

Modified Files:
	test_odbc.py 
Log Message:
A couple of new tests from Frank Millman


Index: test_odbc.py
===================================================================
RCS file: /cvsroot/pywin32/pywin32/win32/test/test_odbc.py,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** test_odbc.py	27 Feb 2006 12:00:57 -0000	1.2
--- test_odbc.py	24 May 2006 01:10:13 -0000	1.3
***************
*** 109,112 ****
--- 109,128 ----
          self._test_val('username', 'foo')
  
+     def test_set_nonzero_length(self):
+         self.assertEqual(self.cur.execute("insert into users (userid,username) "
+             "values (?,?)",['Frank', 'Frank Millman']),1)
+         self.assertEqual(self.cur.execute("update users set username = ?",
+             ['Frank']),1)
+         self.assertEqual(self.cur.execute("select * from users"),0)
+         self.assertEqual(len(self.cur.fetchone()[1]),5)
+ 
+     def test_set_zero_length(self):
+         self.assertEqual(self.cur.execute("insert into users (userid,username) "
+             "values (?,?)",['Frank', 'Frank Millman']),1)
+         self.assertEqual(self.cur.execute("update users set username = ?",
+             ['']),1)
+         self.assertEqual(self.cur.execute("select * from users"),0)
+         self.assertEqual(len(self.cur.fetchone()[1]),0)
+ 
  if __name__ == '__main__':
      unittest.main()