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)
}