server/test/unittest_rql2sql.py
changeset 47 54087a269bdd
parent 0 b97547f5f1fa
child 339 c0a0ce6c0428
equal deleted inserted replaced
46:0155942b5c56 47:54087a269bdd
   336 WHERE X.login=admin'''),
   336 WHERE X.login=admin'''),
   337 
   337 
   338     ('Any XN ORDERBY XN WHERE X name XN',
   338     ('Any XN ORDERBY XN WHERE X name XN',
   339      '''SELECT X.name
   339      '''SELECT X.name
   340 FROM Basket AS X
   340 FROM Basket AS X
       
   341 UNION ALL
       
   342 SELECT X.name
       
   343 FROM ECache AS X
   341 UNION ALL
   344 UNION ALL
   342 SELECT X.name
   345 SELECT X.name
   343 FROM EConstraintType AS X
   346 FROM EConstraintType AS X
   344 UNION ALL
   347 UNION ALL
   345 SELECT X.name
   348 SELECT X.name
   461 WHERE X.name=EGroup AND Y.eid IN(1, 2, 3) AND NOT EXISTS(SELECT 1 FROM read_permission_relation AS rel_read_permission0 WHERE rel_read_permission0.eid_from=X.eid AND rel_read_permission0.eid_to=Y.eid)'''),
   464 WHERE X.name=EGroup AND Y.eid IN(1, 2, 3) AND NOT EXISTS(SELECT 1 FROM read_permission_relation AS rel_read_permission0 WHERE rel_read_permission0.eid_from=X.eid AND rel_read_permission0.eid_to=Y.eid)'''),
   462 
   465 
   463     ('Any MAX(X)+MIN(X), N GROUPBY N WHERE X name N;',
   466     ('Any MAX(X)+MIN(X), N GROUPBY N WHERE X name N;',
   464      '''SELECT (MAX(T1.C0) + MIN(T1.C0)), T1.C1 FROM (SELECT X.eid AS C0, X.name AS C1
   467      '''SELECT (MAX(T1.C0) + MIN(T1.C0)), T1.C1 FROM (SELECT X.eid AS C0, X.name AS C1
   465 FROM Basket AS X
   468 FROM Basket AS X
       
   469 UNION ALL
       
   470 SELECT X.eid AS C0, X.name AS C1
       
   471 FROM ECache AS X
   466 UNION ALL
   472 UNION ALL
   467 SELECT X.eid AS C0, X.name AS C1
   473 SELECT X.eid AS C0, X.name AS C1
   468 FROM EConstraintType AS X
   474 FROM EConstraintType AS X
   469 UNION ALL
   475 UNION ALL
   470 SELECT X.eid AS C0, X.name AS C1
   476 SELECT X.eid AS C0, X.name AS C1