---

import psycopg2
import os
from dotenv import load_dotenv

load_dotenv()

class QwerysSql:
    def __init__(self):
        try:
            self.conn = psycopg2.connect(
                host=os.getenv('db_host'),
                user=os.getenv('db_user'),
                dbname=os.getenv('db_name'),
                password=os.getenv('db_password')
            )
            self.cursor = self.conn.cursor()
        except Exception as ex:
            print(ex)

    def show_available_pets(self):
        sql = "select * from available_pets"
        self.cursor.execute(sql)
        order_data = self.cursor.fetchall()
        return order_data