package main

import (
	"database/sql"
	"log"

	"strconv"

	"github.com/lib/pq"
)

const (
	psqlBusinessError            = "50001"
	psqlBusinessErrorWithLogging = "50002"
	psqlVersionControlError      = "50003"
)

func main() {

	connStrPostgres := "user=postgres password=password1 dbname=test_wild sslmode=disable host=127.0.0.1"
	db, err := sql.Open("postgres", connStrPostgres)
	if err != nil {
		log.Fatal(err)
	}
	if err := db.Ping(); err != nil {
		log.Fatal(err)
	}

	for i := 1; i <= 3; i++ {
		_, err := db.Exec(`SELECT * FROM errortests($1)`, i)
		if err != nil {
			if err, ok := err.(*pq.Error); ok {
				if code, _ := strconv.Atoi(string(err.Code)); code > 50000 {
					log.Print(err.Message)
				} else {
					log.Print("Db error")
				}
			} else {
				log.Print("unknown error")
			}
		}
	}

}