#!/usr/bin/python2.4
#
# Small script to show PostgreSQL and Pyscopg together
#

import psycopg2

import sys


con = None

try:

    con = psycopg2.connect("dbname='postgres' user='nikitos' host='localhost' password='pass'")

    cur = con.cursor()

    #cur.execute("CREATE TABLE Cars(Id INTEGER PRIMARY KEY, Name VARCHAR(20), Price INT)")
    #cur.execute("INSERT INTO Cars VALUES(221,'Audi',52642)")
    #cur.execute("UPDATE Cars SET Name='Alfred Schmidt' WHERE Id=1121;")
    #cur.execute("DELETE FROM Cars where id = 1120")

    cur.execute("INSERT INTO Cars VALUES(1121,'Mercedes',57127),(1120,'Mercedes',57127),(1122,'Mercedes',57127)")
    #cur.execute("SELECT Name, Price FROM Cars WHERE Price = 52642")
    cur.execute("SELECT 151;");
    con.commit()


except psycopg2.DatabaseError, e:

   # if con:
   #     con.rollback()

    print 'Error %s' % e
    sys.exit(1)


finally:

    if con:
        con.close()