21 lines
404 B
Go
21 lines
404 B
Go
package core
|
|
|
|
import (
|
|
"fmt"
|
|
|
|
_ "github.com/jackc/pgx/stdlib"
|
|
"github.com/jmoiron/sqlx"
|
|
)
|
|
|
|
func SetupDB(url string) (*sqlx.DB, error) {
|
|
db, err := sqlx.Open("pgx", url)
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
|
|
return db, nil
|
|
}
|
|
|
|
func ComputeDBURL(dbHost, dbPort, dbUser, dbPassword, dbName string) string {
|
|
return fmt.Sprintf("postgres://%s:%s@%s:%s/%s", dbUser, dbPassword, dbHost, dbPort, dbName)
|
|
}
|