Connect to Postgresql with Python 3.x and get Pandas Dataframe

virtualenv -p python3 venv

source venv/bin/activate

pip install PyGreSQL

from pgdb import connect

class PostGresql(object):

    def __init__(self):
        self.connection_pool = None
        self.database = "database" //(1)
        self.host = "host" //(2)
        self.user = "user" //(3)
        self.password = "password" //(4)

    def get_connection(self):
        connection = connect(database=self.database,host=self.host,user=self.user,password=self.password)
        return connection

import pandas as pd

class PostgreDao(object):

    def __init__(self, postSqlDb):
        self.postSqlDb = postSqlDb
        print("Acquiring connection")
        self.connection = postSqlDb.get_connection()

    def __del__(self):
        print("Closing db connection")
        self.connection.close()

    def read_table(self, query):
        """Read SQL Table
            Args:
              query: text, query to read table or multiple tables
            Returns:
              pandas dataframe, if query is valid
            """
        df = pd.read_sql_query(query, self.connection)
        return df

dbcon = PostGresql()
dbclass = PostgreDao(dbcon)

query = """
            select * from table
            """
data = dbclass.read_table(query)