dabo Commit
Revision 2630
Date: 2007-01-08 20:05:22 -0800 (Mon, 08 Jan 2007)
Author: Paul
Changed:
U branches/paul_sandbox/dabo/db/test/test_dCursorMixin.py
Log:
Added some more test cases, and modified the temp_table_name to be 28
chars instead of 49, so that it won't choke with Firebird which is
limited to 31-char table names. Thanks, Uwe.
Diff:
Modified: branches/paul_sandbox/dabo/db/test/test_dCursorMixin.py
===================================================================
--- branches/paul_sandbox/dabo/db/test/test_dCursorMixin.py 2007-01-08
21:35:37 UTC (rev 2629)
+++ branches/paul_sandbox/dabo/db/test/test_dCursorMixin.py 2007-01-09
04:05:22 UTC (rev 2630)
@@ -6,7 +6,7 @@
class Test_dCursorMixin(object):
def setUp(self):
cur = self.cur
- self.temp_table_name = "unittest_%s" %
getRandomUUID().replace("-", "_")
+ self.temp_table_name = "unittest%s" %
getRandomUUID().replace("-", "")[-20:]
self.createSchema()
cur.UserSQL = "select * from %s" % self.temp_table_name
cur.KeyField = "pk"
@@ -93,6 +93,17 @@
def test_Record(self):
cur = self.cur
+ self.assertEqual(cur.Record.cField, "Paul Keith McNett")
+ cur.Record.cField = "Denise McNett"
+ self.assertEqual(cur.Record.cField, "Denise McNett")
+ self.assertEqual(cur._mementos[cur.Record.pk]["cField"], "Paul
Keith McNett")
+ cur.Record.cField = "Alison Anton"
+ self.assertEqual(cur.Record.cField, "Alison Anton")
+ self.assertEqual(cur._mementos[cur.Record.pk]["cField"], "Paul
Keith McNett")
+ cur.setFieldVal("iField", 80)
+ self.assertEqual(cur.Record.iField, 80)
+ self.assertTrue(isinstance(cur.Record.iField, (int, long)))
+ self.assertEqual(cur._mementos[self.cur.Record.pk]["iField"],
23)
def test_RowCount(self):
cur = self.cur
@@ -115,28 +126,22 @@
def test_Table(self):
cur = self.cur
+ self.assertEqual(cur.Table, self.temp_table_name)
def test_UserSQL(self):
cur = self.cur
+ testSQL = "select * from %s where nField = 23.23" %
self.temp_table_name
+ cur.UserSQL = testSQL
+ cur.requery()
+ self.assertEqual(cur.LastSQL, cur.UserSQL)
+ self.assertEqual(cur.UserSQL, testSQL)
+ self.assertEqual(cur.RowCount, 1)
+ self.assertEqual(cur.RowNumber, 0)
+ self.assertEqual(cur.Record.cField, "Paul Keith McNett")
## - End property unit tests -
- def test_RecordGetValue(self):
- self.assertEqual(self.cur.Record.cField, "Paul Keith McNett")
-
- def test_RecordSetValue(self):
- self.cur.Record.cField = "Denise McNett"
- self.assertEqual(self.cur.Record.cField, "Denise McNett")
-
self.assertEqual(self.cur._mementos[self.cur.Record.pk]["cField"], "Paul Keith
McNett")
- self.cur.Record.cField = "Alison Anton"
- self.assertEqual(self.cur.Record.cField, "Alison Anton")
-
self.assertEqual(self.cur._mementos[self.cur.Record.pk]["cField"], "Paul Keith
McNett")
- self.cur.setFieldVal("iField", 80)
- self.assertEqual(self.cur.Record.iField, 80)
- self.assertTrue(isinstance(self.cur.Record.iField, (int, long)))
-
self.assertEqual(self.cur._mementos[self.cur.Record.pk]["iField"], 23)
-
def testMementos(self):
cur = self.cur
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
