equal
deleted
inserted
replaced
149 syt = self.sexecute('CWUser X WHERE X login "syt"').get_entity(0, 0) |
149 syt = self.sexecute('CWUser X WHERE X login "syt"').get_entity(0, 0) |
150 self.assertEquals([g.name for g in syt.in_group], ['managers', 'users']) |
150 self.assertEquals([g.name for g in syt.in_group], ['managers', 'users']) |
151 self.patch_authenticate() |
151 self.patch_authenticate() |
152 cnx = self.login('syt', 'dummypassword') |
152 cnx = self.login('syt', 'dummypassword') |
153 cu = cnx.cursor() |
153 cu = cnx.cursor() |
154 cu.execute('SET X in_state S WHERE X login "alf", S name "deactivated"') |
154 alf = cu.execute('Any X WHERE X login "alf"').get_entity(0, 0) |
|
155 alf.fire_transition('deactivate') |
155 try: |
156 try: |
156 cnx.commit() |
157 cnx.commit() |
157 alf = self.sexecute('CWUser X WHERE X login "alf"').get_entity(0, 0) |
158 alf = self.sexecute('CWUser X WHERE X login "alf"').get_entity(0, 0) |
158 self.assertEquals(alf.in_state[0].name, 'deactivated') |
159 self.assertEquals(alf.in_state[0].name, 'deactivated') |
159 trinfo = alf.latest_trinfo() |
160 trinfo = alf.latest_trinfo() |
165 {'x': alf.eid}, 'x') |
166 {'x': alf.eid}, 'x') |
166 self.assertEquals(rset.rows, [[syt.eid]]) |
167 self.assertEquals(rset.rows, [[syt.eid]]) |
167 finally: |
168 finally: |
168 # restore db state |
169 # restore db state |
169 self.restore_connection() |
170 self.restore_connection() |
170 self.sexecute('SET X in_state S WHERE X login "alf", S name "activated"') |
171 alf = self.sexecute('Any X WHERE X login "alf"').get_entity(0, 0) |
|
172 alf.fire_transition('activate') |
171 self.sexecute('DELETE X in_group G WHERE X login "syt", G name "managers"') |
173 self.sexecute('DELETE X in_group G WHERE X login "syt", G name "managers"') |
172 |
174 |
173 def test_same_column_names(self): |
175 def test_same_column_names(self): |
174 self.sexecute('Any X, Y WHERE X copain Y, X login "comme", Y login "cochon"') |
176 self.sexecute('Any X, Y WHERE X copain Y, X login "comme", Y login "cochon"') |
175 |
177 |