repo

package module

Go to main page

Versions in this module

v0

v0.1.15

Aug 17, 2022

v0.1.14

Apr 22, 2022

Changes in this version

+ const ForUpdateNowait

+ const ForUpdateSkip

type Base

+ LockOption string

+ func (r *Base) SetLockOption(lock string) error

type BaseMock

+ func (r *BaseMock) SetLockOption(lock string) error

v0.1.13

Apr 12, 2022

v0.1.12

Mar 28, 2022

v0.1.11

Mar 15, 2022

v0.1.10

Feb 23, 2022

v0.1.9

Feb 23, 2022

v0.1.8

Feb 2, 2022

Changes in this version

type Base

+ func (r *Base) AddCustom(name, stmt, alias string) error

+ func (r *Base) GetRowsCustom(queryName string, params map[string]interface{}) (*sqlx.Rows, error)

v0.1.7

Dec 16, 2021

Changes in this version

+ const ErrInvalidColumn

type Options

+ ForUpdate string

+ Limit int

+ Offset int

+ OrderBy []Ordering

+ type Ordering struct

+ Column string

+ Direction string

v0.1.6

Dec 13, 2021

v0.1.5

Dec 13, 2021

Changes in this version

+ const OperatorNotIn

+ const StatementSelectByAltForUpdate

+ const StatementSelectByAltID

+ func IsErrNoRows(err error) bool

type Base

+ AltIDColumn string

+ VarGetByAltIDSQL string

+ func (r *Base) GetByAltIDSQL() string

+ func (r *Base) GetRecByAltID(querySQL string, recID interface{}, rec interface{}, forUpdate bool) error

type BaseMock

+ func (r *BaseMock) InitTx(tx *sqlx.Tx) error

+ type Options = map[string]string

+ type QueryParams = map[string]interface

v0.1.4

Oct 25, 2021

v0.1.3

Oct 6, 2021

Changes in this version

+ const LockOptionNoWait

+ const LockOptionSkip

v0.1.2

Sep 15, 2021

Changes in this version

type Base

+ ColumnMap map[string]Columns

+ CreateColumns Columns

+ Filters ColumnFilters

+ LogicalDeleteColumn string

+ ReturnColumns Columns

+ UpdateColumns Columns

+ VarCreateRecordSQL string

+ VarDeleteRecordSQL string

+ VarGetByIDSQL string

+ VarGetByParamSQL string

+ VarRemoveRecordSQL string

+ VarUpdateRecordSQL string

+ func (r *Base) GetByIDSQL() string

+ func (r *Base) GetByParamSQL() string

+ func (r *Base) GetColumnList(name string) []string

+ func (r *Base) GetCreateSQL() string

+ func (r *Base) GetDeleteSQL() string

+ func (r *Base) GetRemoveSQL() string

+ func (r *Base) GetUpdateSQL() string

+ func (r *Base) InitTx(tx *sqlx.Tx) error

+ type ColumnFilters struct

+ Create map[string]*string

+ Return map[string]*string

+ Update map[string]*string

v0.1.1

Sep 9, 2021

Changes in this version

type BaseMock

+ TableName string

v0.1.0

Sep 6, 2021

Changes in this version

+ const ClauseForUpdate

+ const ClauseLimit

+ const ClauseOffset

+ const ClauseOrderBy

+ const ClauseOrderByAscending

+ const ClauseOrderByDescending

+ const ColumnsCreate

+ const ColumnsReturn

+ const ColumnsUpdate

+ const ErrBetweenArrayHasTwoVals

+ const ErrBetweenBounds

+ const ErrBetweenStringHasTwoVals

+ const NilRecord

+ const OperatorArrayContainedIn

+ const OperatorArrayContains

+ const OperatorBetween

+ const OperatorEqual

+ const OperatorGreaterThan

+ const OperatorGreaterThanEqualTo

+ const OperatorIn

+ const OperatorIsNotNull

+ const OperatorIsNull

+ const OperatorLessThan

+ const OperatorLessThanEqualTo

+ const OperatorLike

+ const OperatorNotEqualTo

+ const QueryNoRows

+ const StatementCount

+ const StatementCreate

+ const StatementDelete

+ const StatementRemove

+ const StatementSelectByAPIID

+ const StatementSelectByID

+ const StatementSelectByIDs

+ const StatementSelectByParam

+ const StatementSelectForUpdate

+ const StatementUpdate

+ const TitleAccess

+ const TitleData

+ const TitleDatabase

+ const TitleIntegrity

+ const TitleInvalid

+ const TitleNoData

+ const TitleQuery

+ const TitleRepo

+ const TitleService

+ const TitleSyntax

+ const TitleSystem

+ func GetTimeString() string

+ type Base struct

+ Logger zerolog.Logger

+ OrderByFunc func() string

+ TableName string

+ Tx *sqlx.Tx

+ func (r *Base) Count() (int, error)

+ func (r *Base) CountByParam(params []Restriction) (int, error)

+ func (r *Base) CreateRec(createSQL string, rec interface{}) error

+ func (r *Base) DeleteRec(deleteSQL string, recID interface{}) error

+ func (r *Base) ErrEmptyParam(param string) *Error

+ func (r *Base) ErrOperatorNotSupported(op string) *Error

+ func (r *Base) GenerateStatement(statementType string, columns map[string]Columns) (stmt string)

+ func (r *Base) GetRecByID(querySQL string, recID interface{}, rec interface{}, forUpdate bool) error

+ func (r *Base) GetRowByID(querySQL string, recID interface{}, forUpdate bool) (*sqlx.Row, error)

+ func (r *Base) GetRowsByParam(querySQL string, params []Restriction, options map[string]string) (rows *sqlx.Rows, err error)

+ func (r *Base) Init(tx *sqlx.Tx) error

+ func (r *Base) OrderBy() string

+ func (r *Base) RemoveRec(removeSQL string, recID interface{}) error

+ func (r *Base) UpdateRec(updateSQL string, rec interface{}) error

+ type BaseMock struct

+ Context string

+ Logger zerolog.Logger

+ func (r *BaseMock) CompareParams(params []Restriction, rec interface{}) (bool, error)

+ func (r *BaseMock) GetByParamSQL() string

+ func (r *BaseMock) GetRowsByParam(querySQL string, params map[string]interface{}, ...) (rows *sqlx.Rows, err error)

+ func (r *BaseMock) Init(tx *sqlx.Tx) error

+ type Columns []string

+ func GetColumns(rec interface{}) Columns

+ func (c Columns) ToList() string

+ func (c Columns) ToPrefixedList(prefix string) string

+ func (c Columns) ToUpdateList() string

+ type Error struct

+ Context string

+ Detail string

+ Title string

+ Value interface{}

+ func ErrNoRows(context string) *Error

+ func NewAccessError(err error) *Error

+ func NewDatabaseError(context, message string, value interface{}) *Error

+ func NewFromDatabaseError(err error, defaultContext string) *Error

+ func NewRepoError(context, message string, value interface{}) *Error

+ func (e *Error) Error() string

+ type Restriction struct

+ Column string

+ Operator string

+ Value interface{}

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL