1505 self.assertEqual(rset.rows, [[peid]]) |
1505 self.assertEqual(rset.rows, [[peid]]) |
1506 |
1506 |
1507 def test_nonregr_has_text_cache(self): |
1507 def test_nonregr_has_text_cache(self): |
1508 eid1 = self.qexecute("INSERT Personne X: X nom 'bidule'")[0][0] |
1508 eid1 = self.qexecute("INSERT Personne X: X nom 'bidule'")[0][0] |
1509 eid2 = self.qexecute("INSERT Personne X: X nom 'tag'")[0][0] |
1509 eid2 = self.qexecute("INSERT Personne X: X nom 'tag'")[0][0] |
1510 rset = self.qexecute("Any X WHERE X has_text %(text)s", {'text': 'bidule'}) |
1510 rset = self.qexecute("Any X WHERE X has_text %(text)s", {'text': u'bidule'}) |
1511 self.assertEqual(rset.rows, [[eid1]]) |
1511 self.assertEqual(rset.rows, [[eid1]]) |
1512 rset = self.qexecute("Any X WHERE X has_text %(text)s", {'text': 'tag'}) |
1512 rset = self.qexecute("Any X WHERE X has_text %(text)s", {'text': u'tag'}) |
1513 self.assertEqual(rset.rows, [[eid2]]) |
1513 self.assertEqual(rset.rows, [[eid2]]) |
1514 |
1514 |
1515 def test_nonregr_sortterm_management(self): |
1515 def test_nonregr_sortterm_management(self): |
1516 """Error: Variable has no attribute 'sql' in rql2sql.py (visit_variable) |
1516 """Error: Variable has no attribute 'sql' in rql2sql.py (visit_variable) |
1517 |
1517 |
1618 self.create_user(cnx, 'user', ('users',)) |
1618 self.create_user(cnx, 'user', ('users',)) |
1619 aff1 = cnx.create_entity('Societe', nom=u'aff1') |
1619 aff1 = cnx.create_entity('Societe', nom=u'aff1') |
1620 aff2 = cnx.create_entity('Societe', nom=u'aff2') |
1620 aff2 = cnx.create_entity('Societe', nom=u'aff2') |
1621 cnx.commit() |
1621 cnx.commit() |
1622 with self.new_access('user').repo_cnx() as cnx: |
1622 with self.new_access('user').repo_cnx() as cnx: |
1623 res = cnx.execute('Any X WHERE X has_text %(text)s', {'text': 'aff1'}) |
1623 res = cnx.execute('Any X WHERE X has_text %(text)s', {'text': u'aff1'}) |
1624 self.assertEqual(res.rows, [[aff1.eid]]) |
1624 self.assertEqual(res.rows, [[aff1.eid]]) |
1625 res = cnx.execute('Any X WHERE X has_text %(text)s', {'text': 'aff2'}) |
1625 res = cnx.execute('Any X WHERE X has_text %(text)s', {'text': u'aff2'}) |
1626 self.assertEqual(res.rows, [[aff2.eid]]) |
1626 self.assertEqual(res.rows, [[aff2.eid]]) |
1627 |
1627 |
1628 def test_set_relations_eid(self): |
1628 def test_set_relations_eid(self): |
1629 with self.admin_access.repo_cnx() as cnx: |
1629 with self.admin_access.repo_cnx() as cnx: |
1630 # create 3 email addresses |
1630 # create 3 email addresses |