#!/usr/bin/python
"Main entry point; listing of currently uploaded pictures"
import cgi
import sqlite3
form = cgi.FieldStorage()
if form.has_key("init"):
import os
try: os.remove("demo.db")
except OSError: pass
conn = sqlite3.connect("demo.db")
cursor = conn.cursor()
cursor.execute("create table album "
" (id integer, title text, "
" description text, picture binary, "
" mimetype text)")
conn.close()
conn = sqlite3.connect("demo.db")
cursor = conn.cursor()
sql = "select id, title from album order by id"
cursor.execute(sql)
lines = []
for row in cursor.fetchall():
id, title = row
lines.append("%s" % (id, cgi.escape(title)))
conn.close()
print "Content-Type: text/html"
print "Pragma: no-cache"
print "Cache-Control: no-cache"
print
print "Picture album"
print ""
print "Picture album
"
if lines:
print ""
print "\n".join(lines)
print "
"
else:
print "No pictures yet."
print "You can upload a new picture.
"
print ""