db

Documentation

Overview

Package db provides support for access to a mysql database using the mysql driver

Index

• Variables
• func ExecContext(ctx context.Context, log *logger.Logger, db sqlx.ExtContext, query string) (sql.Result, error)
• func NamedExecContext(ctx context.Context, log *logger.Logger, db sqlx.ExtContext, query string, ...) (sql.Result, error)
• func NamedQueryStruct(ctx context.Context, log *logger.Logger, db sqlx.ExtContext, query string, ...) error
• func Open(config Config) (*sqlx.DB, error)
• func StatusCheck(ctx context.Context, db *sqlx.DB) error
• type Config

Variables

var (
	ErrDBNotFound        = sql.ErrNoRows
	ErrDBDuplicatedEntry = errors.New("duplicated entry")
	ErrUndefinedTable    = errors.New("undefined table")
)

Set of error variables for CRUD operations.

Functions

func ExecContext

func ExecContext(ctx context.Context, log *logger.Logger, db sqlx.ExtContext, query string) (sql.Result, error)

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

func NamedExecContext

func NamedExecContext(ctx context.Context, log *logger.Logger, db sqlx.ExtContext, query string, data any) (sql.Result, error)

NamedExecContext is a helper function to execute a CUD operation with logging and tracing where field replacement is necessary.

func NamedQueryStruct

func NamedQueryStruct(ctx context.Context, log *logger.Logger, 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 where field replacement is necessary.

func Open

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

Open opens a database specified by a configuration struct and a driver-specific data source name, usually consisting of at least a database name and connection information.

func StatusCheck

func StatusCheck(ctx context.Context, db *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
	Schema       string
	MaxIdleConns int
	MaxOpenConns int
	DisableTLS   bool
}

Config is the required properties to use the database.