db

package module

Go to main page

Versions in this module

v0

v0.1.49

Mar 27, 2024

Changes in this version

+ func AddCleanupPatterns(p misc.StringMap)

v0.1.48

Mar 20, 2024

v0.1.47

Feb 21, 2024

v0.1.46

Feb 15, 2024

Changes in this version

+ const SubstAfter

+ const SubstBefore

v0.1.45

Feb 6, 2024

v0.1.44

Jan 12, 2024

v0.1.43

Jan 8, 2024

v0.1.42

Dec 24, 2023

v0.1.41

Dec 15, 2023

Changes in this version

type Result

+ func (r *Result) Add(sqlResult sql.Result, err error)

+ func (r *Result) Errors() []error

+ func (r *Result) HasError() bool

v0.1.40

Dec 12, 2023

v0.1.39

Dec 12, 2023

Changes in this version

+ type Error struct

+ func NewError(parentError error, msg string, params ...any) (e *Error)

+ func (e *Error) Error() string

+ func (e *Error) Parent() error

+ func (e *Error) String() string

v0.1.38

Dec 7, 2023

Changes in this version

+ const SubstTable

+ const TagDB

+ const TagDBAlt

+ func EnableAltTags()

+ func IsAltTagsEnabled() bool

+ func Tag() string

v0.1.37

Aug 16, 2023

Changes in this version

+ const PatternExtraFullFrom

+ const SubstExtraFullFrom

+ const SubstNames

+ const SubstNamesPreComma

+ const SubstPairs

+ const SubstPairsPreComma

+ const SubstVals

+ const SubstValsPreComma

v0.1.36

Jun 13, 2023

Changes in this version

type FieldsInfoMap

+ func (fields FieldsInfoMap) Field2Name(fieldName string) (name string, err error)

v0.1.35

Jun 7, 2023

v0.1.34

Jun 5, 2023

v0.1.33

Jun 4, 2023

Changes in this version

+ type FieldsInfoMap map[string]*FieldInfo

type FieldsList

+ func (fields *FieldsList) ByCleanDbName() FieldsInfoMap

v0.1.32

May 1, 2023

v0.1.31

Apr 28, 2023

Changes in this version

type FieldInfo

+ CleanDbName string

v0.1.30

Mar 30, 2023

Changes in this version

+ func Disable()

+ func Disabled() bool

v0.1.29

Mar 25, 2023

Changes in this version

type FieldInfo

+ Skipped bool

v0.1.28

Mar 22, 2023

Changes in this version

type Duration

+ func (v Duration) D() time.Duration

type FieldsList

+ func (fields *FieldsList) ByDbName() map[string]*FieldInfo

+ func (fields *FieldsList) ByName() map[string]*FieldInfo

v0.1.27

Mar 15, 2023

v0.1.26

Mar 9, 2023

v0.1.25

Mar 8, 2023

v0.1.24

Feb 24, 2023

Changes in this version

type FieldInfo

+ Tags misc.StringMap

v0.1.23

Feb 21, 2023

Changes in this version

type SubstArg

+ func (a *SubstArg) SetValue(v any)

v0.1.22

Feb 20, 2023

v0.1.21

Feb 14, 2023

v0.1.20

Feb 6, 2023

v0.1.19

Feb 1, 2023

Changes in this version

+ type FieldInfo struct

+ Container string

+ DbName string

+ DbSelect string

+ DefVal any

+ FieldName string

+ JbName string

+ JbType string

+ JsonName string

+ Parent *FieldInfo

+ Type reflect.Type

type FieldsList

+ func (fields *FieldsList) AllDbNames() []string

+ func (fields *FieldsList) AllDbSelect() []string

+ func (fields *FieldsList) ByJsonName() map[string]*FieldInfo

+ func (fields *FieldsList) JbFieldsStr() string

type JbPair

+ FieldInfo *FieldInfo

type JbPairs

+ func (d JbPairs) Len() int

