queryBuilder

package

v1.4.2 Latest Latest Go to latest Published: May 30, 2023 License: Apache-2.0 Imports: 12 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/IBAX-io/go-ibax

Links

Open Source Insights

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

Constants ¶

This section is empty.

Variables ¶

View Source

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

Source Files ¶

View all Source files

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