|
1 # -*- coding: utf-8 -*- |
|
2 """functional tests for core hooks |
|
3 |
|
4 note: most schemahooks.py hooks are actually tested in unittest_migrations.py |
|
5 :license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses |
|
6 """ |
|
7 |
|
8 from logilab.common.testlib import TestCase, unittest_main |
|
9 |
|
10 from datetime import datetime |
|
11 |
|
12 from cubicweb import (ConnectionError, ValidationError, AuthenticationError, |
|
13 BadConnectionId) |
|
14 from cubicweb.devtools.testlib import CubicWebTC, get_versions |
|
15 |
|
16 from cubicweb.server.sqlutils import SQL_PREFIX |
|
17 from cubicweb.server.repository import Repository |
|
18 |
|
19 orig_get_versions = Repository.get_versions |
|
20 |
|
21 def setup_module(*args): |
|
22 Repository.get_versions = get_versions |
|
23 |
|
24 def teardown_module(*args): |
|
25 Repository.get_versions = orig_get_versions |
|
26 |
|
27 |
|
28 |
|
29 class CoreHooksTC(CubicWebTC): |
|
30 |
|
31 def test_delete_internal_entities(self): |
|
32 self.assertRaises(ValidationError, self.execute, |
|
33 'DELETE CWEType X WHERE X name "CWEType"') |
|
34 self.assertRaises(ValidationError, self.execute, |
|
35 'DELETE CWRType X WHERE X name "relation_type"') |
|
36 self.assertRaises(ValidationError, self.execute, |
|
37 'DELETE CWGroup X WHERE X name "owners"') |
|
38 |
|
39 def test_delete_required_relations_subject(self): |
|
40 self.execute('INSERT CWUser X: X login "toto", X upassword "hop", X in_group Y ' |
|
41 'WHERE Y name "users"') |
|
42 self.commit() |
|
43 self.execute('DELETE X in_group Y WHERE X login "toto", Y name "users"') |
|
44 self.assertRaises(ValidationError, self.commit) |
|
45 self.execute('DELETE X in_group Y WHERE X login "toto"') |
|
46 self.execute('SET X in_group Y WHERE X login "toto", Y name "guests"') |
|
47 self.commit() |
|
48 |
|
49 def test_delete_required_relations_object(self): |
|
50 self.skip('no sample in the schema ! YAGNI ? Kermaat ?') |
|
51 |
|
52 def test_static_vocabulary_check(self): |
|
53 self.assertRaises(ValidationError, |
|
54 self.execute, |
|
55 'SET X composite "whatever" WHERE X from_entity FE, FE name "CWUser", X relation_type RT, RT name "in_group"') |
|
56 |
|
57 def test_missing_required_relations_subject_inline(self): |
|
58 # missing in_group relation |
|
59 self.execute('INSERT CWUser X: X login "toto", X upassword "hop"') |
|
60 self.assertRaises(ValidationError, |
|
61 self.commit) |
|
62 |
|
63 def test_inlined(self): |
|
64 self.assertEquals(self.repo.schema['sender'].inlined, True) |
|
65 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') |
|
66 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"') |
|
67 eeid = self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P ' |
|
68 'WHERE Y is EmailAddress, P is EmailPart')[0][0] |
|
69 self.execute('SET X sender Y WHERE X is Email, Y is EmailAddress') |
|
70 rset = self.execute('Any S WHERE X sender S, X eid %s' % eeid) |
|
71 self.assertEquals(len(rset), 1) |
|
72 |
|
73 def test_composite_1(self): |
|
74 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') |
|
75 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"') |
|
76 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P ' |
|
77 'WHERE Y is EmailAddress, P is EmailPart') |
|
78 self.failUnless(self.execute('Email X WHERE X sender Y')) |
|
79 self.commit() |
|
80 self.execute('DELETE Email X') |
|
81 rset = self.execute('Any X WHERE X is EmailPart') |
|
82 self.assertEquals(len(rset), 1) |
|
83 self.commit() |
|
84 rset = self.execute('Any X WHERE X is EmailPart') |
|
85 self.assertEquals(len(rset), 0) |
|
86 |
|
87 def test_composite_2(self): |
|
88 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') |
|
89 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"') |
|
90 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P ' |
|
91 'WHERE Y is EmailAddress, P is EmailPart') |
|
92 self.commit() |
|
93 self.execute('DELETE Email X') |
|
94 self.execute('DELETE EmailPart X') |
|
95 self.commit() |
|
96 rset = self.execute('Any X WHERE X is EmailPart') |
|
97 self.assertEquals(len(rset), 0) |
|
98 |
|
99 def test_composite_redirection(self): |
|
100 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') |
|
101 self.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, X content "this is a test"') |
|
102 self.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, X recipients Y, X parts P ' |
|
103 'WHERE Y is EmailAddress, P is EmailPart') |
|
104 self.execute('INSERT Email X: X messageid "<2345>", X subject "test2", X sender Y, X recipients Y ' |
|
105 'WHERE Y is EmailAddress') |
|
106 self.commit() |
|
107 self.execute('DELETE X parts Y WHERE X messageid "<1234>"') |
|
108 self.execute('SET X parts Y WHERE X messageid "<2345>"') |
|
109 self.commit() |
|
110 rset = self.execute('Any X WHERE X is EmailPart') |
|
111 self.assertEquals(len(rset), 1) |
|
112 self.assertEquals(rset.get_entity(0, 0).reverse_parts[0].messageid, '<2345>') |
|
113 |
|
114 def test_unsatisfied_constraints(self): |
|
115 self.execute('INSERT CWRelation X: X from_entity FE, X relation_type RT, X to_entity TE ' |
|
116 'WHERE FE name "CWUser", RT name "in_group", TE name "String"') |
|
117 ex = self.assertRaises(ValidationError, |
|
118 self.commit) |
|
119 self.assertEquals(str(ex), '612 (to_entity): constraint O final FALSE failed') |
|
120 |
|
121 def test_html_tidy_hook(self): |
|
122 entity = self.add_entity('Workflow', name=u'wf1', description_format=u'text/html', |
|
123 description=u'yo') |
|
124 self.assertEquals(entity.description, u'yo') |
|
125 entity = self.add_entity('Workflow', name=u'wf2', description_format=u'text/html', |
|
126 description=u'<b>yo') |
|
127 self.assertEquals(entity.description, u'<b>yo</b>') |
|
128 entity = self.add_entity('Workflow', name=u'wf3', description_format=u'text/html', |
|
129 description=u'<b>yo</b>') |
|
130 self.assertEquals(entity.description, u'<b>yo</b>') |
|
131 entity = self.add_entity('Workflow', name=u'wf4', description_format=u'text/html', |
|
132 description=u'<b>R&D</b>') |
|
133 self.assertEquals(entity.description, u'<b>R&D</b>') |
|
134 entity = self.add_entity('Workflow', name=u'wf5', description_format=u'text/html', |
|
135 description=u"<div>c'est <b>l'été") |
|
136 self.assertEquals(entity.description, u"<div>c'est <b>l'été</b></div>") |
|
137 |
|
138 def test_nonregr_html_tidy_hook_no_update(self): |
|
139 entity = self.add_entity('Workflow', name=u'wf1', description_format=u'text/html', |
|
140 description=u'yo') |
|
141 entity.set_attributes(name=u'wf2') |
|
142 self.assertEquals(entity.description, u'yo') |
|
143 entity.set_attributes(description=u'R&D<p>yo') |
|
144 entity.pop('description') |
|
145 self.assertEquals(entity.description, u'R&D<p>yo</p>') |
|
146 |
|
147 |
|
148 def test_metadata_cwuri(self): |
|
149 entity = self.add_entity('Workflow', name=u'wf1') |
|
150 self.assertEquals(entity.cwuri, self.repo.config['base-url'] + 'eid/%s' % entity.eid) |
|
151 |
|
152 def test_metadata_creation_modification_date(self): |
|
153 _now = datetime.now() |
|
154 entity = self.add_entity('Workflow', name=u'wf1') |
|
155 self.assertEquals((entity.creation_date - _now).seconds, 0) |
|
156 self.assertEquals((entity.modification_date - _now).seconds, 0) |
|
157 |
|
158 def test_metadata_created_by(self): |
|
159 entity = self.add_entity('Bookmark', title=u'wf1', path=u'/view') |
|
160 self.commit() # fire operations |
|
161 self.assertEquals(len(entity.created_by), 1) # make sure we have only one creator |
|
162 self.assertEquals(entity.created_by[0].eid, self.session.user.eid) |
|
163 |
|
164 def test_metadata_owned_by(self): |
|
165 entity = self.add_entity('Bookmark', title=u'wf1', path=u'/view') |
|
166 self.commit() # fire operations |
|
167 self.assertEquals(len(entity.owned_by), 1) # make sure we have only one owner |
|
168 self.assertEquals(entity.owned_by[0].eid, self.session.user.eid) |
|
169 |
|
170 |
|
171 |
|
172 class UserGroupHooksTC(CubicWebTC): |
|
173 |
|
174 def test_user_synchronization(self): |
|
175 self.create_user('toto', password='hop', commit=False) |
|
176 self.assertRaises(AuthenticationError, |
|
177 self.repo.connect, u'toto', 'hop') |
|
178 self.commit() |
|
179 cnxid = self.repo.connect(u'toto', 'hop') |
|
180 self.failIfEqual(cnxid, self.session.id) |
|
181 self.execute('DELETE CWUser X WHERE X login "toto"') |
|
182 self.repo.execute(cnxid, 'State X') |
|
183 self.commit() |
|
184 self.assertRaises(BadConnectionId, |
|
185 self.repo.execute, cnxid, 'State X') |
|
186 |
|
187 def test_user_group_synchronization(self): |
|
188 user = self.session.user |
|
189 self.assertEquals(user.groups, set(('managers',))) |
|
190 self.execute('SET X in_group G WHERE X eid %s, G name "guests"' % user.eid) |
|
191 self.assertEquals(user.groups, set(('managers',))) |
|
192 self.commit() |
|
193 self.assertEquals(user.groups, set(('managers', 'guests'))) |
|
194 self.execute('DELETE X in_group G WHERE X eid %s, G name "guests"' % user.eid) |
|
195 self.assertEquals(user.groups, set(('managers', 'guests'))) |
|
196 self.commit() |
|
197 self.assertEquals(user.groups, set(('managers',))) |
|
198 |
|
199 def test_user_composite_owner(self): |
|
200 ueid = self.create_user('toto').eid |
|
201 # composite of euser should be owned by the euser regardless of who created it |
|
202 self.execute('INSERT EmailAddress X: X address "toto@logilab.fr", U use_email X ' |
|
203 'WHERE U login "toto"') |
|
204 self.commit() |
|
205 self.assertEquals(self.execute('Any A WHERE X owned_by U, U use_email X,' |
|
206 'U login "toto", X address A')[0][0], |
|
207 'toto@logilab.fr') |
|
208 |
|
209 def test_no_created_by_on_deleted_entity(self): |
|
210 eid = self.execute('INSERT EmailAddress X: X address "toto@logilab.fr"')[0][0] |
|
211 self.execute('DELETE EmailAddress X WHERE X eid %s' % eid) |
|
212 self.commit() |
|
213 self.failIf(self.execute('Any X WHERE X created_by Y, X eid >= %(x)s', {'x': eid})) |
|
214 |
|
215 |
|
216 class CWPropertyHooksTC(CubicWebTC): |
|
217 |
|
218 def test_unexistant_eproperty(self): |
|
219 ex = self.assertRaises(ValidationError, |
|
220 self.execute, 'INSERT CWProperty X: X pkey "bla.bla", X value "hop", X for_user U') |
|
221 self.assertEquals(ex.errors, {'pkey': 'unknown property key'}) |
|
222 ex = self.assertRaises(ValidationError, |
|
223 self.execute, 'INSERT CWProperty X: X pkey "bla.bla", X value "hop"') |
|
224 self.assertEquals(ex.errors, {'pkey': 'unknown property key'}) |
|
225 |
|
226 def test_site_wide_eproperty(self): |
|
227 ex = self.assertRaises(ValidationError, |
|
228 self.execute, 'INSERT CWProperty X: X pkey "ui.site-title", X value "hop", X for_user U') |
|
229 self.assertEquals(ex.errors, {'for_user': "site-wide property can't be set for user"}) |
|
230 |
|
231 def test_bad_type_eproperty(self): |
|
232 ex = self.assertRaises(ValidationError, |
|
233 self.execute, 'INSERT CWProperty X: X pkey "ui.language", X value "hop", X for_user U') |
|
234 self.assertEquals(ex.errors, {'value': u'unauthorized value'}) |
|
235 ex = self.assertRaises(ValidationError, |
|
236 self.execute, 'INSERT CWProperty X: X pkey "ui.language", X value "hop"') |
|
237 self.assertEquals(ex.errors, {'value': u'unauthorized value'}) |
|
238 |
|
239 |
|
240 class SchemaHooksTC(CubicWebTC): |
|
241 |
|
242 def test_duplicate_etype_error(self): |
|
243 # check we can't add a CWEType or CWRType entity if it already exists one |
|
244 # with the same name |
|
245 self.assertRaises(ValidationError, |
|
246 self.execute, 'INSERT CWEType X: X name "CWUser"') |
|
247 self.assertRaises(ValidationError, |
|
248 self.execute, 'INSERT CWRType X: X name "in_group"') |
|
249 |
|
250 def test_validation_unique_constraint(self): |
|
251 self.assertRaises(ValidationError, |
|
252 self.execute, 'INSERT CWUser X: X login "admin"') |
|
253 try: |
|
254 self.execute('INSERT CWUser X: X login "admin"') |
|
255 except ValidationError, ex: |
|
256 self.assertIsInstance(ex.entity, int) |
|
257 self.assertEquals(ex.errors, {'login': 'the value "admin" is already used, use another one'}) |
|
258 |
|
259 |
|
260 class SchemaModificationHooksTC(CubicWebTC): |
|
261 |
|
262 @classmethod |
|
263 def init_config(cls, config): |
|
264 super(SchemaModificationHooksTC, cls).init_config(config) |
|
265 config._cubes = None |
|
266 cls.repo.fill_schema() |
|
267 |
|
268 def index_exists(self, etype, attr, unique=False): |
|
269 self.session.set_pool() |
|
270 dbhelper = self.session.pool.source('system').dbhelper |
|
271 sqlcursor = self.session.pool['system'] |
|
272 return dbhelper.index_exists(sqlcursor, SQL_PREFIX + etype, SQL_PREFIX + attr, unique=unique) |
|
273 |
|
274 def test_base(self): |
|
275 schema = self.repo.schema |
|
276 self.session.set_pool() |
|
277 dbhelper = self.session.pool.source('system').dbhelper |
|
278 sqlcursor = self.session.pool['system'] |
|
279 self.failIf(schema.has_entity('Societe2')) |
|
280 self.failIf(schema.has_entity('concerne2')) |
|
281 # schema should be update on insertion (after commit) |
|
282 self.execute('INSERT CWEType X: X name "Societe2", X description "", X final FALSE') |
|
283 self.execute('INSERT CWRType X: X name "concerne2", X description "", X final FALSE, X symetric FALSE') |
|
284 self.failIf(schema.has_entity('Societe2')) |
|
285 self.failIf(schema.has_entity('concerne2')) |
|
286 self.execute('SET X read_permission G WHERE X is CWEType, X name "Societe2", G is CWGroup') |
|
287 self.execute('SET X read_permission G WHERE X is CWRType, X name "concerne2", G is CWGroup') |
|
288 self.execute('SET X add_permission G WHERE X is CWEType, X name "Societe2", G is CWGroup, G name "managers"') |
|
289 self.execute('SET X add_permission G WHERE X is CWRType, X name "concerne2", G is CWGroup, G name "managers"') |
|
290 self.execute('SET X delete_permission G WHERE X is CWEType, X name "Societe2", G is CWGroup, G name "owners"') |
|
291 self.execute('SET X delete_permission G WHERE X is CWRType, X name "concerne2", G is CWGroup, G name "owners"') |
|
292 # have to commit before adding definition relations |
|
293 self.commit() |
|
294 self.failUnless(schema.has_entity('Societe2')) |
|
295 self.failUnless(schema.has_relation('concerne2')) |
|
296 self.execute('INSERT CWAttribute X: X cardinality "11", X defaultval "noname", X indexed TRUE, X relation_type RT, X from_entity E, X to_entity F ' |
|
297 'WHERE RT name "name", E name "Societe2", F name "String"') |
|
298 concerne2_rdef_eid = self.execute( |
|
299 'INSERT CWRelation X: X cardinality "**", X relation_type RT, X from_entity E, X to_entity E ' |
|
300 'WHERE RT name "concerne2", E name "Societe2"')[0][0] |
|
301 self.failIf('name' in schema['Societe2'].subject_relations()) |
|
302 self.failIf('concerne2' in schema['Societe2'].subject_relations()) |
|
303 self.failIf(self.index_exists('Societe2', 'name')) |
|
304 self.commit() |
|
305 self.failUnless('name' in schema['Societe2'].subject_relations()) |
|
306 self.failUnless('concerne2' in schema['Societe2'].subject_relations()) |
|
307 self.failUnless(self.index_exists('Societe2', 'name')) |
|
308 # now we should be able to insert and query Societe2 |
|
309 s2eid = self.execute('INSERT Societe2 X: X name "logilab"')[0][0] |
|
310 self.execute('Societe2 X WHERE X name "logilab"') |
|
311 self.execute('SET X concerne2 X WHERE X name "logilab"') |
|
312 rset = self.execute('Any X WHERE X concerne2 Y') |
|
313 self.assertEquals(rset.rows, [[s2eid]]) |
|
314 # check that when a relation definition is deleted, existing relations are deleted |
|
315 self.execute('INSERT CWRelation X: X cardinality "**", X relation_type RT, X from_entity E, X to_entity E ' |
|
316 'WHERE RT name "concerne2", E name "CWUser"') |
|
317 self.commit() |
|
318 self.execute('DELETE CWRelation X WHERE X eid %(x)s', {'x': concerne2_rdef_eid}, 'x') |
|
319 self.commit() |
|
320 self.failUnless('concerne2' in schema['CWUser'].subject_relations()) |
|
321 self.failIf('concerne2' in schema['Societe2'].subject_relations()) |
|
322 self.failIf(self.execute('Any X WHERE X concerne2 Y')) |
|
323 # schema should be cleaned on delete (after commit) |
|
324 self.execute('DELETE CWEType X WHERE X name "Societe2"') |
|
325 self.execute('DELETE CWRType X WHERE X name "concerne2"') |
|
326 self.failUnless(self.index_exists('Societe2', 'name')) |
|
327 self.failUnless(schema.has_entity('Societe2')) |
|
328 self.failUnless(schema.has_relation('concerne2')) |
|
329 self.commit() |
|
330 self.failIf(self.index_exists('Societe2', 'name')) |
|
331 self.failIf(schema.has_entity('Societe2')) |
|
332 self.failIf(schema.has_entity('concerne2')) |
|
333 self.failIf('concerne2' in schema['CWUser'].subject_relations()) |
|
334 |
|
335 def test_is_instance_of_insertions(self): |
|
336 seid = self.execute('INSERT Transition T: T name "subdiv"')[0][0] |
|
337 is_etypes = [etype for etype, in self.execute('Any ETN WHERE X eid %s, X is ET, ET name ETN' % seid)] |
|
338 self.assertEquals(is_etypes, ['Transition']) |
|
339 instanceof_etypes = [etype for etype, in self.execute('Any ETN WHERE X eid %s, X is_instance_of ET, ET name ETN' % seid)] |
|
340 self.assertEquals(sorted(instanceof_etypes), ['BaseTransition', 'Transition']) |
|
341 snames = [name for name, in self.execute('Any N WHERE S is BaseTransition, S name N')] |
|
342 self.failIf('subdiv' in snames) |
|
343 snames = [name for name, in self.execute('Any N WHERE S is_instance_of BaseTransition, S name N')] |
|
344 self.failUnless('subdiv' in snames) |
|
345 |
|
346 |
|
347 def test_perms_synchronization_1(self): |
|
348 schema = self.repo.schema |
|
349 self.assertEquals(schema['CWUser'].get_groups('read'), set(('managers', 'users'))) |
|
350 self.failUnless(self.execute('Any X, Y WHERE X is CWEType, X name "CWUser", Y is CWGroup, Y name "users"')[0]) |
|
351 self.execute('DELETE X read_permission Y WHERE X is CWEType, X name "CWUser", Y name "users"') |
|
352 self.assertEquals(schema['CWUser'].get_groups('read'), set(('managers', 'users', ))) |
|
353 self.commit() |
|
354 self.assertEquals(schema['CWUser'].get_groups('read'), set(('managers', ))) |
|
355 self.execute('SET X read_permission Y WHERE X is CWEType, X name "CWUser", Y name "users"') |
|
356 self.commit() |
|
357 self.assertEquals(schema['CWUser'].get_groups('read'), set(('managers', 'users',))) |
|
358 |
|
359 def test_perms_synchronization_2(self): |
|
360 schema = self.repo.schema['in_group'] |
|
361 self.assertEquals(schema.get_groups('read'), set(('managers', 'users', 'guests'))) |
|
362 self.execute('DELETE X read_permission Y WHERE X is CWRType, X name "in_group", Y name "guests"') |
|
363 self.assertEquals(schema.get_groups('read'), set(('managers', 'users', 'guests'))) |
|
364 self.commit() |
|
365 self.assertEquals(schema.get_groups('read'), set(('managers', 'users'))) |
|
366 self.execute('SET X read_permission Y WHERE X is CWRType, X name "in_group", Y name "guests"') |
|
367 self.assertEquals(schema.get_groups('read'), set(('managers', 'users'))) |
|
368 self.commit() |
|
369 self.assertEquals(schema.get_groups('read'), set(('managers', 'users', 'guests'))) |
|
370 |
|
371 def test_nonregr_user_edit_itself(self): |
|
372 ueid = self.session.user.eid |
|
373 groupeids = [eid for eid, in self.execute('CWGroup G WHERE G name in ("managers", "users")')] |
|
374 self.execute('DELETE X in_group Y WHERE X eid %s' % ueid) |
|
375 self.execute('SET X surname "toto" WHERE X eid %s' % ueid) |
|
376 self.execute('SET X in_group Y WHERE X eid %s, Y name "managers"' % ueid) |
|
377 self.commit() |
|
378 eeid = self.execute('Any X WHERE X is CWEType, X name "CWEType"')[0][0] |
|
379 self.execute('DELETE X read_permission Y WHERE X eid %s' % eeid) |
|
380 self.execute('SET X final FALSE WHERE X eid %s' % eeid) |
|
381 self.execute('SET X read_permission Y WHERE X eid %s, Y eid in (%s, %s)' |
|
382 % (eeid, groupeids[0], groupeids[1])) |
|
383 self.commit() |
|
384 self.execute('Any X WHERE X is CWEType, X name "CWEType"') |
|
385 |
|
386 # schema modification hooks tests ######################################### |
|
387 |
|
388 def test_uninline_relation(self): |
|
389 self.session.set_pool() |
|
390 dbhelper = self.session.pool.source('system').dbhelper |
|
391 sqlcursor = self.session.pool['system'] |
|
392 self.failUnless(self.schema['state_of'].inlined) |
|
393 try: |
|
394 self.execute('SET X inlined FALSE WHERE X name "state_of"') |
|
395 self.failUnless(self.schema['state_of'].inlined) |
|
396 self.commit() |
|
397 self.failIf(self.schema['state_of'].inlined) |
|
398 self.failIf(self.index_exists('State', 'state_of')) |
|
399 rset = self.execute('Any X, Y WHERE X state_of Y') |
|
400 self.assertEquals(len(rset), 2) # user states |
|
401 finally: |
|
402 self.execute('SET X inlined TRUE WHERE X name "state_of"') |
|
403 self.failIf(self.schema['state_of'].inlined) |
|
404 self.commit() |
|
405 self.failUnless(self.schema['state_of'].inlined) |
|
406 self.failUnless(self.index_exists('State', 'state_of')) |
|
407 rset = self.execute('Any X, Y WHERE X state_of Y') |
|
408 self.assertEquals(len(rset), 2) |
|
409 |
|
410 def test_indexed_change(self): |
|
411 self.session.set_pool() |
|
412 dbhelper = self.session.pool.source('system').dbhelper |
|
413 sqlcursor = self.session.pool['system'] |
|
414 try: |
|
415 self.execute('SET X indexed FALSE WHERE X relation_type R, R name "name"') |
|
416 self.failUnless(self.schema['name'].rproperty('Workflow', 'String', 'indexed')) |
|
417 self.failUnless(self.index_exists('Workflow', 'name')) |
|
418 self.commit() |
|
419 self.failIf(self.schema['name'].rproperty('Workflow', 'String', 'indexed')) |
|
420 self.failIf(self.index_exists('Workflow', 'name')) |
|
421 finally: |
|
422 self.execute('SET X indexed TRUE WHERE X relation_type R, R name "name"') |
|
423 self.failIf(self.schema['name'].rproperty('Workflow', 'String', 'indexed')) |
|
424 self.failIf(self.index_exists('Workflow', 'name')) |
|
425 self.commit() |
|
426 self.failUnless(self.schema['name'].rproperty('Workflow', 'String', 'indexed')) |
|
427 self.failUnless(self.index_exists('Workflow', 'name')) |
|
428 |
|
429 def test_unique_change(self): |
|
430 self.session.set_pool() |
|
431 dbhelper = self.session.pool.source('system').dbhelper |
|
432 sqlcursor = self.session.pool['system'] |
|
433 try: |
|
434 self.execute('INSERT CWConstraint X: X cstrtype CT, DEF constrained_by X ' |
|
435 'WHERE CT name "UniqueConstraint", DEF relation_type RT, DEF from_entity E,' |
|
436 'RT name "name", E name "Workflow"') |
|
437 self.failIf(self.schema['Workflow'].has_unique_values('name')) |
|
438 self.failIf(self.index_exists('Workflow', 'name', unique=True)) |
|
439 self.commit() |
|
440 self.failUnless(self.schema['Workflow'].has_unique_values('name')) |
|
441 self.failUnless(self.index_exists('Workflow', 'name', unique=True)) |
|
442 finally: |
|
443 self.execute('DELETE DEF constrained_by X WHERE X cstrtype CT, ' |
|
444 'CT name "UniqueConstraint", DEF relation_type RT, DEF from_entity E,' |
|
445 'RT name "name", E name "Workflow"') |
|
446 self.failUnless(self.schema['Workflow'].has_unique_values('name')) |
|
447 self.failUnless(self.index_exists('Workflow', 'name', unique=True)) |
|
448 self.commit() |
|
449 self.failIf(self.schema['Workflow'].has_unique_values('name')) |
|
450 self.failIf(self.index_exists('Workflow', 'name', unique=True)) |
|
451 |
|
452 def test_required_change_1(self): |
|
453 self.execute('SET DEF cardinality "?1" ' |
|
454 'WHERE DEF relation_type RT, DEF from_entity E,' |
|
455 'RT name "title", E name "Bookmark"') |
|
456 self.commit() |
|
457 # should now be able to add bookmark without title |
|
458 self.execute('INSERT Bookmark X: X path "/view"') |
|
459 self.commit() |
|
460 |
|
461 def test_required_change_2(self): |
|
462 self.execute('SET DEF cardinality "11" ' |
|
463 'WHERE DEF relation_type RT, DEF from_entity E,' |
|
464 'RT name "surname", E name "CWUser"') |
|
465 self.commit() |
|
466 # should not be able anymore to add cwuser without surname |
|
467 self.assertRaises(ValidationError, self.create_user, "toto") |
|
468 self.execute('SET DEF cardinality "?1" ' |
|
469 'WHERE DEF relation_type RT, DEF from_entity E,' |
|
470 'RT name "surname", E name "CWUser"') |
|
471 self.commit() |
|
472 |
|
473 if __name__ == '__main__': |
|
474 unittest_main() |