databases/ruby-mysql: update to 3.0.1

pkgsrc change:
* Switch to use gem, 3.0 release.
* Change HOMEPAGE to github page.

[3.0.1] - 2022-06-18

* LICENSE: correct author
* FIX: correct LOAD DATA LOCAL INFILE result information.
* FIX: reset SERVER_MORE_RESULTS_EXISTS when error packet is received.
* FIX: close the socket when the connection is disconnected.
* FIX: allow multiple results by default.

[3.0.0] - 2021-11-16

* Mysql.new no longer connect. use Mysql.connect or Mysql#connect.
* Mysql.init is removed. use Mysql.new instead.

* Mysql.new, Mysql.conncet and Mysql#connect takes URI object or URI string
  or Hash object.

  example:
  Mysql.connect('mysql://user:password@hostname:port/dbname?charset=ascii')
  Mysql.connect('mysql://user:password@%2Ftmp%2Fmysql.sock/dbname?charset=ascii') # for UNIX socket
  Mysql.connect('hostname', 'user', 'password', 'dbname')
  Mysql.connect(host: 'hostname', username: 'user', password: 'password', database: 'dbname')

* Mysql.options is removed. use Mysql#param = value instead. For example:

	m = Mysql.init m.options(Mysql::OPT_LOCAL_INFILE, true)
	m.connect(host, user, passwd)

  change to

	m = Mysql.new m.local_infile = true
	m.connect(host, user, passwd)

  or

	m = Mysql.connect(host, user, passwd, local_infile: true)

* Mysql::Time is removed. Instead, Time object is returned for the DATE,
  DATETIME, TIMESTAMP data, and Integer object is returned for the TIME
  data.  If DATE, DATETIME, TIMESTAMP are invalid values for Time, nil is
  returned.

* meaningless methods are removed:

     bind_result
     client_info
     client_version
     get_proto_info
     get_server_info
     get_server_version
     proto_info
     query_with_result

* alias method are removed:

     get_host_info: use host_info
     real_connect: use connect
     real_query: use query

* methods corresponding to deprecated APIs in MySQL are removed:

     list_dbs: use SHOW DATABASES
     list_fields: use SHOW COLUMNS
     list_processes: use SHOW PROCESSLIST
     list_tables: use SHOW TABLES

3 files changed, 28 insertions, 36 deletions

diff --git a/databases/ruby-mysql/Makefile b/databases/ruby-mysql/Makefile
index 153df85a89e..3cdb091bad4 100644
--- a/databases/ruby-mysql/Makefile
+++ b/databases/ruby-mysql/Makefile
@@ -1,32 +1,17 @@
-# $NetBSD: Makefile,v 1.40 2021/06/23 20:33:09 nia Exp $
+# $NetBSD: Makefile,v 1.41 2022/09/01 15:29:29 taca Exp $
 #
 
