← Back to branch summary

~j5-dev/+junk/sqlalchemy-0.6.1

« back to all changes in this revision

Viewing changes to test/orm/transaction.py

  • Committer: Bazaar Package Importer
  • Author(s): Piotr Ożarowski
  • Date: 2009-03-25 19:25:33 UTC
  • mfrom: (1.1.18 upstream) (6.1.5 squeeze)
  • Revision ID: james.westby@ubuntu.com-20090325192533-aju2jomjwdv1s628
Tags: 0.5.3-1
* New upstream release
* Add --install-layout=deb to setup.py call (prepare for dist-packages in
  python2.6)
  + python-all minimum required version bumped to 2.5.4-1~
* Standards-Version bumped to 3.8.1 (no changes needed)

Show diffs side-by-side

added added

removed removed

Lines of Context:
test/orm/transaction.py
 
1
import testenv; testenv.configure_for_tests()
 
2
import operator
 
3
from sqlalchemy import *
 
4
from sqlalchemy.orm import attributes
 
5
from sqlalchemy import exc as sa_exc
 
6
from sqlalchemy.orm import *
 
7
from testlib import *
 
8
from testlib.fixtures import *
 
9
import gc
 
10
 
 
11
class TransactionTest(FixtureTest):
 
12
    keep_mappers = True
 
13
    session = sessionmaker()
 
14
 
 
15
    def setup_mappers(self):
 
16
        mapper(User, users, properties={
 
17
            'addresses':relation(Address, backref='user',
 
18
                                 cascade="all, delete-orphan"),
 
19
            })
 
20
        mapper(Address, addresses)
 
21
 
 
22
 
 
23
class FixtureDataTest(TransactionTest):
 
24
    refresh_data = True
 
25
 
 
26
    def test_attrs_on_rollback(self):
 
27
        sess = self.session()
 
28
        u1 = sess.query(User).get(7)
 
29
        u1.name = 'ed'
 
30
        sess.rollback()
 
31
        self.assertEquals(u1.name, 'jack')
 
32
 
 
33
    def test_commit_persistent(self):
 
34
        sess = self.session()
 
35
        u1 = sess.query(User).get(7)
 
36
        u1.name = 'ed'
 
37
        sess.flush()
 
38
        sess.commit()
 
39
        self.assertEquals(u1.name, 'ed')
 
40
 
 
41
    def test_concurrent_commit_persistent(self):
 
42
        s1 = self.session()
 
43
        u1 = s1.query(User).get(7)
 
44
        u1.name = 'ed'
 
45
        s1.commit()
 
46
 
 
47
        s2 = self.session()
 
48
        u2 = s2.query(User).get(7)
 
49
        assert u2.name == 'ed'
 
50
        u2.name = 'will'
 
51
        s2.commit()
 
52
 
 
53
        assert u1.name == 'will'
 
54
 
 
55
class AutoExpireTest(TransactionTest):
 
56
    tables_only = True
 
57
 
 
58
    def test_expunge_pending_on_rollback(self):
 
59
        sess = self.session()
 
60
        u2= User(name='newuser')
 
61
        sess.add(u2)
 
62
        assert u2 in sess
 
63
        sess.rollback()
 
64
        assert u2 not in sess
 
65
 
 
66
    def test_trans_pending_cleared_on_commit(self):
 
67
        sess = self.session()
 
68
        u2= User(name='newuser')
 
69
        sess.add(u2)
 
70
        assert u2 in sess
 
71
        sess.commit()
 
72
        assert u2 in sess
 
73
        u3 = User(name='anotheruser')
 
74
        sess.add(u3)
 
75
        sess.rollback()
 
76
        assert u3 not in sess
 
77
        assert u2 in sess
 
78
 
 
79
    def test_update_deleted_on_rollback(self):
 
80
        s = self.session()
 
81
        u1 = User(name='ed')
 
82
        s.add(u1)
 
83
        s.commit()
 
84
 
 
85
        # this actually tests that the delete() operation,
 
86
        # when cascaded to the "addresses" collection, does not
 
