1 files changed, 22 insertions, 0 deletions

diff --git a/api/internal/database/database.go b/api/internal/database/database.go
new file mode 100644
index 0000000..e313af5
--- /dev/null
+++ b/api/internal/database/database.go
@@ -0,0 +1,22 @@
+package database
+
+import (
+        "database/sql"
+        _ "github.com/mattn/go-sqlite3"
+        "log"
+)
+
+func SetupDatabase() {
+        _, err := sql.Open("sqlite3", "water.db")
+        if err != nil {
+                log.Fatal(err)
+        }
+}
+
+func EstablishDBConnection() *sql.DB {
+        db, err := sql.Open("sqlite3", "../db/water.sqlite3")
+        if err != nil {
+                panic(err)
+        }
+        return db
+}
\ No newline at end of file