Python SQLite 코드 샘플-외부 파일 읽어 처리

#!/opt/bin/python
# -*- coding: cp949 -*-
import sys
sys.path.append('/opt/lib/python2.4/site-packages')
from pysqlite2 import dbapi2 as sqlite
import csv, os, string

print "Content-Type: text/html"
print
print "Insert Start.."
print "<br>"
outfile = './' +'insertsql.sql'
# updateline="update credituse set price=price*(-1) where price>0 and accept='취소'"
# Create a connection to the database file "mydb":
con = sqlite.connect("mydb")
cur = con.cursor()
f = open(outfile,'r')
for line in f:
  print line
  print "<br>"
  cur.execute(line)
f.close()       
#cur.execute(updateline)
con.commit()
print "<center>"
print "<br>"
print "데이타베이스에 자료가 입력되었습니다!!"
print "<br>"
print "<br>"
print "<a href=index.html>초기화면으로 </a>"
print "</center>"