805 # '''SELECT _X.cw_eid, _X.cw_relation_type |
805 # '''SELECT _X.cw_eid, _X.cw_relation_type |
806 # FROM cw_CWRelation AS _X'''), |
806 # FROM cw_CWRelation AS _X'''), |
807 |
807 |
808 |
808 |
809 OUTER_JOIN = [ |
809 OUTER_JOIN = [ |
|
810 |
|
811 ('Any U,G WHERE U login L, G name L?, G is CWGroup', |
|
812 '''SELECT _U.cw_eid, _G.cw_eid |
|
813 FROM cw_CWUser AS _U LEFT OUTER JOIN cw_CWGroup AS _G ON (_G.cw_name=_U.cw_login)'''), |
|
814 |
810 ('Any X,S WHERE X travaille S?', |
815 ('Any X,S WHERE X travaille S?', |
811 '''SELECT _X.cw_eid, rel_travaille0.eid_to |
816 '''SELECT _X.cw_eid, rel_travaille0.eid_to |
812 FROM cw_Personne AS _X LEFT OUTER JOIN travaille_relation AS rel_travaille0 ON (rel_travaille0.eid_from=_X.cw_eid)''' |
817 FROM cw_Personne AS _X LEFT OUTER JOIN travaille_relation AS rel_travaille0 ON (rel_travaille0.eid_from=_X.cw_eid)''' |
813 ), |
818 ), |
814 ('Any S,X WHERE X? travaille S, S is Societe', |
819 ('Any S,X WHERE X? travaille S, S is Societe', |
967 ('Any CASE, CALIBCFG, CFG ' |
972 ('Any CASE, CALIBCFG, CFG ' |
968 'WHERE CASE eid 1, CFG ecrit_par CASE, CALIBCFG? ecrit_par CASE', |
973 'WHERE CASE eid 1, CFG ecrit_par CASE, CALIBCFG? ecrit_par CASE', |
969 '''SELECT _CFG.cw_ecrit_par, _CALIBCFG.cw_eid, _CFG.cw_eid |
974 '''SELECT _CFG.cw_ecrit_par, _CALIBCFG.cw_eid, _CFG.cw_eid |
970 FROM cw_Note AS _CFG LEFT OUTER JOIN cw_Note AS _CALIBCFG ON (_CALIBCFG.cw_ecrit_par=_CFG.cw_ecrit_par) |
975 FROM cw_Note AS _CFG LEFT OUTER JOIN cw_Note AS _CALIBCFG ON (_CALIBCFG.cw_ecrit_par=_CFG.cw_ecrit_par) |
971 WHERE _CFG.cw_ecrit_par=1'''), |
976 WHERE _CFG.cw_ecrit_par=1'''), |
|
977 |
|
978 ('Any U,G WHERE U login UL, G name GL, G is CWGroup HAVING UPPER(UL)=UPPER(GL)?', |
|
979 '''SELECT _U.cw_eid, _G.cw_eid |
|
980 FROM cw_CWUser AS _U LEFT OUTER JOIN cw_CWGroup AS _G ON (UPPER(_U.cw_login)=UPPER(_G.cw_name))'''), |
|
981 |
|
982 ('Any U,G WHERE U login UL, G name GL, G is CWGroup HAVING UPPER(UL)?=UPPER(GL)', |
|
983 '''SELECT _U.cw_eid, _G.cw_eid |
|
984 FROM cw_CWGroup AS _G LEFT OUTER JOIN cw_CWUser AS _U ON (UPPER(_U.cw_login)=UPPER(_G.cw_name))'''), |
|
985 |
|
986 ('Any U,G WHERE U login UL, G name GL, G is CWGroup HAVING UPPER(UL)?=UPPER(GL)?', |
|
987 '''SELECT _U.cw_eid, _G.cw_eid |
|
988 FROM cw_CWUser AS _U FULL OUTER JOIN cw_CWGroup AS _G ON (UPPER(_U.cw_login)=UPPER(_G.cw_name))'''), |
972 ] |
989 ] |
973 |
990 |
974 VIRTUAL_VARS = [ |
991 VIRTUAL_VARS = [ |
975 |
992 |
976 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |
993 ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"', |