Mercurial > p > roundup > code

annotate test/test_db.py @ 1446:8ce33ce262a4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix property type check, and dont create items that have no properties
author Richard Jones <richard@users.sourceforge.net>
date Tue, 18 Feb 2003 06:15:21 +0000
parents b953750bdc04
children 405e91b5be46
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 #
1434
b953750bdc04 trackers on mysql can be initialised
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1433
diff changeset
18 # $Id: test_db.py,v 1.71 2003-02-15 23:19:01 kedder 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()
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
52 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
53 shutil.rmtree('_test_dir')
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
54
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
55 class config:
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
56 DATABASE='_test_dir'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
57 MAILHOST = 'localhost'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
58 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
59 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
60 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
61 TRACKER_WEB = 'http://some.useful.url/'
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
62 ADMIN_EMAIL = 'roundup-admin@%s'%MAIL_DOMAIN
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
63 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
64 ANONYMOUS_ACCESS = 'deny' # either 'deny' or 'allow'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
65 ANONYMOUS_REGISTER = 'deny' # either 'deny' or 'allow'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
66 MESSAGES_TO_AUTHOR = 'no' # either 'yes' or 'no'
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
67 EMAIL_SIGNATURE_POSITION = 'bottom'
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
68 # Mysql connection data
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
69 MYSQL_DBHOST = 'localhost'
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
70 MYSQL_DBUSER = 'rounduptest'
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
71 MYSQL_DBPASSWORD = 'rounduptest'
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
72 MYSQL_DBNAME = 'rounduptest'
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
73 MYSQL_DATABASE = (MYSQL_DBHOST, MYSQL_DBUSER, MYSQL_DBPASSWORD, MYSQL_DBNAME)
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
74
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
75 class nodbconfig(config):
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
76 MYSQL_DATABASE = (config.MYSQL_DBHOST, config.MYSQL_DBUSER, config.MYSQL_DBPASSWORD)
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
77
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
78 class anydbmDBTestCase(MyTestCase):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
79 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
80 from roundup.backends import anydbm
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
81 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
82 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
83 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
84 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
85 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
86 setupSchema(self.db, 1, anydbm)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
87
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
88 def testIDGeneration(self):
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
89 id1 = self.db.issue.create(title="spam", status='1')
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
90 id2 = self.db.issue.create(title="eggs", status='2')
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
91 self.assertNotEqual(id1, id2)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
92
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
93 def testStringChange(self):
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
94 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
95 # test set & retrieve
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
96 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
97 self.assertEqual(self.db.issue.get(nid, 'title'), 'spam')
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
98
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
99 # change and make sure we retrieve the correct value
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
100 self.db.issue.set(nid, title='eggs')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
101 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
102 self.assertEqual(self.db.issue.get(nid, 'title'), 'eggs')
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
103
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
104 def testStringUnset(self):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
105 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
106 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
107 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
108 self.assertEqual(self.db.issue.get(nid, 'title'), 'spam')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
109 # make sure we can unset
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
110 self.db.issue.set(nid, title=None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
111 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
112 self.assertEqual(self.db.issue.get(nid, "title"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
113
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
114 def testLinkChange(self):
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
115 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
116 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
117 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
118 self.assertEqual(self.db.issue.get(nid, "status"), '1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
119 self.db.issue.set(nid, status='2')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
120 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
121 self.assertEqual(self.db.issue.get(nid, "status"), '2')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
122
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
123 def testLinkUnset(self):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
124 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
125 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
126 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
127 self.db.issue.set(nid, status=None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
128 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
129 self.assertEqual(self.db.issue.get(nid, "status"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
130
976
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
131 def testMultilinkChange(self):
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
132 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
133 u1 = self.db.user.create(username='foo%s'%commit)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
134 u2 = self.db.user.create(username='bar%s'%commit)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
135 nid = self.db.issue.create(title="spam", nosy=[u1])
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
136 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
137 self.assertEqual(self.db.issue.get(nid, "nosy"), [u1])
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
138 self.db.issue.set(nid, nosy=[])
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
139 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
140 self.assertEqual(self.db.issue.get(nid, "nosy"), [])
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
141 self.db.issue.set(nid, nosy=[u1,u2])
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
142 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
143 self.assertEqual(self.db.issue.get(nid, "nosy"), [u1,u2])
976
8c2036dace08 implemented multilink changes (and a unit test)
Richard Jones <richard@users.sourceforge.net>
parents: 974
diff changeset
144
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
145 def testDateChange(self):
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
146 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
147 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
148 a = self.db.issue.get(nid, "deadline")
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
149 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
150 self.db.issue.set(nid, deadline=date.Date())
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
151 b = self.db.issue.get(nid, "deadline")
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
152 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
153 self.assertNotEqual(a, b)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
154 self.assertNotEqual(b, date.Date('1970-1-1 00:00:00'))
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
155
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
156 def testDateUnset(self):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
157 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
158 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
159 self.db.issue.set(nid, deadline=date.Date())
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
160 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
161 self.assertNotEqual(self.db.issue.get(nid, "deadline"), None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
162 self.db.issue.set(nid, deadline=None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
163 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
164 self.assertEqual(self.db.issue.get(nid, "deadline"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
165
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
166 def testIntervalChange(self):
1264
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
167 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
168 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
169 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
170 a = self.db.issue.get(nid, "foo")
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
171 i = date.Interval('-1d')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
172 self.db.issue.set(nid, foo=i)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
173 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
174 self.assertNotEqual(self.db.issue.get(nid, "foo"), a)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
175 self.assertEqual(i, self.db.issue.get(nid, "foo"))
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
176 j = date.Interval('1y')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
177 self.db.issue.set(nid, foo=j)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
178 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
179 self.assertNotEqual(self.db.issue.get(nid, "foo"), i)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
180 self.assertEqual(j, self.db.issue.get(nid, "foo"))
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
181
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
182 def testIntervalUnset(self):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
183 for commit in (0,1):
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
184 nid = self.db.issue.create(title="spam", status='1')
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
185 self.db.issue.set(nid, foo=date.Interval('-1d'))
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
186 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
187 self.assertNotEqual(self.db.issue.get(nid, "foo"), None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
188 self.db.issue.set(nid, foo=None)
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
189 if commit: self.db.commit()
9e6743c00b5f more anal unit tests
Richard Jones <richard@users.sourceforge.net>
parents: 1261
diff changeset
190 self.assertEqual(self.db.issue.get(nid, "foo"), None)
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
191
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
192 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
193 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
194 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
195 self.db.user.set(userid, assignable=0)
1168
94620e088e3a fixes to the rdbms backends
Richard Jones <richard@users.sourceforge.net>
parents: 1165
diff changeset
196 self.assertEqual(self.db.user.get(userid, 'assignable'), 0)
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
197
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
198 def testBooleanUnset(self):
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
199 nid = self.db.user.create(username='foo', assignable=1)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
200 self.db.user.set(nid, assignable=None)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
201 self.assertEqual(self.db.user.get(nid, "assignable"), None)
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
202
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
203 def testNumberChange(self):
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
204 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
205 self.assertEqual(1, self.db.user.get(nid, 'age'))
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
206 self.db.user.set(nid, age=3)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
207 self.assertNotEqual(self.db.user.get(nid, 'age'), 1)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
208 self.db.user.set(nid, age=1.0)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
209
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
210 def testNumberUnset(self):
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
211 nid = self.db.user.create(username='foo', age=1)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
212 self.db.user.set(nid, age=None)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
213 self.assertEqual(self.db.user.get(nid, "age"), None)
886
816b593c755f added tests for boolean type, and fixes to anydbm backend
Richard Jones <richard@users.sourceforge.net>
parents: 868
diff changeset
214
1174
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
215 def testKeyValue(self):
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
216 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
217 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
218 self.db.commit()
8e318dfaf479 Verify contents of tracker module when the tracker is opened
Richard Jones <richard@users.sourceforge.net>
parents: 1170
diff changeset
219 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
220 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
221 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
222
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
223 # use the key again now that the old is retired
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
224 newid2 = self.db.user.create(username="spam")
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
225 self.assertNotEqual(newid, newid2)
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
226
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
227 def testNewProperty(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
228 self.db.issue.create(title="spam", status='1')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
229 self.db.issue.addprop(fixer=Link("user"))
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
230 # force any post-init stuff to happen
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
231 self.db.post_init()
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
232 props = self.db.issue.getprops()
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
233 keys = props.keys()
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
234 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
235 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
236 '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
237 'nosy', 'status', 'superseder', 'title'])
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
238 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
239
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
240 def testRetire(self):
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
241 self.db.issue.create(title="spam", status='1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
242 b = self.db.status.get('1', 'name')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
243 a = self.db.status.list()
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
244 self.db.status.retire('1')
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
245 # make sure the list is different
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
246 self.assertNotEqual(a, self.db.status.list())
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
247 # can still access the node if necessary
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
248 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
249 self.db.commit()
785
491049fb8e31 Cleaned up the hyperdb tests
Richard Jones <richard@users.sourceforge.net>
parents: 726
diff changeset
250 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
251 self.assertNotEqual(a, self.db.status.list())
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
252
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
253 def testSerialisation(self):
1253
fe67477e678f fixes from changes today
Richard Jones <richard@users.sourceforge.net>
parents: 1244
diff changeset
254 nid = self.db.issue.create(title="spam", status='1',
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
255 deadline=date.Date(), foo=date.Interval('-1d'))
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
256 self.db.commit()
1253
fe67477e678f fixes from changes today
Richard Jones <richard@users.sourceforge.net>
parents: 1244
diff changeset
257 assert isinstance(self.db.issue.get(nid, 'deadline'), date.Date)
fe67477e678f fixes from changes today
Richard Jones <richard@users.sourceforge.net>
parents: 1244
diff changeset
258 assert isinstance(self.db.issue.get(nid, 'foo'), date.Interval)
fe67477e678f fixes from changes today
Richard Jones <richard@users.sourceforge.net>
parents: 1244
diff changeset
259 uid = self.db.user.create(username="fozzy",
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
260 password=password.Password('t. bear'))
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
261 self.db.commit()
1253
fe67477e678f fixes from changes today
Richard Jones <richard@users.sourceforge.net>
parents: 1244
diff changeset
262 assert isinstance(self.db.user.get(uid, 'password'), password.Password)
676
bc46480e2a2b Fixed serialisation problem...
Richard Jones <richard@users.sourceforge.net>
parents: 646
diff changeset
263
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
264 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
265 # 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
266 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
267 num_files = self.db.numfiles()
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
268 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
269 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
270 self.db.rollback()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
271 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
272 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
273 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
274 self.db.commit()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
275 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
276 self.db.rollback()
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
277 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
278 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
279 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
280 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
281 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
282 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
283 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
284 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
285 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
286 self.assertNotEqual(num_files, num_files2)
461
b579418f7ed1 Implemented file store rollback.
Richard Jones <richard@users.sourceforge.net>
parents: 441
diff changeset
287 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
288 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
289 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
290 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
291
891
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
292 def testDestroyNoJournalling(self):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
293 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
294
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
295 def testDestroyJournalling(self):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
296 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
297
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
298 def innerTestDestroy(self, klass):
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
299 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
300 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
301 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
302 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
303 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
304 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
305 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
306 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
307
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
308 # now with a commit
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
309 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
310 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
311 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
312 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
313 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
314 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
315 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
316 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
317 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
318 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
319 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
320
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
321 # now with a rollback
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
322 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
323 n = len(klass.list())
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
324 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
325 self.db.commit()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
326 klass.destroy(newid)
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
327 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
328 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
329 self.db.rollback()
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
330 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
331 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
332 if klass.do_journal:
974a4b94c5e3 Implemented the destroy() method needed by the session database...
Richard Jones <richard@users.sourceforge.net>
parents: 890
diff changeset
333 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
334
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
335 def testExceptions(self):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
336 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
337 ar = self.assertRaises
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
338
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
339 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
340 # class create
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
341 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
342 # string property
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
343 ar(TypeError, self.db.status.create, name=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
344 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
345 ar(KeyError, self.db.status.create, foo='foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
346 # key name clash
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
347 ar(ValueError, self.db.status.create, name='unread')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
348 # invalid link index
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
349 ar(IndexError, self.db.issue.create, title='foo', status='bar')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
350 # invalid link value
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
351 ar(ValueError, self.db.issue.create, title='foo', status=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
352 # invalid multilink type
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
353 ar(TypeError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
354 nosy='hello')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
355 # invalid multilink index type
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
356 ar(ValueError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
357 nosy=[1])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
358 # invalid multilink index
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
359 ar(IndexError, self.db.issue.create, title='foo', status='1',
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
360 nosy=['10'])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
361
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
362 #
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
363 # key property
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
364 #
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
365 # 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
366 ar(TypeError, self.db.file.setkey, 'fooz')
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
367 # key must exist
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
368 ar(KeyError, self.db.file.setkey, 'fubar')
862
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
369
37fb48c3a136 Did some old TODOs
Richard Jones <richard@users.sourceforge.net>
parents: 860
diff changeset
370 #
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
371 # class get
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
372 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
373 # 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
374 ar(IndexError, self.db.issue.get, '99', 'title')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
375 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
376 ar(KeyError, self.db.status.get, '2', 'foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
377
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
378 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
379 # class set
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
380 #
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
381 # 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
382 ar(IndexError, self.db.issue.set, '99', title='foo')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
383 # invalid property name
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
384 ar(KeyError, self.db.status.set, '1', foo='foo')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
385 # string property
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
386 ar(TypeError, self.db.status.set, '1', name=1)
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
387 # key name clash
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
388 ar(ValueError, self.db.status.set, '2', name='unread')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
389 # 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
390 id = self.db.issue.create(title="spam", status='1')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
391 # 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
392 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
393 # 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
394 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
395 # 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
396 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
397 nosy='hello')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
398 # 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
399 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
400 nosy=[1])
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
401 # 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
402 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
403 nosy=['10'])
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
404 # NOTE: the following increment the username to avoid problems
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
405 # within metakit's backend (it creates the node, and then sets the
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
406 # info, so the create (and by a fluke the username set) go through
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
407 # before the age/assignable/etc. set, which raises the exception)
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
408 # invalid number value
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
409 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
410 # invalid boolean value
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
411 ar(TypeError, self.db.user.create, username='foo2', assignable='true')
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
412 nid = self.db.user.create(username='foo3')
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
413 # invalid number value
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
414 ar(TypeError, self.db.user.set, nid, age='a')
887
e7169d6e6e45 added tests for number type too
Richard Jones <richard@users.sourceforge.net>
parents: 886
diff changeset
415 # invalid boolean value
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
416 ar(TypeError, self.db.user.set, nid, assignable='true')
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
417
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
418 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
419 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
420 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
421 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
422 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
423
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
424 # 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
425 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
426 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
427 (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
428 self.assertEqual(nodeid, '1')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
429 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
430 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
431 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
432 keys.sort()
1305
d8de80de9fc4 oops, fixed unit tests for journal change
Richard Jones <richard@users.sourceforge.net>
parents: 1264
diff changeset
433 self.assertEqual(keys, [])
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
434
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
435 # 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
436 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
437 self.assertEqual(1, len(journal))
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
438 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
439 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
440 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
441 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
442 (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
443 self.assertEqual('1', nodeid)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
444 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
445 self.assertEqual('link', action)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
446 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
447
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
448 # journal entry for unlink
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
449 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
450 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
451 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
452 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
453 (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
454 self.assertEqual('1', nodeid)
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
455 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
456 self.assertEqual('unlink', action)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
457 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
458
860
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
459 # test disabling journalling
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
460 # ... get the last entry
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
461 time.sleep(1)
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
462 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
463 (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
464 self.db.issue.disableJournalling()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
465 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
466 self.db.commit()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
467 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
468 (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
469 # 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
470 self.assertEqual(date_stamp, date_stamp2)
1183
08a13a84ed43 Some speedups - both of the SQL backends can handle using only one cursor.
Richard Jones <richard@users.sourceforge.net>
parents: 1178
diff changeset
471 time.sleep(1)
860
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
472 self.db.issue.enableJournalling()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
473 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
474 self.db.commit()
2df32a73eb45 Implemented a switch to disable journalling for a Class.
Richard Jones <richard@users.sourceforge.net>
parents: 859
diff changeset
475 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
476 (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
477 # 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
478 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
479
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
480 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
481 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
482 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
483 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
484 self.db.commit()
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
485
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
486 # sleep for at least a second, then get a date to pack at
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
487 time.sleep(1)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
488 pack_before = date.Date('.')
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
489
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
490 # wait another second and add one more entry
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
491 time.sleep(1)
1178
18bb36e4f62f Remove some assumptions about what idi numbers will be created.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1176
diff changeset
492 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
493 self.db.commit()
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
494 jlen = len(self.db.getjournal('issue', id))
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
495
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
496 # 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
497 self.db.pack(pack_before)
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
498
974
84216d63ed9c ahhh, I understand now
Richard Jones <richard@users.sourceforge.net>
parents: 973
diff changeset
499 # we should have the create and last set entries now
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
500 self.assertEqual(jlen-1, len(self.db.getjournal('issue', id)))
562
62febbd7ffec You can now use the roundup-admin tool to pack the database
Roche Compaan <rochecompaan@users.sourceforge.net>
parents: 555
diff changeset
501
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
502 def testSearching(self):
825
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
503 self.db.file.create(content='hello', type="text/plain")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
504 self.db.file.create(content='world', type="text/frozz",
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
505 comment='blah blah')
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
506 self.db.issue.create(files=['1', '2'], title="flebble plop")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
507 self.db.issue.create(title="flebble frooz")
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
508 self.db.commit()
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
509 self.assertEquals(self.db.indexer.search(['hello'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
510 {'1': {'files': ['1']}})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
511 self.assertEquals(self.db.indexer.search(['world'], self.db.issue), {})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
512 self.assertEquals(self.db.indexer.search(['frooz'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
513 {'2': {}})
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
514 self.assertEquals(self.db.indexer.search(['flebble'], self.db.issue),
0779ea9f1f18 More indexer work:
Richard Jones <richard@users.sourceforge.net>
parents: 785
diff changeset
515 {'2': {}, '1': {}})
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
516
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
517 def testReindexing(self):
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
518 self.db.issue.create(title="frooz")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
519 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
520 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
521 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
522 self.db.issue.set('1', title="dooble")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
523 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
524 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
525 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
526 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
527
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
528 def testForcedReindexing(self):
826
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
529 self.db.issue.create(title="flebble frooz")
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
530 self.db.commit()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
531 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
532 {'1': {}})
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
533 self.db.indexer.quiet = 1
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
534 self.db.indexer.force_reindex()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
535 self.db.post_init()
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
536 self.db.indexer.quiet = 9
6d7a45c8464a Added reindex command to roundup-admin.
Richard Jones <richard@users.sourceforge.net>
parents: 825
diff changeset
537 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
538 {'1': {}})
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
539
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
540 #
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
541 # searching tests follow
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
542 #
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
543 def testFind(self):
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
544 self.db.user.create(username='test')
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
545 ids = []
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
546 ids.append(self.db.issue.create(status="1", nosy=['1']))
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
547 oddid = self.db.issue.create(status="2", nosy=['2'])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
548 ids.append(self.db.issue.create(status="1", nosy=['1','2']))
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
549 self.db.issue.create(status="3", nosy=['1'])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
550 ids.sort()
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
551
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
552 # should match first and third
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
553 got = self.db.issue.find(status='1')
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
554 got.sort()
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
555 self.assertEqual(got, ids)
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
556
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
557 # none
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
558 self.assertEqual(self.db.issue.find(status='4'), [])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
559
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
560 # should match first three
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
561 got = self.db.issue.find(status='1', nosy='2')
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
562 got.sort()
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
563 ids.append(oddid)
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
564 ids.sort()
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
565 self.assertEqual(got, ids)
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
566
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
567 # none
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
568 self.assertEqual(self.db.issue.find(status='4', nosy='3'), [])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
569
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
570 def testStringFind(self):
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
571 ids = []
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
572 ids.append(self.db.issue.create(title="spam"))
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
573 self.db.issue.create(title="not spam")
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
574 ids.append(self.db.issue.create(title="spam"))
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
575 ids.sort()
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
576 got = self.db.issue.stringFind(title='spam')
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
577 got.sort()
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
578 self.assertEqual(got, ids)
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
579 self.assertEqual(self.db.issue.stringFind(title='fubar'), [])
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
580
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
581 def filteringSetup(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
582 for user in (
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
583 {'username': 'bleep'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
584 {'username': 'blop'},
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
585 {'username': 'blorp'}):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
586 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
587 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
588 for issue in (
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
589 {'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
590 {'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
591 {'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
592 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
593 self.db.commit()
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
594 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
595
1365
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
596 def testFilteringID(self):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
597 ae, filt = self.filteringSetup()
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
598 ae(filt(None, {'id': '1'}, ('+','id'), (None,None)), ['1'])
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
599
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
600 def testFilteringString(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
601 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
602 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
603 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
604 ['1','2','3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
605
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
606 def testFilteringLink(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
607 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
608 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
609
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
610 def testFilteringMultilink(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
611 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
612 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
613
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
614 def testFilteringMany(self):
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
615 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
616 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
617 ['3'])
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
618
1361
b94cc62090be reminder comments for where we need new tests
Richard Jones <richard@users.sourceforge.net>
parents: 1333
diff changeset
619 # TODO test auditors and reactors
b94cc62090be reminder comments for where we need new tests
Richard Jones <richard@users.sourceforge.net>
parents: 1333
diff changeset
620
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
621 class anydbmReadOnlyDBTestCase(MyTestCase):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
622 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
623 from roundup.backends import anydbm
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
624 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
625 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
626 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
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 = 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
629 setupSchema(db, 1, anydbm)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
630 db.close()
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
631 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
632 setupSchema(self.db, 0, anydbm)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
633
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
634 def testExceptions(self):
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
635 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
636 ar = self.assertRaises
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
637
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
638 # this tests the exceptions that should be raised
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
639 ar(DatabaseError, self.db.status.create, name="foo")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
640 ar(DatabaseError, self.db.status.set, '1', name="foo")
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
641 ar(DatabaseError, self.db.status.retire, '1')
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
642
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
643
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
644 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
645 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
646 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
647 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
648 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
649 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
650 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
651 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
652 setupSchema(self.db, 1, 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
653
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
654 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
655 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
656 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
657 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
658 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
659 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
660 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
661 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
662 setupSchema(db, 1, bsddb)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
663 db.close()
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
664 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
665 setupSchema(self.db, 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
666
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
667
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
668 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
669 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
670 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
671 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
672 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
673 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
674 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
675 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
676 setupSchema(self.db, 1, 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
677
441
698534628072 Added transaction tests to test_db
Richard Jones <richard@users.sourceforge.net>
parents: 432
diff changeset
678 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
679 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
680 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
681 # remove previous test, ignore errors
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
682 if os.path.exists(config.DATABASE):
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
683 shutil.rmtree(config.DATABASE)
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
684 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
685 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
686 setupSchema(db, 1, bsddb3)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
687 db.close()
524
dce4c75bef5a changed all config accesses...
Richard Jones <richard@users.sourceforge.net>
parents: 461
diff changeset
688 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
689 setupSchema(self.db, 0, bsddb3)
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
690
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
691
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
692 class gadflyDBTestCase(anydbmDBTestCase):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
693 ''' Gadfly doesn't support multiple connections to the one local
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
694 database
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
695 '''
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
696 def setUp(self):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
697 from roundup.backends import gadfly
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
698 # remove previous test, ignore errors
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
699 if os.path.exists(config.DATABASE):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
700 shutil.rmtree(config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
701 config.GADFLY_DATABASE = ('test', config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
702 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
703 self.db = gadfly.Database(config, 'admin')
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
704 setupSchema(self.db, 1, gadfly)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
705
1222
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
706 def testFilteringString(self):
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
707 ae, filt = self.filteringSetup()
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
708 ae(filt(None, {'title': 'issue one'}, ('+','id'), (None,None)), ['1'])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
709 # XXX gadfly can't do substring LIKE searches
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
710 #ae(filt(None, {'title': 'issue'}, ('+','id'), (None,None)),
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
711 # ['1','2','3'])
bc3bc3248dd1 added Class.find() unit test, fixed implementations
Richard Jones <richard@users.sourceforge.net>
parents: 1198
diff changeset
712
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
713 class gadflyReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
714 def setUp(self):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
715 from roundup.backends import gadfly
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
716 # remove previous test, ignore errors
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
717 if os.path.exists(config.DATABASE):
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
718 shutil.rmtree(config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
719 config.GADFLY_DATABASE = ('test', config.DATABASE)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
720 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
721 db = gadfly.Database(config, 'admin')
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
722 setupSchema(db, 1, gadfly)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
723 db.close()
973
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
724 self.db = gadfly.Database(config)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
725 setupSchema(self.db, 0, gadfly)
e21259073500 oops, forgot
Richard Jones <richard@users.sourceforge.net>
parents: 927
diff changeset
726
1365
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
727 class mysqlDBTestCase(anydbmDBTestCase):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
728 def setUp(self):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
729 from roundup.backends import mysql
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
730 # remove previous test, ignore errors
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
731 if os.path.exists(config.DATABASE):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
732 shutil.rmtree(config.DATABASE)
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
733 os.makedirs(config.DATABASE + '/files')
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
734 # open database for testing
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
735 self.db = mysql.Database(config, 'admin')
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
736 setupSchema(self.db, 1, mysql)
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
737
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
738 def tearDown(self):
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
739 from roundup.backends import mysql
1415
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
740 self.db.close()
1434
b953750bdc04 trackers on mysql can be initialised
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1433
diff changeset
741 mysql.Database.nuke(config)
1365
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
742
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
743 class mysqlReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
744 def setUp(self):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
745 from roundup.backends import mysql
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
746 # remove previous test, ignore errors
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
747 if os.path.exists(config.DATABASE):
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
748 shutil.rmtree(config.DATABASE)
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
749 os.makedirs(config.DATABASE + '/files')
1415
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
750 self.db = mysql.Database(config)
1365
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
751 setupSchema(self.db, 0, mysql)
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
752
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
753 def tearDown(self):
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
754 from roundup.backends import mysql
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
755 self.db.close()
1434
b953750bdc04 trackers on mysql can be initialised
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1433
diff changeset
756 mysql.Database.nuke(config)
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
757
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
758 class sqliteDBTestCase(anydbmDBTestCase):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
759 def setUp(self):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
760 from roundup.backends import sqlite
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
761 # remove previous test, ignore errors
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
762 if os.path.exists(config.DATABASE):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
763 shutil.rmtree(config.DATABASE)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
764 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
765 self.db = sqlite.Database(config, 'admin')
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
766 setupSchema(self.db, 1, sqlite)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
767
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
768 class sqliteReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
769 def setUp(self):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
770 from roundup.backends import sqlite
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
771 # remove previous test, ignore errors
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
772 if os.path.exists(config.DATABASE):
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
773 shutil.rmtree(config.DATABASE)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
774 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
775 db = sqlite.Database(config, 'admin')
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
776 setupSchema(db, 1, sqlite)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
777 db.close()
1165
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
778 self.db = sqlite.Database(config)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
779 setupSchema(self.db, 0, sqlite)
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
780
14467c765167 sqlite backend!
Richard Jones <richard@users.sourceforge.net>
parents: 1156
diff changeset
781
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
782 class metakitDBTestCase(anydbmDBTestCase):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
783 def setUp(self):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
784 from roundup.backends import metakit
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
785 import weakref
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
786 metakit._instances = weakref.WeakValueDictionary()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
787 # remove previous test, ignore errors
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
788 if os.path.exists(config.DATABASE):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
789 shutil.rmtree(config.DATABASE)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
790 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
791 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
792 setupSchema(self.db, 1, metakit)
1143
Richard Jones <richard@users.sourceforge.net>
parents: 1126
diff changeset
793
888
Richard Jones <richard@users.sourceforge.net>
parents: 887
diff changeset
794 def testTransactions(self):
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
795 # 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
796 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
797 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
798 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
799 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
800 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
801 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
802 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
803 self.db.commit()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
804 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
805 self.db.rollback()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
806 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
807 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
808 self.db.rollback()
1243
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
809 num_files = len(self.db.file.list())
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
810 for i in range(10):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
811 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
812 content="hi %d"%(i))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
813 self.db.commit()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
814 # 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
815 # a rollback...
1243
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
816 num_files2 = len(self.db.file.list())
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
817 self.assertNotEqual(num_files, num_files2)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
818 self.db.file.create(name="test", type="text/plain", content="hi")
1243
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
819 num_rfiles = len(os.listdir(self.db.config.DATABASE + '/files/file/0'))
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
820 self.db.rollback()
1243
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
821 num_rfiles2 = len(os.listdir(self.db.config.DATABASE + '/files/file/0'))
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
822 self.assertEqual(num_files2, len(self.db.file.list()))
3a028d2f7830 Fix (re)indexing & find in back_metakit.
Gordon B. McMillan <gmcm@users.sourceforge.net>
parents: 1222
diff changeset
823 self.assertEqual(num_rfiles2, num_rfiles-1)
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
824
1392
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
825 def testBooleanUnset(self):
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
826 # XXX: metakit can't unset Booleans :(
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
827 nid = self.db.user.create(username='foo', assignable=1)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
828 self.db.user.set(nid, assignable=None)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
829 self.assertEqual(self.db.user.get(nid, "assignable"), 0)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
830
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
831 def testNumberUnset(self):
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
832 # XXX: metakit can't unset Numbers :(
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
833 nid = self.db.user.create(username='foo', age=1)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
834 self.db.user.set(nid, age=None)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
835 self.assertEqual(self.db.user.get(nid, "age"), 0)
083cce7840aa Metakit now passes all unit tests! w00t! (except the Number/Boolean unset)
Richard Jones <richard@users.sourceforge.net>
parents: 1378
diff changeset
836
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
837 class metakitReadOnlyDBTestCase(anydbmReadOnlyDBTestCase):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
838 def setUp(self):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
839 from roundup.backends import metakit
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
840 import weakref
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
841 metakit._instances = weakref.WeakValueDictionary()
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
842 # remove previous test, ignore errors
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
843 if os.path.exists(config.DATABASE):
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
844 shutil.rmtree(config.DATABASE)
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
845 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
846 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
847 setupSchema(db, 1, metakit)
1333
80d27b7d6db5 implemented whole-database locking
Richard Jones <richard@users.sourceforge.net>
parents: 1305
diff changeset
848 db.close()
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
849 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
850 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
851
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
852 def suite():
1415
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
853 l = []
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
854 # l = [
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
855 # unittest.makeSuite(anydbmDBTestCase, 'test'),
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
856 # unittest.makeSuite(anydbmReadOnlyDBTestCase, 'test')
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
857 # ]
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
858 # 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
859
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
860 from roundup import backends
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
861 p = []
1415
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
862 if hasattr(backends, 'mysql'):
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
863 from roundup.backends import mysql
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
864 try:
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
865 # Check if we can run mysql tests
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
866 import MySQLdb
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
867 db = mysql.Database(nodbconfig, 'admin')
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
868 db.conn.select_db(config.MYSQL_DBNAME)
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
869 db.sql("SHOW TABLES");
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
870 tables = db.sql_fetchall()
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
871 if tables:
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
872 # Database should be empty. We don't dare to delete any data
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
873 raise DatabaseError, "(Database %s contains tables)" % config.MYSQL_DBNAME
1434
b953750bdc04 trackers on mysql can be initialised
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1433
diff changeset
874 db.sql("DROP DATABASE %s" % config.MYSQL_DBNAME)
1433
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
875 db.sql("CREATE DATABASE %s" % config.MYSQL_DBNAME)
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
876 db.close()
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
877 except (MySQLdb.ProgrammingError, DatabaseError), msg:
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
878 print "Warning! Mysql tests will not be performed", msg
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
879 print "See doc/mysql.txt for more details."
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
880 else:
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
881 p.append('mysql')
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
882 l.append(unittest.makeSuite(mysqlDBTestCase, 'test'))
8429095241d7 mysql tests will not be run if there is no chance of passing.
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1415
diff changeset
883 l.append(unittest.makeSuite(mysqlReadOnlyDBTestCase, 'test'))
1415
6883852e9b15 mysql backend passes all tests (at last!)
Andrey Lebedev <kedder@users.sourceforge.net>
parents: 1392
diff changeset
884 #return unittest.TestSuite(l)
1365
4884fb0860f9 fixed rdbms searching by ID [SF#666615]
Richard Jones <richard@users.sourceforge.net>
parents: 1361
diff changeset
885
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
886 if hasattr(backends, 'gadfly'):
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
887 p.append('gadfly')
1176
bd3b57859c37 On second thought, that last checkin was dumb.
Richard Jones <richard@users.sourceforge.net>
parents: 1174
diff changeset
888 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
889 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
890
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
891 if hasattr(backends, 'sqlite'):
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
892 p.append('sqlite')
1170
af104fa52746 Added some words to the installation doc about choosing backends.
Richard Jones <richard@users.sourceforge.net>
parents: 1168
diff changeset
893 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
894 l.append(unittest.makeSuite(sqliteReadOnlyDBTestCase, 'test'))
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
895
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
896 if hasattr(backends, 'bsddb'):
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
897 p.append('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
898 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
899 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
900
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
901 if hasattr(backends, 'bsddb3'):
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
902 p.append('bsddb3')
726
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
903 l.append(unittest.makeSuite(bsddb3DBTestCase, 'test'))
e3d742c75ac3 Well whadya know, bsddb3 works again.
Richard Jones <richard@users.sourceforge.net>
parents: 690
diff changeset
904 l.append(unittest.makeSuite(bsddb3ReadOnlyDBTestCase, 'test'))
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
905
1198
1c5bc0e2ed7d *** empty log message ***
Richard Jones <richard@users.sourceforge.net>
parents: 1183
diff changeset
906 if hasattr(backends, 'metakit'):
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
907 p.append('metakit')
854
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
908 l.append(unittest.makeSuite(metakitDBTestCase, 'test'))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
909 l.append(unittest.makeSuite(metakitReadOnlyDBTestCase, 'test'))
3cdfa5d86cec Added metakit backend to the db tests...
Richard Jones <richard@users.sourceforge.net>
parents: 826
diff changeset
910
1378
5d1fe5d51c12 note on how to fix mysql tests - also indicate which tests are being run
Richard Jones <richard@users.sourceforge.net>
parents: 1375
diff changeset
911 print 'running %s backend tests'%(', '.join(p))
158
86ebcf734a8e Added more DB to test_db. Can skip tests where imports fail.
Richard Jones <richard@users.sourceforge.net>
parents: 127
diff changeset
912 return unittest.TestSuite(l)
92
fa44da8d9df2 moving tests -> test
Richard Jones <richard@users.sourceforge.net>
parents:
diff changeset
913
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
914 # vim: set filetype=python ts=4 sw=4 et si
Roundup Issue Tracker: http://roundup-tracker.org/