#!c:\python24\python.exe -u
#!/usr/bin/env python2.4
 
import cgi, os
import cgitb; cgitb.enable()
import sys
import psycopg2
import psycopg2.extras
 
print "running psycopg2 ...."
 
try :
    conn=psycopg2.connect("host='localhost' dbname='testpsycopg' user='postgres'")
    print "connect database!!"
except StandardError, e:
    print "Unable to Connect !", e
    #sys.exit()
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
login="abc"
password="xyz"
name="123"
location="/ms4w/Apache/cgi-bin/123.txt"
try:
    conn.set_isolation_level(0)
    cur.execute('INSERT INTO web_index(id,login_name,password,name,file_location) VALUE (1,"abc","xyz","kmitnb","/ms4w/Apache/cgi-bin/123.txt")')
    print "INSERT DATABASE"
except:
    print "CAN NOT"
    sys.exit()

try:
    conn.set_isolation_level(0)
    cur.execute('INSERT INTO web_index(id,login_name,password,name,file_location) VALUE (1,"abc","xyz","123","/ms4w/Apache/cgi-bin/123.txt")')
    print "INSERT DATABASE"

try:
    conn.set_isolation_level(0)
    cur.execute('DROP Table ')
    print "INSERT DATABASE"

try:
    conn.set_isolation_level(0)
    cur.execute('INSERT INTO web_index (id,login_name,password,name,file_location) VALUE (%d,%s,%s,%s,%s)', (1,"abc","xyz","kmitnb","/ms4w/Apache/cgi-bin/123.txt"))
    print "INSERT DATABASE"
except Exception,why:
    print "CAN NOT",why
    sys.exit()