ghostly/driver.go at v1.3.0 · Dominic-Wassef/ghostly

Repository navigation

package ghostly

import (

"database/sql"

_ "github.com/jackc/pgconn"

_ "github.com/jackc/pgx/v4"

_ "github.com/jackc/pgx/v4/stdlib"

)

// OpenDB opens a connection to a sql database. dbType must be one of postgres (or pgx).

// TODO: add support for mysql/mariadb

func (g *Ghostly) OpenDB(dbType, dsn string) (*sql.DB, error) {

if dbType == "postgres" || dbType == "postgresql" {

dbType = "pgx"

}

db, err := sql.Open(dbType, dsn)

if err != nil {

return nil, err

}

err = db.Ping()

if err != nil {

return nil, err

}

return db, nil

}