From c5064f6bbd06596ba1eb002904b9572427d71fc6 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 2 Nov 2024 13:14:03 +0200 Subject: feat: client and server api changes to accomedate DB --- internal/server/api/database.go | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 internal/server/api/database.go (limited to 'internal/server/api/database.go') diff --git a/internal/server/api/database.go b/internal/server/api/database.go new file mode 100644 index 0000000..7057393 --- /dev/null +++ b/internal/server/api/database.go @@ -0,0 +1,35 @@ +package api + +import ( + "database/sql" + "log" + + "github.com/kyren223/eko/pkg/assert" +) + +var db *sql.DB + +func ConnectToDatabase() { + db, err := sql.Open("sqlite3", "server.db") + assert.NoError(err, "DB should always be accessible") + assert.AddFlush(db) + log.Println("established connection with the database") + + pragmas := []string{ + "PRAGMA journal_mode = WAL;", + "PRAGMA synchronous = NORMAL;", + "PRAGMA temp_store = MEMORY;", + "PRAGMA mmap_size = 30000000000;", + } + for _, pragma := range pragmas { + _, err := db.Exec(pragma) + assert.NoError(err, "DB pragmas should always execute with no errors") + } + + log.Println("database connection ready to be used") +} + +func CloseDatabase() { + db.Close() + log.Println("connection with database closed") +} -- cgit v1.3.1