git: 75ca7dd38d06 - main - databases/py-mycli: Update to 1.76.0

Go to: [ bottom of page ] [ top of archives ] [ this month ]
From: Po-Chuan Hsieh <sunpoet_at_FreeBSD.org>
Date: Mon, 24 Aug 2026 05:23:08 UTC
The branch main has been updated by sunpoet:

URL: https://cgit.FreeBSD.org/ports/commit/?id=75ca7dd38d06c6650e662e3f08eee5be78169e85

commit 75ca7dd38d06c6650e662e3f08eee5be78169e85
Author:     Po-Chuan Hsieh <sunpoet@FreeBSD.org>
AuthorDate: 2026-08-24 05:00:28 +0000
Commit:     Po-Chuan Hsieh <sunpoet@FreeBSD.org>
CommitDate: 2026-08-24 05:16:29 +0000

    databases/py-mycli: Update to 1.76.0
    
    Changes:        https://github.com/dbcli/mycli/blob/main/changelog.md
---
 databases/py-mycli/Makefile                   | 40 ++++++++++++++---------
 databases/py-mycli/distinfo                   |  6 ++--
 databases/py-mycli/files/patch-pyproject.toml | 47 +++++++++++++++++++++++++++
 databases/py-mycli/files/patch-setup.py       | 11 -------
 4 files changed, 74 insertions(+), 30 deletions(-)

diff --git a/databases/py-mycli/Makefile b/databases/py-mycli/Makefile
index 1a956b69db19..a268f938af49 100644
--- a/databases/py-mycli/Makefile
+++ b/databases/py-mycli/Makefile
@@ -1,6 +1,5 @@
 PORTNAME=	mycli
-PORTVERSION=	1.28.0
-PORTREVISION=	1
+PORTVERSION=	1.76.0
 CATEGORIES=	databases python
 MASTER_SITES=	PYPI
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
@@ -13,28 +12,37 @@ WWW=		https://www.mycli.net/ \
 LICENSE=	BSD3CLAUSE
 LICENSE_FILE=	${WRKSRC}/LICENSE.txt
 
-BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools>=0:devel/py-setuptools@${PY_FLAVOR} \
+BUILD_DEPENDS=	${PYTHON_PKGNAMEPREFIX}setuptools>=61.0:devel/py-setuptools@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}setuptools-scm>=8:devel/py-setuptools-scm@${PY_FLAVOR} \
 		${PYTHON_PKGNAMEPREFIX}wheel>=0:devel/py-wheel@${PY_FLAVOR}
-RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}cli-helpers>=2.2.1: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}prompt-toolkit>=3.0.6<4.0.0:devel/py-prompt-toolkit@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}pyaes>=1.6.1:security/py-pyaes@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}pyfzf>=0.3.1:textproc/py-pyfzf@${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}pyperclip>=1.8.1:devel/py-pyperclip@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}sqlglot>=5.1.3:databases/py-sqlglot@${PY_FLAVOR} \
-		${PYTHON_PKGNAMEPREFIX}sqlparse>=0.3.0<0.6.0:databases/py-sqlparse@${PY_FLAVOR}
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}cli-helpers>=2.15.0<2.16:devel/py-cli-helpers@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}click>=8.3.1<8.4:devel/py-click@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}clickdc>=0.1.1<0.2:devel/py-clickdc@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}configobj>=5.0.9<5.1:devel/py-configobj@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}keyring>=25.6.0,1<25.8,1:security/py-keyring@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}prompt-toolkit>=3.0.41<4.0.0:devel/py-prompt-toolkit@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pycryptodomex>=3.23.0<3.24:security/py-pycryptodomex@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pyfzf>=0.3.1<0.4:textproc/py-pyfzf@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pygments>=2.19.2:textproc/py-pygments@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pymysql>=1.1.2:databases/py-pymysql@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}pyperclip>=1.11.0<1.12:devel/py-pyperclip@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}rapidfuzz>=3.14.3<3.15:devel/py-rapidfuzz@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}sqlglot>=30.8.0:databases/py-sqlglot@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}sqlglotc>=30.8.0:databases/py-sqlglotc@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}sqlparse>=0.3.0<0.6.0:databases/py-sqlparse@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}wcwidth>=0.6.0:devel/py-wcwidth@${PY_FLAVOR} \
+		${PYTHON_PKGNAMEPREFIX}yaspin>=3.4.0<3.5:devel/py-yaspin@${PY_FLAVOR}
 
 USES=		cpe mysql python
-CPE_VENDOR=	dbcli
 USE_PYTHON=	autoplist concurrent cryptography pep517
 
 NO_ARCH=	yes
 
