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
|
from sqlalchemy import *
import testbase
class Jack(object):
def __repr__(self):
return "{Jack %s - %s}" % (self.id, self.number)
def __init__(self, room=None, subroom=None, number=None, status=None):
self.id = None
self.room = room
self.subroom = subroom
self.number = number
self.status = status
class Port(object):
def __repr__(self):
return "{Port %s - %s}" % (self.id, self.name)
def __init__(self, name=None, description=None):
self.id=None
self.name=name
self.description = description
class O2OTest(testbase.AssertMixin):
def setUpAll(self):
global jack, port
jack = Table('jack', testbase.db,
Column('id', Integer, primary_key=True),
#Column('room_id', Integer, ForeignKey("room.id")),
Column('number', String(50)),
Column('status', String(20)),
Column('subroom', String(5)),
)
port = Table('port', testbase.db,
Column('id', Integer, primary_key=True),
#Column('device_id', Integer, ForeignKey("device.id")),
Column('name', String(30)),
Column('description', String(100)),
Column('jack_id', Integer, ForeignKey("jack.id")),
)
jack.create()
port.create()
def setUp(self):
objectstore.clear()
def tearDown(self):
clear_mappers()
def tearDownAll(self):
port.drop()
jack.drop()
def test1(self):
assign_mapper(Port, port)
assign_mapper(Jack, jack, order_by=[jack.c.number],properties = {
'port': relation(Port.mapper, backref='jack', uselist=False, lazy=True),
})
j=Jack(number='101')
p=Port(name='fa0/1')
j.port=p
objectstore.commit()
jid = j.id
pid = p.id
j=Jack.get(jid)
p=Port.get(pid)
print p.jack
print j.port
p.jack=None
assert j.port is None #works
objectstore.clear()
j=Jack.get(jid)
p=Port.get(pid)
j.port=None
self.assert_(p.jack is None)
objectstore.commit()
j.delete()
objectstore.commit()
if __name__ == "__main__":
testbase.main()
|
