代码之家  ›  专栏  ›  技术社区  ›  Géry Ogam

MySQL连接器方法“fetchone”和“fetchmany”不符合PEP 249

  •  2
  • Géry Ogam  · 技术社区  · 8 年前

    具有 Python 3.6.2 MySQL Connector 2.1.6 Windows 10上的软件包,不调用 execute SELECT CREATE DROP , ALTER INSERT DELETE , UPDATE 等)得出以下结果:

    >>> import mysql.connector
    >>> session = mysql.connector.connect(user = "root", database = "mysql")
    >>> cursor = session.cursor()
    >>> cursor.fetchone()
    >>> cursor.fetchmany()
    []
    >>> cursor.fetchall()
    Traceback (most recent call last):
      File "<stdin>", line 1, in <module>
      File "C:\Users\Maggyero\AppData\Local\Programs\Python\Python36-32\lib\site-packages\mysql\connector\cursor.py", line 891, in fetchall
        raise errors.InterfaceError("No result set to fetch from.")
    mysql.connector.errors.InterfaceError: No result set to fetch from.
    >>> cursor.execute("CREATE TABLE test (x INTEGER)")
    >>> cursor.fetchone()
    >>> cursor.fetchmany()
    []
    >>> cursor.fetchall()
    Traceback (most recent call last):
      File "<stdin>", line 1, in <module>
      File "C:\Users\Maggyero\AppData\Local\Programs\Python\Python36-32\lib\site-packages\mysql\connector\cursor.py", line 891, in fetchall
        raise errors.InterfaceError("No result set to fetch from.")
    mysql.connector.errors.InterfaceError: No result set to fetch from.
    

    PEP 249 明确说明 fetchone , fetchmany fetchall 方法:

    那为什么不呢 获取一个 获取许多 获取全部 ?

    1 回复  |  直到 8 年前
        1
  •  0
  •   Géry Ogam    5 年前