README
¶
pqerrors
pqerrors is a Go library that provides constants to make handling pq errors easier
Example Usage:
Error Classes
var err error // err from database/sql
if e, ok := err.(pq.Error); ok {
switch e.Code.Class() {
case pqerrcls.NoData:
// Handle error
case pqerrcls.IntegrityConstraintViolation:
// Handle error
default:
// Handle unexpected error
}
}
Error Codes
var err error // err from database/sql
if e, ok := err.(pq.Error); ok {
switch e.Code {
case pqerrcode.DataExceptionNullValueNotAllowed:
// Handle error
case pqerrcode.IntegrityConstraintViolationUniqueViolation:
// Handle error
default:
// Handle unexpected error
}
}
How to update error class and code constants:
- Copy the table of Postgres errors into
errors_table.txt - Run
go generate - Ensure that tests still pass:
go test -v - Commit the changes
- Open a PR
Documentation
¶
Overview ¶
Package pqerrors provides constants for pq's (github.com/lib/pq) ErrorClass and ErrorCode
ErrorClass constants are in the pqerrcls package and ErrorCode constants are in the pqerrcode package
Example ¶
package main
import (
"fmt"
"github.com/dhui/pqerrors/pqerrcls"
"github.com/dhui/pqerrors/pqerrcode"
"github.com/lib/pq"
)
func main() {
pqErr := pq.Error{Code: pq.ErrorCode("23505")}
var err error = pqErr // err from database/sql
if e, ok := err.(pq.Error); ok {
// Example usage of pqerrcls
switch e.Code.Class() {
case pqerrcls.IntegrityConstraintViolation:
fmt.Println("Class success!")
default:
fmt.Println("Unexpected error class:", e.Code.Class(), e.Code.Class().Name())
}
// Example usage of pqerrcode
switch e.Code {
case pqerrcode.IntegrityConstraintViolationUniqueViolation:
fmt.Println("Code success!")
default:
fmt.Println("Unexpected error code:", e.Code, e.Code.Name())
}
}
}
Output: Class success! Code success!
Source Files
Directories
Click to show internal directories.
Click to hide internal directories.