Mercurial > p > roundup > code

annotate tests/test_db.py @ 66:b936635f142d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added some unit tests
author Richard Jones <richard@users.sourceforge.net>
date Tue, 24 Jul 2001 05:22:55 +0000
parents
children 5147b4c51fd5
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
66
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
1 import unittest, os, shutil
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
2
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
3 from roundup.backends import anydbm
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
4 from roundup.hyperdb import String, Link, Multilink, Date, Interval, Class
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
5
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
6 def setupSchema(db):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
7 status = Class(db, "status", name=String())
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
8 status.setkey("name")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
9 status.create(name="unread")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
10 status.create(name="in-progress")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
11 status.create(name="testing")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
12 status.create(name="resolved")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
13 Class(db, "user", username=String(), password=String())
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
14 Class(db, "issue", title=String(), status=Link("status"))
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
15
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
16 class DBTestCase(unittest.TestCase):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
17 def setUp(self):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
18 class Database(anydbm.Database):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
19 pass
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
20 # remove previous test, ignore errors
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
21 if os.path.exists('_test_dir'):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
22 shutil.rmtree('_test_dir')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
23 os.mkdir('_test_dir')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
24 self.db = Database('_test_dir', 'test')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
25 setupSchema(self.db)
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
26
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
27 def tearDown(self):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
28 self.db.close()
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
29 shutil.rmtree('_test_dir')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
30
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
31 def testChanges(self):
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
32 self.db.issue.create(title="spam", status='1')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
33 self.db.issue.create(title="eggs", status='2')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
34 self.db.issue.create(title="ham", status='4')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
35 self.db.issue.create(title="arguments", status='2')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
36 self.db.issue.create(title="abuse", status='1')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
37 self.db.issue.addprop(fixer=Link("user"))
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
38 self.db.issue.getprops()
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
39 #{"title": <hyperdb.String>, "status": <hyperdb.Link to "status">,
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
40 #"user": <hyperdb.Link to "user">}
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
41 self.db.issue.set('5', status=2)
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
42 self.db.issue.get('5', "status")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
43 self.db.status.get('2', "name")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
44 self.db.issue.get('5', "title")
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
45 self.db.issue.find(status = self.db.status.lookup("in-progress"))
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
46 self.db.issue.history('5')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
47 self.db.status.history('1')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
48 self.db.status.history('2')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
49
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
50
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
51 def suite():
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
52 return unittest.makeSuite(DBTestCase, 'test')
b936635f142d Added some unit tests
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
53
Roundup Issue Tracker: http://roundup-tracker.org/