87
        # trigger a flush (via lazyload) before the cascade is complete.
 
88
        s.delete(u1)
 
89
        assert u1 in s.deleted
 
90
        s.rollback()
 
91
        assert u1 in s
 
92
        assert u1 not in s.deleted
 
93
    
 
94
    def test_gced_delete_on_rollback(self):
 
95
        s = self.session()
 
96
        u1 = User(name='ed')
 
97
        s.add(u1)
 
98
        s.commit()
 
99
        
 
100
        s.delete(u1)
 
101
        u1_state = attributes.instance_state(u1)
 
102
        assert u1_state in s.identity_map.all_states()
 
103
        assert u1_state in s._deleted
 
104
        s.flush()
 
105
        assert u1_state not in s.identity_map.all_states()
 
106
        assert u1_state not in s._deleted
 
107
        del u1
 
108
        gc.collect()
 
109
        assert u1_state.obj() is None
 
110
        
 
111
        s.rollback()
 
112
        assert u1_state in s.identity_map.all_states()
 
113
        u1 = s.query(User).filter_by(name='ed').one()
 
114
        assert u1_state not in s.identity_map.all_states()
 
115
        assert s.scalar(users.count()) == 1
 
116
        s.delete(u1)
 
117
        s.flush()
 
118
        assert s.scalar(users.count()) == 0
 
119
        s.commit()
 
120
        
 
121
    def test_trans_deleted_cleared_on_rollback(self):
 
122
        s = self.session()
 
123
        u1 = User(name='ed')
 
124
        s.add(u1)
 
125
        s.commit()
 
126
 
 
127
        s.delete(u1)
 
128
        s.commit()
 
129
        assert u1 not in s
 
130
        s.rollback()
 
131
        assert u1 not in s
 
132
 
 
133
    def test_update_deleted_on_rollback_cascade(self):
 
134
        s = self.session()
 
135
        u1 = User(name='ed', addresses=[Address(email_address='foo')])
 
136
        s.add(u1)
 
137
        s.commit()
 
138
 
 
139
        s.delete(u1)
 
140
        assert u1 in s.deleted
 
141
        assert u1.addresses[0] in s.deleted
 
142
        s.rollback()
 
143
        assert u1 in s
 
144
        assert u1 not in s.deleted
 
145
        assert u1.addresses[0] not in s.deleted
 
146
 
 
147
    def test_update_deleted_on_rollback_orphan(self):
 
148
        s = self.session()
 
149
        u1 = User(name='ed', addresses=[Address(email_address='foo')])
 
150
        s.add(u1)
 
151
        s.commit()
 
152
 
 
153
        a1 = u1.addresses[0]
 
154
        u1.addresses.remove(a1)
 
155
 
 
156
        s.flush()
 
157
        self.assertEquals(s.query(Address).filter(Address.email_address=='foo').all(), [])
 
158
        s.rollback()
 
159
        assert a1 not in s.deleted
 
160
        assert u1.addresses == [a1]
 
161
 
 
162
    def test_commit_pending(self):
 
163
        sess = self.session()
 
164
        u1 = User(name='newuser')
 
165
        sess.add(u1)
 
166
        sess.flush()
 
167
        sess.commit()
 
168
        self.assertEquals(u1.name, 'newuser')
 
169
 
 
170
 
 
171
    def test_concurrent_commit_pending(self):
 
172
        s1 = self.session()
 
173
        u1 = User(name='edward')
 
174
        s1.add(u1)
 
175
        s1.commit()
 
176
 
 
177
        s2 = self.session()
 
178
        u2 = s2.query(User).filter(User.name=='edward').one()
 
179
        u2.name = 'will'
 
180
        s2.commit()
 
181
 
 
182
        assert u1.name == 'will'
 
183
 
 
184
class TwoPhaseTest(TransactionTest):
 
185
    only_tables = True
 
186
 
 
187
    @testing.requires.two_phase_transactions
 
188
    def test_rollback_on_prepare(self):
 
189
        s = self.session(twophase=True)
 
190
    
 
191
        u = User(name='ed')
 
192
        s.add(u)
 
