Mercurial > p > roundup > code
comparison test/db_test_base.py @ 2472:f41539b3c486
fixed Boolean values in postgresql (bugs [SF#972546] and [SF#972600])
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Wed, 16 Jun 2004 03:54:00 +0000 |
| parents | 0e2a0c2c8142 |
| children | ea7fb2f416db |
comparison
equal
deleted
inserted
replaced
| 2471:31cd032291c5 | 2472:f41539b3c486 |
|---|---|
| 13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS | 13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
| 14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS" | 14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS" |
| 15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, | 15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, |
| 16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. | 16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. |
| 17 # | 17 # |
| 18 # $Id: db_test_base.py,v 1.31 2004-06-13 01:05:46 richard Exp $ | 18 # $Id: db_test_base.py,v 1.32 2004-06-16 03:54:00 richard Exp $ |
| 19 | 19 |
| 20 import unittest, os, shutil, errno, imp, sys, time, pprint | 20 import unittest, os, shutil, errno, imp, sys, time, pprint |
| 21 | 21 |
| 22 from roundup.hyperdb import String, Password, Link, Multilink, Date, \ | 22 from roundup.hyperdb import String, Password, Link, Multilink, Date, \ |
| 23 Interval, DatabaseError, Boolean, Number, Node | 23 Interval, DatabaseError, Boolean, Number, Node |
| 261 self.db.issue.set(nid, foo=None) | 261 self.db.issue.set(nid, foo=None) |
| 262 if commit: self.db.commit() | 262 if commit: self.db.commit() |
| 263 self.assertEqual(self.db.issue.get(nid, "foo"), None) | 263 self.assertEqual(self.db.issue.get(nid, "foo"), None) |
| 264 | 264 |
| 265 # Boolean | 265 # Boolean |
| 266 def testBooleanSet(self): | |
| 267 nid = self.db.user.create(username='one', assignable=1) | |
| 268 self.assertEqual(self.db.user.get(nid, "assignable"), 1) | |
| 269 nid = self.db.user.create(username='two', assignable=0) | |
| 270 self.assertEqual(self.db.user.get(nid, "assignable"), 0) | |
| 271 | |
| 266 def testBooleanChange(self): | 272 def testBooleanChange(self): |
| 267 userid = self.db.user.create(username='foo', assignable=1) | 273 userid = self.db.user.create(username='foo', assignable=1) |
| 268 self.assertEqual(1, self.db.user.get(userid, 'assignable')) | 274 self.assertEqual(1, self.db.user.get(userid, 'assignable')) |
| 269 self.db.user.set(userid, assignable=0) | 275 self.db.user.set(userid, assignable=0) |
| 270 self.assertEqual(self.db.user.get(userid, 'assignable'), 0) | 276 self.assertEqual(self.db.user.get(userid, 'assignable'), 0) |
| 277 self.db.user.set(userid, assignable=1) | |
| 278 self.assertEqual(self.db.user.get(userid, 'assignable'), 1) | |
| 271 | 279 |
| 272 def testBooleanUnset(self): | 280 def testBooleanUnset(self): |
| 273 nid = self.db.user.create(username='foo', assignable=1) | 281 nid = self.db.user.create(username='foo', assignable=1) |
| 274 self.db.user.set(nid, assignable=None) | 282 self.db.user.set(nid, assignable=None) |
| 275 self.assertEqual(self.db.user.get(nid, "assignable"), None) | 283 self.assertEqual(self.db.user.get(nid, "assignable"), None) |