Python execute_and_fetch_query Examples

Example #1

File: models.py Project: mkoryak/django-sql-explorer

 def headers_and_data(self):
     if not self.passes_blacklist():
         return [], [], None, MSG_FAILED_BLACKLIST
     try:
         return execute_and_fetch_query(self.final_sql())
     except (DatabaseError, Warning), e:
         return [], [], None, str(e)

Example #2

File: models.py Project: abhishekreddy1206/django-sql-explorer

    def headers_and_data(self, params=None):
        """
        Retrieve the results from a query.

        :param params: A dictionary of Query param values. These will get merged into the final SQL before execution.
        :return: ([headers], [data], duration in ms, error message)
        """

        if not self.passes_blacklist(params):
            return [], [], None, MSG_FAILED_BLACKLIST
        try:
            return execute_and_fetch_query(self.final_sql(params))
        except (DatabaseError, Warning), e:
            return [], [], None, str(e)

Example #3

File: models.py Project: ersherr/django-sql-explorer

    def headers_and_data(self, params=None):
        """
        Retrieve the results from a query.

        :param params: A dictionary of Query param values. These will get merged into the final SQL before execution.
        :return: ([headers], [data], duration in ms, error message)
        """

        if not self.passes_blacklist(params):
            return [], [], None, MSG_FAILED_BLACKLIST
        try:
            return execute_and_fetch_query(self.final_sql(params))
        except (DatabaseError, Warning), e:
            return [], [], None, str(e)