server/test/unittest_msplanner.py
changeset 1120 1c24cde4bf72
parent 393 45a675515427
child 1121 43fa67acd9d0
equal deleted inserted replaced
1119:3f23846b7946 1120:1c24cde4bf72
  1816                         'Z': 'table1.C1'},
  1816                         'Z': 'table1.C1'},
  1817                        [])]
  1817                        [])]
  1818                       )],
  1818                       )],
  1819                    {'x': 999999})
  1819                    {'x': 999999})
  1820 
  1820 
       
  1821     def test_nonregr13(self):
       
  1822         self._test('Any B,U,UL GROUPBY B,U,UL WHERE B created_by U?, B is File '
       
  1823                    'WITH U,UL BEING (Any U,UL WHERE ME eid %(x)s, (EXISTS(U identity ME) '
       
  1824                    'OR (EXISTS(U in_group G, G name IN("managers", "staff")))) '
       
  1825                    'OR (EXISTS(U in_group H, ME in_group H, NOT H name "users")), U login UL, U is EUser)',
       
  1826                    [('FetchStep', [('Any U,UL WHERE U login UL, U is EUser',
       
  1827                                     [{'U': 'EUser', 'UL': 'String'}])],
       
  1828                      [self.ldap, self.system], None,
       
  1829                      {'U': 'table0.C0', 'U.login': 'table0.C1', 'UL': 'table0.C1'},
       
  1830                      []),
       
  1831                     ('FetchStep', [('Any U,UL WHERE ((EXISTS(U identity 5)) OR (EXISTS(U in_group G, G name IN("managers", "staff"), G is EGroup))) OR (EXISTS(U in_group H, 5 in_group H, NOT H name "users", H is EGroup)), U login UL, U is EUser',
       
  1832                                     [{'G': 'EGroup', 'H': 'EGroup', 'U': 'EUser', 'UL': 'String'}])],
       
  1833                      [self.system],
       
  1834                      {'U': 'table0.C0', 'U.login': 'table0.C1', 'UL': 'table0.C1'},
       
  1835                      {'U': 'table1.C0', 'U.login': 'table1.C1', 'UL': 'table1.C1'},
       
  1836                      []),
       
  1837                     ('OneFetchStep', [('Any B,U,UL GROUPBY B,U,UL WHERE B created_by U?, B is File',
       
  1838                                        [{'B': 'File', 'U': 'EUser', 'UL': 'String'}])],
       
  1839                      None, None, [self.system],
       
  1840                      {'U': 'table1.C0', 'UL': 'table1.C1'},
       
  1841                      [])],
       
  1842                    {'x': self.session.user.eid})
  1821 
  1843 
  1822 class MSPlannerTwoSameExternalSourcesTC(BasePlannerTC):
  1844 class MSPlannerTwoSameExternalSourcesTC(BasePlannerTC):
  1823     """test planner related feature on a 3-sources repository:
  1845     """test planner related feature on a 3-sources repository:
  1824     
  1846     
  1825     * 2 rql source supporting Card
  1847     * 2 rql source supporting Card