193
        s.prepare()
 
194
        s.rollback()
 
195
        
 
196
        assert u not in s
 
197
        
 
198
class RollbackRecoverTest(TransactionTest):
 
199
    only_tables = True
 
200
 
 
201
    def test_pk_violation(self):
 
202
        s = self.session()
 
203
        a1 = Address(email_address='foo')
 
204
        u1 = User(id=1, name='ed', addresses=[a1])
 
205
        s.add(u1)
 
206
        s.commit()
 
207
 
 
208
        a2 = Address(email_address='bar')
 
209
        u2 = User(id=1, name='jack', addresses=[a2])
 
210
 
 
211
        u1.name = 'edward'
 
212
        a1.email_address = 'foober'
 
213
        s.add(u2)
 
214
        self.assertRaises(sa_exc.FlushError, s.commit)
 
215
        self.assertRaises(sa_exc.InvalidRequestError, s.commit)
 
216
        s.rollback()
 
217
        assert u2 not in s
 
218
        assert a2 not in s
 
219
        assert u1 in s
 
220
        assert a1 in s
 
221
        assert u1.name == 'ed'
 
222
        assert a1.email_address == 'foo'
 
223
        u1.name = 'edward'
 
224
        a1.email_address = 'foober'
 
225
        s.commit()
 
226
        self.assertEquals(
 
227
            s.query(User).all(),
 
228
            [User(id=1, name='edward', addresses=[Address(email_address='foober')])]
 
229
        )
 
230
 
 
231
    @testing.requires.savepoints
 
232
    def test_pk_violation_with_savepoint(self):
 
233
        s = self.session()
 
234
        a1 = Address(email_address='foo')
 
235
        u1 = User(id=1, name='ed', addresses=[a1])
 
236
        s.add(u1)
 
237
        s.commit()
 
238
 
 
239
        a2 = Address(email_address='bar')
 
240
        u2 = User(id=1, name='jack', addresses=[a2])
 
241
 
 
242
        u1.name = 'edward'
 
243
        a1.email_address = 'foober'
 
244
        s.begin_nested()
 
245
        s.add(u2)
 
246
        self.assertRaises(sa_exc.FlushError, s.commit)
 
247
        self.assertRaises(sa_exc.InvalidRequestError, s.commit)
 
248
        s.rollback()
 
249
        assert u2 not in s
 
250
        assert a2 not in s
 
251
        assert u1 in s
 
252
        assert a1 in s
 
253
 
 
254
        s.commit()
 
255
        assert s.query(User).all() == [User(id=1, name='edward', addresses=[Address(email_address='foober')])]
 
256
 
 
257
 
 
258
class SavepointTest(TransactionTest):
 
259
 
 
260
    only_tables = True
 
261
 
 
262
    @testing.requires.savepoints
 
263
    def test_savepoint_rollback(self):
 
264
        s = self.session()
 
265
        u1 = User(name='ed')
 
266
        u2 = User(name='jack')
 
267
        s.add_all([u1, u2])
 
268
 
 
269
        s.begin_nested()
 
270
        u3 = User(name='wendy')
 
271
        u4 = User(name='foo')
 
272
        u1.name = 'edward'
 
273
        u2.name = 'jackward'
 
274
        s.add_all([u3, u4])
 
275
        self.assertEquals(s.query(User.name).order_by(User.id).all(), [('edward',), ('jackward',), ('wendy',), ('foo',)])
 
276
        s.rollback()
 
277
        assert u1.name == 'ed'
 
278
        assert u2.name == 'jack'
 
279
        self.assertEquals(s.query(User.name).order_by(User.id).all(), [('ed',), ('jack',)])
 
280
        s.commit()
 
281
        assert u1.name == 'ed'
 
282
        assert u2.name == 'jack'
 
283
        self.assertEquals(s.query(User.name).order_by(User.id).all(), [('ed',), ('jack',)])
 
284
 
 
285
    @testing.requires.savepoints
 
286
    def test_savepoint_delete(self):
 
287
        s = self.session()
 
288
        u1 = User(name='ed')
 
