def testOwner(self): tag = Tag(name='bar') page = Page(title='foo') person = Person(email="*****@*****.**") self.session.add_all([page, tag, person]) page.tags.append(tag) page.owner = person self.session.commit() self.session.expire_all() print '------------ owner' for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to, page.owner_ref owner = page.owner if owner: print '\t', owner.id, owner.ref, owner.email, owner.valid_from, owner.valid_to page.owner = None self.session.commit() self.session.expire_all() for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to, page.owner_ref owner = page.owner if owner: print '\t', owner.id, owner.ref, owner.email, owner.valid_from, owner.valid_to
def testOwner(self): tag = Tag(name='bar') page = Page(title='foo') person = Person(email="*****@*****.**") self.session.add_all([page, tag, person]) page.tags.append(tag) page.owner = person self.session.commit() self.session.expire_all() print '------------ owner' for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to, page.owner_ref owner = page.owner if owner: print '\t', owner.id, owner.ref, owner.email, owner.valid_from, owner.valid_to page.owner = None self.session.commit() self.session.expire_all() for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to, page.owner_ref owner = page.owner if owner: print '\t', owner.id, owner.ref, owner.email, owner.valid_from, owner.valid_to