From fa9b07141713e30bce03d979ad7e8d54bdb33dff Mon Sep 17 00:00:00 2001
From: Tristan Riehs <tristan.riehs@inria.fr>
Date: Tue, 11 Nov 2025 10:57:02 +0100
Subject: Implement ftag init

We execute the ftag SQL init script using the programs sqlite3 and sh.
---
 src/main.c | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'src')

diff --git a/src/main.c b/src/main.c
index dd047e2..1a2fab0 100644
--- a/src/main.c
+++ b/src/main.c
@@ -3,6 +3,7 @@
 #include <stdio.h>
 #include <stdlib.h>
 #include <string.h>
+#include <unistd.h>
 
 #define DATABASE_PATH (FTAG_ROOT "/ftag.sqlite3")
 
@@ -34,7 +35,12 @@ static void __sqlite3_check(int rc, sqlite3 *db, const char *file, int line)
 
 static void ftag_init(int, char **)
 {
-	;
+	char cmd[1024];
+	memset(cmd, 0, sizeof(cmd));
+	snprintf(cmd, sizeof(cmd)-1, "sqlite3 %s < %s", DATABASE_PATH, FTAG_ROOT "/sql/init.sql");
+	execl("/usr/bin/sh", "/usr/bin/sh", "-c", cmd, NULL);
+	perror("exec");
+	exit(EXIT_FAILURE);
 }
 
 static void ftag_help(int, char **)
-- 
cgit v1.2.3