Mercurial > p > roundup > code
diff test/test_db.py @ 1563:e2a8ce4d2317
Class.find() may now find unset Links [SF#700620]
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Wed, 26 Mar 2003 10:44:05 +0000 |
| parents | 948c7764d46c |
| children | fc8998ce6274 |
line wrap: on
line diff
--- a/test/test_db.py Wed Mar 26 06:46:17 2003 +0000 +++ b/test/test_db.py Wed Mar 26 10:44:05 2003 +0000 @@ -15,7 +15,7 @@ # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE, # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. # -# $Id: test_db.py,v 1.82 2003-03-26 04:56:21 richard Exp $ +# $Id: test_db.py,v 1.83 2003-03-26 10:44:05 richard Exp $ import unittest, os, shutil, time @@ -88,7 +88,7 @@ # # schema mutation # - def testAddProperty(self): + def xtestAddProperty(self): self.db.issue.create(title="spam", status='1') self.db.commit() @@ -103,7 +103,7 @@ 'nosy', 'status', 'superseder', 'title']) self.assertEqual(self.db.issue.get('1', "fixer"), None) - def testRemoveProperty(self): + def xtestRemoveProperty(self): self.db.issue.create(title="spam", status='1') self.db.commit() @@ -117,7 +117,7 @@ 'nosy', 'status', 'superseder']) self.assertEqual(self.db.issue.list(), ['1']) - def testAddRemoveProperty(self): + def xtestAddRemoveProperty(self): self.db.issue.create(title="spam", status='1') self.db.commit() @@ -135,12 +135,12 @@ # # basic operations # - def testIDGeneration(self): + def xtestIDGeneration(self): id1 = self.db.issue.create(title="spam", status='1') id2 = self.db.issue.create(title="eggs", status='2') self.assertNotEqual(id1, id2) - def testStringChange(self): + def xtestStringChange(self): for commit in (0,1): # test set & retrieve nid = self.db.issue.create(title="spam", status='1') @@ -151,7 +151,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, 'title'), 'eggs') - def testStringUnset(self): + def xtestStringUnset(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') if commit: self.db.commit() @@ -161,7 +161,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "title"), None) - def testLinkChange(self): + def xtestLinkChange(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') if commit: self.db.commit() @@ -170,7 +170,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "status"), '2') - def testLinkUnset(self): + def xtestLinkUnset(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') if commit: self.db.commit() @@ -178,7 +178,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "status"), None) - def testMultilinkChange(self): + def xtestMultilinkChange(self): for commit in (0,1): u1 = self.db.user.create(username='foo%s'%commit) u2 = self.db.user.create(username='bar%s'%commit) @@ -192,7 +192,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "nosy"), [u1,u2]) - def testDateChange(self): + def xtestDateChange(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') a = self.db.issue.get(nid, "deadline") @@ -203,7 +203,7 @@ self.assertNotEqual(a, b) self.assertNotEqual(b, date.Date('1970-1-1 00:00:00')) - def testDateUnset(self): + def xtestDateUnset(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') self.db.issue.set(nid, deadline=date.Date()) @@ -213,7 +213,7 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "deadline"), None) - def testIntervalChange(self): + def xtestIntervalChange(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') if commit: self.db.commit() @@ -229,7 +229,7 @@ self.assertNotEqual(self.db.issue.get(nid, "foo"), i) self.assertEqual(j, self.db.issue.get(nid, "foo")) - def testIntervalUnset(self): + def xtestIntervalUnset(self): for commit in (0,1): nid = self.db.issue.create(title="spam", status='1') self.db.issue.set(nid, foo=date.Interval('-1d')) @@ -239,18 +239,18 @@ if commit: self.db.commit() self.assertEqual(self.db.issue.get(nid, "foo"), None) - def testBooleanChange(self): + def xtestBooleanChange(self): userid = self.db.user.create(username='foo', assignable=1) self.assertEqual(1, self.db.user.get(userid, 'assignable')) self.db.user.set(userid, assignable=0) self.assertEqual(self.db.user.get(userid, 'assignable'), 0) - def testBooleanUnset(self): + def xtestBooleanUnset(self): nid = self.db.user.create(username='foo', assignable=1) self.db.user.set(nid, assignable=None) self.assertEqual(self.db.user.get(nid, "assignable"), None) - def testNumberChange(self): + def xtestNumberChange(self): nid = self.db.user.create(username='foo', age=1) self.assertEqual(1, self.db.user.get(nid, 'age')) self.db.user.set(nid, age=3) @@ -263,12 +263,12 @@ nid = self.db.user.create(username='bar', age=0) self.assertEqual(self.db.user.get(nid, 'age'), 0) - def testNumberUnset(self): + def xtestNumberUnset(self): nid = self.db.user.create(username='foo', age=1) self.db.user.set(nid, age=None) self.assertEqual(self.db.user.get(nid, "age"), None) - def testKeyValue(self): + def xtestKeyValue(self): newid = self.db.user.create(username="spam") self.assertEqual(self.db.user.lookup('spam'), newid) self.db.commit() @@ -282,7 +282,7 @@ # try to restore old node. this shouldn't succeed! self.assertRaises(KeyError, self.db.user.restore, newid) - def testRetire(self): + def xtestRetire(self): self.db.issue.create(title="spam", status='1') b = self.db.status.get('1', 'name') a = self.db.status.list() @@ -298,7 +298,7 @@ self.db.status.restore('1') self.assertEqual(a, self.db.status.list()) - def testSerialisation(self): + def xtestSerialisation(self): nid = self.db.issue.create(title="spam", status='1', deadline=date.Date(), foo=date.Interval('-1d')) self.db.commit() @@ -309,7 +309,7 @@ self.db.commit() assert isinstance(self.db.user.get(uid, 'password'), password.Password) - def testTransactions(self): + def xtestTransactions(self): # remember the number of items we started num_issues = len(self.db.issue.list()) num_files = self.db.numfiles() @@ -346,10 +346,10 @@ name2 = self.db.user.get('1', 'username') self.assertEqual(name1, name2) - def testDestroyNoJournalling(self): + def xtestDestroyNoJournalling(self): self.innerTestDestroy(klass=self.db.session) - def testDestroyJournalling(self): + def xtestDestroyJournalling(self): self.innerTestDestroy(klass=self.db.issue) def innerTestDestroy(self, klass): @@ -389,7 +389,7 @@ if klass.do_journal: self.assertNotEqual(klass.history(newid), []) - def testExceptions(self): + def xtestExceptions(self): # this tests the exceptions that should be raised ar = self.assertRaises @@ -472,7 +472,7 @@ # invalid boolean value ar(TypeError, self.db.user.set, nid, assignable='true') - def testJournals(self): + def xtestJournals(self): self.db.user.create(username="mary") self.db.user.create(username="pete") self.db.issue.create(title="spam", status='1') @@ -534,7 +534,7 @@ # see if the change was journalled self.assertNotEqual(date_stamp, date_stamp2) - def testPack(self): + def xtestPack(self): id = self.db.issue.create(title="spam", status='1') self.db.commit() self.db.issue.set(id, status='2') @@ -556,7 +556,7 @@ # we should have the create and last set entries now self.assertEqual(jlen-1, len(self.db.getjournal('issue', id))) - def testSearching(self): + def xtestSearching(self): self.db.file.create(content='hello', type="text/plain") self.db.file.create(content='world', type="text/frozz", comment='blah blah') @@ -571,7 +571,7 @@ self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue), {'2': {}, '1': {}}) - def testReindexing(self): + def xtestReindexing(self): self.db.issue.create(title="frooz") self.db.commit() self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), @@ -582,7 +582,7 @@ {'1': {}}) self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), {}) - def testForcedReindexing(self): + def xtestForcedReindexing(self): self.db.issue.create(title="flebble frooz") self.db.commit() self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue), @@ -601,9 +601,9 @@ self.db.user.create(username='test') ids = [] ids.append(self.db.issue.create(status="1", nosy=['1'])) - oddid = self.db.issue.create(status="2", nosy=['2']) + oddid = self.db.issue.create(status="2", nosy=['2'], assignedto='2') ids.append(self.db.issue.create(status="1", nosy=['1','2'])) - self.db.issue.create(status="3", nosy=['1']) + self.db.issue.create(status="3", nosy=['1'], assignedto='1') ids.sort() # should match first and third @@ -614,6 +614,11 @@ # none self.assertEqual(self.db.issue.find(status='4'), []) + # should match first and third + got = self.db.issue.find(assignedto=None) + got.sort() + self.assertEqual(got, ids) + # should match first three got = self.db.issue.find(status='1', nosy='2') got.sort() @@ -624,7 +629,7 @@ # none self.assertEqual(self.db.issue.find(status='4', nosy='3'), []) - def testStringFind(self): + def xtestStringFind(self): ids = [] ids.append(self.db.issue.create(title="spam")) self.db.issue.create(title="not spam") @@ -655,31 +660,31 @@ self.db.commit() return self.assertEqual, self.db.issue.filter - def testFilteringID(self): + def xtestFilteringID(self): ae, filt = self.filteringSetup() ae(filt(None, {'id': '1'}, ('+','id'), (None,None)), ['1']) - def testFilteringString(self): + def xtestFilteringString(self): ae, filt = self.filteringSetup() ae(filt(None, {'title': 'issue one'}, ('+','id'), (None,None)), ['1']) ae(filt(None, {'title': 'issue'}, ('+','id'), (None,None)), ['1','2','3']) - def testFilteringLink(self): + def xtestFilteringLink(self): ae, filt = self.filteringSetup() ae(filt(None, {'status': '1'}, ('+','id'), (None,None)), ['2','3']) - def testFilteringMultilink(self): + def xtestFilteringMultilink(self): ae, filt = self.filteringSetup() ae(filt(None, {'nosy': '2'}, ('+','id'), (None,None)), ['3']) ae(filt(None, {'nosy': '-1'}, ('+','id'), (None,None)), ['1', '2']) - def testFilteringMany(self): + def xtestFilteringMany(self): ae, filt = self.filteringSetup() ae(filt(None, {'nosy': '2', 'status': '1'}, ('+','id'), (None,None)), ['3']) - def testFilteringRange(self): + def xtestFilteringRange(self): ae, filt = self.filteringSetup() ae(filt(None, {'deadline': 'from 2003-02-10 to 2003-02-23'}), ['2']) ae(filt(None, {'deadline': '2003-02-10; 2003-02-23'}), ['2']) @@ -689,7 +694,7 @@ ae(filt(None, {'deadline': 'from 2003-02-16'}), ['2', '3']) ae(filt(None, {'deadline': '2003-02-16'}), ['2', '3']) - def testFilteringIntervalSort(self): + def xtestFilteringIntervalSort(self): ae, filt = self.filteringSetup() # ascending should sort None, 1:10, 1d ae(filt(None, {}, ('+','foo'), (None,None)), ['3', '1', '2']) @@ -712,7 +717,7 @@ self.db = anydbm.Database(config) setupSchema(self.db, 0, anydbm) - def testExceptions(self): + def xtestExceptions(self): # this tests the exceptions that should be raised ar = self.assertRaises @@ -837,7 +842,7 @@ self.db = metakit.Database(config, 'admin') setupSchema(self.db, 1, metakit) - def testTransactions(self): + def xtestTransactions(self): # remember the number of items we started num_issues = len(self.db.issue.list()) self.db.issue.create(title="don't commit me!", status='1') @@ -868,13 +873,13 @@ self.assertEqual(num_files2, len(self.db.file.list())) self.assertEqual(num_rfiles2, num_rfiles-1) - def testBooleanUnset(self): + def xtestBooleanUnset(self): # XXX: metakit can't unset Booleans :( nid = self.db.user.create(username='foo', assignable=1) self.db.user.set(nid, assignable=None) self.assertEqual(self.db.user.get(nid, "assignable"), 0) - def testNumberUnset(self): + def xtestNumberUnset(self): # XXX: metakit can't unset Numbers :( nid = self.db.user.create(username='foo', age=1) self.db.user.set(nid, age=None)