create a base template :) and use it for a new service

1 files changed, 17 insertions, 0 deletions

diff --git a/template/database/conn.go b/template/database/conn.go
new file mode 100644
index 0000000..be27586
--- /dev/null
+++ b/template/database/conn.go
@@ -0,0 +1,17 @@
+package database
+
+import (
+	"database/sql"
+	_ "github.com/mattn/go-sqlite3"
+	"log"
+)
+
+func MakeConn(databasePath *string) *sql.DB {
+	log.Println("opening database at", *databasePath, "with foreign keys enabled")
+	dbConn, err := sql.Open("sqlite3", *databasePath+"?_foreign_keys=on")
+	if err != nil {
+		panic(err)
+	}
+
+	return dbConn
+}