database_python_sample

database_python_sample

import psycopg2
def update_DB(host='localhost',dbname='lapisco',user='postgres',
              password='senha',projetc_id='35',field='status',
              value='5',table='projeto'):
    con = None    
    try:
        con = psycopg2.connect("host='"+host+"' dbname='"+dbname+"' user='"+user+"' password='"+password+"'")           
        cur = con.cursor()

        cur.execute("UPDATE "+table+" SET "+field+"="+value+" WHERE id="+projetc_id)      
        con.commit()
    except psycopg2.DatabaseError, e:
        if con:
            con.rollback()    
        print 'Error %s' % e    
        sys.exit(1)
    finally:   
        if con:
            con.close()
    return True

teste