databases/rubygem-sqlite31: Add rubygem-sqlite31 1.7.3 (copied from rubygem-sqlite3)

- Add PORTSCOUT

6 files changed, 65 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 7a540f95c740..2f230d40c67a 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -1017,6 +1017,7 @@
     SUBDIR += rubygem-seed-fu
     SUBDIR += rubygem-sqlite3
     SUBDIR += rubygem-sqlite3-ruby
+    SUBDIR += rubygem-sqlite31
     SUBDIR += rubygem-state_machines-activemodel
     SUBDIR += rubygem-state_machines-activerecord
     SUBDIR += rubygem-state_machines-activerecord08
diff --git a/databases/rubygem-sqlite31/Makefile b/databases/rubygem-sqlite31/Makefile
new file mode 100644
index 000000000000..c9a7e94954cf
--- /dev/null
+++ b/databases/rubygem-sqlite31/Makefile
@@ -0,0 +1,23 @@
+PORTNAME=	sqlite3
+PORTVERSION=	1.7.3
+CATEGORIES=	databases rubygems
+MASTER_SITES=	RG
+PKGNAMESUFFIX=	1
+
+MAINTAINER=	sunpoet@FreeBSD.org
+COMMENT=	Ruby interface to the SQLite DB engine version 3
+WWW=		https://github.com/sparklemotion/sqlite3-ruby
+
+LICENSE=	BSD3CLAUSE
+LICENSE_FILE=	${WRKSRC}/LICENSE
+
+USES=		gem sqlite
+
+CONFIGURE_ARGS=	--enable-system-libraries --with-sqlite3-dir=${LOCALBASE}
+
+PORTSCOUT=	limit:^1\.
+
+post-patch:
+	@${RM} -r ${WRKSRC}/ports/
+
+.include <bsd.port.mk>
diff --git a/databases/rubygem-sqlite31/distinfo b/databases/rubygem-sqlite31/distinfo
new file mode 100644
index 000000000000..92c9a12fe779
--- /dev/null
+++ b/databases/rubygem-sqlite31/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1716448632
+SHA256 (rubygem/sqlite3-1.7.3.gem) = fa77f63c709548f46d4e9b6bb45cda52aa3881aa12cc85991132758e8968701c
+SIZE (rubygem/sqlite3-1.7.3.gem) = 3307008
diff --git a/databases/rubygem-sqlite31/files/patch-ext-sqlite3-extconf.rb b/databases/rubygem-sqlite31/files/patch-ext-sqlite3-extconf.rb
new file mode 100644
index 000000000000..7a946b9d0a06
--- /dev/null
+++ b/databases/rubygem-sqlite31/files/patch-ext-sqlite3-extconf.rb
@@ -0,0 +1,11 @@
+--- ext/sqlite3/extconf.rb.orig	2023-04-08 07:40:49 UTC
++++ ext/sqlite3/extconf.rb
+@@ -130,8 +130,6 @@ module Sqlite3
+       end
+ 
+       def minimal_recipe
+-        require "mini_portile2"
+-
+         MiniPortile.new(libname, sqlite3_config[:version]).tap do |recipe|
+           if sqlite_source_dir
+             recipe.source_directory = sqlite_source_dir
diff --git a/databases/rubygem-sqlite31/files/patch-gemspec b/databases/rubygem-sqlite31/files/patch-gemspec
new file mode 100644
index 000000000000..f794d37bb4b9
--- /dev/null
+++ b/databases/rubygem-sqlite31/files/patch-gemspec
@@ -0,0 +1,21 @@
+% sed -i .orig 's|, "ports/[^"]*".freeze||g' sqlite3.gemspec
+
+--- sqlite3.gemspec.orig	2024-04-19 04:56:31 UTC
++++ sqlite3.gemspec
+@@ -14,7 +14,7 @@ Gem::Specification.new do |s|
+   s.description = "Ruby library to interface with the SQLite3 database engine (http://www.sqlite.org). Precompiled\nbinaries are available for common platforms for recent versions of Ruby.\n".freeze
+   s.extensions = ["ext/sqlite3/extconf.rb".freeze]
+   s.extra_rdoc_files = ["API_CHANGES.md".freeze, "CHANGELOG.md".freeze, "README.md".freeze, "ext/sqlite3/aggregator.c".freeze, "ext/sqlite3/backup.c".freeze, "ext/sqlite3/database.c".freeze, "ext/sqlite3/exception.c".freeze, "ext/sqlite3/sqlite3.c".freeze, "ext/sqlite3/statement.c".freeze]
+-  s.files = [".gemtest".freeze, "API_CHANGES.md".freeze, "CHANGELOG.md".freeze, "CONTRIBUTING.md".freeze, "ChangeLog.cvs".freeze, "FAQ.md".freeze, "Gemfile".freeze, "INSTALLATION.md".freeze, "LICENSE".freeze, "LICENSE-DEPENDENCIES".freeze, "README.md".freeze, "dependencies.yml".freeze, "ext/sqlite3/aggregator.c".freeze, "ext/sqlite3/aggregator.h".freeze, "ext/sqlite3/backup.c".freeze, "ext/sqlite3/backup.h".freeze, "ext/sqlite3/database.c".freeze, "ext/sqlite3/database.h".freeze, "ext/sqlite3/exception.c".freeze, "ext/sqlite3/exception.h".freeze, "ext/sqlite3/extconf.rb".freeze, "ext/sqlite3/sqlite3.c".freeze, "ext/sqlite3/sqlite3_ruby.h".freeze, "ext/sqlite3/statement.c".freeze, "ext/sqlite3/statement.h".freeze, "lib/sqlite3.rb".freeze, "lib/sqlite3/constants.rb".freeze, "lib/sqlite3/database.rb".freeze, "lib/sqlite3/errors.rb".freeze, "lib/sqlite3/pragmas.rb".freeze, "lib/sqlite3/resultset.rb".freeze, "lib/sqlite3/statement.rb".freeze, "lib/sqlite3/translator.rb".freeze, "lib/sqlite3/value.rb".freeze, "lib/sqlite3/version.rb".freeze, "ports/archives/sqlite-autoconf-3450200.tar.gz".freeze, "test/helper.rb".freeze, "test/test_backup.rb".freeze, "test/test_collation.rb".freeze, "test/test_database.rb".freeze, "test/test_database_flags.rb".freeze, "test/test_database_readonly.rb".freeze, "test/test_database_readwrite.rb".freeze, "test/test_deprecated.rb".freeze, "test/test_encoding.rb".freeze, "test/test_integration.rb".freeze, "test/test_integration_aggregate.rb".freeze, "test/test_integration_open_close.rb".freeze, "test/test_integration_pending.rb".freeze, "test/test_integration_resultset.rb".freeze, "test/test_integration_statement.rb".freeze, "test/test_pragmas.rb".freeze, "test/test_result_set.rb".freeze, "test/test_sqlite3.rb".freeze, "test/test_statement.rb".freeze, "test/test_statement_execute.rb".freeze]
++  s.files = [".gemtest".freeze, "API_CHANGES.md".freeze, "CHANGELOG.md".freeze, "CONTRIBUTING.md".freeze, "ChangeLog.cvs".freeze, "FAQ.md".freeze, "Gemfile".freeze, "INSTALLATION.md".freeze, "LICENSE".freeze, "LICENSE-DEPENDENCIES".freeze, "README.md".freeze, "dependencies.yml".freeze, "ext/sqlite3/aggregator.c".freeze, "ext/sqlite3/aggregator.h".freeze, "ext/sqlite3/backup.c".freeze, "ext/sqlite3/backup.h".freeze, "ext/sqlite3/database.c".freeze, "ext/sqlite3/database.h".freeze, "ext/sqlite3/exception.c".freeze, "ext/sqlite3/exception.h".freeze, "ext/sqlite3/extconf.rb".freeze, "ext/sqlite3/sqlite3.c".freeze, "ext/sqlite3/sqlite3_ruby.h".freeze, "ext/sqlite3/statement.c".freeze, "ext/sqlite3/statement.h".freeze, "lib/sqlite3.rb".freeze, "lib/sqlite3/constants.rb".freeze, "lib/sqlite3/database.rb".freeze, "lib/sqlite3/errors.rb".freeze, "lib/sqlite3/pragmas.rb".freeze, "lib/sqlite3/resultset.rb".freeze, "lib/sqlite3/statement.rb".freeze, "lib/sqlite3/translator.rb".freeze, "lib/sqlite3/value.rb".freeze, "lib/sqlite3/version.rb".freeze, "test/helper.rb".freeze, "test/test_backup.rb".freeze, "test/test_collation.rb".freeze, "test/test_database.rb".freeze, "test/test_database_flags.rb".freeze, "test/test_database_readonly.rb".freeze, "test/test_database_readwrite.rb".freeze, "test/test_deprecated.rb".freeze, "test/test_encoding.rb".freeze, "test/test_integration.rb".freeze, "test/test_integration_aggregate.rb".freeze, "test/test_integration_open_close.rb".freeze, "test/test_integration_pending.rb".freeze, "test/test_integration_resultset.rb".freeze, "test/test_integration_statement.rb".freeze, "test/test_pragmas.rb".freeze, "test/test_result_set.rb".freeze, "test/test_sqlite3.rb".freeze, "test/test_statement.rb".freeze, "test/test_statement_execute.rb".freeze]
+   s.homepage = "https://github.com/sparklemotion/sqlite3-ruby".freeze
+   s.licenses = ["BSD-3-Clause".freeze]
+   s.rdoc_options = ["--main".freeze, "README.md".freeze]
+@@ -23,7 +23,5 @@ Gem::Specification.new do |s|
+   s.summary = "Ruby library to interface with the SQLite3 database engine (http://www.sqlite.org).".freeze
+ 
+   s.specification_version = 4
+-
+-  s.add_runtime_dependency(%q<mini_portile2>.freeze, ["~> 2.8.0".freeze])
+ end
+ 
diff --git a/databases/rubygem-sqlite31/pkg-descr b/databases/rubygem-sqlite31/pkg-descr
new file mode 100644
index 000000000000..f05b893bede6
--- /dev/null
+++ b/databases/rubygem-sqlite31/pkg-descr
@@ -0,0 +1,6 @@
+sqlite3-ruby provides an interface for the SQLite DB engine version 3.
+This differs from the DBD::SQLite module in that it is more complete,
+and from the ruby DBI version of SQLite in that it is SQLite specific,
+so you can do things that would otherwise be more difficult via DBI.
+If you want portability between backends, use DBI.  If you want ease
+of use with SQLite, use this.