Arch Linux User Repository

Prior to flagging the package out-of-date or reporting build errors please:

• Make sure that your system is up-to-date (pacman -Syu)
• Rebuild and reinstall dependencies (especially ones from AUR)
• Rebuild and reinstall the package

Do not expect AUR packages to trigger rebuild or suggest bumping "pkgrel" number. This is expected behaviour and the way Arch packing is designed to work.

For more information read the official documentation and man pages.

sqlparse 4.0 compatibility fixed. Thanks @mtorromeo

mycli -P 3306 -u root -h 127.0.0.1
Traceback (most recent call last):
File "/bin/mycli", line 33, in <module>
sys.exit(load_entry_point('mycli==1.22.1', 'console_scripts', 'mycli')())
File "/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 "/usr/lib/python3.8/site-packages/mycli/main.py", line 39, in <module>
from .sqlcompleter import SQLCompleter
File "/usr/lib/python3.8/site-packages/mycli/sqlcompleter.py", line 7, in <module>
from .packages.completion_engine import suggest_type
File "/usr/lib/python3.8/site-packages/mycli/packages/completion_engine.py", line 5, in <module>
from sqlparse.compat import text_type ModuleNotFoundError: No module named 'sqlparse.compat'

mycli 1.22.1-1

I've opened a pull request upstream to fix the incompatibility with sqlparse 0.4, you might want to backport the patch: https://patch-diff.githubusercontent.com/raw/dbcli/mycli/pull/900.patch

I had to rm -rf /usr/lib/python3.8/site-packages/test due to a conflict with mycli package that installed also a test folder in site-packages...

It seems mycli isn't compatible with pymysql v0.10.0. Needs the following patch:

diff -aur a/sqlexecute.py b/sqlexecute.py
--- a/sqlexecute.py     2020-07-22 12:01:23.355002581 -0400
+++ b/sqlexecute.py     2020-07-22 11:59:50.394800925 -0400
@@ -3,7 +3,7 @@
 import sqlparse
 from .packages import special
 from pymysql.constants import FIELD_TYPE
-from pymysql.converters import (convert_mysql_datetime, convert_datetime,
+from pymysql.converters import (convert_datetime,
                                 convert_timedelta, convert_date, conversions,
                                 decoders)
 try:
@@ -99,7 +99,7 @@
         )
         conv = conversions.copy()
         conv.update({
-            FIELD_TYPE.TIMESTAMP: lambda obj: (convert_mysql_datetime(obj) or obj),
+            FIELD_TYPE.TIMESTAMP: lambda obj: (convert_datetime(obj) or obj),
             FIELD_TYPE.DATETIME: lambda obj: (convert_datetime(obj) or obj),
             FIELD_TYPE.TIME: lambda obj: (convert_timedelta(obj) or obj),
             FIELD_TYPE.DATE: lambda obj: (convert_date(obj) or obj),

I patched the setup.py to allow for prompt_toolkit 3, the library seems to be compatible with that version without an issue: https://gist.github.com/mercutiodesign/8b341a5ca955d62bcb69ce21274f9e23

for those with difficulties, you can download python-prompt_toolkit-2.0.9-1-any.pkg.tar.xz from https://archive.archlinux.org/packages/p/python-prompt_toolkit/ and then use the command pacman -U python-prompt_toolkit-2.0.9-1-any.pkg.tar.xz as root.

note: when upgrading programs, if you update python-prompt_toolkit, you have to downgrade again.

Thanks for maintaining this package.

Currently, the installation of 1.21.1-1 is failing with the following error:

==> Error: Could not find all required packages:
    python-prompt_toolkit<3.0.0 (Wanted by: mycli)

Prior to flagging the package out-of-date or reporting build errors please:

• Make sure that your system is up-to-date (pacman -Syu)
• Rebuild and reinstall dependencies (especially ones from AUR)
• Rebuild and reinstall the package

Do not expect AUR packages to trigger rebuild or suggest bumping "pkgrel" number. This is expected behaviour and the way Arch packing is designed to work.

For more information read the official documentation and man pages.