1 files changed, 24 insertions, 0 deletions

diff --git a/api/internal/database/database.go b/api/internal/database/database.go
new file mode 100644
index 0000000..1866655
--- /dev/null
+++ b/api/internal/database/database.go
@@ -0,0 +1,24 @@
+package database
+
+import (
+        "database/sql"
+        _ "github.com/mattn/go-sqlite3"
+        "log"
+        "path/filepath"
+        "water/api/internal/config"
+)
+
+func EstablishDBConnection() *sql.DB {
+        c, err := config.Load()
+
+        driver := c.GetString("DB_DRIVER")
+        path, err := filepath.Abs(c.GetString("DB_PATH"))
+        if err != nil {
+                log.Fatal("There was and error getting the absolute path of the database.")
+        }
+        db, err := sql.Open(driver, path)
+        if err != nil {
+                panic(err)
+        }
+        return db
+}
\ No newline at end of file