557 self.assertEquals(tuplify(rset.rows), [(1,), (2,)]) |
557 self.assertEquals(tuplify(rset.rows), [(1,), (2,)]) |
558 self.assertEquals(rset.description, [('CWGroup',), ('CWGroup',)]) |
558 self.assertEquals(rset.description, [('CWGroup',), ('CWGroup',)]) |
559 rset = self.execute('CWGroup X ORDERBY N LIMIT 2 OFFSET 2 WHERE X name N') |
559 rset = self.execute('CWGroup X ORDERBY N LIMIT 2 OFFSET 2 WHERE X name N') |
560 self.assertEquals(tuplify(rset.rows), [(3,), (4,)]) |
560 self.assertEquals(tuplify(rset.rows), [(3,), (4,)]) |
561 |
561 |
562 def test_select_symetric(self): |
562 def test_select_symmetric(self): |
563 self.execute("INSERT Personne X: X nom 'machin'") |
563 self.execute("INSERT Personne X: X nom 'machin'") |
564 self.execute("INSERT Personne X: X nom 'bidule'") |
564 self.execute("INSERT Personne X: X nom 'bidule'") |
565 self.execute("INSERT Personne X: X nom 'chouette'") |
565 self.execute("INSERT Personne X: X nom 'chouette'") |
566 self.execute("INSERT Personne X: X nom 'trucmuche'") |
566 self.execute("INSERT Personne X: X nom 'trucmuche'") |
567 self.execute("SET X connait Y WHERE X nom 'chouette', Y nom 'bidule'") |
567 self.execute("SET X connait Y WHERE X nom 'chouette', Y nom 'bidule'") |
936 self.assertEqual(len(rset.rows), 1) |
936 self.assertEqual(len(rset.rows), 1) |
937 self.execute("DELETE X travaille Y WHERE X eid %s, Y eid %s" % (peid, seid)) |
937 self.execute("DELETE X travaille Y WHERE X eid %s, Y eid %s" % (peid, seid)) |
938 rset = self.execute('Personne P WHERE P travaille S') |
938 rset = self.execute('Personne P WHERE P travaille S') |
939 self.assertEqual(len(rset.rows), 0) |
939 self.assertEqual(len(rset.rows), 0) |
940 |
940 |
941 def test_delete_symetric(self): |
941 def test_delete_symmetric(self): |
942 teid1 = self.execute("INSERT Folder T: T name 'toto'")[0][0] |
942 teid1 = self.execute("INSERT Folder T: T name 'toto'")[0][0] |
943 teid2 = self.execute("INSERT Folder T: T name 'tutu'")[0][0] |
943 teid2 = self.execute("INSERT Folder T: T name 'tutu'")[0][0] |
944 self.execute('SET X see_also Y WHERE X eid %s, Y eid %s' % (teid1, teid2)) |
944 self.execute('SET X see_also Y WHERE X eid %s, Y eid %s' % (teid1, teid2)) |
945 rset = self.execute('Any X,Y WHERE X see_also Y') |
945 rset = self.execute('Any X,Y WHERE X see_also Y') |
946 self.assertEquals(len(rset) , 2, rset.rows) |
946 self.assertEquals(len(rset) , 2, rset.rows) |