db

Documentation

Index

• func Create() *srDb
• type Repo
  • func (slf *Repo[T]) Count(cli *clog.Instance, whereQuery, endQuery string, wherePars ...interface{}) (int, error)
  • func (slf *Repo[T]) Delete(cli *clog.Instance, whereQuery string, wherePars ...interface{}) error
  • func (slf *Repo[T]) Execute(cli *clog.Instance, sqlQuery string, sqlPars ...interface{}) error
  • func (slf *Repo[T]) GenerateParamSigns(columnNames string) (paramSign string)
  • func (slf *Repo[T]) GetData(cli *clog.Instance, whereQuery string, endQuery string, ...) (*T, error)
  • func (slf *Repo[T]) GetDatas(cli *clog.Instance, whereQuery string, endQuery string, ...) ([]T, error)
  • func (slf *Repo[T]) Insert(cli *clog.Instance, sqlPars ...interface{}) error
  • func (slf *Repo[T]) OnUnsafe(unsafe *model.DbUnsafeSelectError)
  • func (slf *Repo[T]) RawCount(cli *clog.Instance, query string, pars ...interface{}) (int, error)
  • func (slf *Repo[T]) Select(cli *clog.Instance, query string, args ...interface{}) ([]T, error)
  • func (slf *Repo[T]) SetColumnNames(names string)
  • func (slf *Repo[T]) SetInsertColumnNames(names string)
  • func (slf *Repo[T]) Update(cli *clog.Instance, keyVals map[string]interface{}, whereQuery string, ...) error
• type View
  • func (slf *View) New(db abs.DbInstance, printUnsafeErr bool) *View
  • func (slf *View) Select(out interface{}, sqlQuery string, sqlPars ...interface{}) error

Functions

func Create

func Create() *srDb

Types

type Repo

type Repo[T any] struct {
	DbInstance        abs.DbInstance
	TableName         string
	ColumnNames       string
	InsertColumnNames string // if empty then use columnNames
	ParamSigns        string
	InsertParamSign   string // if empty then use paramSigns
	PrintUnsafeErr    bool
}

func (*Repo[T]) Count

func (slf *Repo[T]) Count(cli *clog.Instance, whereQuery, endQuery string, wherePars ...interface{}) (int, error)

func (*Repo[T]) Delete

func (slf *Repo[T]) Delete(cli *clog.Instance, whereQuery string, wherePars ...interface{}) error

func (*Repo[T]) Execute

func (slf *Repo[T]) Execute(cli *clog.Instance, sqlQuery string, sqlPars ...interface{}) error

func (*Repo[T]) GenerateParamSigns

func (slf *Repo[T]) GenerateParamSigns(columnNames string) (paramSign string)

func (*Repo[T]) GetData

func (slf *Repo[T]) GetData(cli *clog.Instance, whereQuery string, endQuery string, wherePars ...interface{}) (*T, error)

func (*Repo[T]) GetDatas

func (slf *Repo[T]) GetDatas(cli *clog.Instance, whereQuery string, endQuery string, wherePars ...interface{}) ([]T, error)

func (*Repo[T]) Insert

func (slf *Repo[T]) Insert(cli *clog.Instance, sqlPars ...interface{}) error

func (*Repo[T]) OnUnsafe

func (slf *Repo[T]) OnUnsafe(unsafe *model.DbUnsafeSelectError)

func (*Repo[T]) RawCount

func (slf *Repo[T]) RawCount(cli *clog.Instance, query string, pars ...interface{}) (int, error)

func (*Repo[T]) Select

func (slf *Repo[T]) Select(cli *clog.Instance, query string, args ...interface{}) ([]T, error)

func (*Repo[T]) SetColumnNames

func (slf *Repo[T]) SetColumnNames(names string)

func (*Repo[T]) SetInsertColumnNames

func (slf *Repo[T]) SetInsertColumnNames(names string)

func (*Repo[T]) Update

func (slf *Repo[T]) Update(cli *clog.Instance, keyVals map[string]interface{}, whereQuery string, wherePars ...interface{}) error

type View

type View struct {
	// contains filtered or unexported fields
}

func (*View) New

func (slf *View) New(db abs.DbInstance, printUnsafeErr bool) *View

func (*View) Select

func (slf *View) Select(out interface{}, sqlQuery string, sqlPars ...interface{}) error