1 from cubicweb.devtools.apptest import EnvBasedTC |
1 from cubicweb.devtools.apptest import EnvBasedTC |
2 from cubicweb.web.views.searchrestriction import insert_attr_select_relation |
2 from cubicweb.web.facet import insert_attr_select_relation, prepare_facets_rqlst |
3 |
|
4 class ExtractFilterFieldsTC(EnvBasedTC): |
|
5 def test_relations_cleanup(self): |
|
6 self.skip('test needs to be updated (facet API changed)') |
|
7 # removing relation should be done in the table filter form but not |
|
8 # from the facets box |
|
9 rset = self.execute('Any X, S WHERE X in_state S') |
|
10 afielddefs, baserql, groupby, orderby = extract_filter_fields(rset, 0) |
|
11 afielddefs = [(getattr(r, 'r_type', r), role, type) for r, role, type, values in afielddefs] |
|
12 self.assertEquals(afielddefs, [('has_text', 'subject', 'rstring'), |
|
13 ('in_state', 'subject', 'eid')]) |
|
14 self.assertEquals(baserql, 'DISTINCT Any X,S') |
|
15 self.assertEquals(groupby, '') |
|
16 self.assertEquals(orderby, '') |
|
17 # test rql st state |
|
18 self.assertEquals(rset.syntax_tree().as_string(), 'Any X,S WHERE X in_state S') |
|
19 afielddefs, baserql, groupby, orderby = extract_filter_fields(rset, 0, removerels=False) |
|
20 afielddefs = [(getattr(r, 'r_type', r), role, type) for r, role, type, values in afielddefs] |
|
21 self.assertEquals(afielddefs, [('has_text', 'subject', 'rstring'), |
|
22 ('in_state', 'subject', 'eid')]) |
|
23 self.assertEquals(baserql, 'DISTINCT Any X,S WHERE X in_state S') |
|
24 |
3 |
25 |
4 |
26 class InsertAttrRelationTC(EnvBasedTC): |
5 class InsertAttrRelationTC(EnvBasedTC): |
27 def setUp(self): |
|
28 self.skip('test needs to be updated (facet API changed)') |
|
29 |
6 |
30 def parse(self, query): |
7 def parse(self, query): |
31 rqlst = self.vreg.parse(self.session, query) |
8 rqlst = self.vreg.parse(self.session, query) |
32 select = rqlst.children[0] |
9 select = rqlst.children[0] |
|
10 # XXX done in real life? |
33 select.remove_groups() |
11 select.remove_groups() |
34 return select |
12 return rqlst |
35 |
13 |
36 def _generate(self, select, rel, var, attr): |
14 def _generate(self, rqlst, rel, role, attr): |
37 return insert_attr_select_relation(select, select.defined_vars[var], 'subject', rel, attr) |
15 mainvar = prepare_facets_rqlst(rqlst)[0] |
|
16 insert_attr_select_relation(rqlst.children[0], mainvar, rel, role, attr) |
|
17 return rqlst.as_string() |
38 |
18 |
39 @property |
19 @property |
40 def select(self): |
20 def select(self): |
41 return self.parse('Any B,(NOW - CD),S,V,U,GROUP_CONCAT(TN),VN,P,CD,BMD ' |
21 return self.parse('Any B,(NOW - CD),S,V,U,GROUP_CONCAT(TN),VN,P,CD,BMD ' |
42 'GROUPBY B,CD,S,V,U,VN,P,BMD ' |
22 'GROUPBY B,CD,S,V,U,VN,P,BMD ' |
44 'B modification_date BMD, T? tags B, T name TN, ' |
24 'B modification_date BMD, T? tags B, T name TN, ' |
45 'V? bookmarked_by B, V title VN, B created_by U?, ' |
25 'V? bookmarked_by B, V title VN, B created_by U?, ' |
46 'B in_group P, P name "managers"') |
26 'B in_group P, P name "managers"') |
47 |
27 |
48 def test_1(self): |
28 def test_1(self): |
49 self.assertEquals(self._generate(self.select, 'in_state', 'S', 'name'), |
29 self.assertEquals(self._generate(self.select, 'in_state', 'subject', 'name'), |
50 "DISTINCT Any S,A ORDERBY A WHERE B in_state S, B in_group P, " |
30 "DISTINCT Any A,C ORDERBY C WHERE B in_group P, P name 'managers', " |
51 "P name 'managers', S name A, B is EUser") |
31 "B in_state A, A name C, B is EUser") |
52 |
32 |
53 def test_2(self): |
33 def test_2(self): |
54 self.assertEquals(self._generate(self.select, 'tags', 'T', 'name'), |
34 self.assertEquals(self._generate(self.select, 'tags', 'object', 'name'), |
55 "DISTINCT Any T,TN ORDERBY TN WHERE T tags B, T name TN, " |
35 "DISTINCT Any A,C ORDERBY C WHERE B in_group P, P name 'managers', " |
56 "B in_group P, P name 'managers', B is EUser") |
36 "A tags B, A name C, B is EUser") |
57 |
37 |
58 def test_3(self): |
38 def test_3(self): |
59 self.assertEquals(self._generate(self.select, 'created_by', 'U', 'login'), |
39 self.assertEquals(self._generate(self.select, 'created_by', 'subject', 'login'), |
60 "DISTINCT Any U,A ORDERBY A WHERE B created_by U, B in_group P, " |
40 "DISTINCT Any A,C ORDERBY C WHERE B in_group P, P name 'managers', " |
61 "P name 'managers', U login A, B is EUser") |
41 "B created_by A, A login C, B is EUser") |
|
42 |
|
43 def test_4(self): |
|
44 self.assertEquals(self._generate(self.parse('Any X WHERE X is EUser'), 'created_by', 'subject', 'login'), |
|
45 "DISTINCT Any A,B ORDERBY B WHERE X is EUser, X created_by A, A login B") |
|
46 |
|
47 def test_5(self): |
|
48 self.assertEquals(self._generate(self.parse('Any X,L WHERE X is EUser, X login L'), 'created_by', 'subject', 'login'), |
|
49 "DISTINCT Any A,B ORDERBY B WHERE X is EUser, X created_by A, A login B") |
62 |
50 |
63 def test_nonregr1(self): |
51 def test_nonregr1(self): |
64 select = self.parse('Any T,V WHERE T bookmarked_by V?, ' |
52 select = self.parse('Any T,V WHERE T bookmarked_by V?, ' |
65 'V in_state VS, VS name "published", T created_by U') |
53 'V in_state VS, VS name "published", T created_by U') |
66 self.assertEquals(self._generate(select, 'created_by', 'U', 'login'), |
54 self.assertEquals(self._generate(select, 'created_by', 'subject', 'login'), |
67 'DISTINCT Any U,A ORDERBY A WHERE T created_by U, U login A, ' |
55 "DISTINCT Any A,B ORDERBY B WHERE T created_by U, " |
68 'T is Bookmark') |
56 "T created_by A, A login B, T is Bookmark") |
69 |
57 |
70 def test_nonregr2(self): |
58 def test_nonregr2(self): |
71 #'DISTINCT Any X,TMP,N WHERE P name TMP, X version_of P, P is Project, X is Version, not X in_state S,S name "published", X num N ORDERBY TMP,N' |
59 #'DISTINCT Any X,TMP,N WHERE P name TMP, X version_of P, P is Project, X is Version, not X in_state S,S name "published", X num N ORDERBY TMP,N' |
72 select = self.parse('DISTINCT Any V,TN,L ORDERBY TN,L WHERE T nom TN, V connait T, T is Personne, V is EUser,' |
60 select = self.parse('DISTINCT Any V,TN,L ORDERBY TN,L WHERE T nom TN, V connait T, T is Personne, V is EUser,' |
73 'NOT V in_state VS, VS name "published", V login L') |
61 'NOT V in_state VS, VS name "published", V login L') |
74 rschema = self.schema['connait'] |
62 rschema = self.schema['connait'] |
75 for s, o in rschema.iter_rdefs(): |
63 for s, o in rschema.iter_rdefs(): |
76 rschema.set_rproperty(s, o, 'cardinality', '++') |
64 rschema.set_rproperty(s, o, 'cardinality', '++') |
77 try: |
65 try: |
78 self.assertEquals(self._generate(select, 'in_state', 'VS', 'name'), |
66 self.assertEquals(self._generate(select, 'in_state', 'subject', 'name'), |
79 "DISTINCT Any VS,A ORDERBY A WHERE V is EUser, NOT V in_state VS, VS name 'published', VS name A") |
67 "DISTINCT Any A,B ORDERBY B WHERE V is EUser, " |
|
68 "NOT V in_state VS, VS name 'published', " |
|
69 "V in_state A, A name B") |
80 finally: |
70 finally: |
81 for s, o in rschema.iter_rdefs(): |
71 for s, o in rschema.iter_rdefs(): |
82 rschema.set_rproperty(s, o, 'cardinality', '**') |
72 rschema.set_rproperty(s, o, 'cardinality', '**') |
83 |
73 |
84 def test_nonregr3(self): |
74 def test_nonregr3(self): |
85 #'DISTINCT Any X,TMP,N WHERE P name TMP, X version_of P, P is Project, X is Version, not X in_state S,S name "published", X num N ORDERBY TMP,N' |
75 #'DISTINCT Any X,TMP,N WHERE P name TMP, X version_of P, P is Project, X is Version, not X in_state S,S name "published", X num N ORDERBY TMP,N' |
86 select = self.parse('DISTINCT Any X, MAX(Y) GROUPBY X WHERE X is EUser, Y is Bookmark, X in_group A') |
76 select = self.parse('DISTINCT Any X, MAX(Y) GROUPBY X WHERE X is EUser, Y is Bookmark, X in_group A') |
87 self.assertEquals(self._generate(select, 'in_group', 'A', 'name'), |
77 self.assertEquals(self._generate(select, 'in_group', 'subject', 'name'), |
88 "DISTINCT Any A,B ORDERBY B WHERE X is EUser, X in_group A, A name B") |
78 "DISTINCT Any B,C ORDERBY C WHERE X is EUser, X in_group B, B name C") |
89 |
79 |
90 |
80 |
91 if __name__ == '__main__': |
81 if __name__ == '__main__': |
92 from logilab.common.testlib import unittest_main |
82 from logilab.common.testlib import unittest_main |
93 unittest_main() |
83 unittest_main() |