289
        s.add(u1)
 
290
        s.commit()
 
291
        self.assertEquals(s.query(User).filter_by(name='ed').count(), 1)
 
292
        s.begin_nested()
 
293
        s.delete(u1)
 
294
        s.commit()
 
295
        self.assertEquals(s.query(User).filter_by(name='ed').count(), 0)
 
296
        s.commit()
 
297
 
 
298
    @testing.requires.savepoints
 
299
    def test_savepoint_commit(self):
 
300
        s = self.session()
 
301
        u1 = User(name='ed')
 
302
        u2 = User(name='jack')
 
303
        s.add_all([u1, u2])
 
304
 
 
305
        s.begin_nested()
 
306
        u3 = User(name='wendy')
 
307
        u4 = User(name='foo')
 
308
        u1.name = 'edward'
 
309
        u2.name = 'jackward'
 
310
        s.add_all([u3, u4])
 
311
        self.assertEquals(s.query(User.name).order_by(User.id).all(), [('edward',), ('jackward',), ('wendy',), ('foo',)])
 
312
        s.commit()
 
313
        def go():
 
314
            assert u1.name == 'edward'
 
315
            assert u2.name == 'jackward'
 
316
            self.assertEquals(s.query(User.name).order_by(User.id).all(), [('edward',), ('jackward',), ('wendy',), ('foo',)])
 
317
        self.assert_sql_count(testing.db, go, 1)
 
318
 
 
319
        s.commit()
 
320
        self.assertEquals(s.query(User.name).order_by(User.id).all(), [('edward',), ('jackward',), ('wendy',), ('foo',)])
 
321
 
 
322
    @testing.requires.savepoints
 
323
    def test_savepoint_rollback_collections(self):
 
324
        s = self.session()
 
325
        u1 = User(name='ed', addresses=[Address(email_address='foo')])
 
326
        s.add(u1)
 
327
        s.commit()
 
328
 
 
329
        u1.name='edward'
 
330
        u1.addresses.append(Address(email_address='bar'))
 
331
        s.begin_nested()
 
332
        u2 = User(name='jack', addresses=[Address(email_address='bat')])
 
333
        s.add(u2)
 
334
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
335
            [
 
336
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
337
                User(name='jack', addresses=[Address(email_address='bat')])
 
338
            ]
 
339
        )
 
340
        s.rollback()
 
341
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
342
            [
 
343
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
344
            ]
 
345
        )
 
346
        s.commit()
 
347
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
348
            [
 
349
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
350
            ]
 
351
        )
 
352
 
 
353
    @testing.requires.savepoints
 
354
    def test_savepoint_commit_collections(self):
 
355
        s = self.session()
 
356
        u1 = User(name='ed', addresses=[Address(email_address='foo')])
 
357
        s.add(u1)
 
358
        s.commit()
 
359
 
 
360
        u1.name='edward'
 
361
        u1.addresses.append(Address(email_address='bar'))
 
362
        s.begin_nested()
 
363
        u2 = User(name='jack', addresses=[Address(email_address='bat')])
 
364
        s.add(u2)
 
365
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
366
            [
 
367
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
368
                User(name='jack', addresses=[Address(email_address='bat')])
 
369
            ]
 
370
        )
 
371
        s.commit()
 
372
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
373
            [
 
374
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
375
                User(name='jack', addresses=[Address(email_address='bat')])
 
376
            ]
 
377
        )
 
378
        s.commit()
 
379
        self.assertEquals(s.query(User).order_by(User.id).all(),
 
380
            [
 
381
                User(name='edward', addresses=[Address(email_address='foo'), Address(email_address='bar')]),
 
382
                User(name='jack', addresses=[Address(email_address='bat')])
 
383
            ]
 
384
        )
 
385
 
 
386
    @testing.requires.savepoints
 
387
    def test_expunge_pending_on_rollback(self):
 
388
        sess = self.session()
 
389
 
 
390
        sess.begin_nested()
 
391
        u2= User(name='newuser')
 
392
        sess.add(u2)
 
393
        assert u2 in sess
 
394
        sess.rollback()
 