+CPE_VENDOR=	dbcli
+
 OPTIONS_DEFINE=	SSH
 
-SSH_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}paramiko>=0:security/py-paramiko@${PY_FLAVOR}
+SSH_RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}paramiko>=3.5.1<3.6:security/py-paramiko@${PY_FLAVOR} \
+			${PYTHON_PKGNAMEPREFIX}sshtunnel>=0.4.0<0.5:net/py-sshtunnel@${PY_FLAVOR}
 
 .include <bsd.port.mk>
diff --git a/databases/py-mycli/distinfo b/databases/py-mycli/distinfo
index 1f5a3e81c91e..e699fda45665 100644
--- a/databases/py-mycli/distinfo
+++ b/databases/py-mycli/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1731679214
-SHA256 (mycli-1.28.0.tar.gz) = 66bfac0be21df16e01ff6187cc9cece6676a4c5f1bd3435887e633b5e380e4c3
-SIZE (mycli-1.28.0.tar.gz) = 288099
+TIMESTAMP = 1787268058
+SHA256 (mycli-1.76.0.tar.gz) = 3fd6424e60b7ed54029a51c128d625a31c2a99bc449db2979918490c5b644a73
+SIZE (mycli-1.76.0.tar.gz) = 480878
diff --git a/databases/py-mycli/files/patch-pyproject.toml b/databases/py-mycli/files/patch-pyproject.toml
new file mode 100644
index 000000000000..ed6a66688133
--- /dev/null
+++ b/databases/py-mycli/files/patch-pyproject.toml
@@ -0,0 +1,47 @@
+--- pyproject.toml.orig	2026-06-20 14:39:51 UTC
++++ pyproject.toml
+@@ -4,27 +4,27 @@ requires-python = ">=3.10"
+ description = "CLI for MySQL Database. With auto-completion and syntax highlighting."
+ readme = "README.md"
+ requires-python = ">=3.10"
+-license = "BSD-3-Clause"
++license = { text = "BSD-3-Clause" }
+ authors = [{ name = "Mycli Core Team" }]
+ 
+ dependencies = [
+     "click ~= 8.3.1",
+     "clickdc ~= 0.1.1",
+-    "cryptography ~= 46.0.5",
+-    "Pygments ~= 2.19.2",
++    "cryptography>=46.0.5",
++    "Pygments>=2.19.2",
+     "prompt_toolkit>=3.0.41,<4.0.0",
+-    "PyMySQL ~= 1.1.2",
++    "PyMySQL>=1.1.2",
+     "sqlparse>=0.3.0,<0.6.0",
+-    "sqlglot ~= 30.8.0",
+-    "sqlglotc ~= 30.8.0",
++    "sqlglot>=30.8.0",
++    "sqlglotc>=30.8.0",
+     "configobj ~= 5.0.9",
+     "cli_helpers[styles] ~= 2.15.0",
+-    "wcwidth ~= 0.6.0",
++    "wcwidth>=0.6.0",
+     "pyperclip ~= 1.11.0",
+     "pycryptodomex ~= 3.23.0",
+     "pyfzf ~= 0.3.1",
+     "rapidfuzz ~= 3.14.3",
+-    "keyring ~= 25.7.0",
++    "keyring>=25.6.0,<25.8",
+     "yaspin ~= 3.4.0",
+ ]
+ 
+@@ -36,7 +36,7 @@ Changelog = 'https://github.com/dbcli/mycli/blob/main/
+ Changelog = 'https://github.com/dbcli/mycli/blob/main/changelog.md'
+ 
+ [build-system]
+-requires = ["setuptools>=64.0", "setuptools-scm>=8"]
++requires = ["setuptools>=61.0", "setuptools-scm>=8"]
+ build-backend = "setuptools.build_meta"
+ 
+ [tool.setuptools_scm]
diff --git a/databases/py-mycli/files/patch-setup.py b/databases/py-mycli/files/patch-setup.py
deleted file mode 100644
index ff3e42c7b356..000000000000
--- a/databases/py-mycli/files/patch-setup.py
+++ /dev/null
@@ -1,11 +0,0 @@
---- setup.py.orig	2024-11-03 18:30:36 UTC
-+++ setup.py
-@@ -24,7 +24,7 @@ install_requirements = [
-     'Pygments>=1.6',
-     'prompt_toolkit>=3.0.6,<4.0.0',
-     'PyMySQL >= 0.9.2',
--    'sqlparse>=0.3.0,<0.5.0',
-+    'sqlparse>=0.3.0,<0.6.0',
-     'sqlglot>=5.1.3',
-     'configobj >= 5.0.5',
-     'cli_helpers[styles] >= 2.2.1',