#!/usr/bin/python

"Return picture given its id"

import cgi
import sqlite3

form = cgi.FieldStorage()
picid = int(form["id"].value)

conn = sqlite3.connect("demo.db")
cursor = conn.cursor()
sql = "select picture, mimetype from album where id=?"
cursor.execute(sql, (picid,))
picture, mimetype = cursor.fetchone()
picture = str(picture) # MySQL: picture.tostring()
conn.close()

print "Content-Type: %s" % mimetype
print "Content-Length: %d" % len(picture)
print
print picture