1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
from sqlalchemy.engine import default
from sqlalchemy.databases import *
from sqlalchemy.orm import mapper
from sqlalchemy.orm import Session
from test.lib import AssertsCompiledSQL
from test.lib.testing import assert_raises_message
from test.orm import _fixtures
class LockModeTest(_fixtures.FixtureTest, AssertsCompiledSQL):
run_inserts = None
@classmethod
def setup_mappers(cls):
User, users = cls.classes.User, cls.tables.users
mapper(User, users)
def test_default_update(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update'),
"SELECT users.id AS users_id FROM users FOR UPDATE",
dialect=default.DefaultDialect()
)
def test_not_supported_by_dialect_should_just_use_update(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('read'),
"SELECT users.id AS users_id FROM users FOR UPDATE",
dialect=default.DefaultDialect()
)
def test_none_lock_mode(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode(None),
"SELECT users.id AS users_id FROM users",
dialect=default.DefaultDialect()
)
def test_unknown_lock_mode(self):
User = self.classes.User
sess = Session()
assert_raises_message(
Exception, "Unknown lockmode 'unknown_mode'",
self.assert_compile,
sess.query(User.id).with_lockmode('unknown_mode'), None,
dialect=default.DefaultDialect()
)
def test_postgres_read(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('read'),
"SELECT users.id AS users_id FROM users FOR SHARE",
dialect=postgresql.dialect()
)
def test_postgres_read_nowait(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('read_nowait'),
"SELECT users.id AS users_id FROM users FOR SHARE NOWAIT",
dialect=postgresql.dialect()
)
def test_postgres_update(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update'),
"SELECT users.id AS users_id FROM users FOR UPDATE",
dialect=postgresql.dialect()
)
def test_postgres_update_nowait(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update_nowait'),
"SELECT users.id AS users_id FROM users FOR UPDATE NOWAIT",
dialect=postgresql.dialect()
)
def test_oracle_update(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update'),
"SELECT users.id AS users_id FROM users FOR UPDATE",
dialect=oracle.dialect()
)
def test_oracle_update_nowait(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update_nowait'),
"SELECT users.id AS users_id FROM users FOR UPDATE NOWAIT",
dialect=oracle.dialect()
)
def test_mysql_read(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('read'),
"SELECT users.id AS users_id FROM users LOCK IN SHARE MODE",
dialect=mysql.dialect()
)
def test_mysql_update(self):
User = self.classes.User
sess = Session()
self.assert_compile(sess.query(User.id).with_lockmode('update'),
"SELECT users.id AS users_id FROM users FOR UPDATE",
dialect=mysql.dialect()
)
|
