def default(self, pagename="FrontPage"):
     try:
         page = DBSession.query(Page).filter_by(pagename=pagename).one()
     except InvalidRequestError:
         raise tg.redirect("notfound", pagename = pagename)
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     content = publish_parts(page.data, writer_name="html")["html_body"]
     root = tg.url('/')
     content = wikiwords.sub(r'<a href="%s\1">\1</a>' % root, content)
     return dict(content=content, wikipage=page)

 def setUp(self):
     """Prepare model test fixture."""
     try:
         new_attrs = {}
         new_attrs.update(self.attrs)
         new_attrs.update(self.do_get_dependencies())
         self.obj = self.klass(**new_attrs)
         DBSession.add(self.obj)
         DBSession.flush()
         return self.obj
     except:
         DBSession.rollback()
         raise

 def pagelist(self):
     pages = [page.pagename for page in DBSession.query(Page)]
     return dict(pages=pages)

 def notfound(self, pagename):
     page = Page(pagename=pagename, data="")
     DBSession.add(page)
     return dict(wikipage=page)

 def save(self, pagename, data, submit):
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     page.data = data
     redirect("/" + pagename)

 def edit(self, pagename):
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     return dict(wikipage=page)

from wiki20.model import DBSession, Page, metadata
from sqlalchemy import create_engine

# Prepare the database connection
engine = create_engine("sqlite:///devdata.db", echo=True)
DBSession.configure(bind=engine)

# Create the tables
metadata.drop_all(engine)
metadata.create_all(engine)

# Create a page object and set some data
page = Page("FrontPage", "initial data")

# Save the page object to the in memory DBSession
DBSession.save(page)

# Use commit() to write all in-memory changes to the database.
DBSession.commit()

 def index(self, pagename="FrontPage"):
     """Handle the front-page."""
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     return dict(wikipage=page)

 def save(self, pagename, data, submit):
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     page.data = data
     DBSession.commit() # Tells database to commit changes permanently
     redirect("/" + pagename)

 def _default(self, pagename="FrontPage"):
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     content = publish_parts(page.data, writer_name="html")["html_body"]
     root = url('/')
     content = wikiwords.sub(r'<a href="%s\1">\1</a>' % root, content)
     return dict(content=content, wikipage=page)

 def test_query_obj(self):
     """Model objects can be queried"""
     obj = DBSession.query(self.klass).one()
     for key, value in self.attrs.iteritems():
         assert_equals(getattr(obj, key), value)

 def tearDown(self):
     """Finish model test fixture."""
     DBSession.rollback()

 def notfound(self, pagename):
     page = Page(pagename=pagename, data="")
     DBSession.save(page)
     DBSession.commit()
     return dict(wikipage=page)

 def by_user_name(cls, username):
     """Return the user object whose user name is ``username``."""
     return DBSession.query(cls).filter_by(user_name=username).first()

 def by_email_address(cls, email):
     """Return the user object whose email address is ``email``."""
     return DBSession.query(cls).filter_by(email_address=email).first()

 def index(self, pagename="FrontPage"):
     page = DBSession.query(Page).filter_by(pagename=pagename).one()
     return dict(wikipage=page)