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
|
from sqlobject import OR, RelatedJoin, SQLObject, StringCol, cache
from sqlobject.tests.dbtest import setupClass
from .test_basic import TestSO1, setupGetters
########################################
# Delete during select
########################################
def testSelect():
setupGetters(TestSO1)
for obj in TestSO1.select('all'):
obj.destroySelf()
assert list(TestSO1.select('all')) == []
########################################
# Delete many rows at once
########################################
def testDeleteMany():
setupGetters(TestSO1)
TestSO1.deleteMany(OR(TestSO1.q.name == "bob", TestSO1.q.name == "fred"))
assert len(list(TestSO1.select('all'))) == 2
def testDeleteBy():
setupGetters(TestSO1)
TestSO1.deleteBy(name="dave")
assert len(list(TestSO1.select())) == 3
########################################
# Delete without caching
########################################
class NoCache(SQLObject):
name = StringCol()
def testDestroySelf():
setupClass(NoCache)
old = NoCache._connection.cache
NoCache._connection.cache = cache.CacheSet(cache=False)
value = NoCache(name='test')
value.destroySelf()
NoCache._connection.cache = old
########################################
# Delete from related joins
########################################
class Service(SQLObject):
groups = RelatedJoin("ServiceGroup")
class ServiceGroup(SQLObject):
services = RelatedJoin("Service")
def testDeleteRelatedJoins():
setupClass([Service, ServiceGroup])
service = Service()
service_group = ServiceGroup()
service.addServiceGroup(service_group)
service.destroySelf()
service_group = ServiceGroup.get(service_group.id)
assert len(service_group.services) == 0
|
