queryBuilder

Documentation

Overview

---------------------------------------------------------------------------------------------

• Copyright (c) IBAX. All rights reserved.
• See LICENSE in the project root for license information. *--------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------

• Copyright (c) IBAX. All rights reserved.
• See LICENSE in the project root for license information. *--------------------------------------------------------------------------------------------

Index

• Variables
• func CheckNow(inputs ...string) error
• func GetColumns(inColumns any) ([]string, error)
• func GetOrder(tblname string, inOrder any, withDefault bool) (string, error)
• func GetTableName(ecosystem int64, tblname string) string
• func GetWhere(inWhere *types.Map) (string, error)
• func PrepareWhere(where string) string
• type KeyTableChecker
• type NextIDGetter
• type SQLQueryBuilder
  • func (b SQLQueryBuilder) GenerateRollBackInfoString(logData map[string]string) (string, error)
  • func (b *SQLQueryBuilder) GetEcosystem() string
  • func (b *SQLQueryBuilder) GetSQLInsertQuery(idGetter NextIDGetter) (string, error)
  • func (b *SQLQueryBuilder) GetSQLSelectFieldsExpr() (string, error)
  • func (b *SQLQueryBuilder) GetSQLUpdateExpr(logData map[string]string) (string, error)
  • func (b *SQLQueryBuilder) GetSQLWhereExpr() (string, error)
  • func (b *SQLQueryBuilder) GetSelectExpr() (string, error)
  • func (b *SQLQueryBuilder) IsEmptyWhere() bool
  • func (b *SQLQueryBuilder) Prepare() error
  • func (b *SQLQueryBuilder) SetTableID(id string)
  • func (b *SQLQueryBuilder) TableID() string

Variables

var (
	ErrNow = errors.New(`it is prohibited to use current_time or current_date or localtime or current_timestamp sql keyword`)
)

Functions

func CheckNow

func CheckNow(inputs ...string) error

CheckNow allows check if the content contains postgres NOW()

func GetColumns

func GetColumns(inColumns any) ([]string, error)

func GetOrder

func GetOrder(tblname string, inOrder any, withDefault bool) (string, error)

func GetTableName

func GetTableName(ecosystem int64, tblname string) string

func GetWhere

func GetWhere(inWhere *types.Map) (string, error)

func PrepareWhere

func PrepareWhere(where string) string

Types

type KeyTableChecker

type KeyTableChecker interface {
	IsKeyTable(string) bool
}

KeyTableChecker checks table

type NextIDGetter

type NextIDGetter interface {
	GetNextID(string) (int64, error)
}

type SQLQueryBuilder

type SQLQueryBuilder struct {
	*log.Entry

	Table string

	Fields      []string
	FieldValues []any

	Where        *types.Map
	KeyTableChkr KeyTableChecker

	TxEcoID int64
	// contains filtered or unexported fields
}

func (SQLQueryBuilder) GenerateRollBackInfoString

func (b SQLQueryBuilder) GenerateRollBackInfoString(logData map[string]string) (string, error)

func (*SQLQueryBuilder) GetEcosystem

func (b *SQLQueryBuilder) GetEcosystem() string

func (*SQLQueryBuilder) GetSQLInsertQuery

func (b *SQLQueryBuilder) GetSQLInsertQuery(idGetter NextIDGetter) (string, error)

func (*SQLQueryBuilder) GetSQLSelectFieldsExpr

func (b *SQLQueryBuilder) GetSQLSelectFieldsExpr() (string, error)

func (*SQLQueryBuilder) GetSQLUpdateExpr

func (b *SQLQueryBuilder) GetSQLUpdateExpr(logData map[string]string) (string, error)

func (*SQLQueryBuilder) GetSQLWhereExpr

func (b *SQLQueryBuilder) GetSQLWhereExpr() (string, error)

func (*SQLQueryBuilder) GetSelectExpr

func (b *SQLQueryBuilder) GetSelectExpr() (string, error)

func (*SQLQueryBuilder) IsEmptyWhere

func (b *SQLQueryBuilder) IsEmptyWhere() bool

func (*SQLQueryBuilder) Prepare

func (b *SQLQueryBuilder) Prepare() error

func (*SQLQueryBuilder) SetTableID

func (b *SQLQueryBuilder) SetTableID(id string)

func (*SQLQueryBuilder) TableID

func (b *SQLQueryBuilder) TableID() string