""" CGI_DB
combine database concepts and CGI
expects sqlite database called dvd.db in same
directory. Uses CGI and apsw modules
"""
import apsw, cgi
connection = apsw.Connection("dvd.db")
cursor = connection.cursor()
result = cursor.execute("SELECT * FROM vidRating")
print "Content-Type: text/html\n\n"
print """
Database Results
Videos in my collection
| Name |
Rating |
"""
for (name, rating) in result:
print """
| %s |
%s |
""" % (name, rating)
print """
"""