564 'EXISTS(A use_email O, EXISTS(A identity B, NOT B in_group D, D name "guests", D is CWGroup), A is CWUser), B eid 2', |
564 'EXISTS(A use_email O, EXISTS(A identity B, NOT B in_group D, D name "guests", D is CWGroup), A is CWUser), B eid 2', |
565 '''SELECT O.cw_eid, O.cw_address, O.cw_alias, O.cw_modification_date |
565 '''SELECT O.cw_eid, O.cw_address, O.cw_alias, O.cw_modification_date |
566 FROM cw_EmailAddress AS O |
566 FROM cw_EmailAddress AS O |
567 WHERE NOT EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email0 WHERE rel_use_email0.eid_from=1 AND rel_use_email0.eid_to=O.cw_eid) AND EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email1 WHERE rel_use_email1.eid_to=O.cw_eid AND EXISTS(SELECT 1 FROM cw_CWGroup AS D WHERE rel_use_email1.eid_from=2 AND NOT EXISTS(SELECT 1 FROM in_group_relation AS rel_in_group2 WHERE rel_in_group2.eid_from=2 AND rel_in_group2.eid_to=D.cw_eid) AND D.cw_name=guests)) |
567 WHERE NOT EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email0 WHERE rel_use_email0.eid_from=1 AND rel_use_email0.eid_to=O.cw_eid) AND EXISTS(SELECT 1 FROM use_email_relation AS rel_use_email1 WHERE rel_use_email1.eid_to=O.cw_eid AND EXISTS(SELECT 1 FROM cw_CWGroup AS D WHERE rel_use_email1.eid_from=2 AND NOT EXISTS(SELECT 1 FROM in_group_relation AS rel_in_group2 WHERE rel_in_group2.eid_from=2 AND rel_in_group2.eid_to=D.cw_eid) AND D.cw_name=guests)) |
568 ORDER BY 4 DESC'''), |
568 ORDER BY 4 DESC'''), |
|
569 |
|
570 |
|
571 ("Any X WHERE X eid 0, X eid 0", |
|
572 '''SELECT 0'''), |
|
573 |
|
574 ("Any X WHERE X eid 0, X eid 0, X test TRUE", |
|
575 '''SELECT X.cw_eid |
|
576 FROM cw_Personne AS X |
|
577 WHERE X.cw_eid=0 AND X.cw_eid=0 AND X.cw_test='''), |
569 ] |
578 ] |
570 |
579 |
571 MULTIPLE_SEL = [ |
580 MULTIPLE_SEL = [ |
572 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
581 ("DISTINCT Any X,Y where P is Personne, P nom X , P prenom Y;", |
573 '''SELECT DISTINCT P.cw_nom, P.cw_prenom |
582 '''SELECT DISTINCT P.cw_nom, P.cw_prenom |