##import pgdb
from pyPgSQL import PgSQL
import os

def getConnection():
	try:
		single = ConnectionManager()
	except ConnectionManager, s:
		single = s
	return single.getConnection()    

class ConnectionManager :
	__instance__ = None

	def __init__(self):
		if ConnectionManager.__instance__:
			raise ConnectionManager.__instance__
		ConnectionManager.__instance__ = self
		print "info :"
		print info
		##self.connection =  pgdb.connect('%s:%s' % (info['host'], info['db']),'%s' % info['user'],'%s' % info['passwd'])
		self.connection =  PgSQL.connect('localhost::atelier:atelier:atelier')

	def getConnection(self):
		return self.connection

def getConnexionInfo():
	info = {}
	os.system("""if [ -f ~/.atelier.conf ];
			then cp -f ~/.atelier.conf ./.atelier.conf
		fi""")
	cfg = open('.atelier.conf', 'r')
	s = cfg.readline()
	while s != "":
		if s[0] != "#":
			i = 0
			clef = valeur = ""
			while s[i] != ':':
				clef = clef + s[i]
				i = i + 1
			i = i + 1
			while s[i] != "\n":
				valeur = valeur + s[i]
				i = i + 1
			info[clef] = valeur
		s = cfg.readline()
	return info
	
	
info = getConnexionInfo()