database

Documentation

Index

• Variables
• func NamedExecContext(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, ...) error
• func NamedQuerySlice(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, ...) error
• func NamedQueryStruct(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, ...) error
• func Open(cfg Config) (*sqlx.DB, error)
• func StatusCheck(ctx context.Context, sqlxDB *sqlx.DB) error
• type Config

Variables

var (
	ErrNotFound              = errors.New("not found")
	ErrInvalidID             = errors.New("ID is not in its proper form")
	ErrAuthenticationFailure = errors.New("authentication failed")
	ErrForbidden             = errors.New("attempted action is not allowed")
)

Set of error variables for CRUD operations

Functions

func NamedExecContext

func NamedExecContext(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, data interface{}) error

NamedExecContext is a helper function to execute a CUD operation with logging and tracing.

func NamedQuerySlice

func NamedQuerySlice(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, data interface{}, dest interface{}) error

NamedQuerySlice is a helper function for executing queries that return a collection of data to be unmarshaled into a slice.

func NamedQueryStruct

func NamedQueryStruct(ctx context.Context, log *zap.SugaredLogger, sqlxDB *sqlx.DB, query string, data interface{}, dest interface{}) error

NamedQueryStruct is a helper function for executing queries that return a single value to be unmarshalled into a struct type.

func Open

func Open(cfg Config) (*sqlx.DB, error)

Open connects to the postgres database based on the configuration

func StatusCheck

func StatusCheck(ctx context.Context, sqlxDB *sqlx.DB) error

StatusCheck returns nil if it can successfully talk to the database. It returns a non-nil error otherwise.

Types

type Config

type Config struct {
	User       string
	Password   string
	Host       string
	Name       string
	DisableTLS bool
}

Config for db for connecting to db