Clase connection Python a PostgreSQL

config.ini

[postgresql]
host=localhost
port=5432
database=Example-DB
user=postgres
password=yourpostgresspwd

RepositorioPostgres.py

import psycopg2
from configparser import ConfigParser


class Postgres():
	""" Connect to the PostgreSQL database server """
	connection = None
	

	def __init__(self):
		try:
			params = self.config()

			if self.connection is None:
				print('Connecting to the PostgreSQL database...')
				self.connection = psycopg2.connect(**params)
			
		except (Exception, psycopg2.DatabaseError) as error:
			print(error)


	def config(self, filename='config.ini', section='postgresql'):
		
		parser = ConfigParser()
		parser.read(filename)
	
		# get section, default to postgresql
		db = {}
		if parser.has_section(section):
			params = parser.items(section)
			for param in params:
				db[param[0]] = param[1]
		else:
			raise Exception('Section {0} not found in the {1} file'.format(section, filename))
	
		return db


	def return_connection(self):
		if self.connection is not None:
			return self.connection
		else: return None


	def cerrar_conexion(self):
		if self.connection is not None:
			self.connection.close()
			print('Database connection closed.')