postgresql

con1 = {}
con1['host'] = 'x.x.x.x'
con1['dbname'] = 'dbname'
con1['port'] = '5432'
con1['user'] = 'postgres'
con1['password'] = ''

connect1 = postgres_connect(con1)

cursor1 = connect1.cursor()

sql = "INSERT INTO my_table (id, login, status) VALUES(NEXTVAL('uniq_id'), 'test', 'ok');"
			
res = cursor1.execute(sql)
connect1.commit()


def postgres_connect(con):	
	
	import psycopg2	
		
	#database = pgdb.connect (host = con.data['host'] + ':' + con.data['port'], database = con.data['dbname'], user = con.data['user'], password = con.data['password'])
	database = psycopg2.connect (host = con['host'], port = con['port'], database = con['dbname'], user = con['user'], password = con['password'])
	
	return database

con1 = {}
con1['host'] = 'x.x.x.x'
con1['dbname'] = 'dbname'
con1['port'] = '5432'
con1['user'] = 'postgres'
con1['password'] = ''

cursor1 = postgres_connect(con1)

def postgres_connect(con):

	import psycopg2	
		
	#database = pgdb.connect (host = con.data['host'] + ':' + con.data['port'], database = con.data['dbname'], user = con.data['user'], password = con.data['password'])
	database = psycopg2.connect (host = con['host'], port = con['port'], database = con['dbname'], user = con['user'], password = con['password'])
	
	cursor = database.cursor()	

	return cursor