From 5fa9ec1b63acc6ac9dc0a8b5d2f8f044c27ea45e Mon Sep 17 00:00:00 2001 From: Ben Morrison Date: Thu, 6 Jun 2019 18:04:09 -0400 Subject: working on adding sqlite --- svc/db.go | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'svc') diff --git a/svc/db.go b/svc/db.go index e0c2690..f5e8678 100644 --- a/svc/db.go +++ b/svc/db.go @@ -8,6 +8,7 @@ import ( "time" "github.com/getwtxt/registry" + _ "github.com/mattn/go-sqlite3" "github.com/syndtr/goleveldb/leveldb" ) @@ -43,6 +44,12 @@ func initDatabase() { case "sqlite": var lite *sql.DB + lite, err := sql.Open("sqlite3", confObj.DBPath) + errFatal(err) + litePrep, err := lite.Prepare("CREATE TABLE IF NOT EXISTS getwtxt (urlKey TEXT PRIMARY KEY, isUser BOOL, blobKey TEXT, data BLOB)") + errFatal(err) + _, err = litePrep.Exec() + errFatal(err) db = &dbSqlite{db: lite} case "postgres": -- cgit 1.4.1-2-gfad0