1 files changed, 49 insertions, 0 deletions
diff --git a/src/db/db.go b/src/db/db.go
new file mode 100644
index 0000000..7ca96ff
--- /dev/null
+++ b/src/db/db.go
@@ -0,0 +1,49 @@
+/*
+ * vidhublog: Vidhu Kant's Blog
+ * Copyright (C) 2022  Vidhu Kant Sharma <vidhukant@protonmail.ch>
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+package db
+
+import (
+  "database/sql"
+  _ "github.com/go-sql-driver/mysql"
+  "github.com/joho/godotenv"
+  "os"
+)
+
+// ConnectDB opens a connection to the database
+// TODO: properly handle all errors
+func ConnectDB() *sql.DB {
+  // load ENV
+  err := godotenv.Load()
+  if err != nil {
+    panic(err.Error())
+  }
+
+  // read ENV
+  username := os.Getenv("DB_USERNAME")
+  password := os.Getenv("DB_PASSWORD")
+  database := os.Getenv("DB_DATABASE")
+
+  // connect to database
+  db, err := sql.Open("mysql", username + ":" + password + "@/" + database)
+	if err != nil {
+		panic(err.Error())
+	}
+
+	return db
+}