+ func (d JbPairs) Less(i, j int) bool

+ func (d JbPairs) Swap(i, j int)

+ func (jbp JbPairs) String(tp PatternType) (s string)

v0.1.18

Jan 19, 2023

Changes in this version

type FieldsList

+ func (fields *FieldsList) Json2db() misc.StringMap

+ func (fields *FieldsList) TypeByDB() map[string]reflect.Type

+ func (fields *FieldsList) TypeByJson() map[string]reflect.Type

v0.1.17

Jan 18, 2023

v0.1.16

Jan 13, 2023

Changes in this version

+ func EnableMock()

+ func ExecExWithMock(mock MockCallback, dbName string, dest any, queryName string, tp PatternType, ...) (result sql.Result, err error)

+ func IsMockEnabled() bool

+ func QueryWithMock(mock MockCallback, dbName string, dest any, queryName string, fields []string, ...) (err error)

+ func SetMockCallback(f MockCallback)

type DB

+ func (db *DB) ExecExWithMock(mock MockCallback, dest any, queryName string, tp PatternType, ...) (result sql.Result, err error)

+ func (db *DB) QueryWithMock(mock MockCallback, dest any, queryName string, fields []string, vars []any) (err error)

+ type MockCallback func(db *DB, mock sqlmock.Sqlmock, q string, v []any) (err error)

type SubstArg

+ func (a *SubstArg) String() string

v0.1.15

Jan 12, 2023

v0.1.14

Jan 10, 2023

v0.1.13

Dec 31, 2022

Changes in this version

+ type Bulk [][]any

type FieldsList

+ func (fields *FieldsList) Prepare(data []misc.InterfaceMap) (jbPairs JbPairs, names []string, rows Bulk)

+ type JbPair struct

+ Format string

+ Idx int

+ type JbPairs []*JbPair

+ type Result struct

+ func (r Result) AllInsertId() ([]int64, error)

+ func (r Result) LastInsertId() (int64, error)

+ func (r Result) RowsAffected() (int64, error)

v0.1.12

Dec 29, 2022

v0.1.11

Dec 21, 2022

v0.1.10

Dec 17, 2022

Changes in this version

type FieldsList

+ func (fields *FieldsList) Json() misc.StringMap

v0.1.9

Dec 16, 2022

Changes in this version

type DB

+ UseQueriesFrom string

v0.1.8

Dec 16, 2022

v0.1.7

Dec 14, 2022

Changes in this version

+ const PatternExtraFrom

+ const SubstExtraFrom

v0.1.6

Dec 1, 2022

Changes in this version

+ const PatternExtra

+ const SubstExtra

+ const SubstJbFields

type FieldsList

+ func (fields *FieldsList) AllSrc() []string

v0.1.5

Nov 28, 2022

v0.1.4

Nov 28, 2022

v0.1.3

Nov 28, 2022

Changes in this version

+ const JbFields

+ const PatternNamesPreComma

+ const PatternPairsPreComma

+ const PatternValsPreComma

type FieldsList

+ func MakeFieldsList(o any) (fields *FieldsList, err error)

+ func (fields *FieldsList) All() []string

+ func (fields *FieldsList) AllStr() string

+ func (fields *FieldsList) JbFull() misc.StringMap

+ func (fields *FieldsList) JbPrepareBuild(vars misc.InterfaceMap) (jb JbBuildFormats, names []string, vals []any)

+ func (fields *FieldsList) JbSelectStr() string

+ func (fields *FieldsList) JbShort() misc.StringMap

+ func (fields *FieldsList) Regular() []string

+ func (fields *FieldsList) RegularStr() string

+ type JbBuildFormat struct

+ Format string

+ Idx int

+ type JbBuildFormats []*JbBuildFormat

v0.1.2

Nov 23, 2022

v0.1.1

Nov 23, 2022

v0.1.0

Nov 20, 2022

Changes in this version

+ const PatternNames

+ const PatternPairs

+ const PatternVals

