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 testPage(self): tag = Tag.find_or_create(self.session, 'bar') page = Page(title='foo') self.session.add(page) page.tags.append(tag) self.session.commit() print '------------ page' for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to for tag in page.tags: print '\t', tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
def testPage(self): tag = Tag.find_or_create(self.session,'bar') page = Page(title='foo') self.session.add(page) page.tags.append(tag) self.session.commit() print '------------ page' for page in self.session.query(Page).filter(Page.valid_on()): print page.id, page.ref, page.title, page.valid_from, page.valid_to for tag in page.tags: print '\t', tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to