database

Documentation

Index

• Variables
• func Migrate(db *sqlx.DB) error
• func NamedExecContext(ctx context.Context, db sqlx.ExtContext, query string, data any) error
• func NamedQuerySlice[T any](ctx context.Context, db sqlx.ExtContext, query string, data any, dest *[]T) error
• func NamedQueryStruct(ctx context.Context, db sqlx.ExtContext, query string, data any, dest any) error
• func Open(cfg config.DB) (*sqlx.DB, error)
• func Seed(db *sqlx.DB, seed string) error
• func Transaction(db *sqlx.DB, f func(db sqlx.ExtContext) error) error

Variables

var (
	ErrDBNotFound        = errors.New("not found")
	ErrDBDuplicatedEntry = errors.New("duplicated entry")
)

Set of error variables for CRUD operations.

Functions

func Migrate

func Migrate(db *sqlx.DB) error

func NamedExecContext

func NamedExecContext(ctx context.Context, db sqlx.ExtContext, query string, data any) error

NamedExecContext is a helper function to execute a CUD operation.

func NamedQuerySlice

func NamedQuerySlice[T any](ctx context.Context, db sqlx.ExtContext, query string, data any, dest *[]T) error

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

func NamedQueryStruct

func NamedQueryStruct(ctx context.Context, db sqlx.ExtContext, query string, data any, dest any) 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.DB) (*sqlx.DB, error)

Open knows how to open a database connection based on the configuration.

func Seed

func Seed(db *sqlx.DB, seed string) error

func Transaction

func Transaction(db *sqlx.DB, f func(db sqlx.ExtContext) error) error