Index: head/databases/py-mycli/Makefile
===================================================================
--- head/databases/py-mycli/Makefile	(revision 552251)
+++ head/databases/py-mycli/Makefile	(revision 552252)
@@ -1,30 +1,31 @@
 # Created by: Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org>
 # $FreeBSD$
 
 PORTNAME=	mycli
 PORTVERSION=	1.22.2
+PORTREVISION=	1
 CATEGORIES=	databases python
 MASTER_SITES=	CHEESESHOP
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
 
 MAINTAINER=	sunpoet@FreeBSD.org
 COMMENT=	CLI for MySQL Database with auto-completion and syntax highlighting
 
 LICENSE=	BSD3CLAUSE
 LICENSE_FILE=	${WRKSRC}/LICENSE.txt
 
 RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}cli-helpers>=1.1.0:devel/py-cli-helpers@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}click>=7.0:devel/py-click@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}configobj>=5.0.5:devel/py-configobj@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}cryptography>=1.0.0:security/py-cryptography@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}prompt_toolkit>=3.0.0<4.0.0:devel/py-prompt_toolkit@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}pygments>=1.6:textproc/py-pygments@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}pymysql>=0.9.2:databases/py-pymysql@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}sqlparse>=0.3.0<0.4.0:databases/py-sqlparse@${PY_FLAVOR}
+		${PYTHON_PKGNAMEPREFIX}sqlparse>=0.3.0:databases/py-sqlparse@${PY_FLAVOR}
 
 USES=		mysql python:3.6+
 USE_PYTHON=	autoplist concurrent distutils
 
 NO_ARCH=	yes
 
 .include <bsd.port.mk>
Index: head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
===================================================================
--- head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py	(nonexistent)
+++ head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py	(revision 552252)
@@ -0,0 +1,19 @@
+--- mycli/packages/completion_engine.py.orig	2020-07-25 03:46:06 UTC
++++ mycli/packages/completion_engine.py
+@@ -2,7 +2,6 @@ import os
+ import sys
+ import sqlparse
+ from sqlparse.sql import Comparison, Identifier, Where
+-from sqlparse.compat import text_type
+ from .parseutils import last_word, extract_tables, find_prev_keyword
+ from .special import parse_special_command
+ 
+@@ -55,7 +54,7 @@ def suggest_type(full_text, text_before_cursor):
+         stmt_start, stmt_end = 0, 0
+ 
+         for statement in parsed:
+-            stmt_len = len(text_type(statement))
++            stmt_len = len(str(statement))
+             stmt_start, stmt_end = stmt_end, stmt_end + stmt_len
+ 
+             if stmt_end >= current_pos:

Property changes on: head/databases/py-mycli/files/patch-mycli-packages-completion_engine.py
___________________________________________________________________
Added: fbsd:nokeywords
## -0,0 +1 ##
+yes
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Index: head/databases/py-mycli/files/patch-setup.py
===================================================================
--- head/databases/py-mycli/files/patch-setup.py	(nonexistent)
+++ head/databases/py-mycli/files/patch-setup.py	(revision 552252)
@@ -0,0 +1,11 @@
+--- setup.py.orig	2020-07-25 03:46:06 UTC
++++ setup.py
+@@ -21,7 +21,7 @@ install_requirements = [
+     'Pygments >= 1.6',
+     'prompt_toolkit>=3.0.0,<4.0.0',
+     'PyMySQL >= 0.9.2',
+-    'sqlparse>=0.3.0,<0.4.0',
++    'sqlparse>=0.3.0',
+     'configobj >= 5.0.5',
+     'cryptography >= 1.0.0',
+     'cli_helpers[styles] > 1.1.0',

Property changes on: head/databases/py-mycli/files/patch-setup.py
___________________________________________________________________
Added: fbsd:nokeywords
## -0,0 +1 ##
+yes
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Index: head/databases/py-mycli/pkg-descr
===================================================================
--- head/databases/py-mycli/pkg-descr	(revision 552251)
+++ head/databases/py-mycli/pkg-descr	(revision 552252)
@@ -1,5 +1,5 @@
 mycli is a command line interface for MySQL, MariaDB, and Percona with
 auto-completion and syntax highlighting.
 
-WWW: https://pypi.org/project/mycli/
 WWW: https://www.mycli.net/
+WWW: https://github.com/dbcli/mycli