395
        assert u2 not in sess
 
396
 
 
397
    @testing.requires.savepoints
 
398
    def test_update_deleted_on_rollback(self):
 
399
        s = self.session()
 
400
        u1 = User(name='ed')
 
401
        s.add(u1)
 
402
        s.commit()
 
403
 
 
404
        s.begin_nested()
 
405
        s.delete(u1)
 
406
        assert u1 in s.deleted
 
407
        s.rollback()
 
408
        assert u1 in s
 
409
        assert u1 not in s.deleted
 
410
 
 
411
 
 
412
class AccountingFlagsTest(TransactionTest):
 
413
    
 
414
    def test_no_expire_on_commit(self):
 
415
        sess = sessionmaker(expire_on_commit=False)()
 
416
        u1 = User(name='ed')
 
417
        sess.add(u1)
 
418
        sess.commit()
 
419
 
 
420
        testing.db.execute(users.update(users.c.name=='ed').values(name='edward'))
 
421
        
 
422
        assert u1.name == 'ed'
 
423
        sess.expire_all()
 
424
        assert u1.name == 'edward'
 
425
 
 
426
    def test_rollback_no_accounting(self):
 
427
        sess = sessionmaker(_enable_transaction_accounting=False)()
 
428
        u1 = User(name='ed')
 
429
        sess.add(u1)
 
430
        sess.commit()
 
431
 
 
432
        u1.name = 'edwardo'
 
433
        sess.rollback()
 
434
        
 
435
        testing.db.execute(users.update(users.c.name=='ed').values(name='edward'))
 
436
 
 
437
        assert u1.name == 'edwardo'
 
438
        sess.expire_all()
 
439
        assert u1.name == 'edward'
 
440
 
 
441
    def test_commit_no_accounting(self):
 
442
        sess = sessionmaker(_enable_transaction_accounting=False)()
 
443
        u1 = User(name='ed')
 
444
        sess.add(u1)
 
445
        sess.commit()
 
446
 
 
447
        u1.name = 'edwardo'
 
448
        sess.rollback()
 
449
 
 
450
        testing.db.execute(users.update(users.c.name=='ed').values(name='edward'))
 
451
 
 
452
        assert u1.name == 'edwardo'
 
453
        sess.commit()
 
454
        
 
455
        assert testing.db.execute(select([users.c.name])).fetchall() == [('edwardo',)]
 
456
        assert u1.name == 'edwardo'
 
457
 
 
458
        sess.delete(u1)
 
459
        sess.commit()
 
460
        
 
461
    def test_preflush_no_accounting(self):
 
462
        sess = sessionmaker(_enable_transaction_accounting=False, autocommit=True)()
 
463
        u1 = User(name='ed')
 
464
        sess.add(u1)
 
465
        sess.flush()
 
466
        
 
467
        sess.begin()
 
468
        u1.name = 'edwardo'
 
469
        u2 = User(name="some other user")
 
470
        sess.add(u2)
 
471
        
 
472
        sess.rollback()
 
473
 
 
474
        sess.begin()
 
475
        assert testing.db.execute(select([users.c.name])).fetchall() == [('ed',)]
 
476
        
 
477
    
 
478
class AutocommitTest(TransactionTest):
 
479
    def test_begin_nested_requires_trans(self):
 
480
        sess = create_session(autocommit=True)
 
481
        self.assertRaises(sa_exc.InvalidRequestError, sess.begin_nested)
 
482
 
 
483
    def test_begin_preflush(self):
 
484
        sess = create_session(autocommit=True)
 
485
 
 
486
        u1 = User(name='ed')
 
487
        sess.add(u1)
 
488
        
 
489
        sess.begin()
 
490
        u2 = User(name='some other user')
 
491
        sess.add(u2)
 
492
        sess.rollback()
 
493
        assert u2 not in sess
 
494
        assert u1 in sess
 
495
        assert sess.query(User).filter_by(name='ed').one() is u1
 
496
        
 
497
        
 
498
 
 
499
 
 
500
if __name__ == '__main__':
 
501
    testenv.main()