Method get_result

mycli/sqlexecute.py:391–412

Get the current result's data from the cursor.

(self, cursor: Cursor)

                        break

    def get_result(self, cursor: Cursor) -> SQLResult:
        """Get the current result's data from the cursor."""
        preamble = header = None

        # cursor.description is not None for queries that return result sets,
        # e.g. SELECT or SHOW.
        plural = '' if cursor.rowcount == 1 else 's'
        if cursor.description:
            header = [x[0] for x in cursor.description]
            status = FormattedText([('', f'{cursor.rowcount} row{plural} in set')])
        else:
            _logger.debug("No rows in result.")
            status = FormattedText([('', f'Query OK, {cursor.rowcount} row{plural} affected')])

        if cursor.warning_count > 0:
            plural = '' if cursor.warning_count == 1 else 's'
            comma = FormattedText([('', ', ')])
            warning_count = FormattedText([('class:output.status.warning-count', f'{cursor.warning_count} warning{plural}')])
            status.extend(comma)
            status.extend(warning_count)

        return SQLResult(preamble=preamble, header=header, rows=cursor, status=status)

    def tables(self) -> Generator[tuple[str], None, None]:
        """Yields table names"""