Mercurial > p > roundup > code

annotate test/test_db.py @ 1178:18bb36e4f62f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Remove some assumptions about what idi numbers will be created.
author Gordon B. McMillan <gmcm@users.sourceforge.net>
date Fri, 20 Sep 2002 19:26:28 +0000
parents bd3b57859c37
children 08a13a84ed43
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
213
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
1 #
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
2 # Copyright (c) 2001 Bizar Software Pty Ltd (http://www.bizarsoftware.com.au/)
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
3 # This module is free software, and you may redistribute it and/or modify
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
4 # under the same terms as Python, so long as this copyright message and
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
5 # disclaimer are retained in their original form.
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
6 #
214
18134bffab37 stupid typo
Richard Jones <richard@users.sourceforge.net>
parents: 213
diff changeset
7 # IN NO EVENT SHALL BIZAR SOFTWARE PTY LTD BE LIABLE TO ANY PARTY FOR
213
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
8 # DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
9 # OUT OF THE USE OF THIS CODE, EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
10 # POSSIBILITY OF SUCH DAMAGE.
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
11 #
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
12 # BIZAR SOFTWARE PTY LTD SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING,
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
13 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
14 # FOR A PARTICULAR PURPOSE. THE CODE PROVIDED HEREUNDER IS ON AN "AS IS"
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
15 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
16 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
d45384bc6420 Added the copyright/license notice to (nearly) all files...
Richard Jones <richard@users.sourceforge.net>
parents: 158
diff changeset
17 #
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
18 # $Id: test_db.py,v 1.53 2002-09-20 19:26:28 gmcm Exp $
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
19
860
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
20 import unittest, os, shutil, time
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
21
270
a4241ddd22d7 Added the Password property type.
Richard Jones <richard@users.sourceforge.net>
parents: 243
diff changeset
22 from roundup.hyperdb import String, Password, Link, Multilink, Date, \
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
23 Interval, DatabaseError, Boolean, Number
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
24 from roundup import date, password
825
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
25 from roundup.indexer import Indexer
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
26
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
27 def setupSchema(db, create, module):
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
28 status = module.Class(db, "status", name=String())
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
29 status.setkey("name")
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
30 user = module.Class(db, "user", username=String(), password=Password(),
905
502a5ae11cc5 Very close now. The cgi and mailgw now use the new security API.
Richard Jones <richard@users.sourceforge.net>
parents: 902
diff changeset
31 assignable=Boolean(), age=Number(), roles=String())
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
32 user.setkey("username")
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
33 file = module.FileClass(db, "file", name=String(), type=String(),
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
34 comment=String(indexme="yes"), fooz=Password())
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
35 issue = module.IssueClass(db, "issue", title=String(indexme="yes"),
825
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
36 status=Link("status"), nosy=Multilink("user"), deadline=Date(),
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
37 foo=Interval(), files=Multilink("file"), assignedto=Link('user'))
891
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
38 session = module.Class(db, 'session', title=String())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
39 session.disableJournalling()
825
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
40 db.post_init()
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
41 if create:
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
42 user.create(username="admin", roles='Admin')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
43 status.create(name="unread")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
44 status.create(name="in-progress")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
45 status.create(name="testing")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
46 status.create(name="resolved")
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
47 db.commit()
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
48
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
49 class MyTestCase(unittest.TestCase):
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
50 def tearDown(self):
1126
d77b86cc541b close the databases before test cleanup
Richard Jones <richard@users.sourceforge.net>
parents: 1096
diff changeset
51 self.db.close()
d77b86cc541b close the databases before test cleanup
Richard Jones <richard@users.sourceforge.net>
parents: 1096
diff changeset
52 if hasattr(self, 'db2'):
d77b86cc541b close the databases before test cleanup
Richard Jones <richard@users.sourceforge.net>
parents: 1096
diff changeset
53 self.db2.close()
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
54 if os.path.exists('_test_dir'):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
55 shutil.rmtree('_test_dir')
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
56
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
57 class config:
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
58 DATABASE='_test_dir'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
59 MAILHOST = 'localhost'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
60 MAIL_DOMAIN = 'fill.me.in.'
1096
fa7df238e2d4 More cleaning up of configuration, and the "instance" -> "tracker" renaming.
Richard Jones <richard@users.sourceforge.net>
parents: 1090
diff changeset
61 TRACKER_NAME = 'Roundup issue tracker'
fa7df238e2d4 More cleaning up of configuration, and the "instance" -> "tracker" renaming.
Richard Jones <richard@users.sourceforge.net>
parents: 1090
diff changeset
62 TRACKER_EMAIL = 'issue_tracker@%s'%MAIL_DOMAIN
fa7df238e2d4 More cleaning up of configuration, and the "instance" -> "tracker" renaming.
Richard Jones <richard@users.sourceforge.net>
parents: 1090
diff changeset
63 TRACKER_WEB = 'http://some.useful.url/'
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
64 ADMIN_EMAIL = 'roundup-admin@%s'%MAIL_DOMAIN
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
65 FILTER_POSITION = 'bottom' # one of 'top', 'bottom', 'top and bottom'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
66 ANONYMOUS_ACCESS = 'deny' # either 'deny' or 'allow'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
67 ANONYMOUS_REGISTER = 'deny' # either 'deny' or 'allow'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
68 MESSAGES_TO_AUTHOR = 'no' # either 'yes' or 'no'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
69 EMAIL_SIGNATURE_POSITION = 'bottom'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
70
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
71 class anydbmDBTestCase(MyTestCase):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
72 def setUp(self):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
73 from roundup.backends import anydbm
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
74 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
75 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
76 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
77 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
78 self.db = anydbm.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
79 setupSchema(self.db, 1, anydbm)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
80 self.db2 = anydbm.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
81 setupSchema(self.db2, 0, anydbm)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
82
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
83 def testStringChange(self):
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
84 # test set & retrieve
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
85 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
86 self.assertEqual(self.db.issue.get('1', 'title'), 'spam')
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
87
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
88 # change and make sure we retrieve the correct value
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
89 self.db.issue.set('1', title='eggs')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
90 self.assertEqual(self.db.issue.get('1', 'title'), 'eggs')
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
91
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
92 # do some commit stuff
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
93 self.db.commit()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
94 self.assertEqual(self.db.issue.get('1', 'title'), 'eggs')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
95 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
96 self.db.commit()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
97 self.assertEqual(self.db.issue.get('2', 'title'), 'spam')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
98 self.db.issue.set('2', title='ham')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
99 self.assertEqual(self.db.issue.get('2', 'title'), 'ham')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
100 self.db.commit()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
101 self.assertEqual(self.db.issue.get('2', 'title'), 'ham')
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
102
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
103 # make sure we can unset
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
104 self.db.issue.set('1', title=None)
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
105 self.assertEqual(self.db.issue.get('1', "title"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
106
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
107 def testLinkChange(self):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
108 self.db.issue.create(title="spam", status='1')
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
109 self.assertEqual(self.db.issue.get('1', "status"), '1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
110 self.db.issue.set('1', status='2')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
111 self.assertEqual(self.db.issue.get('1', "status"), '2')
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
112 self.db.issue.set('1', status=None)
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
113 self.assertEqual(self.db.issue.get('1', "status"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
114
976
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
115 def testMultilinkChange(self):
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
116 u1 = self.db.user.create(username='foo')
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
117 u2 = self.db.user.create(username='bar')
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
118 self.db.issue.create(title="spam", nosy=[u1])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
119 self.assertEqual(self.db.issue.get('1', "nosy"), [u1])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
120 self.db.issue.set('1', nosy=[])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
121 self.assertEqual(self.db.issue.get('1', "nosy"), [])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
122 self.db.issue.set('1', nosy=[u1,u2])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
123 self.assertEqual(self.db.issue.get('1', "nosy"), [u1,u2])
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
124
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
125 def testDateChange(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
126 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
127 a = self.db.issue.get('1', "deadline")
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
128 self.db.issue.set('1', deadline=date.Date())
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
129 b = self.db.issue.get('1', "deadline")
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
130 self.db.commit()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
131 self.assertNotEqual(a, b)
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
132 self.assertNotEqual(b, date.Date('1970-1-1 00:00:00'))
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
133 self.db.issue.set('1', deadline=date.Date())
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
134 self.db.issue.set('1', deadline=None)
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
135 self.assertEqual(self.db.issue.get('1', "deadline"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
136
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
137 def testIntervalChange(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
138 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
139 a = self.db.issue.get('1', "foo")
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
140 self.db.issue.set('1', foo=date.Interval('-1d'))
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
141 self.assertNotEqual(self.db.issue.get('1', "foo"), a)
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
142 self.db.issue.set('1', foo=None)
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
143 self.assertEqual(self.db.issue.get('1', "foo"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
144
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
145 def testBooleanChange(self):
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
146 userid = self.db.user.create(username='foo', assignable=1)
1168
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
147 self.assertEqual(1, self.db.user.get(userid, 'assignable'))
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
148 self.db.user.set(userid, assignable=0)
1168
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
149 self.assertEqual(self.db.user.get(userid, 'assignable'), 0)
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
150 self.db.user.set(userid, assignable=None)
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
151 self.assertEqual(self.db.user.get('1', "assignable"), None)
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
152
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
153 def testNumberChange(self):
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
154 nid = self.db.user.create(username='foo', age=1)
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
155 self.assertEqual(1, self.db.user.get(nid, 'age'))
1168
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
156 self.db.user.set('1', age=3)
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
157 self.assertNotEqual(self.db.user.get('1', 'age'), 1)
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
158 self.db.user.set('1', age=1.0)
927
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
159 self.db.user.set('1', age=None)
51519406b73e web forms may now unset Link values (like assignedto)
Richard Jones <richard@users.sourceforge.net>
parents: 905
diff changeset
160 self.assertEqual(self.db.user.get('1', "age"), None)
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
161
1174
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
162 def testKeyValue(self):
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
163 newid = self.db.user.create(username="spam")
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
164 self.assertEqual(self.db.user.lookup('spam'), newid)
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
165 self.db.commit()
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
166 self.assertEqual(self.db.user.lookup('spam'), newid)
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
167 self.db.user.retire(newid)
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
168 self.assertRaises(KeyError, self.db.user.lookup, 'spam')
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
169
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
170 def testNewProperty(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
171 self.db.issue.create(title="spam", status='1')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
172 self.db.issue.addprop(fixer=Link("user"))
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
173 # force any post-init stuff to happen
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
174 self.db.post_init()
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
175 props = self.db.issue.getprops()
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
176 keys = props.keys()
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
177 keys.sort()
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
178 self.assertEqual(keys, ['activity', 'assignedto', 'creation',
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
179 'creator', 'deadline', 'files', 'fixer', 'foo', 'id', 'messages',
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
180 'nosy', 'status', 'superseder', 'title'])
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
181 self.assertEqual(self.db.issue.get('1', "fixer"), None)
543
22e0edf7da6e lots of date/interval related changes: more relaxed date format for input
Richard Jones <richard@users.sourceforge.net>
parents: 524
diff changeset
182
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
183 def testRetire(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
184 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
185 b = self.db.status.get('1', 'name')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
186 a = self.db.status.list()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
187 self.db.status.retire('1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
188 # make sure the list is different
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
189 self.assertNotEqual(a, self.db.status.list())
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
190 # can still access the node if necessary
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
191 self.assertEqual(self.db.status.get('1', 'name'), b)
432
f97415cccb9d Fixes so the tests use commit and not close
Richard Jones <richard@users.sourceforge.net>
parents: 431
diff changeset
192 self.db.commit()
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
193 self.assertEqual(self.db.status.get('1', 'name'), b)
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
194 self.assertNotEqual(a, self.db.status.list())
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
195
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
196 def testSerialisation(self):
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
197 self.db.issue.create(title="spam", status='1',
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
198 deadline=date.Date(), foo=date.Interval('-1d'))
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
199 self.db.commit()
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
200 assert isinstance(self.db.issue.get('1', 'deadline'), date.Date)
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
201 assert isinstance(self.db.issue.get('1', 'foo'), date.Interval)
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
202 self.db.user.create(username="fozzy",
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
203 password=password.Password('t. bear'))
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
204 self.db.commit()
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
205 assert isinstance(self.db.user.get('1', 'password'), password.Password)
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
206
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
207 def testTransactions(self):
646
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
208 # remember the number of items we started
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
209 num_issues = len(self.db.issue.list())
646
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
210 num_files = self.db.numfiles()
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
211 self.db.issue.create(title="don't commit me!", status='1')
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
212 self.assertNotEqual(num_issues, len(self.db.issue.list()))
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
213 self.db.rollback()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
214 self.assertEqual(num_issues, len(self.db.issue.list()))
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
215 self.db.issue.create(title="please commit me!", status='1')
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
216 self.assertNotEqual(num_issues, len(self.db.issue.list()))
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
217 self.db.commit()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
218 self.assertNotEqual(num_issues, len(self.db.issue.list()))
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
219 self.db.rollback()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
220 self.assertNotEqual(num_issues, len(self.db.issue.list()))
461
b579418f7ed1 Implemented file store rollback.
Richard Jones <richard@users.sourceforge.net>
parents: 441
diff changeset
221 self.db.file.create(name="test", type="text/plain", content="hi")
b579418f7ed1 Implemented file store rollback.
Richard Jones <richard@users.sourceforge.net>
parents: 441
diff changeset
222 self.db.rollback()
646
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
223 self.assertEqual(num_files, self.db.numfiles())
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
224 for i in range(10):
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
225 self.db.file.create(name="test", type="text/plain",
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
226 content="hi %d"%(i))
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
227 self.db.commit()
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
228 num_files2 = self.db.numfiles()
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
229 self.assertNotEqual(num_files, num_files2)
461
b579418f7ed1 Implemented file store rollback.
Richard Jones <richard@users.sourceforge.net>
parents: 441
diff changeset
230 self.db.file.create(name="test", type="text/plain", content="hi")
b579418f7ed1 Implemented file store rollback.
Richard Jones <richard@users.sourceforge.net>
parents: 441
diff changeset
231 self.db.rollback()
646
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
232 self.assertNotEqual(num_files, self.db.numfiles())
07abfe8f0c01 use blobfiles in back_anydbm which is used in back_bsddb.
Engelbert Gruber <grubert@users.sourceforge.net>
parents: 570
diff changeset
233 self.assertEqual(num_files2, self.db.numfiles())
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
234
891
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
235 def testDestroyNoJournalling(self):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
236 self.innerTestDestroy(klass=self.db.session)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
237
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
238 def testDestroyJournalling(self):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
239 self.innerTestDestroy(klass=self.db.issue)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
240
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
241 def innerTestDestroy(self, klass):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
242 newid = klass.create(title='Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
243 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
244 self.assertEqual(klass.get(newid, 'title'), 'Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
245 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
246 self.assertRaises(IndexError, klass.get, newid, 'title')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
247 self.assertNotEqual(len(klass.list()), n)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
248 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
249 self.assertRaises(IndexError, klass.history, newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
250
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
251 # now with a commit
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
252 newid = klass.create(title='Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
253 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
254 self.assertEqual(klass.get(newid, 'title'), 'Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
255 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
256 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
257 self.assertRaises(IndexError, klass.get, newid, 'title')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
258 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
259 self.assertRaises(IndexError, klass.get, newid, 'title')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
260 self.assertNotEqual(len(klass.list()), n)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
261 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
262 self.assertRaises(IndexError, klass.history, newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
263
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
264 # now with a rollback
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
265 newid = klass.create(title='Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
266 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
267 self.assertEqual(klass.get(newid, 'title'), 'Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
268 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
269 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
270 self.assertNotEqual(len(klass.list()), n)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
271 self.assertRaises(IndexError, klass.get, newid, 'title')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
272 self.db.rollback()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
273 self.assertEqual(klass.get(newid, 'title'), 'Mr Friendly')
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
274 self.assertEqual(len(klass.list()), n)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
275 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
276 self.assertNotEqual(klass.history(newid), [])
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
277
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
278 def testExceptions(self):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
279 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
280 ar = self.assertRaises
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
281
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
282 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
283 # class create
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
284 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
285 # string property
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
286 ar(TypeError, self.db.status.create, name=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
287 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
288 ar(KeyError, self.db.status.create, foo='foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
289 # key name clash
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
290 ar(ValueError, self.db.status.create, name='unread')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
291 # invalid link index
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
292 ar(IndexError, self.db.issue.create, title='foo', status='bar')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
293 # invalid link value
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
294 ar(ValueError, self.db.issue.create, title='foo', status=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
295 # invalid multilink type
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
296 ar(TypeError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
297 nosy='hello')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
298 # invalid multilink index type
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
299 ar(ValueError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
300 nosy=[1])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
301 # invalid multilink index
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
302 ar(IndexError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
303 nosy=['10'])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
304
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
305 #
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
306 # key property
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
307 #
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
308 # key must be a String
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
309 ar(TypeError, self.db.file.setkey, 'fooz')
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
310 # key must exist
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
311 ar(KeyError, self.db.file.setkey, 'fubar')
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
312
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
313 #
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
314 # class get
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
315 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
316 # invalid node id
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
317 ar(IndexError, self.db.issue.get, '99', 'title')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
318 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
319 ar(KeyError, self.db.status.get, '2', 'foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
320
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
321 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
322 # class set
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
323 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
324 # invalid node id
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
325 ar(IndexError, self.db.issue.set, '99', title='foo')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
326 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
327 ar(KeyError, self.db.status.set, '1', foo='foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
328 # string property
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
329 ar(TypeError, self.db.status.set, '1', name=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
330 # key name clash
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
331 ar(ValueError, self.db.status.set, '2', name='unread')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
332 # set up a valid issue for me to work on
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
333 id = self.db.issue.create(title="spam", status='1')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
334 # invalid link index
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
335 ar(IndexError, self.db.issue.set, id, title='foo', status='bar')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
336 # invalid link value
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
337 ar(ValueError, self.db.issue.set, id, title='foo', status=1)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
338 # invalid multilink type
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
339 ar(TypeError, self.db.issue.set, id, title='foo', status='1',
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
340 nosy='hello')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
341 # invalid multilink index type
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
342 ar(ValueError, self.db.issue.set, id, title='foo', status='1',
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
343 nosy=[1])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
344 # invalid multilink index
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
345 ar(IndexError, self.db.issue.set, id, title='foo', status='1',
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
346 nosy=['10'])
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
347 # invalid number value
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
348 ar(TypeError, self.db.user.create, username='foo', age='a')
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
349 # invalid boolean value
890
a568596dbea7 Unit tests and a few fixes.
Richard Jones <richard@users.sourceforge.net>
parents: 888
diff changeset
350 ar(TypeError, self.db.user.create, username='foo', assignable='true')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
351 nid = self.db.user.create(username='foo')
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
352 # invalid number value
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
353 ar(TypeError, self.db.user.set, nid, username='foo', age='a')
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
354 # invalid boolean value
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
355 ar(TypeError, self.db.user.set, nid, username='foo', assignable='true')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
356
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
357 def testJournals(self):
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
358 self.db.user.create(username="mary")
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
359 self.db.user.create(username="pete")
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
360 self.db.issue.create(title="spam", status='1')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
361 self.db.commit()
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
362
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
363 # journal entry for issue create
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
364 journal = self.db.getjournal('issue', '1')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
365 self.assertEqual(1, len(journal))
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
366 (nodeid, date_stamp, journaltag, action, params) = journal[0]
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
367 self.assertEqual(nodeid, '1')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
368 self.assertEqual(journaltag, self.db.user.lookup('admin'))
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
369 self.assertEqual(action, 'create')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
370 keys = params.keys()
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
371 keys.sort()
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
372 self.assertEqual(keys, ['assignedto', 'deadline', 'files',
902
b0d3d3535998 Bugger it. Here's the current shape of the new security implementation.
Richard Jones <richard@users.sourceforge.net>
parents: 891
diff changeset
373 'foo', 'messages', 'nosy', 'status', 'superseder', 'title'])
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
374 self.assertEqual(None,params['deadline'])
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
375 self.assertEqual(None,params['foo'])
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
376 self.assertEqual([],params['nosy'])
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
377 self.assertEqual('1',params['status'])
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
378 self.assertEqual('spam',params['title'])
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
379
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
380 # journal entry for link
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
381 journal = self.db.getjournal('user', '1')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
382 self.assertEqual(1, len(journal))
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
383 self.db.issue.set('1', assignedto='1')
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
384 self.db.commit()
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
385 journal = self.db.getjournal('user', '1')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
386 self.assertEqual(2, len(journal))
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
387 (nodeid, date_stamp, journaltag, action, params) = journal[1]
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
388 self.assertEqual('1', nodeid)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
389 self.assertEqual('1', journaltag)
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
390 self.assertEqual('link', action)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
391 self.assertEqual(('issue', '1', 'assignedto'), params)
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
392
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
393 # journal entry for unlink
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
394 self.db.issue.set('1', assignedto='2')
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
395 self.db.commit()
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
396 journal = self.db.getjournal('user', '1')
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
397 self.assertEqual(3, len(journal))
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
398 (nodeid, date_stamp, journaltag, action, params) = journal[2]
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
399 self.assertEqual('1', nodeid)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
400 self.assertEqual('1', journaltag)
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
401 self.assertEqual('unlink', action)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
402 self.assertEqual(('issue', '1', 'assignedto'), params)
555
5fd94347c6f2 Journal entries for link and multilink properties can now be switched on or off.
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 543
diff changeset
403
860
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
404 # test disabling journalling
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
405 # ... get the last entry
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
406 time.sleep(1)
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
407 entry = self.db.getjournal('issue', '1')[-1]
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
408 (x, date_stamp, x, x, x) = entry
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
409 self.db.issue.disableJournalling()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
410 self.db.issue.set('1', title='hello world')
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
411 self.db.commit()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
412 entry = self.db.getjournal('issue', '1')[-1]
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
413 (x, date_stamp2, x, x, x) = entry
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
414 # see if the change was journalled when it shouldn't have been
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
415 self.assertEqual(date_stamp, date_stamp2)
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
416 self.db.issue.enableJournalling()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
417 self.db.issue.set('1', title='hello world 2')
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
418 self.db.commit()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
419 entry = self.db.getjournal('issue', '1')[-1]
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
420 (x, date_stamp2, x, x, x) = entry
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
421 # see if the change was journalled
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
422 self.assertNotEqual(date_stamp, date_stamp2)
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
423
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
424 def testPack(self):
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
425 id = self.db.issue.create(title="spam", status='1')
566
73af3e54c309 We need to keep the last 'set' entry in the journal...
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 562
diff changeset
426 self.db.commit()
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
427 self.db.issue.set(id, status='2')
562
62febbd7ffec You can now use the roundup-admin tool to pack the database
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 555
diff changeset
428 self.db.commit()
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
429
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
430 # sleep for at least a second, then get a date to pack at
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
431 time.sleep(1)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
432 pack_before = date.Date('.')
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
433 time.sleep(1)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
434
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
435 # one more entry
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
436 self.db.issue.set(id, status='3')
566
73af3e54c309 We need to keep the last 'set' entry in the journal...
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 562
diff changeset
437 self.db.commit()
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
438
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
439 # pack
562
62febbd7ffec You can now use the roundup-admin tool to pack the database
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 555
diff changeset
440 self.db.pack(pack_before)
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
441 journal = self.db.getjournal('issue', id)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
442
974
84216d63ed9c ahhh, I understand now
Richard Jones <richard@users.sourceforge.net>
parents: 973
diff changeset
443 # we should have the create and last set entries now
84216d63ed9c ahhh, I understand now
Richard Jones <richard@users.sourceforge.net>
parents: 973
diff changeset
444 self.assertEqual(2, len(journal))
562
62febbd7ffec You can now use the roundup-admin tool to pack the database
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 555
diff changeset
445
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
446 def testIDGeneration(self):
690
509a101305da node ids are now generated from a lockable store - no more race conditions
Richard Jones <richard@users.sourceforge.net>
parents: 676
diff changeset
447 id1 = self.db.issue.create(title="spam", status='1')
509a101305da node ids are now generated from a lockable store - no more race conditions
Richard Jones <richard@users.sourceforge.net>
parents: 676
diff changeset
448 id2 = self.db2.issue.create(title="eggs", status='2')
509a101305da node ids are now generated from a lockable store - no more race conditions
Richard Jones <richard@users.sourceforge.net>
parents: 676
diff changeset
449 self.assertNotEqual(id1, id2)
509a101305da node ids are now generated from a lockable store - no more race conditions
Richard Jones <richard@users.sourceforge.net>
parents: 676
diff changeset
450
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
451 def testSearching(self):
825
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
452 self.db.file.create(content='hello', type="text/plain")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
453 self.db.file.create(content='world', type="text/frozz",
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
454 comment='blah blah')
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
455 self.db.issue.create(files=['1', '2'], title="flebble plop")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
456 self.db.issue.create(title="flebble frooz")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
457 self.db.commit()
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
458 self.assertEquals(self.db.indexer.search(['hello'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
459 {'1': {'files': ['1']}})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
460 self.assertEquals(self.db.indexer.search(['world'], self.db.issue), {})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
461 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
462 {'2': {}})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
463 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
464 {'2': {}, '1': {}})
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
465
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
466 def testReindexing(self):
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
467 self.db.issue.create(title="frooz")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
468 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
469 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue),
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
470 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
471 self.db.issue.set('1', title="dooble")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
472 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
473 self.assertEquals(self.db.indexer.search(['dooble'], self.db.issue),
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
474 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
475 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue), {})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
476
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
477 def testForcedReindexing(self):
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
478 self.db.issue.create(title="flebble frooz")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
479 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
480 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
481 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
482 self.db.indexer.quiet = 1
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
483 self.db.indexer.force_reindex()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
484 self.db.post_init()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
485 self.db.indexer.quiet = 9
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
486 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
487 {'1': {}})
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
488
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
489 def filteringSetup(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
490 for user in (
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
491 {'username': 'bleep'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
492 {'username': 'blop'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
493 {'username': 'blorp'}):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
494 self.db.user.create(**user)
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
495 iss = self.db.issue
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
496 for issue in (
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
497 {'title': 'issue one', 'status': '2'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
498 {'title': 'issue two', 'status': '1'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
499 {'title': 'issue three', 'status': '1', 'nosy': ['1','2']}):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
500 self.db.issue.create(**issue)
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
501 self.db.commit()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
502 return self.assertEqual, self.db.issue.filter
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
503
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
504 def testFilteringString(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
505 ae, filt = self.filteringSetup()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
506 ae(filt(None, {'title': 'issue one'}, ('+','id'), (None,None)), ['1'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
507 ae(filt(None, {'title': 'issue'}, ('+','id'), (None,None)),
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
508 ['1','2','3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
509
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
510 def testFilteringLink(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
511 ae, filt = self.filteringSetup()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
512 ae(filt(None, {'status': '1'}, ('+','id'), (None,None)), ['2','3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
513
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
514 def testFilteringMultilink(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
515 ae, filt = self.filteringSetup()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
516 ae(filt(None, {'nosy': '2'}, ('+','id'), (None,None)), ['3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
517
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
518 def testFilteringMany(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
519 ae, filt = self.filteringSetup()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
520 ae(filt(None, {'nosy': '2', 'status': '1'}, ('+','id'), (None,None)),
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
521 ['3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
522
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
523 class anydbmReadOnlyDBTestCase(MyTestCase):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
524 def setUp(self):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
525 from roundup.backends import anydbm
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
526 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
527 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
528 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
529 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
530 db = anydbm.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
531 setupSchema(db, 1, anydbm)
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
532 self.db = anydbm.Database(config)
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
533 setupSchema(self.db, 0, anydbm)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
534 self.db2 = anydbm.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
535 setupSchema(self.db2, 0, anydbm)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
536
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
537 def testExceptions(self):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
538 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
539 ar = self.assertRaises
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
540
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
541 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
542 ar(DatabaseError, self.db.status.create, name="foo")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
543 ar(DatabaseError, self.db.status.set, '1', name="foo")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
544 ar(DatabaseError, self.db.status.retire, '1')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
545
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
546
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
547 class bsddbDBTestCase(anydbmDBTestCase):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
548 def setUp(self):
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
549 from roundup.backends import bsddb
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
550 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
551 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
552 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
553 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
554 self.db = bsddb.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
555 setupSchema(self.db, 1, bsddb)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
556 self.db2 = bsddb.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
557 setupSchema(self.db2, 0, bsddb)
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
558
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
559 class bsddbReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
560 def setUp(self):
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
561 from roundup.backends import bsddb
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
562 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
563 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
564 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
565 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
566 db = bsddb.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
567 setupSchema(db, 1, bsddb)
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
568 self.db = bsddb.Database(config)
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
569 setupSchema(self.db, 0, bsddb)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
570 self.db2 = bsddb.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
571 setupSchema(self.db2, 0, bsddb)
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
572
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
573
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
574 class bsddb3DBTestCase(anydbmDBTestCase):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
575 def setUp(self):
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
576 from roundup.backends import bsddb3
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
577 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
578 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
579 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
580 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
581 self.db = bsddb3.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
582 setupSchema(self.db, 1, bsddb3)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
583 self.db2 = bsddb3.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
584 setupSchema(self.db2, 0, bsddb3)
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
585
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
586 class bsddb3ReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
587 def setUp(self):
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
588 from roundup.backends import bsddb3
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
589 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
590 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
591 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
592 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
593 db = bsddb3.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
594 setupSchema(db, 1, bsddb3)
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
595 self.db = bsddb3.Database(config)
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
596 setupSchema(self.db, 0, bsddb3)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
597 self.db2 = bsddb3.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
598 setupSchema(self.db2, 0, bsddb3)
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
599
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
600
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
601 class gadflyDBTestCase(anydbmDBTestCase):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
602 ''' Gadfly doesn't support multiple connections to the one local
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
603 database
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
604 '''
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
605 def setUp(self):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
606 from roundup.backends import gadfly
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
607 # remove previous test, ignore errors
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
608 if os.path.exists(config.DATABASE):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
609 shutil.rmtree(config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
610 config.GADFLY_DATABASE = ('test', config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
611 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
612 self.db = gadfly.Database(config, 'admin')
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
613 setupSchema(self.db, 1, gadfly)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
614
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
615 def testIDGeneration(self):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
616 id1 = self.db.issue.create(title="spam", status='1')
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
617 id2 = self.db.issue.create(title="eggs", status='2')
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
618 self.assertNotEqual(id1, id2)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
619
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
620 class gadflyReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
621 def setUp(self):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
622 from roundup.backends import gadfly
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
623 # remove previous test, ignore errors
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
624 if os.path.exists(config.DATABASE):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
625 shutil.rmtree(config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
626 config.GADFLY_DATABASE = ('test', config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
627 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
628 db = gadfly.Database(config, 'admin')
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
629 setupSchema(db, 1, gadfly)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
630 self.db = gadfly.Database(config)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
631 setupSchema(self.db, 0, gadfly)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
632
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
633
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
634 class sqliteDBTestCase(anydbmDBTestCase):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
635 def setUp(self):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
636 from roundup.backends import sqlite
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
637 # remove previous test, ignore errors
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
638 if os.path.exists(config.DATABASE):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
639 shutil.rmtree(config.DATABASE)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
640 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
641 self.db = sqlite.Database(config, 'admin')
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
642 setupSchema(self.db, 1, sqlite)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
643
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
644 def testIDGeneration(self):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
645 pass
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
646
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
647 class sqliteReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
648 def setUp(self):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
649 from roundup.backends import sqlite
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
650 # remove previous test, ignore errors
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
651 if os.path.exists(config.DATABASE):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
652 shutil.rmtree(config.DATABASE)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
653 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
654 db = sqlite.Database(config, 'admin')
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
655 setupSchema(db, 1, sqlite)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
656 self.db = sqlite.Database(config)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
657 setupSchema(self.db, 0, sqlite)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
658
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
659
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
660 class metakitDBTestCase(anydbmDBTestCase):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
661 def setUp(self):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
662 from roundup.backends import metakit
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
663 import weakref
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
664 metakit._instances = weakref.WeakValueDictionary()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
665 # remove previous test, ignore errors
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
666 if os.path.exists(config.DATABASE):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
667 shutil.rmtree(config.DATABASE)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
668 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
669 self.db = metakit.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
670 setupSchema(self.db, 1, metakit)
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
671
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
672 def testIDGeneration(self):
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
673 id1 = self.db.issue.create(title="spam", status='1')
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
674 id2 = self.db.issue.create(title="eggs", status='2')
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
675 self.assertNotEqual(id1, id2)
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
676
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
677 def testTransactions(self):
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
678 # remember the number of items we started
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
679 num_issues = len(self.db.issue.list())
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
680 self.db.issue.create(title="don't commit me!", status='1')
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
681 self.assertNotEqual(num_issues, len(self.db.issue.list()))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
682 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
683 self.assertEqual(num_issues, len(self.db.issue.list()))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
684 self.db.issue.create(title="please commit me!", status='1')
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
685 self.assertNotEqual(num_issues, len(self.db.issue.list()))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
686 self.db.commit()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
687 self.assertNotEqual(num_issues, len(self.db.issue.list()))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
688 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
689 self.assertNotEqual(num_issues, len(self.db.issue.list()))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
690 self.db.file.create(name="test", type="text/plain", content="hi")
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
691 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
692 for i in range(10):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
693 self.db.file.create(name="test", type="text/plain",
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
694 content="hi %d"%(i))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
695 self.db.commit()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
696 # TODO: would be good to be able to ensure the file is not on disk after
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
697 # a rollback...
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
698 self.assertNotEqual(num_files, num_files2)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
699 self.db.file.create(name="test", type="text/plain", content="hi")
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
700 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
701
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
702 class metakitReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
703 def setUp(self):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
704 from roundup.backends import metakit
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
705 import weakref
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
706 metakit._instances = weakref.WeakValueDictionary()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
707 # remove previous test, ignore errors
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
708 if os.path.exists(config.DATABASE):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
709 shutil.rmtree(config.DATABASE)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
710 os.makedirs(config.DATABASE + '/files')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
711 db = metakit.Database(config, 'admin')
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
712 setupSchema(db, 1, metakit)
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
713 self.db = metakit.Database(config)
858
2dd862af72ee all storage-specific code (ie. backend) is now implemented by the backends
Richard Jones <richard@users.sourceforge.net>
parents: 854
diff changeset
714 setupSchema(self.db, 0, metakit)
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
715
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
716 def suite():
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
717 l = [
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
718 unittest.makeSuite(anydbmDBTestCase, 'test'),
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
719 unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test')
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
720 ]
1174
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
721 # return unittest.TestSuite(l)
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
722
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
723 try:
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
724 import gadfly
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
725 l.append(unittest.makeSuite(gadflyDBTestCase, 'test'))
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
726 l.append(unittest.makeSuite(gadflyReadOnlyDBTestCase, 'test'))
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
727 except:
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
728 print 'gadfly module not found, skipping gadfly DBTestCase'
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
729
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
730 try:
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
731 import sqlite
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
732 l.append(unittest.makeSuite(sqliteDBTestCase, 'test'))
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
733 l.append(unittest.makeSuite(sqliteReadOnlyDBTestCase, 'test'))
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
734 except:
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
735 print 'sqlite module not found, skipping gadfly DBTestCase'
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
736
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
737 try:
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
738 import bsddb
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
739 l.append(unittest.makeSuite(bsddbDBTestCase, 'test'))
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
740 l.append(unittest.makeSuite(bsddbReadOnlyDBTestCase, 'test'))
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
741 except:
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
742 print 'bsddb module not found, skipping bsddb DBTestCase'
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
743
726
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
744 try:
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
745 import bsddb3
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
746 l.append(unittest.makeSuite(bsddb3DBTestCase, 'test'))
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
747 l.append(unittest.makeSuite(bsddb3ReadOnlyDBTestCase, 'test'))
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
748 except:
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
749 print 'bsddb3 module not found, skipping bsddb3 DBTestCase'
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
750
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
751 try:
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
752 import metakit
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
753 l.append(unittest.makeSuite(metakitDBTestCase, 'test'))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
754 l.append(unittest.makeSuite(metakitReadOnlyDBTestCase, 'test'))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
755 except:
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
756 print 'metakit module not found, skipping metakit DBTestCase'
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
757
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
758 return unittest.TestSuite(l)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
759
127
0791d13baea7 Added vim command to all source so that we don't get no steenkin' tabs :)
Richard Jones <richard@users.sourceforge.net>
parents: 121
diff changeset
760 # vim: set filetype=python ts=4 sw=4 et si
Roundup Issue Tracker: http://roundup-tracker.org/