1 files changed, 45 insertions, 0 deletions
diff --git a/src/dbi.c b/src/dbi.c
new file mode 100644
index 0000000..6640f50
--- /dev/null
+++ b/src/dbi.c
@@ -0,0 +1,45 @@
+/*
+ * Copyright (C) 2020 Soleta Networks <info@soleta.eu>
+ *
+ * This program is free software: you can redistribute it and/or modify it under
+ * the terms of the GNU Affero General Public License as published by the
+ * Free Software Foundation, version 3.
+ */
+
+#include "dbi.h"
+
+struct og_dbi *og_dbi_open(struct og_dbi_config *config)
+{
+	struct og_dbi *dbi;
+
+	dbi = (struct og_dbi *)malloc(sizeof(struct og_dbi));
+	if (!dbi)
+		return NULL;
+
+	dbi_initialize_r(NULL, &dbi->inst);
+	dbi->conn = dbi_conn_new_r("mysql", dbi->inst);
+	if (!dbi->conn) {
+		free(dbi);
+		return NULL;
+	}
+
+	dbi_conn_set_option(dbi->conn, "host", config->host);
+	dbi_conn_set_option(dbi->conn, "username", config->user);
+	dbi_conn_set_option(dbi->conn, "password", config->passwd);
+	dbi_conn_set_option(dbi->conn, "dbname", config->database);
+	dbi_conn_set_option(dbi->conn, "encoding", "UTF-8");
+
+	if (dbi_conn_connect(dbi->conn) < 0) {
+		free(dbi);
+		return NULL;
+	}
+
+	return dbi;
+}
+
+void og_dbi_close(struct og_dbi *dbi)
+{
+	dbi_conn_close(dbi->conn);
+	dbi_shutdown_r(dbi->inst);
+	free(dbi);
+}