1484 yield t |
1484 yield t |
1485 |
1485 |
1486 def test_has_text(self): |
1486 def test_has_text(self): |
1487 for t in self._parse(( |
1487 for t in self._parse(( |
1488 ('Any X WHERE X has_text "toto tata"', |
1488 ('Any X WHERE X has_text "toto tata"', |
1489 """SELECT appears0.uid |
1489 """SELECT DISTINCT appears0.uid |
1490 FROM appears AS appears0 |
1490 FROM appears AS appears0 |
1491 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata'))"""), |
1491 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata'))"""), |
1492 |
1492 |
1493 ('Any X WHERE X has_text %(text)s', |
1493 ('Any X WHERE X has_text %(text)s', |
1494 """SELECT appears0.uid |
1494 """SELECT DISTINCT appears0.uid |
1495 FROM appears AS appears0 |
1495 FROM appears AS appears0 |
1496 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('hip', 'hop', 'momo'))"""), |
1496 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('hip', 'hop', 'momo'))"""), |
1497 |
1497 |
1498 ('Personne X WHERE X has_text "toto tata"', |
1498 ('Personne X WHERE X has_text "toto tata"', |
1499 """SELECT _X.eid |
1499 """SELECT DISTINCT _X.eid |
1500 FROM appears AS appears0, entities AS _X |
1500 FROM appears AS appears0, entities AS _X |
1501 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.eid AND _X.type='Personne'"""), |
1501 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.eid AND _X.type='Personne'"""), |
1502 |
1502 |
1503 ('Any X WHERE X has_text "toto tata", X name "tutu", X is IN (Basket,Folder)', |
1503 ('Any X WHERE X has_text "toto tata", X name "tutu", X is IN (Basket,Folder)', |
1504 """SELECT _X.cw_eid |
1504 """SELECT DISTINCT _X.cw_eid |
1505 FROM appears AS appears0, cw_Basket AS _X |
1505 FROM appears AS appears0, cw_Basket AS _X |
1506 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.cw_eid AND _X.cw_name=tutu |
1506 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.cw_eid AND _X.cw_name=tutu |
1507 UNION ALL |
1507 UNION |
1508 SELECT _X.cw_eid |
1508 SELECT DISTINCT _X.cw_eid |
1509 FROM appears AS appears0, cw_Folder AS _X |
1509 FROM appears AS appears0, cw_Folder AS _X |
1510 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.cw_eid AND _X.cw_name=tutu |
1510 WHERE appears0.word_id IN (SELECT word_id FROM word WHERE word in ('toto', 'tata')) AND appears0.uid=_X.cw_eid AND _X.cw_name=tutu |
1511 """), |
1511 """), |
1512 )): |
1512 )): |
1513 yield t |
1513 yield t |