+ var Log = log.NewFacility("db")

+ func Exec(dbName string, idx int, queryName string, vars []any) (result sql.Result, err error)

+ func ExecEx(dbName string, idx int, queryName string, tp PatternType, startIdx int, ...) (result sql.Result, err error)

+ func FieldsList(o any) (list []string, err error)

+ func GetConn(dbName string, idx int) (conn *sqlx.DB, err error)

+ func GetQuery(dbName string, queryName string) (q string, err error)

+ func Query(dbName string, idx int, dest any, queryName string, fields []string, ...) (err error)

+ func SetStatPeriod(newPeriod time.Duration) (oldPeriod time.Duration)

+ type Config map[string]*DB

+ func (c Config) ConnectAll() (err error)

+ func (x *Config) Check(cfg any) (err error)

+ type DB struct

+ Active bool

+ DSN []string

+ Driver string

+ Name string

+ Queries misc.StringMap

+ func GetDB(dbName string) (db *DB, err error)

+ func (db *DB) Connect(idx int) (conn *sqlx.DB, doRetry bool, err error)

+ func (db *DB) Exec(idx int, queryName string, vars []any) (result sql.Result, err error)

+ func (db *DB) ExecEx(idx int, queryName string, tp PatternType, startIdx int, fields []string, ...) (result sql.Result, err error)

+ func (db *DB) GetQuery(queryName string) (q string, err error)

+ func (db *DB) Query(idx int, dest any, queryName string, fields []string, vars []any) (err error)

+ func (x *DB) Check(cfg any) (err error)

+ type Duration config.Duration

+ func (v *Duration) Scan(value any) error

+ func (v *Duration) UnmarshalJSON(s []byte) error

+ func (v Duration) MarshalJSON() ([]byte, error)

+ func (v Duration) Value() (driver.Value, error)

+ type NullBool sql.NullBool

+ func (v *NullBool) Scan(value any) error

+ func (v *NullBool) UnmarshalJSON(s []byte) error

+ func (v NullBool) MarshalJSON() ([]byte, error)

+ func (v NullBool) Value() (driver.Value, error)

+ type NullFloat64 sql.NullFloat64

+ func (v *NullFloat64) Scan(value any) error

+ func (v *NullFloat64) UnmarshalJSON(s []byte) error

+ func (v NullFloat64) MarshalJSON() ([]byte, error)

+ func (v NullFloat64) Value() (driver.Value, error)

+ type NullInt64 sql.NullInt64

+ func (v *NullInt64) Scan(value any) error

+ func (v *NullInt64) UnmarshalJSON(s []byte) error

+ func (v NullInt64) MarshalJSON() ([]byte, error)

+ func (v NullInt64) Value() (driver.Value, error)

+ type NullString sql.NullString

+ func (v *NullString) Scan(value any) error

+ func (v *NullString) UnmarshalJSON(s []byte) error

+ func (v NullString) MarshalJSON() ([]byte, error)

+ func (v NullString) Value() (driver.Value, error)

+ type NullTime sql.NullTime

+ func (v *NullTime) Scan(value any) error

+ func (v *NullTime) UnmarshalJSON(s []byte) error

+ func (v NullTime) MarshalJSON() ([]byte, error)

+ func (v NullTime) Value() (driver.Value, error)

+ type NullUint64 struct

+ Uint64 uint64

+ Valid bool

+ func (v *NullUint64) Scan(value any) error

+ func (v *NullUint64) UnmarshalJSON(s []byte) error

+ func (v NullUint64) MarshalJSON() ([]byte, error)

+ func (v NullUint64) Value() (driver.Value, error)

+ type PatternType int

+ const PatternTypeInsert

+ const PatternTypeNone

+ const PatternTypeSelect

+ const PatternTypeUpdate

+ type Stat struct

+ Stat map[string]dbStat

+ func GetStat() *Stat

+ type SubstArg struct

+ Name string

+ Value any

+ func Subst(name string, value any) *SubstArg

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