server/test/unittest_rql2sql.py
branchstable
changeset 7630 f4b954676721
parent 7596 f3cdf1694c92
child 7642 64eee2a83bfa
equal deleted inserted replaced
7621:55b2d0cce69b 7630:f4b954676721
   952 
   952 
   953     ('Any X,T,OT WHERE X tags T, OT? tags X, X is Tag, X eid 123',
   953     ('Any X,T,OT WHERE X tags T, OT? tags X, X is Tag, X eid 123',
   954      '''SELECT rel_tags0.eid_from, rel_tags0.eid_to, rel_tags1.eid_from
   954      '''SELECT rel_tags0.eid_from, rel_tags0.eid_to, rel_tags1.eid_from
   955 FROM tags_relation AS rel_tags0 LEFT OUTER JOIN tags_relation AS rel_tags1 ON (rel_tags1.eid_to=123)
   955 FROM tags_relation AS rel_tags0 LEFT OUTER JOIN tags_relation AS rel_tags1 ON (rel_tags1.eid_to=123)
   956 WHERE rel_tags0.eid_from=123'''),
   956 WHERE rel_tags0.eid_from=123'''),
       
   957 
       
   958     ('Any CASE, CALIBCFG, CFG '
       
   959      'WHERE CASE eid 1, CFG ecrit_par CASE, CALIBCFG? ecrit_par CASE',
       
   960      '''SELECT _CFG.cw_ecrit_par, _CALIBCFG.cw_eid, _CFG.cw_eid
       
   961 FROM cw_Note AS _CFG LEFT OUTER JOIN cw_Note AS _CALIBCFG ON (_CALIBCFG.cw_ecrit_par=_CFG.cw_ecrit_par)
       
   962 WHERE _CFG.cw_ecrit_par=1'''),
   957     ]
   963     ]
   958 
   964 
   959 VIRTUAL_VARS = [
   965 VIRTUAL_VARS = [
   960 
   966 
   961     ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"',
   967     ('Any X WHERE X is CWUser, X creation_date > D1, Y creation_date D1, Y login "SWEB09"',