Added SQLite3 embedding

1 files changed, 40 insertions, 0 deletions

diff --git a/c-sqlite-embed-db/main.c b/c-sqlite-embed-db/main.c
new file mode 100644
index 0000000..ecc9c04
--- /dev/null
+++ b/c-sqlite-embed-db/main.c
@@ -0,0 +1,40 @@
+#include <stdio.h>
+#include <stdlib.h>
+#include <string.h>
+
+#include "sqlite3.h"
+#include "data.h"
+
+int main(void) {
+	sqlite3 *db;
+	int rc;
+
+	rc = sqlite3_open(":memory:", &db);
+	if (rc != SQLITE_OK) {
+		fprintf(stderr, "Cannot open database: %s\n", sqlite3_errmsg(db));
+		return 1;
+	}
+
+	rc = sqlite3_deserialize(db, "main", data, data_len, data_len, SQLITE_DESERIALIZE_READONLY);
+	if (rc != SQLITE_OK) {
+		fprintf(stderr, "Failed to load database: %s\n", sqlite3_errmsg(db));
+		sqlite3_close(db);
+		return 1;
+	}
+
+	printf("Database loaded successfully!\n");
+
+	sqlite3_stmt *stmt;
+	const char *sql = "SELECT name FROM sqlite_master WHERE type='table';";
+	rc = sqlite3_prepare_v2(db, sql, -1, &stmt, NULL);
+	if (rc == SQLITE_OK) {
+		printf("Tables in database:\n");
+		while (sqlite3_step(stmt) == SQLITE_ROW) {
+			printf("- %s\n", sqlite3_column_text(stmt, 0));
+		}
+		sqlite3_finalize(stmt);
+	}
+
+	sqlite3_close(db);
+	return 0;
+}