Method test_nextset

tests/test_MySQLdb_dbapi20.py:184–227

(self)

        cur.execute("drop procedure deleteme")

    def test_nextset(self):
        # from warnings import warn

        con = self._connect()
        try:
            cur = con.cursor()
            if not hasattr(cur, "nextset"):
                return

            try:
                self.executeDDL1(cur)
                sql = self._populate()
                for sql in self._populate():
                    cur.execute(sql)

                self.help_nextset_setUp(cur)

                cur.callproc("deleteme")
                numberofrows = cur.fetchone()
                assert numberofrows[0] == len(self.samples)
                assert cur.nextset()
                names = cur.fetchall()
                assert len(names) == len(self.samples)
                s = cur.nextset()
                if s:
                    empty = cur.fetchall()
                    self.assertEqual(
                        len(empty), 0, "non-empty result set after other result sets"
                    )
                    # warn(
                    #    ": ".join(
                    #        [
                    #            "Incompatibility",
                    #            "MySQL returns an empty result set for the CALL itself"
                    #        ]
                    #    ),
                    #    Warning,
                    # )
                # assert s == None, "No more return sets, should return None"
            finally:
                self.help_nextset_tearDown(cur)

        finally:
            con.close()


if __name__ == "__main__":