diff -r 058bb3dc685f -r 0b59724cb3f2 hooks/test/unittest_integrity.py --- a/hooks/test/unittest_integrity.py Mon Jan 04 18:40:30 2016 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,162 +0,0 @@ -# -*- coding: utf-8 -*- -# copyright 2003-2014 LOGILAB S.A. (Paris, FRANCE), all rights reserved. -# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr -# -# This file is part of CubicWeb. -# -# CubicWeb is free software: you can redistribute it and/or modify it under the -# terms of the GNU Lesser General Public License as published by the Free -# Software Foundation, either version 2.1 of the License, or (at your option) -# any later version. -# -# CubicWeb is distributed in the hope that it will be useful, but WITHOUT -# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS -# FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more -# details. -# -# You should have received a copy of the GNU Lesser General Public License along -# with CubicWeb. If not, see . -"""functional tests for integrity hooks""" - -from cubicweb import ValidationError -from cubicweb.devtools.testlib import CubicWebTC - -class CoreHooksTC(CubicWebTC): - - def test_delete_internal_entities(self): - with self.admin_access.repo_cnx() as cnx: - self.assertRaises(ValidationError, cnx.execute, - 'DELETE CWEType X WHERE X name "CWEType"') - cnx.rollback() - self.assertRaises(ValidationError, cnx.execute, - 'DELETE CWRType X WHERE X name "relation_type"') - cnx.rollback() - self.assertRaises(ValidationError, cnx.execute, - 'DELETE CWGroup X WHERE X name "owners"') - - def test_delete_required_relations_subject(self): - with self.admin_access.repo_cnx() as cnx: - cnx.execute('INSERT CWUser X: X login "toto", X upassword "hop", X in_group Y ' - 'WHERE Y name "users"') - cnx.commit() - cnx.execute('DELETE X in_group Y WHERE X login "toto", Y name "users"') - self.assertRaises(ValidationError, cnx.commit) - cnx.rollback() - cnx.execute('DELETE X in_group Y WHERE X login "toto"') - cnx.execute('SET X in_group Y WHERE X login "toto", Y name "guests"') - cnx.commit() - - def test_static_vocabulary_check(self): - with self.admin_access.repo_cnx() as cnx: - self.assertRaises(ValidationError, - cnx.execute, - 'SET X composite "whatever" WHERE X from_entity FE, FE name "CWUser", ' - 'X relation_type RT, RT name "in_group"') - - def test_missing_required_relations_subject_inline(self): - with self.admin_access.repo_cnx() as cnx: - # missing in_group relation - cnx.execute('INSERT CWUser X: X login "toto", X upassword "hop"') - self.assertRaises(ValidationError, cnx.commit) - - def test_composite_1(self): - with self.admin_access.repo_cnx() as cnx: - cnx.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') - cnx.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, ' - 'X content "this is a test"') - cnx.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, ' - 'X recipients Y, X parts P ' - 'WHERE Y is EmailAddress, P is EmailPart') - self.assertTrue(cnx.execute('Email X WHERE X sender Y')) - cnx.commit() - cnx.execute('DELETE Email X') - rset = cnx.execute('Any X WHERE X is EmailPart') - self.assertEqual(len(rset), 0) - cnx.commit() - rset = cnx.execute('Any X WHERE X is EmailPart') - self.assertEqual(len(rset), 0) - - def test_composite_2(self): - with self.admin_access.repo_cnx() as cnx: - cnx.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') - cnx.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, ' - 'X content "this is a test"') - cnx.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, ' - 'X recipients Y, X parts P ' - 'WHERE Y is EmailAddress, P is EmailPart') - cnx.commit() - cnx.execute('DELETE Email X') - cnx.execute('DELETE EmailPart X') - cnx.commit() - rset = cnx.execute('Any X WHERE X is EmailPart') - self.assertEqual(len(rset), 0) - - def test_composite_redirection(self): - with self.admin_access.repo_cnx() as cnx: - cnx.execute('INSERT EmailAddress X: X address "toto@logilab.fr", X alias "hop"') - cnx.execute('INSERT EmailPart X: X content_format "text/plain", X ordernum 1, ' - 'X content "this is a test"') - cnx.execute('INSERT Email X: X messageid "<1234>", X subject "test", X sender Y, ' - 'X recipients Y, X parts P ' - 'WHERE Y is EmailAddress, P is EmailPart') - cnx.execute('INSERT Email X: X messageid "<2345>", X subject "test2", X sender Y, ' - 'X recipients Y ' - 'WHERE Y is EmailAddress') - cnx.commit() - cnx.execute('DELETE X parts Y WHERE X messageid "<1234>"') - cnx.execute('SET X parts Y WHERE X messageid "<2345>"') - cnx.commit() - rset = cnx.execute('Any X WHERE X is EmailPart') - self.assertEqual(len(rset), 1) - self.assertEqual(rset.get_entity(0, 0).reverse_parts[0].messageid, '<2345>') - - def test_composite_object_relation_deletion(self): - with self.admin_access.repo_cnx() as cnx: - root = cnx.create_entity('Folder', name=u'root') - a = cnx.create_entity('Folder', name=u'a', parent=root) - cnx.create_entity('Folder', name=u'b', parent=a) - cnx.create_entity('Folder', name=u'c', parent=root) - cnx.commit() - cnx.execute('DELETE Folder F WHERE F name "a"') - cnx.execute('DELETE F parent R WHERE R name "root"') - cnx.commit() - self.assertEqual([['root'], ['c']], - cnx.execute('Any NF WHERE F is Folder, F name NF').rows) - self.assertEqual([], cnx.execute('Any NF,NP WHERE F parent P, F name NF, P name NP').rows) - - def test_composite_subject_relation_deletion(self): - with self.admin_access.repo_cnx() as cnx: - root = cnx.create_entity('Folder', name=u'root') - a = cnx.create_entity('Folder', name=u'a') - b = cnx.create_entity('Folder', name=u'b') - c = cnx.create_entity('Folder', name=u'c') - root.cw_set(children=(a, c)) - a.cw_set(children=b) - cnx.commit() - cnx.execute('DELETE Folder F WHERE F name "a"') - cnx.execute('DELETE R children F WHERE R name "root"') - cnx.commit() - self.assertEqual([['root'], ['c']], - cnx.execute('Any NF WHERE F is Folder, F name NF').rows) - self.assertEqual([], cnx.execute('Any NF,NP WHERE F parent P, F name NF, P name NP').rows) - - def test_unsatisfied_constraints(self): - with self.admin_access.repo_cnx() as cnx: - cnx.execute('SET U in_group G WHERE G name "owners", U login "admin"')[0][0] - with self.assertRaises(ValidationError) as cm: - cnx.commit() - self.assertEqual(cm.exception.errors, - {'in_group-object': u'RQLConstraint NOT O name "owners" failed'}) - - def test_unique_constraint(self): - with self.admin_access.repo_cnx() as cnx: - entity = cnx.create_entity('CWGroup', name=u'trout') - cnx.commit() - self.assertRaises(ValidationError, cnx.create_entity, 'CWGroup', name=u'trout') - cnx.rollback() - cnx.execute('SET X name "trout" WHERE X eid %(x)s', {'x': entity.eid}) - cnx.commit() - -if __name__ == '__main__': - from logilab.common.testlib import unittest_main - unittest_main()