def testTag(self):
tag = Tag.find_or_create(self.session,'foo')
self.session.commit()
tag.name = 'harry'
self.session.commit()
print '------------ tag 1'
for tag in self.session.query(Tag):
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
print '------------ tag 2'
for tag in self.session.query(Tag).filter(Tag.valid_on()):
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
def testTag(self):
tag = Tag.find_or_create(self.session, 'foo')
self.session.commit()
tag.name = 'harry'
self.session.commit()
print '------------ tag 1'
for tag in self.session.query(Tag):
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
print '------------ tag 2'
for tag in self.session.query(Tag).filter(Tag.valid_on()):
print tag.id, tag.ref, tag.name, tag.valid_from, tag.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
def testChange(self):
tag = Tag.find_or_create(self.session,'bar')
self.session.commit()
print '------------ change'
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
tag.name = 'foo'
self.session.commit()
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
def testChange(self):
tag = Tag.find_or_create(self.session, 'bar')
self.session.commit()
print '------------ change'
print tag.id, tag.ref, tag.name, tag.valid_from, tag.valid_to
tag.name = 'foo'
self.session.commit()
print 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
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
