From 809fc4639e58ca9ca082ce68b5c62b463b2f1e1d Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Sat, 30 Dec 2023 16:00:20 -0500 Subject: Add initial code --- internal/db/db.go | 48 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 internal/db/db.go (limited to 'internal/db') diff --git a/internal/db/db.go b/internal/db/db.go new file mode 100644 index 0000000..df5934c --- /dev/null +++ b/internal/db/db.go @@ -0,0 +1,48 @@ +package db + +import ( + "database/sql" + "fmt" + + "github.com/eugenetriguba/bolt/internal/config" + _ "github.com/lib/pq" +) + +var db *sql.DB + +// Connect to the database using the driver and connection +// parameter that are specified in the bolt configuration file. +// +// Note that subsequent calls to Connect return the same database +// handle. +func Connect() (*sql.DB, error) { + if db == nil { + config, err := config.NewConfig() + if err != nil { + return nil, err + } + + connInfo := fmt.Sprintf( + "host=%s port=%d user=%s password=%s dbname=%s sslmode=disable", + config.Connection.Host, config.Connection.Port, config.Connection.User, + config.Connection.Password, config.Connection.DBName, + ) + newDb, err := sql.Open(config.Connection.Driver, connInfo) + if err != nil { + return nil, err + } + + // Note: `sql.Open` only validates the connection string we provided + // it is sane. It doesn't actually open up a connection to the database. + // For that, we ping the database to ensure the connection string is fully + // valid. + err = newDb.Ping() + if err != nil { + return nil, err + } + + db = newDb + } + + return db, nil +} -- cgit v1.2.3