#!/usr/bin/python

import psycopg2
import sys

def main():
    h = "192.168.9.10"
    db='CAMDPAMS'
    passwd = 'BSiyA1ov'
    user = "cert_botan"
    try:
	conn=psycopg2.connect(host=h, database=db, user=user, password=passwd)
	cursor=conn.cursor()
	sql="select \"SampleSha1\" from samples limit 10"
	cursor.execute(sql)
	for row in cursor:
		print "%s\r" % row[0]
    except:
	exceptionType, exceptionValue, exceptionTraceback = sys.exc_info()
	sys.exit("Database connection failed!\n ->%s" % (exceptionValue))


if __name__ == "__main__":
    sys.exit(main())