1 files changed, 59 insertions, 0 deletions
diff --git a/static/netbsd/man3/sqlite3_total_changes.3 b/static/netbsd/man3/sqlite3_total_changes.3
new file mode 100644
index 00000000..f4ec74d2
--- /dev/null
+++ b/static/netbsd/man3/sqlite3_total_changes.3
@@ -0,0 +1,59 @@
+.Dd January 24, 2024
+.Dt SQLITE3_TOTAL_CHANGES 3
+.Os
+.Sh NAME
+.Nm sqlite3_total_changes ,
+.Nm sqlite3_total_changes64
+.Nd total number of rows modified
+.Sh SYNOPSIS
+.In sqlite3.h
+.Ft int
+.Fo sqlite3_total_changes
+.Fa "sqlite3*"
+.Fc
+.Ft sqlite3_int64
+.Fo sqlite3_total_changes64
+.Fa "sqlite3*"
+.Fc
+.Sh DESCRIPTION
+These functions return the total number of rows inserted, modified
+or deleted by all INSERT, UPDATE or DELETE statements
+completed since the database connection was opened, including those
+executed as part of trigger programs.
+The two functions are identical except for the type of the return value
+and that if the number of rows modified by the connection exceeds the
+maximum value supported by type "int", then the return value of sqlite3_total_changes()
+is undefined.
+Executing any other type of SQL statement does not affect the value
+returned by sqlite3_total_changes().
+.Pp
+Changes made as part of foreign key actions are
+included in the count, but those made as part of REPLACE constraint
+resolution are not.
+Changes to a view that are intercepted by INSTEAD OF triggers are not
+counted.
+.Pp
+The sqlite3_total_changes(D) interface only
+reports the number of rows that changed due to SQL statement run against
+database connection D.
+Any changes by other database connections are ignored.
+To detect changes against a database file from other database connections
+use the PRAGMA data_version command or the SQLITE_FCNTL_DATA_VERSION
+file control.
+.Pp
+If a separate thread makes changes on the same database connection
+while
+.Fn sqlite3_total_changes
+is running then the value returned is unpredictable and not meaningful.
+.Pp
+.Sh IMPLEMENTATION NOTES
+These declarations were extracted from the
+interface documentation at line 2661.
+.Bd -literal
+SQLITE_API int sqlite3_total_changes(sqlite3*);
+SQLITE_API sqlite3_int64 sqlite3_total_changes64(sqlite3*);
+.Ed
+.Sh SEE ALSO
+.Xr sqlite3_changes 3 ,
+.Xr sqlite3_file_control 3 ,
+.Xr SQLITE_FCNTL_LOCKSTATE 3