def test_expunge_cascade(self):
tables.data()
mapper(Address, addresses)
mapper(User, users, properties={
'addresses':relation(Address, backref=backref("user", cascade="all"), cascade="all")
})
session = create_session()
u = session.query(User).filter_by(user_id=7).one()
# get everything to load in both directions
print [a.user for a in u.addresses]
def dont_test_autoflush_rollback(self):
tables.data()
mapper(Address, addresses)
mapper(User, users, properties={
'addresses':relation(Address)
})
sess = create_session(transactional=True, autoflush=True)
u = sess.query(User).get(8)
newad = Address()
newad.email_address == 'something new'
u.addresses.append(newad)
u.user_name = 'some new name'
assert u.user_name == 'some new name'
assert len(u.addresses) == 4
assert newad in u.addresses
sess.rollback()
assert u.user_name == 'ed'
assert len(u.addresses) == 3
assert newad not in u.addresses
def setUpAll(self):
tables.create()
tables.data()