summary refs log tree commit diff
path: root/database.h
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-05 11:22:42 -0500
committerJune McEnroe <june@causal.agency>2019-12-05 11:22:42 -0500
commitad68bbd4122683ac1ac00ebfeea6cdcfaae40777 (patch)
tree00f7813565483533315fff63811469140bdd3c72 /database.h
parentInsert colons into timezones (diff)
downloadlitterbox-ad68bbd4122683ac1ac00ebfeea6cdcfaae40777.tar.gz
litterbox-ad68bbd4122683ac1ac00ebfeea6cdcfaae40777.zip
Import in one transaction per file
Diffstat (limited to 'database.h')
-rw-r--r--database.h10
1 files changed, 10 insertions, 0 deletions
diff --git a/database.h b/database.h
index 3247fee..038ce70 100644
--- a/database.h
+++ b/database.h
@@ -94,6 +94,16 @@ static inline sqlite3 *dbFind(int flags) {
 	return NULL;
 }
 
+static inline void dbBegin(sqlite3 *db) {
+	int error = sqlite3_exec(db, "BEGIN TRANSACTION;", NULL, NULL, NULL);
+	if (error) errx(EX_SOFTWARE, "sqlite3_exec: %s", sqlite3_errmsg(db));
+}
+
+static inline void dbCommit(sqlite3 *db) {
+	int error = sqlite3_exec(db, "COMMIT TRANSACTION;", NULL, NULL, NULL);
+	if (error) errx(EX_SOFTWARE, "sqlite3_exec: %s", sqlite3_errmsg(db));
+}
+
 static inline sqlite3_stmt *
 dbPrepare(sqlite3 *db, unsigned flags, const char *sql) {
 	sqlite3_stmt *stmt;