equal
deleted
inserted
replaced
176 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
176 "NOT EXISTS(X owned_by U, U in_group G, G name 'lulufanclub' OR G name 'managers');", |
177 '''SELECT _X.cw_eid |
177 '''SELECT _X.cw_eid |
178 FROM cw_Personne AS _X |
178 FROM cw_Personne AS _X |
179 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))))'''), |
179 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))))'''), |
180 |
180 |
181 |
|
182 |
|
183 ] |
181 ] |
|
182 |
184 |
183 |
185 ADVANCED= [ |
184 ADVANCED= [ |
186 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
185 ("Societe S WHERE S nom 'Logilab' OR S nom 'Caesium'", |
187 '''SELECT _S.cw_eid |
186 '''SELECT _S.cw_eid |
188 FROM cw_Societe AS _S |
187 FROM cw_Societe AS _S |
579 GROUP BY T1.C0,T1.C2 |
578 GROUP BY T1.C0,T1.C2 |
580 ORDER BY T1.C2'''), |
579 ORDER BY T1.C2'''), |
581 |
580 |
582 ] |
581 ] |
583 |
582 |
|
583 |
584 MULTIPLE_SEL = [ |
584 MULTIPLE_SEL = [ |
585 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
585 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
586 '''SELECT DISTINCT _P.cw_nom, _P.cw_prenom |
586 '''SELECT DISTINCT _P.cw_nom, _P.cw_prenom |
587 FROM cw_Personne AS _P'''), |
587 FROM cw_Personne AS _P'''), |
588 ("Any X,Y where P is Personne, P nom X , P prenom Y, not P nom NULL;", |
588 ("Any X,Y where P is Personne, P nom X , P prenom Y, not P nom NULL;", |
593 '''SELECT _X.cw_eid, _Y.cw_eid |
593 '''SELECT _X.cw_eid, _Y.cw_eid |
594 FROM cw_Personne AS _X, cw_Personne AS _Y |
594 FROM cw_Personne AS _X, cw_Personne AS _Y |
595 WHERE _Y.cw_nom=_X.cw_nom AND NOT (_Y.cw_eid=_X.cw_eid)''') |
595 WHERE _Y.cw_nom=_X.cw_nom AND NOT (_Y.cw_eid=_X.cw_eid)''') |
596 ] |
596 ] |
597 |
597 |
|
598 |
598 NEGATIONS = [ |
599 NEGATIONS = [ |
|
600 |
599 ("Personne X WHERE NOT X evaluee Y;", |
601 ("Personne X WHERE NOT X evaluee Y;", |
600 '''SELECT _X.cw_eid |
602 '''SELECT _X.cw_eid |
601 FROM cw_Personne AS _X |
603 FROM cw_Personne AS _X |
602 WHERE NOT (EXISTS(SELECT 1 FROM evaluee_relation AS rel_evaluee0 WHERE rel_evaluee0.eid_from=_X.cw_eid))'''), |
604 WHERE NOT (EXISTS(SELECT 1 FROM evaluee_relation AS rel_evaluee0 WHERE rel_evaluee0.eid_from=_X.cw_eid))'''), |
603 |
605 |