#!/usr/bin/python

import cgi
import sqlite3

conn = sqlite3.connect('/tmp/example')

c = conn.cursor()

# Create table
c.execute('''create table stocks (date text, price real)''')

# Insert a row of data
c.execute("""insert into stocks values ('2006-01-05',35.14)""")

# Save (commit) the changes
conn.commit()

c.close()