Implement ftag init

We execute the ftag SQL init script using the programs sqlite3 and sh.

1 files changed, 7 insertions, 1 deletions

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 **)