cubicweb/hooks/test/unittest_syncsession.py
author Philippe Pepiot <ph@itsalwaysdns.eu>
Mon, 30 Mar 2020 15:46:12 +0200
changeset 12963 dd9e98b25213
parent 12567 26744ad37953
permissions -rw-r--r--
[server] dynamically close idle database connections When pool hasn't been empty for `idle_timeout` time, start closing connections.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     1
# -*- coding: utf-8 -*-
11348
70337ad23145 pep8 + docstrings and comments improvments
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11129
diff changeset
     2
# copyright 2003-2016 LOGILAB S.A. (Paris, FRANCE), all rights reserved.
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     3
# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     4
#
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     5
# This file is part of CubicWeb.
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     6
#
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     7
# CubicWeb is free software: you can redistribute it and/or modify it under the
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     8
# terms of the GNU Lesser General Public License as published by the Free
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
     9
# Software Foundation, either version 2.1 of the License, or (at your option)
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    10
# any later version.
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    11
#
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    12
# CubicWeb is distributed in the hope that it will be useful, but WITHOUT
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    13
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    14
# FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    15
# details.
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    16
#
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    17
# You should have received a copy of the GNU Lesser General Public License along
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    18
# with CubicWeb.  If not, see <http://www.gnu.org/licenses/>.
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    19
"""functional tests for core hooks
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    20
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    21
Note:
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    22
  syncschema.py hooks are mostly tested in server/test/unittest_migrations.py
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    23
"""
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    24
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    25
from cubicweb import ValidationError
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    26
from cubicweb.devtools.testlib import CubicWebTC
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    27
11348
70337ad23145 pep8 + docstrings and comments improvments
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11129
diff changeset
    28
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    29
class CWPropertyHooksTC(CubicWebTC):
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    30
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    31
    def test_unexistant_cwproperty(self):
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    32
        with self.admin_access.web_request() as req:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    33
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    34
                req.execute('INSERT CWProperty X: X pkey "bla.bla", '
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    35
                            'X value "hop", X for_user U')
12567
26744ad37953 Drop python2 support
Denis Laxalde <denis.laxalde@logilab.fr>
parents: 12126
diff changeset
    36
            cm.exception.translate(str)
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    37
            self.assertEqual(cm.exception.errors,
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    38
                             {'pkey-subject': 'unknown property key bla.bla'})
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    39
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    40
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    41
                req.execute('INSERT CWProperty X: X pkey "bla.bla", X value "hop"')
12567
26744ad37953 Drop python2 support
Denis Laxalde <denis.laxalde@logilab.fr>
parents: 12126
diff changeset
    42
            cm.exception.translate(str)
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    43
            self.assertEqual(cm.exception.errors,
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    44
                             {'pkey-subject': 'unknown property key bla.bla'})
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    45
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    46
    def test_site_wide_cwproperty(self):
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    47
        with self.admin_access.web_request() as req:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    48
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    49
                req.execute('INSERT CWProperty X: X pkey "ui.site-title", '
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    50
                            'X value "hop", X for_user U')
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    51
            self.assertEqual(cm.exception.errors,
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    52
                             {'for_user-subject': "site-wide property can't be set for user"})
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    53
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    54
    def test_system_cwproperty(self):
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    55
        with self.admin_access.web_request() as req:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    56
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    57
                req.execute('INSERT CWProperty X: X pkey "system.version.cubicweb", '
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    58
                            'X value "hop", X for_user U')
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    59
            self.assertEqual(cm.exception.errors,
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    60
                             {'for_user-subject': "site-wide property can't be set for user"})
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    61
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    62
    def test_bad_type_cwproperty(self):
9863
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    63
        with self.admin_access.web_request() as req:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    64
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    65
                req.execute('INSERT CWProperty X: X pkey "ui.language", '
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    66
                            'X value "hop", X for_user U')
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    67
            self.assertEqual(cm.exception.errors,
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    68
                             {'value-subject': u'unauthorized value'})
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    69
            with self.assertRaises(ValidationError) as cm:
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    70
                req.execute('INSERT CWProperty X: X pkey "ui.language", X value "hop"')
3fbad401eb61 [tests/syncsession] use the new connection api
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents: 8694
diff changeset
    71
            self.assertEqual(cm.exception.errors, {'value-subject': u'unauthorized value'})
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    72
11097
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    73
    def test_vreg_propertyvalues_update(self):
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    74
        self.vreg.register_property(
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    75
            'test.int', type='Int', help='', sitewide=True)
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    76
        with self.admin_access.repo_cnx() as cnx:
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    77
            cnx.execute('INSERT CWProperty X: X pkey "test.int", X value "42"')
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    78
            cnx.commit()
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    79
        self.assertEqual(self.vreg.property_value('test.int'), 42)
900c27ea30e9 [cwvreg] Fix propertyvalues hot updates
Christophe de Vienne <christophe@unlish.com>
parents: 9863
diff changeset
    80
11350
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    81
    def test_sync_sitewide_props(self):
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    82
        with self.admin_access.client_cnx() as cnx:
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    83
            self.assertNotIn('ui.language', cnx.vreg['propertyvalues'])
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    84
            cwprop = cnx.create_entity('CWProperty', pkey=u'ui.language', value=u'fr')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    85
            self.assertNotIn('ui.language', cnx.vreg['propertyvalues'])
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    86
            cnx.commit()
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    87
            self.assertEqual(cnx.vreg['propertyvalues']['ui.language'], 'fr')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    88
            cwprop.cw_set(value=u'en')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    89
            self.assertEqual(cnx.vreg['propertyvalues']['ui.language'], 'fr')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    90
            cnx.commit()
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    91
            self.assertEqual(cnx.vreg['propertyvalues']['ui.language'], 'en')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    92
            cwprop.cw_delete()
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    93
            self.assertEqual(cnx.vreg['propertyvalues']['ui.language'], 'en')
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    94
            cnx.commit()
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    95
            self.assertNotIn('ui.language', cnx.vreg['propertyvalues'])
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    96
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    97
7192
9e92c8558fea [test, cw props] ensure we can't add user specific / system-wide properties
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
diff changeset
    98
if __name__ == '__main__':
11350
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
    99
    import unittest
de466349b742 [hooks] Add a bunch of tests for session synchronization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents: 11348
diff changeset
   100
    unittest.main()