pgsql

README

pgsql

pgsql is the helper functions for postgres

Documentation

Index

• func IsInvalidTextRepresentation(err error) bool
• func IsUniqueViolation(err error, constraint ...string) bool
• func RunInTx(db BeginTxer, opts *TxOptions, fn func(*sql.Tx) error) error
• func RunInTxContext(ctx context.Context, db BeginTxer, opts *TxOptions, fn func(*sql.Tx) error) error
• type BeginTxer
• type Time
  • func (t *Time) Scan(src interface{}) error
  • func (t Time) Value() (driver.Value, error)
• type TxOptions

Functions

func IsInvalidTextRepresentation

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 RunInTx

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

RunInTx runs fn inside retryable transaction

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

Types

type BeginTxer

type BeginTxer interface {
	BeginTx(context.Context, *sql.TxOptions) (*sql.Tx, error)
}

BeginTxer type

type Time

type Time struct {
	time.Time
}

Time is the time.Time but can scan null into empty

func (*Time) Scan

func (t *Time) Scan(src interface{}) error

Scan implements Scanner interface

func (Time) Value

func (t Time) Value() (driver.Value, error)

Value implements Valuer interface

type TxOptions

type TxOptions struct {
	sql.TxOptions
	MaxAttempts int
}

TxOptions is the transaction options