hooks/test/unittest_integrity.py
author Aurelien Campeas <aurelien.campeas@logilab.fr>
Tue, 27 May 2014 18:47:24 +0200
changeset 10087 ed0b076c119b
parent 9854 4071c52b8fca
permissions -rw-r--r--
[rset] kill the rset._rqlst cache Right now it "works" for the standard, internal uses. However when we will fold ClientConnection and Connection, it will hurt, because suddenly we get more cache hits, and the following situation would become commonplace: * there is an un-annotated _rqlst given by the querier * some view (e.g. facets) requests the .syntax_tree, which takes a copy of _rqlst * the view actually expects the rql syntax tree to be annotated, but it was not, hence we crash. Related to #3837233.

# -*- 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 <http://www.gnu.org/licenses/>.
"""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()