diff options
| author | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-09 10:41:46 -0500 |
|---|---|---|
| committer | Eugene Triguba <eugenetriguba@gmail.com> | 2024-03-09 10:41:46 -0500 |
| commit | 64b73944a6849c0b376bffa33b44f9ee6ac20a51 (patch) | |
| tree | 55c55aaf83eb829d1c522ce173bf1d1edd8de019 /internal/storage/db.go | |
| parent | Release v0.3.0 (diff) | |
| download | cli-64b73944a6849c0b376bffa33b44f9ee6ac20a51.zip | |
Replace lib/pq with pgx
Diffstat (limited to 'internal/storage/db.go')
| -rw-r--r-- | internal/storage/db.go | 15 |
1 files changed, 12 insertions, 3 deletions
diff --git a/internal/storage/db.go b/internal/storage/db.go index a9e35af..d83e71d 100644 --- a/internal/storage/db.go +++ b/internal/storage/db.go @@ -4,16 +4,20 @@ import ( "database/sql" "errors" "fmt" + "slices" "github.com/eugenetriguba/bolt/internal/configloader" - _ "github.com/lib/pq" + _ "github.com/jackc/pgx/v5/stdlib" ) +var supportedDrivers = []string{"postgres"} + var ( ErrMalformedConnectionString = errors.New( "malformed database connection parameters provided", ) - ErrUnableToConnect = errors.New("unable to open connection to database") + ErrUnableToConnect = errors.New("unable to open connection to database") + ErrUnsupportedDriver = fmt.Errorf("unsupported driver, supported drivers are %s", supportedDrivers) ) // DBConnect establishes a connection to the database using the driver @@ -24,8 +28,13 @@ var ( // not in a valid format. // - ErrUnableToConnect: Unable to make a connection to the database with // the provided connection parameters. +// - ErrUnsupportedDriver: The provided driver is not supported. func DBConnect(driver string, connectionParams string) (*sql.DB, error) { - db, err := sql.Open(driver, connectionParams) + if !slices.Contains(supportedDrivers, driver) { + return nil, ErrUnsupportedDriver + } + + db, err := sql.Open("pgx", connectionParams) if err != nil { return nil, fmt.Errorf("%w: %v", ErrMalformedConnectionString, err) } |