-
Notifications
You must be signed in to change notification settings - Fork 28
Expand file tree
/
Copy pathtest_ForeignKey_cascade.py
More file actions
150 lines (103 loc) · 3.43 KB
/
Copy pathtest_ForeignKey_cascade.py
File metadata and controls
150 lines (103 loc) · 3.43 KB
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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
from sqlobject import ForeignKey, SQLObject, StringCol, \
SQLObjectIntegrityError, SQLObjectNotFound
from sqlobject.tests.dbtest import raises, setupClass
class SOTestPerson1(SQLObject):
name = StringCol()
class SOTestMessageCascadeTrue(SQLObject):
sender = ForeignKey('SOTestPerson1', cascade=True)
recipient = ForeignKey('SOTestPerson1', cascade=True)
body = StringCol()
def test1():
setupClass([SOTestPerson1, SOTestMessageCascadeTrue])
john = SOTestPerson1(name='john')
emily = SOTestPerson1(name='emily')
message = SOTestMessageCascadeTrue(
sender=emily, recipient=john, body='test1'
)
SOTestPerson1.delete(emily.id)
john.expire()
message.expire()
john.sync()
raises(SQLObjectNotFound, emily.sync)
raises(SQLObjectNotFound, message.sync)
class SOTestPerson2(SQLObject):
name = StringCol()
class SOTestMessageCascadeFalse(SQLObject):
sender = ForeignKey('SOTestPerson2', cascade=False)
recipient = ForeignKey('SOTestPerson2', cascade=False)
body = StringCol()
def test2():
setupClass([SOTestPerson2, SOTestMessageCascadeFalse])
john = SOTestPerson2(name='john')
emily = SOTestPerson2(name='emily')
message = SOTestMessageCascadeFalse(
sender=emily, recipient=john, body='test2'
)
raises(SQLObjectIntegrityError, SOTestPerson2.delete, emily.id)
john.expire()
emily.expire()
message.expire()
john.sync()
emily.sync()
message.sync()
assert message.sender == emily
assert message.recipient == john
class SOTestPerson3(SQLObject):
name = StringCol()
class SOTestMessageCascadeNull(SQLObject):
sender = ForeignKey('SOTestPerson3', cascade='null')
recipient = ForeignKey('SOTestPerson3', cascade='null')
body = StringCol()
def test3():
setupClass([SOTestPerson3, SOTestMessageCascadeNull])
john = SOTestPerson3(name='john')
emily = SOTestPerson3(name='emily')
message = SOTestMessageCascadeNull(
sender=emily, recipient=john, body='test3'
)
SOTestPerson3.delete(emily.id)
john.expire()
message.expire()
john.sync()
message.sync()
raises(SQLObjectNotFound, emily.sync)
assert message.sender is None
assert message.recipient == john
SOTestPerson3.delete(john.id)
john.expire()
message.expire()
message.sync()
raises(SQLObjectNotFound, john.sync)
assert message.recipient is None
class SOTestPerson4(SQLObject):
name = StringCol()
class SOTestMessageCascadeMixed(SQLObject):
sender = ForeignKey('SOTestPerson4', cascade=True)
recipient = ForeignKey('SOTestPerson4', cascade='null')
body = StringCol()
def test4():
setupClass([SOTestPerson4, SOTestMessageCascadeMixed])
john = SOTestPerson4(name='john')
emily = SOTestPerson4(name='emily')
message = SOTestMessageCascadeMixed(
sender=emily, recipient=john, body='test4'
)
SOTestPerson4.delete(emily.id)
john.expire()
message.expire()
john.sync()
raises(SQLObjectNotFound, message.sync)
def test5():
setupClass([SOTestPerson4, SOTestMessageCascadeMixed])
john = SOTestPerson4(name='john')
emily = SOTestPerson4(name='emily')
message = SOTestMessageCascadeMixed(
sender=emily, recipient=john, body='test5'
)
john.destroySelf()
emily.expire()
message.expire()
emily.sync()
message.sync()
assert message.recipient is None
assert message.sender == emily