37 rset = self.execute('Any X WHERE X eid 1') |
37 rset = self.execute('Any X WHERE X eid 1') |
38 self.assertEquals(vid_from_rset(req, rset, self.schema), 'primary') |
38 self.assertEquals(vid_from_rset(req, rset, self.schema), 'primary') |
39 |
39 |
40 def test_more_than_one_entity(self): |
40 def test_more_than_one_entity(self): |
41 req = self.request() |
41 req = self.request() |
42 rset = self.execute('Any X WHERE X is EUser') |
42 rset = self.execute('Any X WHERE X is CWUser') |
43 self.assertEquals(vid_from_rset(req, rset, self.schema), 'list') |
43 self.assertEquals(vid_from_rset(req, rset, self.schema), 'list') |
44 rset = self.execute('Any X, L WHERE X login L') |
44 rset = self.execute('Any X, L WHERE X login L') |
45 self.assertEquals(vid_from_rset(req, rset, self.schema), 'list') |
45 self.assertEquals(vid_from_rset(req, rset, self.schema), 'list') |
46 |
46 |
47 def test_more_than_one_entity_by_row(self): |
47 def test_more_than_one_entity_by_row(self): |
56 |
56 |
57 def test_aggregat(self): |
57 def test_aggregat(self): |
58 req = self.request() |
58 req = self.request() |
59 rset = self.execute('Any X, COUNT(T) GROUPBY X WHERE X is T') |
59 rset = self.execute('Any X, COUNT(T) GROUPBY X WHERE X is T') |
60 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
60 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
61 rset = self.execute('Any MAX(X) WHERE X is EUser') |
61 rset = self.execute('Any MAX(X) WHERE X is CWUser') |
62 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
62 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
63 |
63 |
64 def test_subquery(self): |
64 def test_subquery(self): |
65 rset = self.execute( |
65 rset = self.execute( |
66 'DISTINCT Any X,N ORDERBY N ' |
66 'DISTINCT Any X,N ORDERBY N ' |
67 'WITH X,N BEING (' |
67 'WITH X,N BEING (' |
68 ' (DISTINCT Any P,N WHERE P is EUser, P login N)' |
68 ' (DISTINCT Any P,N WHERE P is CWUser, P login N)' |
69 ' UNION' |
69 ' UNION' |
70 ' (DISTINCT Any W,N WHERE W is EGroup, W name N))') |
70 ' (DISTINCT Any W,N WHERE W is CWGroup, W name N))') |
71 req = self.request() |
71 req = self.request() |
72 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
72 self.assertEquals(vid_from_rset(req, rset, self.schema), 'table') |
73 |
73 |
74 |
74 |
75 class TableViewTC(EnvBasedTC): |
75 class TableViewTC(EnvBasedTC): |