Работа с Firebird

class DB:
    def __init__(self):
        self.connect = None  # connection object
        self.result = None
 
    def engine(self):
        engine = create_engine(f'firebird+fdb://login:password@1.1.1.1:3050/db?charset=utf-8',
                               echo=True, poolclass=NullPool)
        self.connect = engine.connect()  # open connection to  DB
 
    def execute(self, request, **param):
        self.result = self.connect.execute(request, **param)
        return self.result
 
    def __del__(self):
        if self.result is not None:
            self.result.close()  # close sql request result
        if self.connect is not None:
            self.connect.close()  # close db connection

class Monitoring(APIView):
    """List all organizations, or create new organization."""
    @staticmethod
    def get(request):
        # [GET]: /api/monitoring
        """
        Get list of servers with full monitoring data.
        :param request: request data
        :return: dict
        """
        if request.method == 'GET':
            try:
                s = select([monitoring]).order_by('id')
 
                d = DB()
                d.engine()
                row = d.execute(s).fetchall()
                return Response(row)
            except Exception as e:
                return HttpResponse(str(e))