pgsql

func IsForeignKeyViolation ¶ added in v0.2.8

func IsForeignKeyViolation(err error, constraint ...string) bool

IsForeignKeyViolation checks is error an foreign_key_violation

func IsInvalidTextRepresentation ¶ added in v0.2.2

func IsInvalidTextRepresentation(err error) bool

IsInvalidTextRepresentation checks is error an invalid_text_representation

func IsUniqueViolation ¶

func IsUniqueViolation(err error, constraint ...string) bool

IsUniqueViolation checks is error an unique_violation with given constraint, constraint can be empty to ignore constraint name checks

func Iter ¶ added in v0.5.0

func Iter(q interface {
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
}, iter Iterator, query string, args ...interface{}) error

func IterContext ¶ added in v0.5.0

func IterContext(ctx context.Context, q interface {
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
}, iter Iterator, query string, args ...interface{}) error

func JSON ¶ added in v0.4.0

func JSON(value interface{}) interface {
	driver.Valuer
	sql.Scanner
}

JSON wraps value with scanner and valuer

func NullString ¶ added in v0.2.5

func NullString(s *string) interface {
	driver.Valuer
	sql.Scanner
}

NullString scans null into empty string

func NullTime ¶ added in v0.2.4

func NullTime(t *time.Time) interface {
	driver.Valuer
	sql.Scanner
}

NullTime likes Time but wrap time.Time with scanner

func RunInTx ¶

func RunInTx(db BeginTxer, opts *TxOptions, fn func(*sql.Tx) error) error

RunInTx runs fn inside retryable transaction.

see RunInTxContext for more info.

func RunInTxContext ¶

func RunInTxContext(ctx context.Context, db BeginTxer, opts *TxOptions, fn func(*sql.Tx) error) error

RunInTxContext runs fn inside retryable transaction with context. It use Serializable isolation level if tx options isolation is setted to sql.LevelDefault.

RunInTxContext DO NOT handle panic. But when panic, it will rollback the transaction.