pink_fox/application/packages/fw/pg.go

22 lines
438 B
Go

package fw
import (
"database/sql"
"fmt"
)
func CreateConnection(host, port, user, password, database string) (*sql.DB, Error) {
psqlInfo := fmt.Sprintf("host=%s port=%s user=%s password=%s dbname=%s sslmode=disable",
host, port, user, password, database)
var db *sql.DB
var err error
db, err = sql.Open("postgres", psqlInfo)
if err == nil {
err = db.Ping()
if err == nil {
return db, nil
}
}
return nil, Err(err)
}