equal
deleted
inserted
replaced
182 cnx.commit() |
182 cnx.commit() |
183 self.assertEqual(cnx.execute('Any A WHERE X owned_by U, U use_email X,' |
183 self.assertEqual(cnx.execute('Any A WHERE X owned_by U, U use_email X,' |
184 'U login "toto", X address A')[0][0], |
184 'U login "toto", X address A')[0][0], |
185 'toto@logilab.fr') |
185 'toto@logilab.fr') |
186 |
186 |
|
187 def test_user_composite_no_owner_on_deleted_entity(self): |
|
188 with self.admin_access.repo_cnx() as cnx: |
|
189 u = self.create_user(cnx, 'toto').eid |
|
190 cnx.commit() |
|
191 e = cnx.create_entity('EmailAddress', address=u'toto@logilab.fr', reverse_use_email=u) |
|
192 e.cw_delete() |
|
193 cnx.commit() |
|
194 self.assertFalse(cnx.system_sql( |
|
195 'SELECT * FROM owned_by_relation ' |
|
196 'WHERE eid_from NOT IN (SELECT eid FROM entities)').fetchall()) |
|
197 |
187 def test_no_created_by_on_deleted_entity(self): |
198 def test_no_created_by_on_deleted_entity(self): |
188 with self.admin_access.repo_cnx() as cnx: |
199 with self.admin_access.repo_cnx() as cnx: |
189 eid = cnx.execute('INSERT EmailAddress X: X address "toto@logilab.fr"')[0][0] |
200 eid = cnx.execute('INSERT EmailAddress X: X address "toto@logilab.fr"')[0][0] |
190 cnx.execute('DELETE EmailAddress X WHERE X eid %s' % eid) |
201 cnx.execute('DELETE EmailAddress X WHERE X eid %s' % eid) |
191 cnx.commit() |
202 cnx.commit() |