CVS commit: pkgsrc/databases/sqlite3-diff

["Amitai Schleier" <schmonz%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   schmonz
Date:           Tue May 20 16:46:24 UTC 2025

Added Files:
        pkgsrc/databases/sqlite3-diff: DESCR Makefile PLIST distinfo

Log Message:
Add sqlite3-diff: Display content differences between SQLite databases

sqldiff is a command-line utility program that displays content
differences between SQLite databases. The usual output is an SQL script
that will transform the source database into the destination database.

The sqldiff utility works by finding rows in the source and destination
that are logical "pairs". The default behavior is to treat two rows as
pairs if they are in tables with the same name and they have the same
rowid, or in the case of a WITHOUT ROWID table if they have the same
PRIMARY KEY. Any differences in the content of paired rows are output as
UPDATEs. Rows in the source database that could not be paired are output
as DELETEs. Rows in the destination database that could not be paired
are output as INSERTs.


To generate a diff of this commit:
cvs rdiff -u -r0 -r1.1 pkgsrc/databases/sqlite3-diff/DESCR \
    pkgsrc/databases/sqlite3-diff/Makefile \
    pkgsrc/databases/sqlite3-diff/PLIST \
    pkgsrc/databases/sqlite3-diff/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Added files:

Index: pkgsrc/databases/sqlite3-diff/DESCR
diff -u /dev/null pkgsrc/databases/sqlite3-diff/DESCR:1.1
--- /dev/null   Tue May 20 16:46:24 2025
+++ pkgsrc/databases/sqlite3-diff/DESCR Tue May 20 16:46:24 2025
@@ -0,0 +1,12 @@
+sqldiff is a command-line utility program that displays content
+differences between SQLite databases. The usual output is an SQL script
+that will transform the source database into the destination database.
+
+The sqldiff utility works by finding rows in the source and destination
+that are logical "pairs". The default behavior is to treat two rows as
+pairs if they are in tables with the same name and they have the same
+rowid, or in the case of a WITHOUT ROWID table if they have the same
+PRIMARY KEY. Any differences in the content of paired rows are output as
+UPDATEs. Rows in the source database that could not be paired are output
+as DELETEs. Rows in the destination database that could not be paired
+are output as INSERTs.
Index: pkgsrc/databases/sqlite3-diff/Makefile
diff -u /dev/null pkgsrc/databases/sqlite3-diff/Makefile:1.1
--- /dev/null   Tue May 20 16:46:24 2025
+++ pkgsrc/databases/sqlite3-diff/Makefile      Tue May 20 16:46:24 2025
@@ -0,0 +1,22 @@
+# $NetBSD: Makefile,v 1.1 2025/05/20 16:46:24 schmonz Exp $
+
+.include "../../databases/sqlite3/Makefile.common"
+
+DISTNAME=              sqlite-src-${SQLITE3_DISTVERSION}
+PKGNAME=               sqlite3-diff-${SQLITE3_VERSION}
+CATEGORIES=            databases
+EXTRACT_SUFX=          .zip
+
+MAINTAINER=            schmonz%NetBSD.org@localhost
+COMMENT=               Display content differences between SQLite databases
+
+HAS_CONFIGURE=         yes
+
+BUILD_TARGET=          sqldiff
+
+INSTALLATION_DIRS=     bin
+
+do-install:
+       ${INSTALL_PROGRAM} ${WRKSRC}/sqldiff ${DESTDIR}${PREFIX}/bin
+
+.include "../../mk/bsd.pkg.mk"
Index: pkgsrc/databases/sqlite3-diff/PLIST
diff -u /dev/null pkgsrc/databases/sqlite3-diff/PLIST:1.1
--- /dev/null   Tue May 20 16:46:24 2025
+++ pkgsrc/databases/sqlite3-diff/PLIST Tue May 20 16:46:24 2025
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1 2025/05/20 16:46:24 schmonz Exp $
+bin/sqldiff
Index: pkgsrc/databases/sqlite3-diff/distinfo
diff -u /dev/null pkgsrc/databases/sqlite3-diff/distinfo:1.1
--- /dev/null   Tue May 20 16:46:24 2025
+++ pkgsrc/databases/sqlite3-diff/distinfo      Tue May 20 16:46:24 2025
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1 2025/05/20 16:46:24 schmonz Exp $
+
+BLAKE2s (sqlite-src-3490200.zip) = ff6662bea8f3eec66a72cefe46f011f81fb9ea6780ff389ebf4f186f0186c382
+SHA512 (sqlite-src-3490200.zip) = d07600391df9fd635b1d43cff208021450a18cedad67221e239b0ed86ef287f2f31c040ac413c8a69123615f01658b68f26b6e70a71da39be3ead372a13c8bdc
+Size (sqlite-src-3490200.zip) = 14377708 bytes