server/test/unittest_rql2sql.py
branchstable
changeset 6930 118881289a31
parent 6929 e9464d975908
child 6940 1172c25655b7
equal deleted inserted replaced
6929:e9464d975908 6930:118881289a31
   575 
   575 
   576     ('CWEType X WHERE X name CV, X description V HAVING NOT V=CV AND NOT V = "parent"',
   576     ('CWEType X WHERE X name CV, X description V HAVING NOT V=CV AND NOT V = "parent"',
   577      '''SELECT _X.cw_eid
   577      '''SELECT _X.cw_eid
   578 FROM cw_CWEType AS _X
   578 FROM cw_CWEType AS _X
   579 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''),
   579 WHERE NOT (EXISTS(SELECT 1 WHERE _X.cw_description=parent)) AND NOT (EXISTS(SELECT 1 WHERE _X.cw_description=_X.cw_name))'''),
       
   580     ('CWEType X WHERE X name CV, X description V HAVING V!=CV AND V != "parent"',
       
   581      '''SELECT _X.cw_eid
       
   582 FROM cw_CWEType AS _X
       
   583 WHERE _X.cw_description!=parent AND _X.cw_description!=_X.cw_name'''),
   580     ]
   584     ]
   581 
   585 
   582 
   586 
   583 MULTIPLE_SEL = [
   587 MULTIPLE_SEL = [
   584     ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;",
   588     ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;",