Files

/blog.py/schema.sql/templates:/templates/view.html/templates/new.html/templates/base.html/templates/index.html/templates/edit.html/model.py

/blog.py

""" Basic blog using webpy 0.3 """import webimport model### Url mappingsurls = ('/', 'Index','/view/(\d+)', 'View','/new', 'New','/delete/(\d+)', 'Delete','/edit/(\d+)', 'Edit',)### Templatest_globals = {'datestr': web.datestr}render = web.template.render('templates', base='base', globals=t_globals)class Index:def GET(self):""" Show page """posts = model.get_posts()return render.index(posts)class View:def GET(self, id):""" View single post """post = model.get_post(int(id))return render.view(post)class New:form = web.form.Form(web.form.Textbox('title', web.form.notnull,size=30,description="Post title:"),web.form.Textarea('content', web.form.notnull,rows=30, cols=80,description="Post content:"),web.form.Button('Post entry'),)def GET(self):form = self.form()return render.new(form)def POST(self):form = self.form()if not form.validates():return render.new(form)model.new_post(form.d.title, form.d.content)raise web.seeother('/')class Delete:def POST(self, id):model.del_post(int(id))raise web.seeother('/')class Edit:def GET(self, id):post = model.get_post(int(id))form = New.form()form.fill(post)return render.edit(post, form)def POST(self, id):form = New.form()post = model.get_post(int(id))if not form.validates():return render.edit(post, form)model.update_post(int(id), form.d.title, form.d.content)raise web.seeother('/')app = web.application(urls, globals())if __name__ == '__main__':app.run()

/schema.sql

CREATE TABLE entries (id INT AUTO_INCREMENT,title TEXT,content TEXT,posted_on DATETIME,primary key (id));

/templates/view.html

$def with (post)
$post.title
$datestr(post.posted_on)
$post.content

/templates/new.html

$def with (form)
New Blog Post
$:form.render()

/templates/base.html

$def with (page)
Home
New Post
$:page

/templates/index.html

$def with (posts)
Blog posts
$for post in posts:
$post.titlefrom $datestr(post.posted_on)Edit

/templates/edit.html

$def with (post, form)
Edit $form.d.title
$:form.render()
Delete post

/model.py

import web, datetimedb = web.database(dbn='mysql', db='blog', user='justin')def get_posts():return db.select('entries', order='id DESC')def get_post(id):try:return db.select('entries', where='id=$id', vars=locals())[0]except IndexError:return Nonedef new_post(title, text):db.insert('entries', title=title, content=text, posted_on=datetime.datetime.utcnow())def del_post(id):db.delete('entries', where="id=$id", vars=locals())def update_post(id, title, text):db.update('entries', where="id=$id", vars=locals(),title=title, content=text)