PyMySQL version 0.10 produces ImportError crash on mycli execution

[lukaus]

After updating PyMySQL from 0.9.3 to 0.10.0 the following crash occurs when executing mycli (version 1.12.1):

Traceback (most recent call last):
  File "/usr/bin/mycli", line 33, in <module>
    sys.exit(load_entry_point('mycli==1.21.1', 'console_scripts', 'mycli')())
  File "/usr/bin/mycli", line 25, in importlib_load_entry_point
    return next(matches).load()
  File "/usr/lib/python3.8/importlib/metadata.py", line 77, in load
    module = import_module(match.group('module'))
  File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
  File "<frozen importlib._bootstrap>", line 991, in _find_and_load
  File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 783, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "/home/<user>/.local/lib/python3.8/site-packages/mycli/main.py", line 41, in <module>
    from .sqlexecute import FIELD_TYPES, SQLExecute
  File "/home/<user>/.local/lib/python3.8/site-packages/mycli/sqlexecute.py", line 6, in <module>
    from pymysql.converters import (convert_mysql_timestamp, convert_datetime,
ImportError: cannot import name 'convert_mysql_timestamp' from 'pymysql.converters' (/home/<user>/.local/lib/python3.8/site-packages/pymysql/converters.py)

I downgraded to PyMySQL 0.9.3 to continue using mycli

[lukaus]

Here's the commit that removed the convert_mysql_timestamp function:
PyMySQL/PyMySQL@fe0cd60#diff-40496cc4a0f4db6907de60f7ce470b95

[lunatiee]

solution 1) Install PyMySQL 0.9.2 (this is last version that you can use with mycli)

or

solution 2)
/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/mycli/sqlexecute.py

Open the above file and modify it as follows:

line 6) from pymysql.converters import (convert_datetime,
line 102) FIELD_TYPE.TIMESTAMP: lambda obj: (convert_datetime(obj) or obj),

[fraoustin]

If you want to use the last version of mycli, you can use mycli with docker https://hub.docker.com/repository/docker/dbcliorg/mycli

[artfulrobot]

I was new to doing this, so in case it helps anyone else, these are the commands I used to get it working based on @lunatiee 's solution ➊

$ pip3 install mycli
$ pip3 install -I PyMySQL==0.9.2

[amjith]

We have a sprint this weekend and we'll see if we can tackle this issue during the sprint.

If anyone is interested in participating, we're doing a virtual sprint through the PyOhio conference. https://www.pyohio.org/2020/events/sprints

[ZDSDESIRE]

solution 1) Install PyMySQL 0.9.2 (this is last version that you can use with mycli)

or

solution 2)
/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/mycli/sqlexecute.py

Open the above file and modify it as follows:

line 6) from pymysql.converters import (convert_datetime,
line 102) FIELD_TYPE.TIMESTAMP: lambda obj: (convert_datetime(obj) or obj),

This is an effective solution. Thank you!

[amjith]

It's fixed in the latest version. Please update. pip install -U mycli

…

On Sun, Jul 26, 2020, 20:49 ZDSDESIRE ***@***.***> wrote: solution 1) Install PyMySQL 0.9.2 (this is last version that you can use with mycli) or solution 2) /Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/mycli/sqlexecute.py *Open the above file and modify it as follows:* line 6) from pymysql.converters import (convert_datetime, line 102) FIELD_TYPE.TIMESTAMP: lambda obj: (convert_datetime(obj) or obj), This is an effective solution. — You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub <#882 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAMA3FA42WZUYZMZ6Y5VTDR5TTLLANCNFSM4PAC2OGQ> .

[artfulrobot]

yay, it works again. THANKS ALL!

[verajosemanuel]

not working even with the latest version in Cent Os

[ZDSDESIRE]

Not working even with the latest version in Win10:

Successfully installed mycli-1.22.1 prompt-toolkit-3.0.5

C:\Users\z_zon>mycli --help
Traceback (most recent call last):
  File "e:\python\python38\lib\runpy.py", line 194, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "e:\python\python38\lib\runpy.py", line 87, in _run_code
    exec(code, run_globals)
  File "E:\Python\Python38\Scripts\mycli.exe\__main__.py", line 4, in <module>
  File "e:\python\python38\lib\site-packages\mycli\main.py", line 9, in <module>
    from pwd import getpwuid
ModuleNotFoundError: No module named 'pwd'

I returned to mycli-1.21.1 and get it working based on @lunatiee 's solution ②: #882 (comment)

[amjith]

@verajosemanuel Can you tell me what is the version you're using? If you installed it via yum the latest version is probably not available via yum.

You need to install it via pip.

[amjith]

@ZDSDESIRE I can't reproduce it. Looks like the error you're seeing is very different from the original error reported.

Looks like there is an issue with your python installation. The module not found error is complaining about a module called pwd but this is a standard library module that is shipped with python. https://docs.python.org/3.8/library/pwd.html

You might want to reinstall python on your machine and try again.

[thorstenkampe]

@amjith pwd is Unix-only:

This module provides access to the Unix user account and password database. It is available on all Unix versions.

[thorstenkampe]

Looks like the developers are only testing on Linux or MacOS. On Windows mycli is completely broken because of the import of pwd.

[amjith]

You're right. I'm sorry. I didn't know that pwd is Unix only. I'll have to address this.

…

On Fri, Jul 31, 2020, 10:40 Thorsten Kampe ***@***.***> wrote: Looks like the developers are only testing on Linux or MacOS. On Windows mycli is completely broken because of the import of pwd. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#882 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAMA3BDQOPULFTI2ZGLOE3R6LXZFANCNFSM4PAC2OGQ> .

[amjith]

@thorstenkampe @ZDSDESIRE I'v created a branch that fixes the pwd import issue.

Can you try it out?

pip install -U https://github.com/dbcli/mycli/archive/pwd_optional.zip

[thorstenkampe]

@amjith seems to work fine

[verajosemanuel]

ERROR: Package 'mycli' requires a different Python: 2.7.5 not in '>=3.6'

The above command should be:

pip3 install -U https://github.com/dbcli/mycli/archive/pwd_optional.zip

[ZDSDESIRE]

@amjith
Yay, it's working, thanks! Have you pulled out the pwd module?