def notfound(self, pagename):
page = Page(pagename=pagename, data="")
DBSession.save(page)
DBSession.commit()
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 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)
