找不到名为游标的模块

Question

我只是在VPS上安装了PyMySQL，安装似乎没有任何问题。

为了确保一切正常，我尝试执行在他们的文档中找到的以下脚本。

Python 2.7.5 和 Python 3.6.5

Server version: 10.1.34-MariaDB MariaDB Server

import pymysql.cursors

# Connect to datebase

con = pymysql.connect(host='localhost',

                    user='dbuser',

                    password='dbpass',

                    db='dbname',

                    charset='utf8mb4',

                    cursorclass=pymysql.cursor.DictCursor)

try:

    with con.cursor() as cursor:

        # Create new record

        sql = "INSERT INTO `test` (`idx`, `title`, `description`, `category`) VALUES (%s, %s, %s, %s)"

        cursor.execute(sql, (1, 'Fake Title', 'Fake description about a fake post.', 'WELLNESS'))

    with con.cursor() as cursor:

        # Read a single record

        sql = "SELECT `idx`, `title` FROM `test` WHERE `idx`=%s"

        cursor.execute(sql, ('1'))

        result = cursor.fetchone()

finally:

    with open('dbText.txt', 'w') as f:

        f.write('%s'.format(result))

        con.close()

但是，我收到一个ImportError，显示为No module found named cursors。

[root@host public_html]# python pymysql.py

Traceback (most recent call last):

    File "pymysql.py", line 1, in <module>

        import pymysql.cursors

    File "/home/bldsprt/public_html/pymysql.py", line 1, in <module>

        import pymysql.cursors

ImportError: No module named cursors

[root@host public_html]# python3.6 pymysql.py

Traceback (most recent call last):

  File "pymysql.py", line 1, in <module>

    import pymysql.cursors

  File "/home/bldsprt/public_html/pymysql.py", line 1, in <module>

    import pymysql.cursors

ModuleNotFoundError: No module named 'pymysql.cursors'; 'pymysql' is not a package

我需要cursors单独安装模块吗？