author | Julien Cristau <julien.cristau@logilab.fr> |
Thu, 08 Jan 2015 12:22:43 +0100 | |
changeset 10146 | 78f541f50369 |
parent 9965 | a8769b752299 |
child 10203 | 1443fe643a38 |
child 10280 | 2cdab5e33542 |
permissions | -rw-r--r-- |
0 | 1 |
# -*- coding: iso-8859-1 -*- |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
2 |
# copyright 2003-2014 LOGILAB S.A. (Paris, FRANCE), all rights reserved. |
5421
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
3 |
# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
4 |
# |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
5 |
# This file is part of CubicWeb. |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
6 |
# |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
7 |
# CubicWeb is free software: you can redistribute it and/or modify it under the |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
8 |
# terms of the GNU Lesser General Public License as published by the Free |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
9 |
# Software Foundation, either version 2.1 of the License, or (at your option) |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
10 |
# any later version. |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
11 |
# |
5424
8ecbcbff9777
replace logilab-common by CubicWeb in disclaimer
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5421
diff
changeset
|
12 |
# CubicWeb is distributed in the hope that it will be useful, but WITHOUT |
5421
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
13 |
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
14 |
# FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
15 |
# details. |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
16 |
# |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
17 |
# You should have received a copy of the GNU Lesser General Public License along |
8167de96c523
proper licensing information (LGPL-2.1). Hope I get it right this time.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5213
diff
changeset
|
18 |
# with CubicWeb. If not, see <http://www.gnu.org/licenses/>. |
5889
014ea69e5200
[test] running transaction while session is closed are now killed, update test accordingly
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5582
diff
changeset
|
19 |
"""unit tests for module cubicweb.server.repository""" |
0 | 20 |
|
21 |
import threading |
|
22 |
import time |
|
7381
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
23 |
import logging |
0 | 24 |
|
25 |
from yams.constraints import UniqueConstraint |
|
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
26 |
from yams import register_base_type, unregister_base_type |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
27 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
28 |
from logilab.database import get_db_helper |
0 | 29 |
|
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
30 |
from cubicweb import (BadConnectionId, ValidationError, |
6385
9f91d09ee5fa
[repo transaction] fix rollback behaviour as discussed on the mailing-list: instead of rollbacking automatically on Unauthorized/ValidationError, mark the transaction as uncommitable and disallow commiting
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6364
diff
changeset
|
31 |
UnknownEid, AuthenticationError, Unauthorized, QueryError) |
8190
2a3c1b787688
[vreg] move base registry implementation to logilab.common. Closes #1916014
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7795
diff
changeset
|
32 |
from cubicweb.predicates import is_instance |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
33 |
from cubicweb.schema import RQLConstraint |
8669
62213a34726e
[db-api/configuration] simplify db-api and configuration so that all the connection information is in the repository url, closes #2521848
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8573
diff
changeset
|
34 |
from cubicweb.dbapi import connect, multiple_connections_unfix |
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
35 |
from cubicweb.devtools.testlib import CubicWebTC |
1251
af40e615dc89
introduce a 'cw_' prefix on entity table and column names so we don't conflict with sql or DBMS specific keywords
sylvain.thenault@logilab.fr
parents:
17
diff
changeset
|
36 |
from cubicweb.devtools.repotest import tuplify |
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
37 |
from cubicweb.server import repository, hook |
1251
af40e615dc89
introduce a 'cw_' prefix on entity table and column names so we don't conflict with sql or DBMS specific keywords
sylvain.thenault@logilab.fr
parents:
17
diff
changeset
|
38 |
from cubicweb.server.sqlutils import SQL_PREFIX |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
39 |
from cubicweb.server.hook import Hook |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
40 |
from cubicweb.server.sources import native |
8999
81a5d57d9230
[session] upgrade session closed error from Exception to SessionClosedError
pierre-yves
parents:
8947
diff
changeset
|
41 |
from cubicweb.server.session import SessionClosedError |
0 | 42 |
|
43 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
44 |
class RepositoryTC(CubicWebTC): |
0 | 45 |
""" singleton providing access to a persistent storage for entities |
46 |
and relation |
|
47 |
""" |
|
1787 | 48 |
|
9130
0f1504a9fb51
[constraint] more robust unicity constraint failures reporting for end-users
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9128
diff
changeset
|
49 |
def test_unique_together_constraint(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
50 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
51 |
cnx.execute('INSERT Societe S: S nom "Logilab", S type "SSLL", S cp "75013"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
52 |
with self.assertRaises(ValidationError) as wraperr: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
53 |
cnx.execute('INSERT Societe S: S nom "Logilab", S type "SSLL", S cp "75013"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
54 |
self.assertEqual( |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
55 |
{'cp': u'cp is part of violated unicity constraint', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
56 |
'nom': u'nom is part of violated unicity constraint', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
57 |
'type': u'type is part of violated unicity constraint', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
58 |
'unicity constraint': u'some relations violate a unicity constraint'}, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
59 |
wraperr.exception.args[1]) |
8820
dbffb6959564
server/source/native: fix wrong usage of .lstrip that produce garbled error messages (closes #2777641)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
8572
diff
changeset
|
60 |
|
9130
0f1504a9fb51
[constraint] more robust unicity constraint failures reporting for end-users
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9128
diff
changeset
|
61 |
def test_unique_together_schema(self): |
6208
07b176640a8c
unique_together integration in CW (alf+syt)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
6188
diff
changeset
|
62 |
person = self.repo.schema.eschema('Personne') |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
63 |
self.assertEqual(len(person._unique_together), 1) |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
64 |
self.assertItemsEqual(person._unique_together[0], |
6208
07b176640a8c
unique_together integration in CW (alf+syt)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
6188
diff
changeset
|
65 |
('nom', 'prenom', 'inline2')) |
07b176640a8c
unique_together integration in CW (alf+syt)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
6188
diff
changeset
|
66 |
|
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
67 |
def test_all_entities_have_owner(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
68 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
69 |
self.assertFalse(cnx.execute('Any X WHERE NOT X owned_by U')) |
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
70 |
|
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
71 |
def test_all_entities_have_is(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
72 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
73 |
self.assertFalse(cnx.execute('Any X WHERE NOT X is ET')) |
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
74 |
|
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
75 |
def test_all_entities_have_cw_source(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
76 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
77 |
self.assertFalse(cnx.execute('Any X WHERE NOT X cw_source S')) |
1787 | 78 |
|
0 | 79 |
def test_connect(self): |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
80 |
cnxid = self.repo.connect(self.admlogin, password=self.admpassword) |
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
81 |
self.assert_(cnxid) |
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
82 |
self.repo.close(cnxid) |
0 | 83 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
84 |
self.repo.connect, self.admlogin, password='nimportnawak') |
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
85 |
self.assertRaises(AuthenticationError, |
8520
fcd048fa6e6d
[source/native] only system source users should be authenticated by the native source (closes #2465883)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
8388
diff
changeset
|
86 |
self.repo.connect, self.admlogin, password='') |
fcd048fa6e6d
[source/native] only system source users should be authenticated by the native source (closes #2465883)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
8388
diff
changeset
|
87 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
88 |
self.repo.connect, self.admlogin, password=None) |
0 | 89 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
90 |
self.repo.connect, None, password=None) |
0 | 91 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
92 |
self.repo.connect, self.admlogin) |
0 | 93 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
94 |
self.repo.connect, None) |
1787 | 95 |
|
0 | 96 |
def test_execute(self): |
97 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
98 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 99 |
repo.execute(cnxid, 'Any X') |
100 |
repo.execute(cnxid, 'Any X where X is Personne') |
|
101 |
repo.execute(cnxid, 'Any X where X is Personne, X nom ~= "to"') |
|
102 |
repo.execute(cnxid, 'Any X WHERE X has_text %(text)s', {'text': u'\xe7a'}) |
|
103 |
repo.close(cnxid) |
|
1787 | 104 |
|
0 | 105 |
def test_login_upassword_accent(self): |
106 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
107 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
2920
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
108 |
repo.execute(cnxid, 'INSERT CWUser X: X login %(login)s, X upassword %(passwd)s, X in_group G WHERE G name "users"', |
0 | 109 |
{'login': u"barnab�", 'passwd': u"h�h�h�".encode('UTF8')}) |
110 |
repo.commit(cnxid) |
|
111 |
repo.close(cnxid) |
|
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
112 |
cnxid = repo.connect(u"barnab�", password=u"h�h�h�".encode('UTF8')) |
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
113 |
self.assert_(cnxid) |
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
114 |
repo.close(cnxid) |
1787 | 115 |
|
6361
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
116 |
def test_rollback_on_commit_error(self): |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
117 |
cnxid = self.repo.connect(self.admlogin, password=self.admpassword) |
3771 | 118 |
self.repo.execute(cnxid, |
119 |
'INSERT CWUser X: X login %(login)s, X upassword %(passwd)s', |
|
120 |
{'login': u"tutetute", 'passwd': 'tutetute'}) |
|
121 |
self.assertRaises(ValidationError, self.repo.commit, cnxid) |
|
7791
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
122 |
self.assertFalse(self.repo.execute(cnxid, 'CWUser X WHERE X login "tutetute"')) |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
123 |
self.repo.close(cnxid) |
1787 | 124 |
|
6361
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
125 |
def test_rollback_on_execute_validation_error(self): |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
126 |
class ValidationErrorAfterHook(Hook): |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
127 |
__regid__ = 'valerror-after-hook' |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
128 |
__select__ = Hook.__select__ & is_instance('CWGroup') |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
129 |
events = ('after_update_entity',) |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
130 |
def __call__(self): |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
131 |
raise ValidationError(self.entity.eid, {}) |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
132 |
|
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
133 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
134 |
with self.temporary_appobjects(ValidationErrorAfterHook): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
135 |
self.assertRaises(ValidationError, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
136 |
cnx.execute, 'SET X name "toto" WHERE X is CWGroup, X name "guests"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
137 |
self.assertTrue(cnx.execute('Any X WHERE X is CWGroup, X name "toto"')) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
138 |
with self.assertRaises(QueryError) as cm: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
139 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
140 |
self.assertEqual(str(cm.exception), 'transaction must be rolled back') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
141 |
cnx.rollback() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
142 |
self.assertFalse(cnx.execute('Any X WHERE X is CWGroup, X name "toto"')) |
6361
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
143 |
|
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
144 |
def test_rollback_on_execute_unauthorized(self): |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
145 |
class UnauthorizedAfterHook(Hook): |
6364
ad9ed9803eb6
cleanup and micro-optimization
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6361
diff
changeset
|
146 |
__regid__ = 'unauthorized-after-hook' |
6361
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
147 |
__select__ = Hook.__select__ & is_instance('CWGroup') |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
148 |
events = ('after_update_entity',) |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
149 |
def __call__(self): |
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
150 |
raise Unauthorized() |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
151 |
|
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
152 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
153 |
with self.temporary_appobjects(UnauthorizedAfterHook): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
154 |
self.assertRaises(Unauthorized, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
155 |
cnx.execute, 'SET X name "toto" WHERE X is CWGroup, X name "guests"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
156 |
self.assertTrue(cnx.execute('Any X WHERE X is CWGroup, X name "toto"')) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
157 |
with self.assertRaises(QueryError) as cm: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
158 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
159 |
self.assertEqual(str(cm.exception), 'transaction must be rolled back') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
160 |
cnx.rollback() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
161 |
self.assertFalse(cnx.execute('Any X WHERE X is CWGroup, X name "toto"')) |
6361
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
162 |
|
843684a50e48
[transaction] to avoid potential db corruption, we should rollback systematically in case of ValidationError
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6340
diff
changeset
|
163 |
|
0 | 164 |
def test_close(self): |
165 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
166 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 167 |
self.assert_(cnxid) |
168 |
repo.close(cnxid) |
|
169 |
self.assertRaises(BadConnectionId, repo.execute, cnxid, 'Any X') |
|
1787 | 170 |
|
0 | 171 |
def test_invalid_cnxid(self): |
172 |
self.assertRaises(BadConnectionId, self.repo.execute, 0, 'Any X') |
|
173 |
self.assertRaises(BadConnectionId, self.repo.close, None) |
|
1787 | 174 |
|
0 | 175 |
def test_shared_data(self): |
176 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
177 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 178 |
repo.set_shared_data(cnxid, 'data', 4) |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
179 |
cnxid2 = repo.connect(self.admlogin, password=self.admpassword) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
180 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), 4) |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
181 |
self.assertEqual(repo.get_shared_data(cnxid2, 'data'), None) |
0 | 182 |
repo.set_shared_data(cnxid2, 'data', 5) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
183 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), 4) |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
184 |
self.assertEqual(repo.get_shared_data(cnxid2, 'data'), 5) |
0 | 185 |
repo.get_shared_data(cnxid2, 'data', pop=True) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
186 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), 4) |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
187 |
self.assertEqual(repo.get_shared_data(cnxid2, 'data'), None) |
0 | 188 |
repo.close(cnxid) |
189 |
repo.close(cnxid2) |
|
190 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid, 'data') |
|
191 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid2, 'data') |
|
192 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid, 'data', 1) |
|
193 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid2, 'data', 1) |
|
194 |
||
195 |
def test_check_session(self): |
|
196 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
197 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
6030
a1544ca8913e
[test] check_session returns an int since 6012:d56fd78006cd
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5890
diff
changeset
|
198 |
self.assertIsInstance(repo.check_session(cnxid), float) |
0 | 199 |
repo.close(cnxid) |
200 |
self.assertRaises(BadConnectionId, repo.check_session, cnxid) |
|
201 |
||
202 |
def test_transaction_base(self): |
|
203 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
204 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 205 |
# check db state |
206 |
result = repo.execute(cnxid, 'Personne X') |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
207 |
self.assertEqual(result.rowcount, 0) |
0 | 208 |
# rollback entity insertion |
209 |
repo.execute(cnxid, "INSERT Personne X: X nom 'bidule'") |
|
210 |
result = repo.execute(cnxid, 'Personne X') |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
211 |
self.assertEqual(result.rowcount, 1) |
0 | 212 |
repo.rollback(cnxid) |
213 |
result = repo.execute(cnxid, 'Personne X') |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
214 |
self.assertEqual(result.rowcount, 0, result.rows) |
0 | 215 |
# commit |
216 |
repo.execute(cnxid, "INSERT Personne X: X nom 'bidule'") |
|
217 |
repo.commit(cnxid) |
|
218 |
result = repo.execute(cnxid, 'Personne X') |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
219 |
self.assertEqual(result.rowcount, 1) |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
220 |
repo.close(cnxid) |
0 | 221 |
|
222 |
def test_transaction_base2(self): |
|
223 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
224 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 225 |
# rollback relation insertion |
226 |
repo.execute(cnxid, "SET U in_group G WHERE U login 'admin', G name 'guests'") |
|
227 |
result = repo.execute(cnxid, "Any U WHERE U in_group G, U login 'admin', G name 'guests'") |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
228 |
self.assertEqual(result.rowcount, 1) |
0 | 229 |
repo.rollback(cnxid) |
230 |
result = repo.execute(cnxid, "Any U WHERE U in_group G, U login 'admin', G name 'guests'") |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
231 |
self.assertEqual(result.rowcount, 0, result.rows) |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
232 |
repo.close(cnxid) |
1787 | 233 |
|
0 | 234 |
def test_transaction_base3(self): |
235 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
236 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 237 |
# rollback state change which trigger TrInfo insertion |
4835
13b0b96d7982
[repo] enhanced security handling: deprecates unsafe_execute, in favor of explicit read/write security control using the `enabled_security` context manager. Also code executed on the repository side is now unsafe by default.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4808
diff
changeset
|
238 |
session = repo._get_session(cnxid) |
13b0b96d7982
[repo] enhanced security handling: deprecates unsafe_execute, in favor of explicit read/write security control using the `enabled_security` context manager. Also code executed on the repository side is now unsafe by default.
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4808
diff
changeset
|
239 |
user = session.user |
5556
9ab2b4c74baf
[entity] introduce a new 'adapters' registry
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5429
diff
changeset
|
240 |
user.cw_adapt_to('IWorkflowable').fire_transition('deactivate') |
2920
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
241 |
rset = repo.execute(cnxid, 'TrInfo T WHERE T wf_info_for X, X eid %(x)s', {'x': user.eid}) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
242 |
self.assertEqual(len(rset), 1) |
0 | 243 |
repo.rollback(cnxid) |
2920
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
244 |
rset = repo.execute(cnxid, 'TrInfo T WHERE T wf_info_for X, X eid %(x)s', {'x': user.eid}) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
245 |
self.assertEqual(len(rset), 0) |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
246 |
repo.close(cnxid) |
1787 | 247 |
|
5889
014ea69e5200
[test] running transaction while session is closed are now killed, update test accordingly
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5582
diff
changeset
|
248 |
def test_close_kill_processing_request(self): |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
249 |
repo = self.repo |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
250 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
251 |
repo.execute(cnxid, 'INSERT CWUser X: X login "toto", X upassword "tutu", X in_group G WHERE G name "users"') |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
252 |
repo.commit(cnxid) |
7343 | 253 |
lock = threading.Lock() |
7339
dd5e49a5dcab
[server test] use a lock instead of sleep to have higher green probability :/
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7238
diff
changeset
|
254 |
lock.acquire() |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
255 |
# close has to be in the thread due to sqlite limitations |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
256 |
def close_in_a_few_moment(): |
7339
dd5e49a5dcab
[server test] use a lock instead of sleep to have higher green probability :/
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7238
diff
changeset
|
257 |
lock.acquire() |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
258 |
repo.close(cnxid) |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
259 |
t = threading.Thread(target=close_in_a_few_moment) |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
260 |
t.start() |
5889
014ea69e5200
[test] running transaction while session is closed are now killed, update test accordingly
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5582
diff
changeset
|
261 |
def run_transaction(): |
7339
dd5e49a5dcab
[server test] use a lock instead of sleep to have higher green probability :/
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7238
diff
changeset
|
262 |
lock.release() |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
263 |
repo.execute(cnxid, 'DELETE CWUser X WHERE X login "toto"') |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
264 |
repo.commit(cnxid) |
5889
014ea69e5200
[test] running transaction while session is closed are now killed, update test accordingly
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5582
diff
changeset
|
265 |
try: |
8999
81a5d57d9230
[session] upgrade session closed error from Exception to SessionClosedError
pierre-yves
parents:
8947
diff
changeset
|
266 |
with self.assertRaises(SessionClosedError) as cm: |
6796
e70ca9abfc51
[unittest2] update to unittest2 assertRaises api
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6427
diff
changeset
|
267 |
run_transaction() |
7666
8644c2a065f0
fix test broken by previous commit
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7563
diff
changeset
|
268 |
self.assertEqual(str(cm.exception), 'try to access connections set on a closed session %s' % cnxid) |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
269 |
finally: |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
270 |
t.join() |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
271 |
|
0 | 272 |
def test_initial_schema(self): |
273 |
schema = self.repo.schema |
|
274 |
# check order of attributes is respected |
|
9128
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
275 |
notin = set(('eid', 'is', 'is_instance_of', 'identity', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
276 |
'creation_date', 'modification_date', 'cwuri', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
277 |
'owned_by', 'created_by', 'cw_source', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
278 |
'update_permission', 'read_permission', |
9395
96dba2efd16d
[hooks/security] provide attribute "add" permission
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9267
diff
changeset
|
279 |
'add_permission', 'in_basket')) |
9128
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
280 |
self.assertListEqual(['relation_type', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
281 |
'from_entity', 'to_entity', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
282 |
'constrained_by', |
9965
a8769b752299
[CWEP002] Account for attribute formula in schema bootstrap
Denis Laxalde <denis.laxalde@logilab.fr>
parents:
9803
diff
changeset
|
283 |
'cardinality', 'ordernum', 'formula', |
9128
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
284 |
'indexed', 'fulltextindexed', 'internationalizable', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
285 |
'defaultval', 'extra_props', |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
286 |
'description', 'description_format'], |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
287 |
[r.type |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
288 |
for r in schema.eschema('CWAttribute').ordered_relations() |
d988eec2d5d3
[test/schemaserial] swap got/expected to get nicer unittest2 diagnostics
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9008
diff
changeset
|
289 |
if r.type not in notin]) |
0 | 290 |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
291 |
self.assertEqual(schema.eschema('CWEType').main_attribute(), 'name') |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
292 |
self.assertEqual(schema.eschema('State').main_attribute(), 'name') |
0 | 293 |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
294 |
constraints = schema.rschema('name').rdef('CWEType', 'String').constraints |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
295 |
self.assertEqual(len(constraints), 2) |
0 | 296 |
for cstr in constraints[:]: |
297 |
if isinstance(cstr, UniqueConstraint): |
|
298 |
constraints.remove(cstr) |
|
299 |
break |
|
300 |
else: |
|
301 |
self.fail('unique constraint not found') |
|
302 |
sizeconstraint = constraints[0] |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
303 |
self.assertEqual(sizeconstraint.min, None) |
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
304 |
self.assertEqual(sizeconstraint.max, 64) |
0 | 305 |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
306 |
constraints = schema.rschema('relation_type').rdef('CWAttribute', 'CWRType').constraints |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
307 |
self.assertEqual(len(constraints), 1) |
0 | 308 |
cstr = constraints[0] |
309 |
self.assert_(isinstance(cstr, RQLConstraint)) |
|
7161
e3f69df8dac7
fix failing tests before 3.12 release
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7148
diff
changeset
|
310 |
self.assertEqual(cstr.expression, 'O final TRUE') |
0 | 311 |
|
312 |
ownedby = schema.rschema('owned_by') |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
313 |
self.assertEqual(ownedby.objects('CWEType'), ('CWUser',)) |
0 | 314 |
|
315 |
def test_pyro(self): |
|
316 |
import Pyro |
|
317 |
Pyro.config.PYRO_MULTITHREADED = 0 |
|
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
318 |
done = [] |
8874
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
319 |
self.repo.config.global_set_option('pyro-ns-host', 'NO_PYRONS') |
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
320 |
daemon = self.repo.pyro_register() |
0 | 321 |
try: |
8874
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
322 |
uri = self.repo.pyro_uri.replace('PYRO', 'pyroloc') |
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
323 |
# the client part has to be in the thread due to sqlite limitations |
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
324 |
t = threading.Thread(target=self._pyro_client, args=(uri, done)) |
0 | 325 |
t.start() |
1880
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
326 |
while not done: |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
327 |
daemon.handleRequests(1.0) |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
328 |
t.join(1) |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
329 |
if t.isAlive(): |
293fe4b49e28
two in one: #343320: Logging out while deleting a CWUser blocks the cw server / #342692: ensure transaction state when Ctrl-C or other stop signal is received
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1787
diff
changeset
|
330 |
self.fail('something went wrong, thread still alive') |
0 | 331 |
finally: |
332 |
repository.pyro_unregister(self.repo.config) |
|
4766
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
333 |
from logilab.common import pyro_ext |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
334 |
pyro_ext._DAEMONS.clear() |
1787 | 335 |
|
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
336 |
|
8874
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
337 |
def _pyro_client(self, uri, done): |
522bdba66690
[server/test] remove dependency on a pyro name server (closes #2801737)
Julien Cristau <julien.cristau@logilab.fr>
parents:
8821
diff
changeset
|
338 |
cnx = connect(uri, |
8669
62213a34726e
[db-api/configuration] simplify db-api and configuration so that all the connection information is in the repository url, closes #2521848
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8573
diff
changeset
|
339 |
u'admin', password='gingkow', |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
340 |
initlog=False) # don't reset logging configuration |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
341 |
try: |
5429
5ca1f8fe8a42
[dbapi] more test and documentation of dbapi
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5426
diff
changeset
|
342 |
cnx.load_appobjects(subpath=('entities',)) |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
343 |
# check we can get the schema |
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
344 |
schema = cnx.get_schema() |
7791
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
345 |
self.assertTrue(cnx.vreg) |
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
346 |
self.assertTrue('etypes'in cnx.vreg) |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
347 |
cu = cnx.cursor() |
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
348 |
rset = cu.execute('Any U,G WHERE U in_group G') |
5429
5ca1f8fe8a42
[dbapi] more test and documentation of dbapi
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5426
diff
changeset
|
349 |
user = iter(rset.entities()).next() |
7791
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
350 |
self.assertTrue(user._cw) |
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
351 |
self.assertTrue(user._cw.vreg) |
5429
5ca1f8fe8a42
[dbapi] more test and documentation of dbapi
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5426
diff
changeset
|
352 |
from cubicweb.entities import authobjs |
5ca1f8fe8a42
[dbapi] more test and documentation of dbapi
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5426
diff
changeset
|
353 |
self.assertIsInstance(user._cw.user, authobjs.CWUser) |
9008
e0aa7cf8abf8
repository: make tests pass again
Julien Cristau <julien.cristau@logilab.fr>
parents:
8999
diff
changeset
|
354 |
# make sure the tcp connection is closed properly; yes, it's disgusting. |
e0aa7cf8abf8
repository: make tests pass again
Julien Cristau <julien.cristau@logilab.fr>
parents:
8999
diff
changeset
|
355 |
adapter = cnx._repo.adapter |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
356 |
cnx.close() |
9008
e0aa7cf8abf8
repository: make tests pass again
Julien Cristau <julien.cristau@logilab.fr>
parents:
8999
diff
changeset
|
357 |
adapter.release() |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
358 |
done.append(True) |
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
359 |
finally: |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
360 |
# connect monkey patch some method by default, remove them |
2650
18aec79ec3a3
R [vreg] important refactoring of the vregistry, moving behaviour to end dictionnary (and so leaving room for more flexibility ; keep bw compat ; update api usage in cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2642
diff
changeset
|
361 |
multiple_connections_unfix() |
0 | 362 |
|
8353
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
363 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
364 |
def test_zmq(self): |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
365 |
try: |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
366 |
import zmq |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
367 |
except ImportError: |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
368 |
self.skipTest("zmq in not available") |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
369 |
done = [] |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
370 |
from cubicweb.devtools import TestServerConfiguration as ServerConfiguration |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
371 |
from cubicweb.server.cwzmq import ZMQRepositoryServer |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
372 |
# the client part has to be in a thread due to sqlite limitations |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
373 |
t = threading.Thread(target=self._zmq_client, args=(done,)) |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
374 |
t.start() |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
375 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
376 |
zmq_server = ZMQRepositoryServer(self.repo) |
8670
f02139297beb
prefix "tcp://" zmq uris with "zmqpickle" (closes #2574114)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
8669
diff
changeset
|
377 |
zmq_server.connect('zmqpickle-tcp://127.0.0.1:41415') |
8353
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
378 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
379 |
t2 = threading.Thread(target=self._zmq_quit, args=(done, zmq_server,)) |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
380 |
t2.start() |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
381 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
382 |
zmq_server.run() |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
383 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
384 |
t2.join(1) |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
385 |
t.join(1) |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
386 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
387 |
if t.isAlive(): |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
388 |
self.fail('something went wrong, thread still alive') |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
389 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
390 |
def _zmq_quit(self, done, srv): |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
391 |
while not done: |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
392 |
time.sleep(0.1) |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
393 |
srv.quit() |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
394 |
|
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
395 |
def _zmq_client(self, done): |
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
396 |
try: |
8670
f02139297beb
prefix "tcp://" zmq uris with "zmqpickle" (closes #2574114)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
8669
diff
changeset
|
397 |
cnx = connect('zmqpickle-tcp://127.0.0.1:41415', u'admin', password=u'gingkow', |
8388
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
398 |
initlog=False) # don't reset logging configuration |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
399 |
try: |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
400 |
cnx.load_appobjects(subpath=('entities',)) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
401 |
# check we can get the schema |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
402 |
schema = cnx.get_schema() |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
403 |
self.assertTrue(cnx.vreg) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
404 |
self.assertTrue('etypes'in cnx.vreg) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
405 |
cu = cnx.cursor() |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
406 |
rset = cu.execute('Any U,G WHERE U in_group G') |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
407 |
user = iter(rset.entities()).next() |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
408 |
self.assertTrue(user._cw) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
409 |
self.assertTrue(user._cw.vreg) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
410 |
from cubicweb.entities import authobjs |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
411 |
self.assertIsInstance(user._cw.user, authobjs.CWUser) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
412 |
cnx.close() |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
413 |
done.append(True) |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
414 |
finally: |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
415 |
# connect monkey patch some method by default, remove them |
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
416 |
multiple_connections_unfix() |
8353
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
417 |
finally: |
8388
c6c624cea870
[repo test] Avoid hangs in zmq repo unit test
Julien Cristau <julien.cristau@logilab.fr>
parents:
8353
diff
changeset
|
418 |
done.append(False) |
8353
c1cc2f1cd177
[zmq] add unit tests for ZMQ-based repository (server and dbapi)
David Douard <david.douard@logilab.fr>
parents:
8190
diff
changeset
|
419 |
|
0 | 420 |
def test_internal_api(self): |
421 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
422 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
7398
26695dd703d8
[repository api] definitly kill usage of word 'pool' to refer to connections set used by a session
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7382
diff
changeset
|
423 |
session = repo._get_session(cnxid, setcnxset=True) |
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
424 |
self.assertEqual(repo.type_and_source_from_eid(2, session), |
9469
032825bbacab
[multi-sources-removal] Drop entities.source column
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9455
diff
changeset
|
425 |
('CWGroup', None, 'system')) |
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
426 |
self.assertEqual(repo.type_from_eid(2, session), 'CWGroup') |
7186
287f2273917f
[test] drop some warnings introduced by new test dabase handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6796
diff
changeset
|
427 |
repo.close(cnxid) |
0 | 428 |
|
429 |
def test_public_api(self): |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
430 |
self.assertEqual(self.repo.get_schema(), self.repo.schema) |
7563
8e129bb6b571
[tests] update repository tests with new `use_cwuri_as_url` attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7543
diff
changeset
|
431 |
self.assertEqual(self.repo.source_defs(), {'system': {'type': 'native', |
8e129bb6b571
[tests] update repository tests with new `use_cwuri_as_url` attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7543
diff
changeset
|
432 |
'uri': 'system', |
8e129bb6b571
[tests] update repository tests with new `use_cwuri_as_url` attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7543
diff
changeset
|
433 |
'use-cwuri-as-url': False} |
8e129bb6b571
[tests] update repository tests with new `use_cwuri_as_url` attribute
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7543
diff
changeset
|
434 |
}) |
0 | 435 |
# .properties() return a result set |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
436 |
self.assertEqual(self.repo.properties().rql, 'Any K,V WHERE P is CWProperty,P pkey K, P value V, NOT P for_user U') |
0 | 437 |
|
438 |
def test_session_api(self): |
|
439 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
440 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
6427
c8a5ac2d1eaa
[schema / sources] store data sources as cubicweb entities
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6401
diff
changeset
|
441 |
self.assertEqual(repo.user_info(cnxid), (6, 'admin', set([u'managers']), {})) |
9469
032825bbacab
[multi-sources-removal] Drop entities.source column
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9455
diff
changeset
|
442 |
self.assertEqual({'type': u'CWGroup', 'extid': None, 'source': 'system'}, |
032825bbacab
[multi-sources-removal] Drop entities.source column
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9455
diff
changeset
|
443 |
repo.entity_metas(cnxid, 2)) |
032825bbacab
[multi-sources-removal] Drop entities.source column
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9455
diff
changeset
|
444 |
self.assertEqual(repo.describe(cnxid, 2), (u'CWGroup', 'system', None, 'system')) |
0 | 445 |
repo.close(cnxid) |
446 |
self.assertRaises(BadConnectionId, repo.user_info, cnxid) |
|
447 |
self.assertRaises(BadConnectionId, repo.describe, cnxid, 1) |
|
448 |
||
449 |
def test_shared_data_api(self): |
|
450 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
451 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
452 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), None) |
0 | 453 |
repo.set_shared_data(cnxid, 'data', 4) |
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
454 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), 4) |
0 | 455 |
repo.get_shared_data(cnxid, 'data', pop=True) |
456 |
repo.get_shared_data(cnxid, 'whatever', pop=True) |
|
6340
470d8e828fda
[test] update test to unittest2 api (still using lgc.testlib though)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6236
diff
changeset
|
457 |
self.assertEqual(repo.get_shared_data(cnxid, 'data'), None) |
0 | 458 |
repo.close(cnxid) |
459 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid, 'data', 0) |
|
460 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid, 'data') |
|
1787 | 461 |
|
2588
3a590ff82e99
[F schema serial] #344876: missing some 'is'/'is_instance_of' relation for newly created instances
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2200
diff
changeset
|
462 |
def test_schema_is_relation(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
463 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
464 |
no_is_rset = cnx.execute('Any X WHERE NOT X is ET') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
465 |
self.assertFalse(no_is_rset, no_is_rset.description) |
2588
3a590ff82e99
[F schema serial] #344876: missing some 'is'/'is_instance_of' relation for newly created instances
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2200
diff
changeset
|
466 |
|
2642 | 467 |
# def test_perfo(self): |
468 |
# self.set_debug(True) |
|
469 |
# from time import time, clock |
|
470 |
# t, c = time(), clock() |
|
471 |
# try: |
|
472 |
# self.create_user('toto') |
|
473 |
# finally: |
|
474 |
# self.set_debug(False) |
|
475 |
# print 'test time: %.3f (time) %.3f (cpu)' % ((time() - t), clock() - c) |
|
476 |
||
2923
b97a0f8dd4dc
fix test schema and update some tests to work again with wf changes
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2920
diff
changeset
|
477 |
def test_delete_if_singlecard1(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
478 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
479 |
note = cnx.create_entity('Affaire') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
480 |
p1 = cnx.create_entity('Personne', nom=u'toto') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
481 |
cnx.execute('SET A todo_by P WHERE A eid %(x)s, P eid %(p)s', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
482 |
{'x': note.eid, 'p': p1.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
483 |
rset = cnx.execute('Any P WHERE A todo_by P, A eid %(x)s', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
484 |
{'x': note.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
485 |
self.assertEqual(len(rset), 1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
486 |
p2 = cnx.create_entity('Personne', nom=u'tutu') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
487 |
cnx.execute('SET A todo_by P WHERE A eid %(x)s, P eid %(p)s', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
488 |
{'x': note.eid, 'p': p2.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
489 |
rset = cnx.execute('Any P WHERE A todo_by P, A eid %(x)s', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
490 |
{'x': note.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
491 |
self.assertEqual(len(rset), 1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
492 |
self.assertEqual(rset.rows[0][0], p2.eid) |
2923
b97a0f8dd4dc
fix test schema and update some tests to work again with wf changes
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2920
diff
changeset
|
493 |
|
6188
e1c9610b2360
[integrity] fix case where we can get two entities related while the cardinality is single on the object of an inlined relation
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5890
diff
changeset
|
494 |
def test_delete_if_object_inlined_singlecard(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
495 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
496 |
c = cnx.create_entity('Card', title=u'Carte') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
497 |
cnx.create_entity('Personne', nom=u'Vincent', fiche=c) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
498 |
cnx.create_entity('Personne', nom=u'Florent', fiche=c) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
499 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
500 |
self.assertEqual(len(c.reverse_fiche), 1) |
0 | 501 |
|
8483
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
502 |
def test_cw_set_in_before_update(self): |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
503 |
# local hook |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
504 |
class DummyBeforeHook(Hook): |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
505 |
__regid__ = 'dummy-before-hook' |
5877
0c7b7b76a84f
[selectors] provide a new, optimized, is_instance selector that should at some point replace implements (along with the adaptable selector)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5717
diff
changeset
|
506 |
__select__ = Hook.__select__ & is_instance('EmailAddress') |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
507 |
events = ('before_update_entity',) |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
508 |
def __call__(self): |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
509 |
# safety belt: avoid potential infinite recursion if the test |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
510 |
# fails (i.e. RuntimeError not raised) |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
511 |
pendings = self._cw.transaction_data.setdefault('pending', set()) |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
512 |
if self.entity.eid not in pendings: |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
513 |
pendings.add(self.entity.eid) |
8483
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
514 |
self.entity.cw_set(alias=u'foo') |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
515 |
|
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
516 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
517 |
with self.temporary_appobjects(DummyBeforeHook): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
518 |
addr = cnx.create_entity('EmailAddress', address=u'a@b.fr') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
519 |
addr.cw_set(address=u'a@b.com') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
520 |
rset = cnx.execute('Any A,AA WHERE X eid %(x)s, X address A, X alias AA', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
521 |
{'x': addr.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
522 |
self.assertEqual(rset.rows, [[u'a@b.com', u'foo']]) |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
523 |
|
8483
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
524 |
def test_cw_set_in_before_add(self): |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
525 |
# local hook |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
526 |
class DummyBeforeHook(Hook): |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
527 |
__regid__ = 'dummy-before-hook' |
5877
0c7b7b76a84f
[selectors] provide a new, optimized, is_instance selector that should at some point replace implements (along with the adaptable selector)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5717
diff
changeset
|
528 |
__select__ = Hook.__select__ & is_instance('EmailAddress') |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
529 |
events = ('before_add_entity',) |
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
530 |
def __call__(self): |
8483
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
531 |
# cw_set is forbidden within before_add_entity() |
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
532 |
self.entity.cw_set(alias=u'foo') |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
533 |
|
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
534 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
535 |
with self.temporary_appobjects(DummyBeforeHook): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
536 |
# XXX will fail with python -O |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
537 |
self.assertRaises(AssertionError, cnx.create_entity, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
538 |
'EmailAddress', address=u'a@b.fr') |
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
539 |
|
8483
4ba11607d84a
[entity api] unify set_attributes / set_relations into a cw_set method. Closes #2423719
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8388
diff
changeset
|
540 |
def test_multiple_edit_cw_set(self): |
6142
8bc6eac1fac1
[session] cleanup hook / operation / entity edition api
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6030
diff
changeset
|
541 |
"""make sure cw_edited doesn't get cluttered |
5213
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
542 |
by previous entities on multiple set |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
543 |
""" |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
544 |
# local hook |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
545 |
class DummyBeforeHook(Hook): |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
546 |
_test = self # keep reference to test instance |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
547 |
__regid__ = 'dummy-before-hook' |
5877
0c7b7b76a84f
[selectors] provide a new, optimized, is_instance selector that should at some point replace implements (along with the adaptable selector)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5717
diff
changeset
|
548 |
__select__ = Hook.__select__ & is_instance('Affaire') |
5213
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
549 |
events = ('before_update_entity',) |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
550 |
def __call__(self): |
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
551 |
# invoiced attribute shouldn't be considered "edited" before the hook |
7791
31bb51ea5485
[deprecation] fix unittest pending deprecation warnings on failIf/failUnless methods family
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7723
diff
changeset
|
552 |
self._test.assertFalse('invoiced' in self.entity.cw_edited, |
6142
8bc6eac1fac1
[session] cleanup hook / operation / entity edition api
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6030
diff
changeset
|
553 |
'cw_edited cluttered by previous update') |
8bc6eac1fac1
[session] cleanup hook / operation / entity edition api
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6030
diff
changeset
|
554 |
self.entity.cw_edited['invoiced'] = 10 |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
555 |
|
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
556 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
557 |
with self.temporary_appobjects(DummyBeforeHook): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
558 |
cnx.create_entity('Affaire', ref=u'AFF01') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
559 |
cnx.create_entity('Affaire', ref=u'AFF02') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
560 |
cnx.execute('SET A duration 10 WHERE A is Affaire') |
5213
8604000bf3b2
[repository] fix edited_attributes management in multiple SET queries
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
5126
diff
changeset
|
561 |
|
9226
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
562 |
|
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
563 |
def test_user_friendly_error(self): |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
564 |
from cubicweb.entities.adapters import IUserFriendlyUniqueTogether |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
565 |
class MyIUserFriendlyUniqueTogether(IUserFriendlyUniqueTogether): |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
566 |
__select__ = IUserFriendlyUniqueTogether.__select__ & is_instance('Societe') |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
567 |
def raise_user_exception(self): |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
568 |
raise ValidationError(self.entity.eid, {'hip': 'hop'}) |
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
569 |
|
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
570 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
571 |
with self.temporary_appobjects(MyIUserFriendlyUniqueTogether): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
572 |
s = cnx.create_entity('Societe', nom=u'Logilab', type=u'ssll', cp=u'75013') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
573 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
574 |
with self.assertRaises(ValidationError) as cm: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
575 |
cnx.create_entity('Societe', nom=u'Logilab', type=u'ssll', cp=u'75013') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
576 |
self.assertEqual(cm.exception.errors, {'hip': 'hop'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
577 |
cnx.rollback() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
578 |
cnx.create_entity('Societe', nom=u'Logilab', type=u'ssll', cp=u'31400') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
579 |
with self.assertRaises(ValidationError) as cm: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
580 |
s.cw_set(cp=u'31400') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
581 |
self.assertEqual(cm.exception.entity, s.eid) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
582 |
self.assertEqual(cm.exception.errors, {'hip': 'hop'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
583 |
cnx.rollback() |
9226
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
584 |
|
653f1d4a1101
[repository] properly use IUserFriendlyError when UniqueTogetherError is raised during entity update. Closes #3096638
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
9130
diff
changeset
|
585 |
|
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
586 |
class SchemaDeserialTC(CubicWebTC): |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
587 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
588 |
appid = 'data-schemaserial' |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
589 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
590 |
@classmethod |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
591 |
def setUpClass(cls): |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
592 |
register_base_type('BabarTestType', ('jungle_speed',)) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
593 |
helper = get_db_helper('sqlite') |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
594 |
helper.TYPE_MAPPING['BabarTestType'] = 'TEXT' |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
595 |
helper.TYPE_CONVERTERS['BabarTestType'] = lambda x: '"%s"' % x |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
596 |
super(SchemaDeserialTC, cls).setUpClass() |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
597 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
598 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
599 |
@classmethod |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
600 |
def tearDownClass(cls): |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
601 |
unregister_base_type('BabarTestType') |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
602 |
helper = get_db_helper('sqlite') |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
603 |
helper.TYPE_MAPPING.pop('BabarTestType', None) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
604 |
helper.TYPE_CONVERTERS.pop('BabarTestType', None) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
605 |
super(SchemaDeserialTC, cls).tearDownClass() |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
606 |
|
8947
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
607 |
def test_deserialization_base(self): |
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
608 |
"""Check the following deserialization |
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
609 |
|
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
610 |
* all CWEtype has name |
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
611 |
* Final type |
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
612 |
* CWUniqueTogetherConstraint |
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
613 |
* _unique_together__ content""" |
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
614 |
origshema = self.repo.schema |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
615 |
try: |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
616 |
self.repo.config.repairing = True # avoid versions checking |
8947
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
617 |
self.repo.set_schema(self.repo.deserialize_schema()) |
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
618 |
table = SQL_PREFIX + 'CWEType' |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
619 |
namecol = SQL_PREFIX + 'name' |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
620 |
finalcol = SQL_PREFIX + 'final' |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
621 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
622 |
with cnx.ensure_cnx_set: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
623 |
cu = cnx.system_sql('SELECT %s FROM %s WHERE %s is NULL' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
624 |
% (namecol, table, finalcol)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
625 |
self.assertEqual(cu.fetchall(), []) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
626 |
cu = cnx.system_sql('SELECT %s FROM %s ' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
627 |
'WHERE %s=%%(final)s ORDER BY %s' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
628 |
% (namecol, table, finalcol, namecol), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
629 |
{'final': True}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
630 |
self.assertEqual(cu.fetchall(), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
631 |
[(u'BabarTestType',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
632 |
(u'BigInt',), (u'Boolean',), (u'Bytes',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
633 |
(u'Date',), (u'Datetime',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
634 |
(u'Decimal',),(u'Float',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
635 |
(u'Int',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
636 |
(u'Interval',), (u'Password',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
637 |
(u'String',), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
638 |
(u'TZDatetime',), (u'TZTime',), (u'Time',)]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
639 |
sql = ("SELECT etype.cw_eid, etype.cw_name, cstr.cw_eid, rel.eid_to " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
640 |
"FROM cw_CWUniqueTogetherConstraint as cstr, " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
641 |
" relations_relation as rel, " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
642 |
" cw_CWEType as etype " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
643 |
"WHERE cstr.cw_eid = rel.eid_from " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
644 |
" AND cstr.cw_constraint_of = etype.cw_eid " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
645 |
" AND etype.cw_name = 'Personne' " |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
646 |
";") |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
647 |
cu = cnx.system_sql(sql) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
648 |
rows = cu.fetchall() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
649 |
self.assertEqual(len(rows), 3) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
650 |
person = self.repo.schema.eschema('Personne') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
651 |
self.assertEqual(len(person._unique_together), 1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
652 |
self.assertItemsEqual(person._unique_together[0], |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
653 |
('nom', 'prenom', 'inline2')) |
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
654 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
655 |
finally: |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
656 |
self.repo.set_schema(origshema) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
657 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
658 |
def test_custom_attribute_param(self): |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
659 |
origshema = self.repo.schema |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
660 |
try: |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
661 |
self.repo.config.repairing = True # avoid versions checking |
8947
3bbd416b09ec
[repo] straightforward bootstrap sequence. Closes #2841188
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
8945
diff
changeset
|
662 |
self.repo.set_schema(self.repo.deserialize_schema()) |
8945
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
663 |
pes = self.repo.schema['Personne'] |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
664 |
attr = pes.rdef('custom_field_of_jungle') |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
665 |
self.assertIn('jungle_speed', vars(attr)) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
666 |
self.assertEqual(42, attr.jungle_speed) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
667 |
finally: |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
668 |
self.repo.set_schema(origshema) |
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
669 |
|
ba9e3fbfa5a5
[schemaserial] serialize additional yams parameter for customs type
Vincent Michel <vincent.michel@logilab.fr>
parents:
8874
diff
changeset
|
670 |
|
5115
2e43ef618d14
[repository] forbid usage of set_attributes() in before_add_entity
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5106
diff
changeset
|
671 |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
672 |
class DataHelpersTC(CubicWebTC): |
1787 | 673 |
|
0 | 674 |
def test_type_from_eid(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
675 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
676 |
with cnx.ensure_cnx_set: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
677 |
self.assertEqual(self.repo.type_from_eid(2, cnx), 'CWGroup') |
1787 | 678 |
|
0 | 679 |
def test_type_from_eid_raise(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
680 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
681 |
with cnx.ensure_cnx_set: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
682 |
self.assertRaises(UnknownEid, self.repo.type_from_eid, -2, cnx) |
1787 | 683 |
|
0 | 684 |
def test_add_delete_info(self): |
9802
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
685 |
with self.admin_access.repo_cnx() as cnx: |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
686 |
with cnx.ensure_cnx_set: |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
687 |
cnx.mode = 'write' |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
688 |
entity = self.repo.vreg['etypes'].etype_class('Personne')(cnx) |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
689 |
entity.eid = -1 |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
690 |
entity.complete = lambda x: None |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
691 |
self.repo.add_info(cnx, entity, self.repo.system_source) |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
692 |
cu = cnx.system_sql('SELECT * FROM entities WHERE eid = -1') |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
693 |
data = cu.fetchall() |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
694 |
self.assertEqual(tuplify(data), [(-1, 'Personne', 'system', None)]) |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
695 |
self.repo.delete_info(cnx, entity, 'system') |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
696 |
#self.repo.commit() |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
697 |
cu = cnx.system_sql('SELECT * FROM entities WHERE eid = -1') |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
698 |
data = cu.fetchall() |
9f815b1f2516
[repository,tests] use the new connection api (part 1/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9469
diff
changeset
|
699 |
self.assertEqual(data, []) |
0 | 700 |
|
701 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
702 |
class FTITC(CubicWebTC): |
1787 | 703 |
|
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
704 |
def test_fulltext_container_entity(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
705 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
706 |
assert self.schema.rschema('use_email').fulltext_container == 'subject' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
707 |
toto = cnx.create_entity('EmailAddress', address=u'toto@logilab.fr') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
708 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
709 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
710 |
self.assertEqual(rset.rows, []) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
711 |
cnx.user.cw_set(use_email=toto) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
712 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
713 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
714 |
self.assertEqual(rset.rows, [[cnx.user.eid]]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
715 |
cnx.execute('DELETE X use_email Y WHERE X login "admin", Y eid %(y)s', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
716 |
{'y': toto.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
717 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
718 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
719 |
self.assertEqual(rset.rows, []) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
720 |
tutu = cnx.create_entity('EmailAddress', address=u'tutu@logilab.fr') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
721 |
cnx.user.cw_set(use_email=tutu) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
722 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
723 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'tutu'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
724 |
self.assertEqual(rset.rows, [[cnx.user.eid]]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
725 |
tutu.cw_set(address=u'hip@logilab.fr') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
726 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
727 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'tutu'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
728 |
self.assertEqual(rset.rows, []) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
729 |
rset = cnx.execute('Any X WHERE X has_text %(t)s', {'t': 'hip'}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
730 |
self.assertEqual(rset.rows, [[cnx.user.eid]]) |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
731 |
|
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
732 |
def test_no_uncessary_ftiindex_op(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
733 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
734 |
cnx.create_entity('Workflow', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
735 |
name=u'dummy workflow', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
736 |
description=u'huuuuu') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
737 |
self.assertFalse(any(x for x in cnx.pending_operations |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
738 |
if isinstance(x, native.FTIndexEntityOp))) |
1787 | 739 |
|
740 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
741 |
class DBInitTC(CubicWebTC): |
1787 | 742 |
|
0 | 743 |
def test_versions_inserted(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
744 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
745 |
inserted = [r[0] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
746 |
for r in cnx.execute('Any K ORDERBY K ' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
747 |
'WHERE P pkey K, P pkey ~= "system.version.%"')] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
748 |
self.assertEqual(inserted, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
749 |
[u'system.version.basket', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
750 |
u'system.version.card', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
751 |
u'system.version.comment', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
752 |
u'system.version.cubicweb', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
753 |
u'system.version.email', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
754 |
u'system.version.file', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
755 |
u'system.version.folder', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
756 |
u'system.version.localperms', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
757 |
u'system.version.tag']) |
1787 | 758 |
|
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
759 |
CALLED = [] |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
760 |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
761 |
class InlineRelHooksTC(CubicWebTC): |
0 | 762 |
"""test relation hooks are called for inlined relations |
763 |
""" |
|
764 |
def setUp(self): |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
765 |
CubicWebTC.setUp(self) |
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
766 |
CALLED[:] = () |
0 | 767 |
|
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
768 |
def test_inline_relation(self): |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
769 |
"""make sure <event>_relation hooks are called for inlined relation""" |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
770 |
|
4766
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
771 |
class EcritParHook(hook.Hook): |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
772 |
__regid__ = 'inlinedrelhook' |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
773 |
__select__ = hook.Hook.__select__ & hook.match_rtype('ecrit_par') |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
774 |
events = ('before_add_relation', 'after_add_relation', |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
775 |
'before_delete_relation', 'after_delete_relation') |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
776 |
def __call__(self): |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
777 |
CALLED.append((self.event, self.eidfrom, self.rtype, self.eidto)) |
162b2b127b15
[test] get a chance to get proper garbage collection when running pytest on whole cw
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
778 |
|
5105
57e0fc953676
[test] use new temporary_appobjects context manager
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
5103
diff
changeset
|
779 |
with self.temporary_appobjects(EcritParHook): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
780 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
781 |
eidp = cnx.execute('INSERT Personne X: X nom "toto"')[0][0] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
782 |
eidn = cnx.execute('INSERT Note X: X type "T"')[0][0] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
783 |
cnx.execute('SET N ecrit_par Y WHERE N type "T", Y nom "toto"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
784 |
self.assertEqual(CALLED, [('before_add_relation', eidn, 'ecrit_par', eidp), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
785 |
('after_add_relation', eidn, 'ecrit_par', eidp)]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
786 |
CALLED[:] = () |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
787 |
cnx.execute('DELETE N ecrit_par Y WHERE N type "T", Y nom "toto"') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
788 |
self.assertEqual(CALLED, [('before_delete_relation', eidn, 'ecrit_par', eidp), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
789 |
('after_delete_relation', eidn, 'ecrit_par', eidp)]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
790 |
CALLED[:] = () |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
791 |
eidn = cnx.execute('INSERT Note N: N ecrit_par P WHERE P nom "toto"')[0][0] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
792 |
self.assertEqual(CALLED, [('before_add_relation', eidn, 'ecrit_par', eidp), |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
793 |
('after_add_relation', eidn, 'ecrit_par', eidp)]) |
0 | 794 |
|
6236
9138f23ee263
[repo tests] add test case for RQLUniqueConstraint
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
6208
diff
changeset
|
795 |
def test_unique_contraint(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
796 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
797 |
toto = cnx.create_entity('Personne', nom=u'toto') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
798 |
a01 = cnx.create_entity('Affaire', ref=u'A01', todo_by=toto) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
799 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
800 |
cnx.create_entity('Note', type=u'todo', inline1=a01) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
801 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
802 |
cnx.create_entity('Note', type=u'todo', inline1=a01) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
803 |
with self.assertRaises(ValidationError) as cm: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
804 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
805 |
self.assertEqual(cm.exception.errors, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
806 |
{'inline1-subject': u'RQLUniqueConstraint S type T, S inline1 A1, ' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
807 |
'A1 todo_by C, Y type T, Y inline1 A2, A2 todo_by C failed'}) |
1787 | 808 |
|
7238
576abb8c4626
fix implementation of repository.glob_add_relations (closes ##1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7237
diff
changeset
|
809 |
def test_add_relations_at_creation_with_del_existing_rel(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
810 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
811 |
person = cnx.create_entity('Personne', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
812 |
nom=u'Toto', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
813 |
prenom=u'Lanturlu', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
814 |
sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
815 |
users_rql = 'Any U WHERE U is CWGroup, U name "users"' |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
816 |
users = cnx.execute(users_rql).get_entity(0, 0) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
817 |
cnx.create_entity('CWUser', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
818 |
login=u'Toto', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
819 |
upassword=u'firstname', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
820 |
firstname=u'firstname', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
821 |
surname=u'surname', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
822 |
reverse_login_user=person, |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
823 |
in_group=users) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
824 |
cnx.commit() |
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
825 |
|
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
826 |
|
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
827 |
class PerformanceTest(CubicWebTC): |
7381
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
828 |
def setUp(self): |
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
829 |
super(PerformanceTest, self).setUp() |
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
830 |
logger = logging.getLogger('cubicweb.session') |
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
831 |
#logger.handlers = [logging.StreamHandler(sys.stdout)] |
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
832 |
logger.setLevel(logging.INFO) |
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
833 |
self.info = logger.info |
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
834 |
|
7381
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
835 |
def tearDown(self): |
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
836 |
super(PerformanceTest, self).tearDown() |
7382
91061a22755d
fix name error introduced in previous changeset
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7381
diff
changeset
|
837 |
logger = logging.getLogger('cubicweb.session') |
7381
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
838 |
logger.setLevel(logging.CRITICAL) |
a10b2d90d1a3
[server test] restore logging level after test end
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
839 |
|
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
840 |
def test_composite_deletion(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
841 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
842 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
843 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
844 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
845 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
846 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
847 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
848 |
for j in xrange(0, 2000, 100): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
849 |
abraham.cw_set(personne_composite=personnes[j:j+100]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
850 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
851 |
self.info('creation: %.2gs', (t1 - t0)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
852 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
853 |
t2 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
854 |
self.info('commit creation: %.2gs', (t2 - t1)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
855 |
cnx.execute('DELETE Personne P WHERE P eid %(eid)s', {'eid': abraham.eid}) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
856 |
t3 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
857 |
self.info('deletion: %.2gs', (t3 - t2)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
858 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
859 |
t4 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
860 |
self.info("commit deletion: %2gs", (t4 - t3)) |
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
861 |
|
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
862 |
def test_add_relation_non_inlined(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
863 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
864 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
865 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
866 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
867 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
868 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
869 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
870 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
871 |
personne_composite=personnes[:100]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
872 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
873 |
self.info('creation: %.2gs', (t1 - t0)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
874 |
for j in xrange(100, 2000, 100): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
875 |
abraham.cw_set(personne_composite=personnes[j:j+100]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
876 |
t2 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
877 |
self.info('more relations: %.2gs', (t2-t1)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
878 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
879 |
t3 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
880 |
self.info('commit creation: %.2gs', (t3 - t2)) |
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
881 |
|
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
882 |
def test_add_relation_inlined(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
883 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
884 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
885 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
886 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
887 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
888 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
889 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
890 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M', |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
891 |
personne_inlined=personnes[:100]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
892 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
893 |
self.info('creation: %.2gs', (t1 - t0)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
894 |
for j in xrange(100, 2000, 100): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
895 |
abraham.cw_set(personne_inlined=personnes[j:j+100]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
896 |
t2 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
897 |
self.info('more relations: %.2gs', (t2-t1)) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
898 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
899 |
t3 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
900 |
self.info('commit creation: %.2gs', (t3 - t2)) |
7236
b91205ada414
added test case to monitor speed improvements in the repository code.
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7194
diff
changeset
|
901 |
|
7237
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
902 |
|
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
903 |
def test_session_add_relation(self): |
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
904 |
""" to be compared with test_session_add_relations""" |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
905 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
906 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
907 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
908 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
909 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
910 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
911 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
912 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
913 |
add_relation = cnx.add_relation |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
914 |
for p in personnes: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
915 |
add_relation(abraham.eid, 'personne_composite', p.eid) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
916 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
917 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
918 |
self.info('add relation: %.2gs', t1-t0) |
7237
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
919 |
|
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
920 |
def test_session_add_relations (self): |
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
921 |
""" to be compared with test_session_add_relation""" |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
922 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
923 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
924 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
925 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
926 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
927 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
928 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
929 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
930 |
add_relations = cnx.add_relations |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
931 |
relations = [('personne_composite', [(abraham.eid, p.eid) for p in personnes])] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
932 |
add_relations(relations) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
933 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
934 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
935 |
self.info('add relations: %.2gs', t1-t0) |
7543
570522300e22
[ms, entity metas] add 'actual source' to entities table / base entity metadata cache. Closes #1767090
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7539
diff
changeset
|
936 |
|
7237
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
937 |
def test_session_add_relation_inlined(self): |
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
938 |
""" to be compared with test_session_add_relations""" |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
939 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
940 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
941 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
942 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
943 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
944 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
945 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
946 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
947 |
add_relation = cnx.add_relation |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
948 |
for p in personnes: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
949 |
add_relation(abraham.eid, 'personne_inlined', p.eid) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
950 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
951 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
952 |
self.info('add relation (inlined): %.2gs', t1-t0) |
7237
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
953 |
|
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
954 |
def test_session_add_relations_inlined (self): |
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
955 |
""" to be compared with test_session_add_relation""" |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
956 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
957 |
personnes = [] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
958 |
for i in xrange(2000): |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
959 |
p = cnx.create_entity('Personne', nom=u'Doe%03d'%i, prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
960 |
personnes.append(p) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
961 |
abraham = cnx.create_entity('Personne', nom=u'Abraham', prenom=u'John', sexe=u'M') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
962 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
963 |
t0 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
964 |
add_relations = cnx.add_relations |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
965 |
relations = [('personne_inlined', [(abraham.eid, p.eid) for p in personnes])] |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
966 |
add_relations(relations) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
967 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
968 |
t1 = time.time() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
969 |
self.info('add relations (inlined): %.2gs', t1-t0) |
7237
9f619715665b
[server] improve the speed of setting relations between entities (closes #1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7236
diff
changeset
|
970 |
|
7513
8f4422391e5a
[repo integrity] test and fix glob add relation where several entities are added at once for a relation of 1? cardinality
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
971 |
def test_optional_relation_reset_1(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
972 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
973 |
p1 = cnx.create_entity('Personne', nom=u'Vincent') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
974 |
p2 = cnx.create_entity('Personne', nom=u'Florent') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
975 |
w = cnx.create_entity('Affaire', ref=u'wc') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
976 |
w.cw_set(todo_by=[p1,p2]) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
977 |
w.cw_clear_all_caches() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
978 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
979 |
self.assertEqual(len(w.todo_by), 1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
980 |
self.assertEqual(w.todo_by[0].eid, p2.eid) |
7513
8f4422391e5a
[repo integrity] test and fix glob add relation where several entities are added at once for a relation of 1? cardinality
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
981 |
|
8f4422391e5a
[repo integrity] test and fix glob add relation where several entities are added at once for a relation of 1? cardinality
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
7343
diff
changeset
|
982 |
def test_optional_relation_reset_2(self): |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
983 |
with self.admin_access.repo_cnx() as cnx: |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
984 |
p1 = cnx.create_entity('Personne', nom=u'Vincent') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
985 |
p2 = cnx.create_entity('Personne', nom=u'Florent') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
986 |
w = cnx.create_entity('Affaire', ref=u'wc') |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
987 |
w.cw_set(todo_by=p1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
988 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
989 |
w.cw_set(todo_by=p2) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
990 |
w.cw_clear_all_caches() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
991 |
cnx.commit() |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
992 |
self.assertEqual(len(w.todo_by), 1) |
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
993 |
self.assertEqual(w.todo_by[0].eid, p2.eid) |
7238
576abb8c4626
fix implementation of repository.glob_add_relations (closes ##1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7237
diff
changeset
|
994 |
|
576abb8c4626
fix implementation of repository.glob_add_relations (closes ##1625257)
Alexandre Fayolle <alexandre.fayolle@logilab.fr>
parents:
7237
diff
changeset
|
995 |
|
0 | 996 |
if __name__ == '__main__': |
9803
5bd395e9649a
[tests/repository] use the new connection api (part 2/2)
Aurelien Campeas <aurelien.campeas@logilab.fr>
parents:
9802
diff
changeset
|
997 |
from logilab.common.testlib import unittest_main |
0 | 998 |
unittest_main() |