sqlTools

Documentation

Index

• func BindCommonParamsToSelectBuilder(builder squirrel.SelectBuilder, params contexts.CommonParamsForFetch) squirrel.SelectBuilder
• func GetColumnsAndValuesFromStruct(ctx context.Context, st interface{}, callOpts ...CallOptionMapValues) ([]string, []interface{})
• func GetMapValuesFromStruct(ctx context.Context, st interface{}, callOpts ...CallOptionMapValues) map[string]interface{}
• func NewMock() (*sql.DB, sqlmock.Sqlmock)
• func NewPSQLStatementBuilder(db *sqlx.DB) squirrel.StatementBuilderType
• func ParseColumnsForSelect(cols []string) []string
• func ParseColumnsForSelectWithAlias(cols []string, alias string) []string
• type CallOptionMapValues
  • func WithMapValuesAutoDateTimeFields(fields []string) CallOptionMapValues
  • func WithMapValuesIgnoreFields(fields []string) CallOptionMapValues
  • func WithMapValuesSelectFields(fields []string) CallOptionMapValues
• type CommonRepository
• type SqlxTransaction
  • func NewSqlxTransaction(mdbi *datastore.MasterDbInstance) *SqlxTransaction
  • func (s SqlxTransaction) Init() (tx *sqlx.Tx, err error)

Functions

func BindCommonParamsToSelectBuilder

func BindCommonParamsToSelectBuilder(builder squirrel.SelectBuilder, params contexts.CommonParamsForFetch) squirrel.SelectBuilder

func GetColumnsAndValuesFromStruct

func GetColumnsAndValuesFromStruct(ctx context.Context, st interface{}, callOpts ...CallOptionMapValues) ([]string, []interface{})

func GetMapValuesFromStruct

func GetMapValuesFromStruct(ctx context.Context, st interface{}, callOpts ...CallOptionMapValues) map[string]interface{}

GetMapValuesFromStruct For INSERT or UPDATE queries

func NewMock

func NewMock() (*sql.DB, sqlmock.Sqlmock)

func NewPSQLStatementBuilder

func NewPSQLStatementBuilder(db *sqlx.DB) squirrel.StatementBuilderType

func ParseColumnsForSelect

func ParseColumnsForSelect(cols []string) []string

func ParseColumnsForSelectWithAlias

func ParseColumnsForSelectWithAlias(cols []string, alias string) []string

Types

type CallOptionMapValues

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

func WithMapValuesAutoDateTimeFields

func WithMapValuesAutoDateTimeFields(fields []string) CallOptionMapValues

func WithMapValuesIgnoreFields

func WithMapValuesIgnoreFields(fields []string) CallOptionMapValues

func WithMapValuesSelectFields

func WithMapValuesSelectFields(fields []string) CallOptionMapValues

type CommonRepository

type CommonRepository interface {
	Close()
}

type SqlxTransaction

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

func NewSqlxTransaction

func NewSqlxTransaction(mdbi *datastore.MasterDbInstance) *SqlxTransaction

func (SqlxTransaction) Init

func (s SqlxTransaction) Init() (tx *sqlx.Tx, err error)