Go Result type

test.go

func ConnectToDB() result.Result[sql.DB] {
	psqlInfo := fmt.Sprintf("host=%s port=%s user=%s password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)

	return result.NewResult(sql.Open("postgres", psqlInfo)).Try(func(db *sql.DB) error {
		return db.Ping()
	}).IfOk(func() {
		fmt.Println("Successfully connected to database!")
	})
}


func ConnectToDB() (*sql.DB, error) {

	psqlInfo := fmt.Sprintf("host=%s port=%s user=%s password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)

	db, err := sql.Open("postgres", psqlInfo)

	if err != nil {
		return nil, err
	}

	err = db.Ping()

	if err != nil {
		return nil, err
	}

	fmt.Println("Successfully connected to database!")

	return db, err

}