mysql

Documentation

Index

• Variables
• func NewConnPool(mysqlDBConf Config) (*sqlx.DB, error)
• type Config
• type QueryFilter
• type SQLNamedExecuter
• type SQLNamedQueryer

Variables

var ErrSQLNotFound = errors.New("not found")

ErrSQLNotFound happens when no rows were found

Functions

func NewConnPool

func NewConnPool(mysqlDBConf Config) (*sqlx.DB, error)

NewConnPool connects to db and return a connection pool

Types

type Config

type Config struct {
	Protocol string
	Host     string
	Port     string
	User     string
	Password string
	DbName   string
}

Config is a conf for the mysql database

type QueryFilter

type QueryFilter struct {
	FilterSQL   string
	NamedParams map[string]interface{}
}

QueryFilter allows for select filters

type SQLNamedExecuter

type SQLNamedExecuter interface {
	NamedExecContext(ctx context.Context, query string, arg interface{}) (
		sql.Result, error,
	)
}

SQLNamedExecuter is an interface used for CUD

type SQLNamedQueryer

type SQLNamedQueryer interface {
	NamedQueryContext(ctx context.Context, query string, arg interface{}) (
		*sqlx.Rows, error,
	)
}

SQLNamedQueryer is used to do select queries