-DISTNAME=	ruby-mysql-2.9.14
-PKGNAME=	${RUBY_PKGPREFIX}-mysql-2.9.14
-PKGREVISION=	1
-CATEGORIES=	databases ruby
-MASTER_SITES=	${MASTER_SITE_GITHUB:=tmtm/}
-GITHUB_PROJECT=	ruby-mysql
-GITHUB_TAG=	${PKGVERSION_NOREV}
+DISTNAME=	ruby-mysql-3.0.1
+PKGNAME=	${RUBY_PKGPREFIX}-${DISTNAME:S/ruby-//}
+CATEGORIES=	databases
 
 MAINTAINER=	neumann@s-direktnet.de
-HOMEPAGE=	http://www.tmtm.org/en/mysql/ruby/
+HOMEPAGE=	https://github.com/tmtm/ruby-mysql
 COMMENT=	Ruby extension for MySQL
 LICENSE=	gnu-gpl-v2 OR ruby-license
 
-USE_RUBY_SETUP=		yes
-USE_RUBY_SETUP_PKG=	yes
+USE_LANGUAGES=	# empty
 
-INSTALLATION_DIRS=	${RUBY_DOC}/mysql ${RUBY_EG}/mysql
-
-DOCS=		README.rdoc
-
-ppost-install:
-.for f in ${DOCS}
-	${INSTALL_DATA} ${WRKSRC}/${f} ${DESTDIR}${PREFIX}/${RUBY_DOC}/mysql
-.endfor
-	${INSTALL_SCRIPT} ${WRKSRC}/test.rb ${DESTDIR}${PREFIX}/${RUBY_EG}/mysql
-
-.include "../../lang/ruby/modules.mk"
+.include "../../lang/ruby/gem.mk"
 .include "../../mk/mysql.buildlink3.mk"
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/ruby-mysql/PLIST b/databases/ruby-mysql/PLIST
index dcc373121a4..c750b4bf194 100644
--- a/databases/ruby-mysql/PLIST
+++ b/databases/ruby-mysql/PLIST
@@ -1,10 +1,17 @@
-@comment $NetBSD: PLIST,v 1.8 2015/05/19 13:32:38 ryoon Exp $
-${RUBY_VENDORLIB}/mysql.rb
-${RUBY_VENDORLIB}/mysql/charset.rb
-${RUBY_VENDORLIB}/mysql/constants.rb
-${RUBY_VENDORLIB}/mysql/error.rb
-${RUBY_VENDORLIB}/mysql/packet.rb
-${RUBY_VENDORLIB}/mysql/protocol.rb
-${RUBY_VENDORARCHLIB}/ext.${RUBY_DLEXT}
-@pkgdir share/examples/${RUBY_NAME}/mysql
-@pkgdir share/doc/${RUBY_NAME}/mysql
+@comment $NetBSD: PLIST,v 1.9 2022/09/01 15:29:29 taca Exp $
+${GEM_HOME}/cache/${GEM_NAME}.gem
+${GEM_LIBDIR}/CHANGELOG.md
+${GEM_LIBDIR}/README.md
+${GEM_LIBDIR}/lib/mysql.rb
+${GEM_LIBDIR}/lib/mysql/authenticator.rb
+${GEM_LIBDIR}/lib/mysql/authenticator/caching_sha2_password.rb
+${GEM_LIBDIR}/lib/mysql/authenticator/mysql_native_password.rb
+${GEM_LIBDIR}/lib/mysql/authenticator/sha256_password.rb
+${GEM_LIBDIR}/lib/mysql/charset.rb
+${GEM_LIBDIR}/lib/mysql/constants.rb
+${GEM_LIBDIR}/lib/mysql/error.rb
+${GEM_LIBDIR}/lib/mysql/packet.rb
+${GEM_LIBDIR}/lib/mysql/protocol.rb
+${GEM_LIBDIR}/test/test_mysql.rb
+${GEM_LIBDIR}/test/test_mysql_packet.rb
+${GEM_HOME}/specifications/${GEM_NAME}.gemspec
diff --git a/databases/ruby-mysql/distinfo b/databases/ruby-mysql/distinfo
index 1bc666bc13d..8a8f74d30e0 100644
--- a/databases/ruby-mysql/distinfo
+++ b/databases/ruby-mysql/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.19 2021/10/26 10:10:03 nia Exp $
+$NetBSD: distinfo,v 1.20 2022/09/01 15:29:29 taca Exp $
 
-BLAKE2s (ruby-mysql-2.9.14.tar.gz) = 82a0d00236c02b04fee60b62cdb65b996051e9123ba44e8172a0e95cc14f4e36
-SHA512 (ruby-mysql-2.9.14.tar.gz) = 7aaea3f40a37645c6b2e38b8bd0efa42e520dd7e3c1f9a907f772cfd7661a16045ce81c935f3ccc995d0c809e5df614bff3808d54a41fcf02ea8e936ea54f349
-Size (ruby-mysql-2.9.14.tar.gz) = 58759 bytes
+BLAKE2s (ruby-mysql-3.0.1.gem) = 05d97895110a0daa8eb2744b116ac01d75e74a25da4dd76507fde9eaf528fc26
+SHA512 (ruby-mysql-3.0.1.gem) = 75d39845f3cd1276632491d04130fe14663f7dddad34bc6c0d294144776a7651c87944ea5bdb3f3408a53222387db5dce3264a2caf779e44942d610c3f7fd915
+Size (ruby-mysql-3.0.1.gem) = 47616 bytes