author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
Wed, 17 Mar 2010 09:21:58 +0100 | |
branch | stable |
changeset 4928 | cbca73dc9753 |
parent 4806 | 4f12f59b1a13 |
child 4808 | 23df4a120c96 |
permissions | -rw-r--r-- |
0 | 1 |
# -*- coding: iso-8859-1 -*- |
1977
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
2 |
"""unit tests for module cubicweb.server.repository |
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
3 |
|
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
4 |
:organization: Logilab |
4212
ab6573088b4a
update copyright: welcome 2010
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
3771
diff
changeset
|
5 |
:copyright: 2001-2010 LOGILAB S.A. (Paris, FRANCE), license is LGPL v2. |
1977
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
6 |
:contact: http://www.logilab.fr/ -- mailto:contact@logilab.fr |
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
7 |
:license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses |
606923dff11b
big bunch of copyright / docstring update
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
1954
diff
changeset
|
8 |
""" |
0 | 9 |
|
10 |
import os |
|
11 |
import sys |
|
12 |
import threading |
|
13 |
import time |
|
14 |
from copy import deepcopy |
|
1016
26387b836099
use datetime instead of mx.DateTime
sylvain.thenault@logilab.fr
parents:
17
diff
changeset
|
15 |
from datetime import datetime |
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
|
16 |
|
0 | 17 |
from logilab.common.testlib import TestCase, unittest_main |
18 |
||
19 |
from yams.constraints import UniqueConstraint |
|
20 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
21 |
from cubicweb import (BadConnectionId, RepositoryError, ValidationError, |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
22 |
UnknownEid, AuthenticationError) |
0 | 23 |
from cubicweb.schema import CubicWebSchema, RQLConstraint |
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
|
24 |
from cubicweb.dbapi import connect, repo_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
|
25 |
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
|
26 |
from cubicweb.devtools.repotest import tuplify |
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
27 |
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
|
28 |
from cubicweb.server.sqlutils import SQL_PREFIX |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
29 |
from cubicweb.server.sources import native |
0 | 30 |
|
31 |
# start name server anyway, process will fail if already running |
|
32 |
os.system('pyro-ns >/dev/null 2>/dev/null &') |
|
33 |
||
34 |
||
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 |
class RepositoryTC(CubicWebTC): |
0 | 36 |
""" singleton providing access to a persistent storage for entities |
37 |
and relation |
|
38 |
""" |
|
1787 | 39 |
|
0 | 40 |
def test_fill_schema(self): |
41 |
self.repo.schema = CubicWebSchema(self.repo.config.appid) |
|
42 |
self.repo.config._cubes = None # avoid assertion error |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
43 |
self.repo.config.repairing = True # avoid versions checking |
0 | 44 |
self.repo.fill_schema() |
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
45 |
table = SQL_PREFIX + 'CWEType' |
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
|
46 |
namecol = SQL_PREFIX + 'name' |
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
|
47 |
finalcol = SQL_PREFIX + 'final' |
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
48 |
self.session.set_pool() |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
49 |
cu = self.session.system_sql('SELECT %s FROM %s WHERE %s is NULL' % ( |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
50 |
namecol, table, finalcol)) |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
51 |
self.assertEquals(cu.fetchall(), []) |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
52 |
cu = self.session.system_sql('SELECT %s FROM %s WHERE %s=%%(final)s ORDER BY %s' |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
53 |
% (namecol, table, finalcol, namecol), {'final': 'TRUE'}) |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
54 |
self.assertEquals(cu.fetchall(), [(u'Boolean',), (u'Bytes',), |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
55 |
(u'Date',), (u'Datetime',), |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
56 |
(u'Decimal',),(u'Float',), |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
57 |
(u'Int',), |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
58 |
(u'Interval',), (u'Password',), |
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
59 |
(u'String',), (u'Time',)]) |
1787 | 60 |
|
0 | 61 |
def test_schema_has_owner(self): |
62 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
63 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
64 |
self.failIf(repo.execute(cnxid, 'CWEType X WHERE NOT X owned_by U')) |
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
65 |
self.failIf(repo.execute(cnxid, 'CWRType X WHERE NOT X owned_by U')) |
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
66 |
self.failIf(repo.execute(cnxid, 'CWAttribute X WHERE NOT X owned_by U')) |
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
67 |
self.failIf(repo.execute(cnxid, 'CWRelation X WHERE NOT X owned_by U')) |
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
68 |
self.failIf(repo.execute(cnxid, 'CWConstraint X WHERE NOT X owned_by U')) |
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
69 |
self.failIf(repo.execute(cnxid, 'CWConstraintType X WHERE NOT X owned_by U')) |
1787 | 70 |
|
0 | 71 |
def test_connect(self): |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
72 |
self.assert_(self.repo.connect(self.admlogin, password=self.admpassword)) |
0 | 73 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
74 |
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
|
75 |
self.assertRaises(AuthenticationError, |
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
76 |
self.repo.connect, self.admlogin, password=None) |
0 | 77 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
78 |
self.repo.connect, None, password=None) |
0 | 79 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
80 |
self.repo.connect, self.admlogin) |
0 | 81 |
self.assertRaises(AuthenticationError, |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
82 |
self.repo.connect, None) |
1787 | 83 |
|
0 | 84 |
def test_execute(self): |
85 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
86 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 87 |
repo.execute(cnxid, 'Any X') |
88 |
repo.execute(cnxid, 'Any X where X is Personne') |
|
89 |
repo.execute(cnxid, 'Any X where X is Personne, X nom ~= "to"') |
|
90 |
repo.execute(cnxid, 'Any X WHERE X has_text %(text)s', {'text': u'\xe7a'}) |
|
91 |
repo.close(cnxid) |
|
1787 | 92 |
|
0 | 93 |
def test_login_upassword_accent(self): |
94 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
95 |
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
|
96 |
repo.execute(cnxid, 'INSERT CWUser X: X login %(login)s, X upassword %(passwd)s, X in_group G WHERE G name "users"', |
0 | 97 |
{'login': u"barnab�", 'passwd': u"h�h�h�".encode('UTF8')}) |
98 |
repo.commit(cnxid) |
|
99 |
repo.close(cnxid) |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
100 |
self.assert_(repo.connect(u"barnab�", password=u"h�h�h�".encode('UTF8'))) |
1787 | 101 |
|
0 | 102 |
def test_invalid_entity_rollback(self): |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
103 |
cnxid = self.repo.connect(self.admlogin, password=self.admpassword) |
1787 | 104 |
# no group |
3771 | 105 |
self.repo.execute(cnxid, |
106 |
'INSERT CWUser X: X login %(login)s, X upassword %(passwd)s', |
|
107 |
{'login': u"tutetute", 'passwd': 'tutetute'}) |
|
108 |
self.assertRaises(ValidationError, self.repo.commit, cnxid) |
|
109 |
self.failIf(self.repo.execute(cnxid, 'CWUser X WHERE X login "tutetute"')) |
|
1787 | 110 |
|
0 | 111 |
def test_close(self): |
112 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
113 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 114 |
self.assert_(cnxid) |
115 |
repo.close(cnxid) |
|
116 |
self.assertRaises(BadConnectionId, repo.execute, cnxid, 'Any X') |
|
1787 | 117 |
|
0 | 118 |
def test_invalid_cnxid(self): |
119 |
self.assertRaises(BadConnectionId, self.repo.execute, 0, 'Any X') |
|
120 |
self.assertRaises(BadConnectionId, self.repo.close, None) |
|
1787 | 121 |
|
0 | 122 |
def test_shared_data(self): |
123 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
124 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 125 |
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
|
126 |
cnxid2 = repo.connect(self.admlogin, password=self.admpassword) |
0 | 127 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), 4) |
128 |
self.assertEquals(repo.get_shared_data(cnxid2, 'data'), None) |
|
129 |
repo.set_shared_data(cnxid2, 'data', 5) |
|
130 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), 4) |
|
131 |
self.assertEquals(repo.get_shared_data(cnxid2, 'data'), 5) |
|
132 |
repo.get_shared_data(cnxid2, 'data', pop=True) |
|
133 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), 4) |
|
134 |
self.assertEquals(repo.get_shared_data(cnxid2, 'data'), None) |
|
135 |
repo.close(cnxid) |
|
136 |
repo.close(cnxid2) |
|
137 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid, 'data') |
|
138 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid2, 'data') |
|
139 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid, 'data', 1) |
|
140 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid2, 'data', 1) |
|
141 |
||
142 |
def test_check_session(self): |
|
143 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
144 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 145 |
self.assertEquals(repo.check_session(cnxid), None) |
146 |
repo.close(cnxid) |
|
147 |
self.assertRaises(BadConnectionId, repo.check_session, cnxid) |
|
148 |
||
149 |
def test_transaction_base(self): |
|
150 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
151 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 152 |
# check db state |
153 |
result = repo.execute(cnxid, 'Personne X') |
|
154 |
self.assertEquals(result.rowcount, 0) |
|
155 |
# rollback entity insertion |
|
156 |
repo.execute(cnxid, "INSERT Personne X: X nom 'bidule'") |
|
157 |
result = repo.execute(cnxid, 'Personne X') |
|
158 |
self.assertEquals(result.rowcount, 1) |
|
159 |
repo.rollback(cnxid) |
|
160 |
result = repo.execute(cnxid, 'Personne X') |
|
161 |
self.assertEquals(result.rowcount, 0, result.rows) |
|
162 |
# commit |
|
163 |
repo.execute(cnxid, "INSERT Personne X: X nom 'bidule'") |
|
164 |
repo.commit(cnxid) |
|
165 |
result = repo.execute(cnxid, 'Personne X') |
|
166 |
self.assertEquals(result.rowcount, 1) |
|
167 |
||
168 |
def test_transaction_base2(self): |
|
169 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
170 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 171 |
# rollback relation insertion |
172 |
repo.execute(cnxid, "SET U in_group G WHERE U login 'admin', G name 'guests'") |
|
173 |
result = repo.execute(cnxid, "Any U WHERE U in_group G, U login 'admin', G name 'guests'") |
|
174 |
self.assertEquals(result.rowcount, 1) |
|
175 |
repo.rollback(cnxid) |
|
176 |
result = repo.execute(cnxid, "Any U WHERE U in_group G, U login 'admin', G name 'guests'") |
|
177 |
self.assertEquals(result.rowcount, 0, result.rows) |
|
1787 | 178 |
|
0 | 179 |
def test_transaction_base3(self): |
180 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
181 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 182 |
# rollback state change which trigger TrInfo insertion |
2920
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
183 |
user = repo._get_session(cnxid).user |
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
184 |
user.fire_transition('deactivate') |
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
185 |
rset = repo.execute(cnxid, 'TrInfo T WHERE T wf_info_for X, X eid %(x)s', {'x': user.eid}) |
0 | 186 |
self.assertEquals(len(rset), 1) |
187 |
repo.rollback(cnxid) |
|
2920
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
188 |
rset = repo.execute(cnxid, 'TrInfo T WHERE T wf_info_for X, X eid %(x)s', {'x': user.eid}) |
64322aa83a1d
start a new workflow engine
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
189 |
self.assertEquals(len(rset), 0) |
1787 | 190 |
|
0 | 191 |
def test_transaction_interleaved(self): |
192 |
self.skip('implement me') |
|
193 |
||
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
|
194 |
def test_close_wait_processing_request(self): |
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
|
195 |
repo = self.repo |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
196 |
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
|
197 |
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
|
198 |
repo.commit(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
|
199 |
# 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
|
200 |
def 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
|
201 |
time.sleep(0.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
|
202 |
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
|
203 |
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
|
204 |
t.start() |
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
|
205 |
try: |
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
|
206 |
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
|
207 |
repo.commit(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
|
208 |
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
|
209 |
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
|
210 |
|
0 | 211 |
def test_initial_schema(self): |
212 |
schema = self.repo.schema |
|
213 |
# check order of attributes is respected |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
214 |
self.assertListEquals([r.type for r in schema.eschema('CWAttribute').ordered_relations() |
1787 | 215 |
if not r.type in ('eid', 'is', 'is_instance_of', 'identity', |
2608
21856eda34f6
[F repo tests] tests have to be updated:
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2588
diff
changeset
|
216 |
'creation_date', 'modification_date', 'cwuri', |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
217 |
'owned_by', 'created_by', |
4680
8a6bee838464
[test] update tests broken by changes on attributes permissions handling in yams (add/delete replaced by update
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4252
diff
changeset
|
218 |
'update_permission', 'read_permission')], |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
219 |
['relation_type', |
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
220 |
'from_entity', 'to_entity', |
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
221 |
'in_basket', 'constrained_by', |
1787 | 222 |
'cardinality', 'ordernum', |
0 | 223 |
'indexed', 'fulltextindexed', 'internationalizable', |
2608
21856eda34f6
[F repo tests] tests have to be updated:
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2588
diff
changeset
|
224 |
'defaultval', 'description', 'description_format']) |
0 | 225 |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
226 |
self.assertEquals(schema.eschema('CWEType').main_attribute(), 'name') |
0 | 227 |
self.assertEquals(schema.eschema('State').main_attribute(), 'name') |
228 |
||
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
229 |
constraints = schema.rschema('name').rdef('CWEType', 'String').constraints |
0 | 230 |
self.assertEquals(len(constraints), 2) |
231 |
for cstr in constraints[:]: |
|
232 |
if isinstance(cstr, UniqueConstraint): |
|
233 |
constraints.remove(cstr) |
|
234 |
break |
|
235 |
else: |
|
236 |
self.fail('unique constraint not found') |
|
237 |
sizeconstraint = constraints[0] |
|
238 |
self.assertEquals(sizeconstraint.min, None) |
|
239 |
self.assertEquals(sizeconstraint.max, 64) |
|
240 |
||
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
241 |
constraints = schema.rschema('relation_type').rdef('CWAttribute', 'CWRType').constraints |
0 | 242 |
self.assertEquals(len(constraints), 1) |
243 |
cstr = constraints[0] |
|
244 |
self.assert_(isinstance(cstr, RQLConstraint)) |
|
245 |
self.assertEquals(cstr.restriction, 'O final TRUE') |
|
246 |
||
247 |
ownedby = schema.rschema('owned_by') |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
248 |
self.assertEquals(ownedby.objects('CWEType'), ('CWUser',)) |
0 | 249 |
|
250 |
def test_pyro(self): |
|
251 |
import Pyro |
|
252 |
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
|
253 |
done = [] |
0 | 254 |
# the client part has to be in the thread due to sqlite limitations |
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 |
t = threading.Thread(target=self._pyro_client, args=(done,)) |
0 | 256 |
try: |
257 |
daemon = self.repo.pyro_register() |
|
258 |
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
|
259 |
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
|
260 |
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
|
261 |
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
|
262 |
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
|
263 |
self.fail('something went wrong, thread still alive') |
0 | 264 |
finally: |
265 |
repository.pyro_unregister(self.repo.config) |
|
1787 | 266 |
|
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
|
267 |
def _pyro_client(self, done): |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
268 |
cnx = connect(self.repo.config.appid, u'admin', password='gingkow') |
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
|
269 |
try: |
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
|
270 |
# 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
|
271 |
schema = cnx.get_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
|
272 |
self.assertEquals(schema.__hashmode__, None) |
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
|
273 |
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
|
274 |
rset = cu.execute('Any U,G WHERE U in_group G') |
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
|
275 |
cnx.close() |
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
|
276 |
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
|
277 |
finally: |
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
|
278 |
# connect monkey path some method by default, remove them |
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
|
279 |
multiple_connections_unfix() |
0 | 280 |
|
281 |
def test_internal_api(self): |
|
282 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
283 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 284 |
session = repo._get_session(cnxid, setpool=True) |
1954 | 285 |
self.assertEquals(repo.type_and_source_from_eid(1, session), |
286 |
('CWGroup', 'system', None)) |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
287 |
self.assertEquals(repo.type_from_eid(1, session), 'CWGroup') |
0 | 288 |
self.assertEquals(repo.source_from_eid(1, session).uri, 'system') |
289 |
self.assertEquals(repo.eid2extid(repo.system_source, 1, session), None) |
|
290 |
class dummysource: uri = 'toto' |
|
291 |
self.assertRaises(UnknownEid, repo.eid2extid, dummysource, 1, session) |
|
292 |
||
293 |
def test_public_api(self): |
|
294 |
self.assertEquals(self.repo.get_schema(), self.repo.schema) |
|
295 |
self.assertEquals(self.repo.source_defs(), {'system': {'adapter': 'native', 'uri': 'system'}}) |
|
296 |
# .properties() return a result set |
|
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
297 |
self.assertEquals(self.repo.properties().rql, 'Any K,V WHERE P is CWProperty,P pkey K, P value V, NOT P for_user U') |
0 | 298 |
|
299 |
def test_session_api(self): |
|
300 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
301 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 302 |
self.assertEquals(repo.user_info(cnxid), (5, 'admin', set([u'managers']), {})) |
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
303 |
self.assertEquals(repo.describe(cnxid, 1), (u'CWGroup', u'system', None)) |
0 | 304 |
repo.close(cnxid) |
305 |
self.assertRaises(BadConnectionId, repo.user_info, cnxid) |
|
306 |
self.assertRaises(BadConnectionId, repo.describe, cnxid, 1) |
|
307 |
||
308 |
def test_shared_data_api(self): |
|
309 |
repo = self.repo |
|
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
310 |
cnxid = repo.connect(self.admlogin, password=self.admpassword) |
0 | 311 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), None) |
312 |
repo.set_shared_data(cnxid, 'data', 4) |
|
313 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), 4) |
|
314 |
repo.get_shared_data(cnxid, 'data', pop=True) |
|
315 |
repo.get_shared_data(cnxid, 'whatever', pop=True) |
|
316 |
self.assertEquals(repo.get_shared_data(cnxid, 'data'), None) |
|
317 |
repo.close(cnxid) |
|
318 |
self.assertRaises(BadConnectionId, repo.set_shared_data, cnxid, 'data', 0) |
|
319 |
self.assertRaises(BadConnectionId, repo.get_shared_data, cnxid, 'data') |
|
1787 | 320 |
|
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
|
321 |
def test_schema_is_relation(self): |
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
|
322 |
no_is_rset = self.execute('Any X WHERE NOT X is ET') |
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
|
323 |
self.failIf(no_is_rset, no_is_rset.description) |
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
|
324 |
|
2642 | 325 |
# def test_perfo(self): |
326 |
# self.set_debug(True) |
|
327 |
# from time import time, clock |
|
328 |
# t, c = time(), clock() |
|
329 |
# try: |
|
330 |
# self.create_user('toto') |
|
331 |
# finally: |
|
332 |
# self.set_debug(False) |
|
333 |
# print 'test time: %.3f (time) %.3f (cpu)' % ((time() - t), clock() - c) |
|
334 |
||
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
|
335 |
def test_delete_if_singlecard1(self): |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
336 |
note = self.request().create_entity('Affaire') |
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
337 |
p1 = self.request().create_entity('Personne', nom=u'toto') |
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
|
338 |
self.execute('SET A todo_by P WHERE A eid %(x)s, P eid %(p)s', |
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
|
339 |
{'x': note.eid, 'p': p1.eid}) |
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
|
340 |
rset = self.execute('Any P WHERE A todo_by P, A eid %(x)s', |
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
|
341 |
{'x': note.eid}) |
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
|
342 |
self.assertEquals(len(rset), 1) |
4191
01638461d4b0
test update. All cw tests OK
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
3777
diff
changeset
|
343 |
p2 = self.request().create_entity('Personne', nom=u'tutu') |
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
|
344 |
self.execute('SET A todo_by P WHERE A eid %(x)s, P eid %(p)s', |
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
|
345 |
{'x': note.eid, 'p': p2.eid}) |
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
|
346 |
rset = self.execute('Any P WHERE A todo_by P, A eid %(x)s', |
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
|
347 |
{'x': note.eid}) |
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
|
348 |
self.assertEquals(len(rset), 1) |
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
|
349 |
self.assertEquals(rset.rows[0][0], p2.eid) |
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
|
350 |
|
0 | 351 |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
352 |
class DataHelpersTC(CubicWebTC): |
1787 | 353 |
|
0 | 354 |
def test_create_eid(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
|
355 |
self.session.set_pool() |
0 | 356 |
self.assert_(self.repo.system_source.create_eid(self.session)) |
357 |
||
358 |
def test_source_from_eid(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
|
359 |
self.session.set_pool() |
0 | 360 |
self.assertEquals(self.repo.source_from_eid(1, self.session), |
361 |
self.repo.sources_by_uri['system']) |
|
362 |
||
363 |
def test_source_from_eid_raise(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
|
364 |
self.session.set_pool() |
0 | 365 |
self.assertRaises(UnknownEid, self.repo.source_from_eid, -2, self.session) |
366 |
||
367 |
def test_type_from_eid(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
|
368 |
self.session.set_pool() |
1398
5fe84a5f7035
rename internal entity types to have CW prefix instead of E
sylvain.thenault@logilab.fr
parents:
1263
diff
changeset
|
369 |
self.assertEquals(self.repo.type_from_eid(1, self.session), 'CWGroup') |
1787 | 370 |
|
0 | 371 |
def test_type_from_eid_raise(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
|
372 |
self.session.set_pool() |
0 | 373 |
self.assertRaises(UnknownEid, self.repo.type_from_eid, -2, self.session) |
1787 | 374 |
|
0 | 375 |
def test_add_delete_info(self): |
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
|
376 |
entity = self.repo.vreg['etypes'].etype_class('Personne')(self.session) |
0 | 377 |
entity.eid = -1 |
378 |
entity.complete = lambda x: None |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
379 |
self.session.set_pool() |
0 | 380 |
self.repo.add_info(self.session, entity, self.repo.sources_by_uri['system']) |
2200
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
381 |
cu = self.session.system_sql('SELECT * FROM entities WHERE eid = -1') |
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
382 |
data = cu.fetchall() |
1016
26387b836099
use datetime instead of mx.DateTime
sylvain.thenault@logilab.fr
parents:
17
diff
changeset
|
383 |
self.assertIsInstance(data[0][3], datetime) |
0 | 384 |
data[0] = list(data[0]) |
385 |
data[0][3] = None |
|
386 |
self.assertEquals(tuplify(data), [(-1, 'Personne', 'system', None, None)]) |
|
387 |
self.repo.delete_info(self.session, -1) |
|
388 |
#self.repo.commit() |
|
2200
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
389 |
cu = self.session.system_sql('SELECT * FROM entities WHERE eid = -1') |
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
390 |
data = cu.fetchall() |
0 | 391 |
self.assertEquals(data, []) |
392 |
||
393 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
394 |
class FTITC(CubicWebTC): |
1787 | 395 |
|
0 | 396 |
def test_reindex_and_modified_since(self): |
397 |
eidp = self.execute('INSERT Personne X: X nom "toto", X prenom "tutu"')[0][0] |
|
398 |
self.commit() |
|
1016
26387b836099
use datetime instead of mx.DateTime
sylvain.thenault@logilab.fr
parents:
17
diff
changeset
|
399 |
ts = datetime.now() |
0 | 400 |
self.assertEquals(len(self.execute('Personne X WHERE X has_text "tutu"')), 1) |
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
401 |
self.session.set_pool() |
2200
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
402 |
cu = self.session.system_sql('SELECT mtime, eid FROM entities WHERE eid = %s' % eidp) |
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
403 |
omtime = cu.fetchone()[0] |
0 | 404 |
# our sqlite datetime adapter is ignore seconds fraction, so we have to |
405 |
# ensure update is done the next seconds |
|
406 |
time.sleep(1 - (ts.second - int(ts.second))) |
|
407 |
self.execute('SET X nom "tata" WHERE X eid %(x)s', {'x': eidp}, 'x') |
|
408 |
self.commit() |
|
409 |
self.assertEquals(len(self.execute('Personne X WHERE X has_text "tutu"')), 1) |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
410 |
self.session.set_pool() |
2200
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
411 |
cu = self.session.system_sql('SELECT mtime FROM entities WHERE eid = %s' % eidp) |
25bb65dc4559
test fixes, all server tests ok, except unittest_migractions (due to inter-tests-side-effects...)
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
1977
diff
changeset
|
412 |
mtime = cu.fetchone()[0] |
0 | 413 |
self.failUnless(omtime < mtime) |
414 |
self.commit() |
|
415 |
date, modified, deleted = self.repo.entities_modified_since(('Personne',), omtime) |
|
416 |
self.assertEquals(modified, [('Personne', eidp)]) |
|
417 |
self.assertEquals(deleted, []) |
|
418 |
date, modified, deleted = self.repo.entities_modified_since(('Personne',), mtime) |
|
419 |
self.assertEquals(modified, []) |
|
420 |
self.assertEquals(deleted, []) |
|
421 |
self.execute('DELETE Personne X WHERE X eid %(x)s', {'x': eidp}) |
|
422 |
self.commit() |
|
423 |
date, modified, deleted = self.repo.entities_modified_since(('Personne',), omtime) |
|
424 |
self.assertEquals(modified, []) |
|
425 |
self.assertEquals(deleted, [('Personne', eidp)]) |
|
426 |
||
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
427 |
def test_fulltext_container_entity(self): |
0 | 428 |
assert self.schema.rschema('use_email').fulltext_container == 'subject' |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
429 |
req = self.request() |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
430 |
toto = req.create_entity('EmailAddress', address=u'toto@logilab.fr') |
0 | 431 |
self.commit() |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
432 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
433 |
self.assertEquals(rset.rows, []) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
434 |
req.user.set_relations(use_email=toto) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
435 |
self.commit() |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
436 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
437 |
self.assertEquals(rset.rows, [[req.user.eid]]) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
438 |
req.execute('DELETE X use_email Y WHERE X login "admin", Y eid %(y)s', |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
439 |
{'y': toto.eid}) |
0 | 440 |
self.commit() |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
441 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'toto'}) |
0 | 442 |
self.assertEquals(rset.rows, []) |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
443 |
tutu = req.create_entity('EmailAddress', address=u'tutu@logilab.fr') |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
444 |
req.user.set_relations(use_email=tutu) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
445 |
self.commit() |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
446 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'tutu'}) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
447 |
self.assertEquals(rset.rows, [[req.user.eid]]) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
448 |
tutu.set_attributes(address=u'hip@logilab.fr') |
0 | 449 |
self.commit() |
4806
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
450 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'tutu'}) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
451 |
self.assertEquals(rset.rows, []) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
452 |
rset = req.execute('Any X WHERE X has_text %(t)s', {'t': 'hip'}) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
453 |
self.assertEquals(rset.rows, [[req.user.eid]]) |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
454 |
|
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
455 |
def test_no_uncessary_ftiindex_op(self): |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
456 |
req = self.request() |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
457 |
req.create_entity('Workflow', name=u'dummy workflow', description=u'huuuuu') |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
458 |
self.failIf(any(x for x in self.session.pending_operations |
4f12f59b1a13
[fti] refactor and fix full text indexation handling
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
4680
diff
changeset
|
459 |
if isinstance(x, native.FTIndexEntityOp))) |
1787 | 460 |
|
461 |
||
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
462 |
class DBInitTC(CubicWebTC): |
1787 | 463 |
|
0 | 464 |
def test_versions_inserted(self): |
465 |
inserted = [r[0] for r in self.execute('Any K ORDERBY K WHERE P pkey K, P pkey ~= "system.version.%"')] |
|
466 |
self.assertEquals(inserted, |
|
1787 | 467 |
[u'system.version.basket', u'system.version.card', u'system.version.comment', |
468 |
u'system.version.cubicweb', u'system.version.email', |
|
469 |
u'system.version.file', u'system.version.folder', |
|
17
62ce3e6126e0
work in progress: fix cubicweb/server tests
Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
parents:
0
diff
changeset
|
470 |
u'system.version.tag']) |
1787 | 471 |
|
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
472 |
CALLED = [] |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
473 |
class EcritParHook(hook.Hook): |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
474 |
__regid__ = 'inlinedrelhook' |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
475 |
__select__ = hook.Hook.__select__ & hook.match_rtype('ecrit_par') |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
476 |
events = ('before_add_relation', 'after_add_relation', |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
477 |
'before_delete_relation', 'after_delete_relation') |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
478 |
def __call__(self): |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
479 |
CALLED.append((self.event, self.eidfrom, self.rtype, self.eidto)) |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
480 |
|
2773
b2530e3e0afb
[testlib] #345052 and #344207: major test lib refactoring/cleanup + update usage
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2650
diff
changeset
|
481 |
class InlineRelHooksTC(CubicWebTC): |
0 | 482 |
"""test relation hooks are called for inlined relations |
483 |
""" |
|
484 |
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
|
485 |
CubicWebTC.setUp(self) |
0 | 486 |
self.hm = self.repo.hm |
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
487 |
CALLED[:] = () |
0 | 488 |
|
489 |
def _after_relation_hook(self, pool, fromeid, rtype, toeid): |
|
490 |
self.called.append((fromeid, rtype, toeid)) |
|
1787 | 491 |
|
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
492 |
def test_inline_relation(self): |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
493 |
"""make sure <event>_relation hooks are called for inlined relation""" |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
494 |
self.hm.register(EcritParHook) |
0 | 495 |
eidp = self.execute('INSERT Personne X: X nom "toto"')[0][0] |
496 |
eidn = self.execute('INSERT Note X: X type "T"')[0][0] |
|
497 |
self.execute('SET N ecrit_par Y WHERE N type "T", Y nom "toto"') |
|
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
498 |
self.assertEquals(CALLED, [('before_add_relation', eidn, 'ecrit_par', eidp), |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
499 |
('after_add_relation', eidn, 'ecrit_par', eidp)]) |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
500 |
CALLED[:] = () |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
501 |
self.execute('DELETE N ecrit_par Y WHERE N type "T", Y nom "toto"') |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
502 |
self.assertEquals(CALLED, [('before_delete_relation', eidn, 'ecrit_par', eidp), |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
503 |
('after_delete_relation', eidn, 'ecrit_par', eidp)]) |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
504 |
CALLED[:] = () |
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
|
505 |
eidn = self.execute('INSERT Note N: N ecrit_par P WHERE P nom "toto"')[0][0] |
3445
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
506 |
self.assertEquals(CALLED, [('before_add_relation', eidn, 'ecrit_par', eidp), |
32492e9e734b
update and simplify test
Sylvain Thénault <sylvain.thenault@logilab.fr>
parents:
2968
diff
changeset
|
507 |
('after_add_relation', eidn, 'ecrit_par', eidp)]) |
0 | 508 |
|
1787 | 509 |
|
0 | 510 |
if __name__ == '__main__': |
511 |
unittest_main() |