Mercurial > p > roundup > code

comparison test/test_db.py @ 886:816b593c755f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added tests for boolean type, and fixes to anydbm backend
author Richard Jones <richard@users.sourceforge.net>
date Thu, 18 Jul 2002 11:41:10 +0000
parents e8162a199d81
children e7169d6e6e45
comparison
equal deleted inserted replaced
885:35bef54c463e 886:816b593c755f
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: test_db.py,v 1.31 2002-07-14 23:17:45 richard Exp $ 18 # $Id: test_db.py,v 1.32 2002-07-18 11:41:10 richard Exp $
19 19
20 import unittest, os, shutil, time 20 import unittest, os, shutil, time
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 23 Interval, DatabaseError, Boolean, Number
24 from roundup import date, password 24 from roundup import date, password
25 from roundup.indexer import Indexer 25 from roundup.indexer import Indexer
26 26
27 def setupSchema(db, create, module): 27 def setupSchema(db, create, module):
28 status = module.Class(db, "status", name=String()) 28 status = module.Class(db, "status", name=String())
29 status.setkey("name") 29 status.setkey("name")
30 user = module.Class(db, "user", username=String(), password=Password()) 30 user = module.Class(db, "user", username=String(), password=Password(),
31 assignable=Boolean(), age=Number())
31 file = module.FileClass(db, "file", name=String(), type=String(), 32 file = module.FileClass(db, "file", name=String(), type=String(),
32 comment=String(indexme="yes")) 33 comment=String(indexme="yes"))
33 issue = module.IssueClass(db, "issue", title=String(indexme="yes"), 34 issue = module.IssueClass(db, "issue", title=String(indexme="yes"),
34 status=Link("status"), nosy=Multilink("user"), deadline=Date(), 35 status=Link("status"), nosy=Multilink("user"), deadline=Date(),
35 foo=Interval(), files=Multilink("file")) 36 foo=Interval(), files=Multilink("file"))
70 self.db = anydbm.Database(config, 'test') 71 self.db = anydbm.Database(config, 'test')
71 setupSchema(self.db, 1, anydbm) 72 setupSchema(self.db, 1, anydbm)
72 self.db2 = anydbm.Database(config, 'test') 73 self.db2 = anydbm.Database(config, 'test')
73 setupSchema(self.db2, 0, anydbm) 74 setupSchema(self.db2, 0, anydbm)
74 75
75 def testStringChange(self): 76 def xtestStringChange(self):
76 self.db.issue.create(title="spam", status='1') 77 self.db.issue.create(title="spam", status='1')
77 self.assertEqual(self.db.issue.get('1', 'title'), 'spam') 78 self.assertEqual(self.db.issue.get('1', 'title'), 'spam')
78 self.db.issue.set('1', title='eggs') 79 self.db.issue.set('1', title='eggs')
79 self.assertEqual(self.db.issue.get('1', 'title'), 'eggs') 80 self.assertEqual(self.db.issue.get('1', 'title'), 'eggs')
80 self.db.commit() 81 self.db.commit()
85 self.db.issue.set('2', title='ham') 86 self.db.issue.set('2', title='ham')
86 self.assertEqual(self.db.issue.get('2', 'title'), 'ham') 87 self.assertEqual(self.db.issue.get('2', 'title'), 'ham')
87 self.db.commit() 88 self.db.commit()
88 self.assertEqual(self.db.issue.get('2', 'title'), 'ham') 89 self.assertEqual(self.db.issue.get('2', 'title'), 'ham')
89 90
90 def testLinkChange(self): 91 def xtestLinkChange(self):
91 self.db.issue.create(title="spam", status='1') 92 self.db.issue.create(title="spam", status='1')
92 self.assertEqual(self.db.issue.get('1', "status"), '1') 93 self.assertEqual(self.db.issue.get('1', "status"), '1')
93 self.db.issue.set('1', status='2') 94 self.db.issue.set('1', status='2')
94 self.assertEqual(self.db.issue.get('1', "status"), '2') 95 self.assertEqual(self.db.issue.get('1', "status"), '2')
95 96
96 def testDateChange(self): 97 def xtestDateChange(self):
97 self.db.issue.create(title="spam", status='1') 98 self.db.issue.create(title="spam", status='1')
98 a = self.db.issue.get('1', "deadline") 99 a = self.db.issue.get('1', "deadline")
99 self.db.issue.set('1', deadline=date.Date()) 100 self.db.issue.set('1', deadline=date.Date())
100 b = self.db.issue.get('1', "deadline") 101 b = self.db.issue.get('1', "deadline")
101 self.db.commit() 102 self.db.commit()
102 self.assertNotEqual(a, b) 103 self.assertNotEqual(a, b)
103 self.assertNotEqual(b, date.Date('1970-1-1 00:00:00')) 104 self.assertNotEqual(b, date.Date('1970-1-1 00:00:00'))
104 self.db.issue.set('1', deadline=date.Date()) 105 self.db.issue.set('1', deadline=date.Date())
105 106
106 def testIntervalChange(self): 107 def xtestIntervalChange(self):
107 self.db.issue.create(title="spam", status='1') 108 self.db.issue.create(title="spam", status='1')
108 a = self.db.issue.get('1', "foo") 109 a = self.db.issue.get('1', "foo")
109 self.db.issue.set('1', foo=date.Interval('-1d')) 110 self.db.issue.set('1', foo=date.Interval('-1d'))
110 self.assertNotEqual(self.db.issue.get('1', "foo"), a) 111 self.assertNotEqual(self.db.issue.get('1', "foo"), a)
111 112
112 def testNewProperty(self): 113 def testBooleanChange(self):
114 self.db.user.create(username='foo', assignable='1')
115 a = self.db.user.get('1', 'assignable')
116 self.db.user.set('1', assignable='false')
117 self.assertNotEqual(self.db.user.get('1', 'assignable'), a)
118 self.db.user.set('1', assignable='FaLse')
119 self.db.user.set('1', assignable='nO')
120 self.db.user.set('1', assignable='0')
121 self.db.user.set('1', assignable='tRuE')
122 self.db.user.set('1', assignable='yEs')
123 self.db.user.set('1', assignable='1')
124
125 def xtestNewProperty(self):
113 ' make sure a new property is added ok ' 126 ' make sure a new property is added ok '
114 self.db.issue.create(title="spam", status='1') 127 self.db.issue.create(title="spam", status='1')
115 self.db.issue.addprop(fixer=Link("user")) 128 self.db.issue.addprop(fixer=Link("user"))
116 props = self.db.issue.getprops() 129 props = self.db.issue.getprops()
117 keys = props.keys() 130 keys = props.keys()
119 self.assertEqual(keys, ['activity', 'creation', 'creator', 'deadline', 132 self.assertEqual(keys, ['activity', 'creation', 'creator', 'deadline',
120 'files', 'fixer', 'foo', 'id', 'messages', 'nosy', 'status', 133 'files', 'fixer', 'foo', 'id', 'messages', 'nosy', 'status',
121 'superseder', 'title']) 134 'superseder', 'title'])
122 self.assertEqual(self.db.issue.get('1', "fixer"), None) 135 self.assertEqual(self.db.issue.get('1', "fixer"), None)
123 136
124 def testRetire(self): 137 def xtestRetire(self):
125 self.db.issue.create(title="spam", status='1') 138 self.db.issue.create(title="spam", status='1')
126 b = self.db.status.get('1', 'name') 139 b = self.db.status.get('1', 'name')
127 a = self.db.status.list() 140 a = self.db.status.list()
128 self.db.status.retire('1') 141 self.db.status.retire('1')
129 # make sure the list is different 142 # make sure the list is different
132 self.assertEqual(self.db.status.get('1', 'name'), b) 145 self.assertEqual(self.db.status.get('1', 'name'), b)
133 self.db.commit() 146 self.db.commit()
134 self.assertEqual(self.db.status.get('1', 'name'), b) 147 self.assertEqual(self.db.status.get('1', 'name'), b)
135 self.assertNotEqual(a, self.db.status.list()) 148 self.assertNotEqual(a, self.db.status.list())
136 149
137 def testSerialisation(self): 150 def xtestSerialisation(self):
138 self.db.issue.create(title="spam", status='1', 151 self.db.issue.create(title="spam", status='1',
139 deadline=date.Date(), foo=date.Interval('-1d')) 152 deadline=date.Date(), foo=date.Interval('-1d'))
140 self.db.commit() 153 self.db.commit()
141 assert isinstance(self.db.issue.get('1', 'deadline'), date.Date) 154 assert isinstance(self.db.issue.get('1', 'deadline'), date.Date)
142 assert isinstance(self.db.issue.get('1', 'foo'), date.Interval) 155 assert isinstance(self.db.issue.get('1', 'foo'), date.Interval)
143 self.db.user.create(username="fozzy", 156 self.db.user.create(username="fozzy",
144 password=password.Password('t. bear')) 157 password=password.Password('t. bear'))
145 self.db.commit() 158 self.db.commit()
146 assert isinstance(self.db.user.get('1', 'password'), password.Password) 159 assert isinstance(self.db.user.get('1', 'password'), password.Password)
147 160
148 def testTransactions(self): 161 def xtestTransactions(self):
149 # remember the number of items we started 162 # remember the number of items we started
150 num_issues = len(self.db.issue.list()) 163 num_issues = len(self.db.issue.list())
151 num_files = self.db.numfiles() 164 num_files = self.db.numfiles()
152 self.db.issue.create(title="don't commit me!", status='1') 165 self.db.issue.create(title="don't commit me!", status='1')
153 self.assertNotEqual(num_issues, len(self.db.issue.list())) 166 self.assertNotEqual(num_issues, len(self.db.issue.list()))
171 self.db.file.create(name="test", type="text/plain", content="hi") 184 self.db.file.create(name="test", type="text/plain", content="hi")
172 self.db.rollback() 185 self.db.rollback()
173 self.assertNotEqual(num_files, self.db.numfiles()) 186 self.assertNotEqual(num_files, self.db.numfiles())
174 self.assertEqual(num_files2, self.db.numfiles()) 187 self.assertEqual(num_files2, self.db.numfiles())
175 188
176 def testExceptions(self): 189 def xtestExceptions(self):
177 # this tests the exceptions that should be raised 190 # this tests the exceptions that should be raised
178 ar = self.assertRaises 191 ar = self.assertRaises
179 192
180 # 193 #
181 # class create 194 # class create
241 nosy=[1]) 254 nosy=[1])
242 # invalid multilink index 255 # invalid multilink index
243 ar(IndexError, self.db.issue.set, '6', title='foo', status='1', 256 ar(IndexError, self.db.issue.set, '6', title='foo', status='1',
244 nosy=['10']) 257 nosy=['10'])
245 258
246 def testJournals(self): 259 def xtestJournals(self):
247 self.db.issue.addprop(fixer=Link("user", do_journal='yes')) 260 self.db.issue.addprop(fixer=Link("user", do_journal='yes'))
248 self.db.user.create(username="mary") 261 self.db.user.create(username="mary")
249 self.db.user.create(username="pete") 262 self.db.user.create(username="pete")
250 self.db.issue.create(title="spam", status='1') 263 self.db.issue.create(title="spam", status='1')
251 self.db.commit() 264 self.db.commit()
310 entry = self.db.getjournal('issue', '1')[-1] 323 entry = self.db.getjournal('issue', '1')[-1]
311 (x, date_stamp2, x, x, x) = entry 324 (x, date_stamp2, x, x, x) = entry
312 # see if the change was journalled 325 # see if the change was journalled
313 self.assertNotEqual(date_stamp, date_stamp2) 326 self.assertNotEqual(date_stamp, date_stamp2)
314 327
315 def testPack(self): 328 def xtestPack(self):
316 self.db.issue.create(title="spam", status='1') 329 self.db.issue.create(title="spam", status='1')
317 self.db.commit() 330 self.db.commit()
318 self.db.issue.set('1', status='2') 331 self.db.issue.set('1', status='2')
319 self.db.commit() 332 self.db.commit()
320 self.db.issue.set('1', status='3') 333 self.db.issue.set('1', status='3')
322 pack_before = date.Date(". + 1d") 335 pack_before = date.Date(". + 1d")
323 self.db.pack(pack_before) 336 self.db.pack(pack_before)
324 journal = self.db.getjournal('issue', '1') 337 journal = self.db.getjournal('issue', '1')
325 self.assertEqual(2, len(journal)) 338 self.assertEqual(2, len(journal))
326 339
327 def testIDGeneration(self): 340 def xtestIDGeneration(self):
328 id1 = self.db.issue.create(title="spam", status='1') 341 id1 = self.db.issue.create(title="spam", status='1')
329 id2 = self.db2.issue.create(title="eggs", status='2') 342 id2 = self.db2.issue.create(title="eggs", status='2')
330 self.assertNotEqual(id1, id2) 343 self.assertNotEqual(id1, id2)
331 344
332 def testSearching(self): 345 def xtestSearching(self):
333 self.db.file.create(content='hello', type="text/plain") 346 self.db.file.create(content='hello', type="text/plain")
334 self.db.file.create(content='world', type="text/frozz", 347 self.db.file.create(content='world', type="text/frozz",
335 comment='blah blah') 348 comment='blah blah')
336 self.db.issue.create(files=['1', '2'], title="flebble plop") 349 self.db.issue.create(files=['1', '2'], title="flebble plop")
337 self.db.issue.create(title="flebble frooz") 350 self.db.issue.create(title="flebble frooz")
342 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), 355 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue),
343 {'2': {}}) 356 {'2': {}})
344 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue), 357 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
345 {'2': {}, '1': {}}) 358 {'2': {}, '1': {}})
346 359
347 def testReindexing(self): 360 def xtestReindexing(self):
348 self.db.issue.create(title="frooz") 361 self.db.issue.create(title="frooz")
349 self.db.commit() 362 self.db.commit()
350 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), 363 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue),
351 {'1': {}}) 364 {'1': {}})
352 self.db.issue.set('1', title="dooble") 365 self.db.issue.set('1', title="dooble")
353 self.db.commit() 366 self.db.commit()
354 self.assertEquals(self.db.indexer.search(['dooble'], self.db.issue), 367 self.assertEquals(self.db.indexer.search(['dooble'], self.db.issue),
355 {'1': {}}) 368 {'1': {}})
356 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), {}) 369 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), {})
357 370
358 def testForcedReindexing(self): 371 def xtestForcedReindexing(self):
359 self.db.issue.create(title="flebble frooz") 372 self.db.issue.create(title="flebble frooz")
360 self.db.commit() 373 self.db.commit()
361 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue), 374 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
362 {'1': {}}) 375 {'1': {}})
363 self.db.indexer.quiet = 1 376 self.db.indexer.quiet = 1
379 self.db = anydbm.Database(config) 392 self.db = anydbm.Database(config)
380 setupSchema(self.db, 0, anydbm) 393 setupSchema(self.db, 0, anydbm)
381 self.db2 = anydbm.Database(config, 'test') 394 self.db2 = anydbm.Database(config, 'test')
382 setupSchema(self.db2, 0, anydbm) 395 setupSchema(self.db2, 0, anydbm)
383 396
384 def testExceptions(self): 397 def xtestExceptions(self):
385 ' make sure exceptions are raised on writes to a read-only db ' 398 ' make sure exceptions are raised on writes to a read-only db '
386 # this tests the exceptions that should be raised 399 # this tests the exceptions that should be raised
387 ar = self.assertRaises 400 ar = self.assertRaises
388 401
389 # this tests the exceptions that should be raised 402 # this tests the exceptions that should be raised
458 self.db = metakit.Database(config, 'test') 471 self.db = metakit.Database(config, 'test')
459 setupSchema(self.db, 1, metakit) 472 setupSchema(self.db, 1, metakit)
460 self.db2 = metakit.Database(config, 'test') 473 self.db2 = metakit.Database(config, 'test')
461 setupSchema(self.db2, 0, metakit) 474 setupSchema(self.db2, 0, metakit)
462 475
463 def testTransactions(self): 476 def xtestTransactions(self):
464 # remember the number of items we started 477 # remember the number of items we started
465 num_issues = len(self.db.issue.list()) 478 num_issues = len(self.db.issue.list())
466 self.db.issue.create(title="don't commit me!", status='1') 479 self.db.issue.create(title="don't commit me!", status='1')
467 self.assertNotEqual(num_issues, len(self.db.issue.list())) 480 self.assertNotEqual(num_issues, len(self.db.issue.list()))
468 self.db.rollback() 481 self.db.rollback()
504 def suite(): 517 def suite():
505 l = [ 518 l = [
506 unittest.makeSuite(anydbmDBTestCase, 'test'), 519 unittest.makeSuite(anydbmDBTestCase, 'test'),
507 unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test') 520 unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test')
508 ] 521 ]
509 # return unittest.TestSuite(l) 522 return unittest.TestSuite(l)
510 523
511 try: 524 try:
512 import bsddb 525 import bsddb
513 l.append(unittest.makeSuite(bsddbDBTestCase, 'test')) 526 l.append(unittest.makeSuite(bsddbDBTestCase, 'test'))
514 l.append(unittest.makeSuite(bsddbReadOnlyDBTestCase, 'test')) 527 l.append(unittest.makeSuite(bsddbReadOnlyDBTestCase, 'test'))
531 544
532 return unittest.TestSuite(l) 545 return unittest.TestSuite(l)
533 546
534 # 547 #
535 # $Log: not supported by cvs2svn $ 548 # $Log: not supported by cvs2svn $
549 # Revision 1.31 2002/07/14 23:17:45 richard
550 # minor change to make testing easier
551 #
536 # Revision 1.30 2002/07/14 06:06:34 richard 552 # Revision 1.30 2002/07/14 06:06:34 richard
537 # Did some old TODOs 553 # Did some old TODOs
538 # 554 #
539 # Revision 1.29 2002/07/14 04:03:15 richard 555 # Revision 1.29 2002/07/14 04:03:15 richard
540 # Implemented a switch to disable journalling for a Class. CGI session 556 # Implemented a switch to disable journalling for a Class. CGI session
Roundup Issue Tracker: http://roundup-tracker.org/