server/test/unittest_rql2sql.py
branch3.5
changeset 3245 7ef021ac8dec
parent 3238 988a72e59b2b
child 3447 0a0f8df4a2f7
child 3520 eb508952ee81
equal deleted inserted replaced
3244:1fc804b2c5ba 3245:7ef021ac8dec
   161 FROM cw_Personne AS X
   161 FROM cw_Personne AS X
   162 WHERE X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS G WHERE rel_owned_by0.eid_from=X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=G.cw_eid AND ((G.cw_name=lulufanclub) OR (G.cw_name=managers)))'''),
   162 WHERE X.cw_prenom=lulu AND NOT EXISTS(SELECT 1 FROM owned_by_relation AS rel_owned_by0, in_group_relation AS rel_in_group1, cw_CWGroup AS G WHERE rel_owned_by0.eid_from=X.cw_eid AND rel_in_group1.eid_from=rel_owned_by0.eid_to AND rel_in_group1.eid_to=G.cw_eid AND ((G.cw_name=lulufanclub) OR (G.cw_name=managers)))'''),
   163 ]
   163 ]
   164 
   164 
   165 ADVANCED= [
   165 ADVANCED= [
   166 
       
   167     ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'",
   166     ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'",
   168      '''SELECT S.cw_eid
   167      '''SELECT S.cw_eid
   169 FROM cw_Societe AS S
   168 FROM cw_Societe AS S
   170 WHERE ((S.cw_nom=Logilab) OR (S.cw_nom=Caesium))'''),
   169 WHERE ((S.cw_nom=Logilab) OR (S.cw_nom=Caesium))'''),
   171 
   170