statement

Documentation

Index

• Constants
• type ClauseType
• type Statement
  • func NewStatement(table string) *Statement
  • func (own *Statement) Build(types ...ClauseType) (string, []any)
  • func (own *Statement) Reset(table ...string)
  • func (own *Statement) WithClause(typ ClauseType, vars ...any) *Statement
  • func (own *Statement) WithTableName(name string) *Statement

Constants

const (
	ORDER_ASC  string = "ASC"
	ORDER_DESC string = "DESC"
)

Types

type ClauseType

type ClauseType int

ClauseType defines the dataype of SQL clause

const (
	CLAUSE_INSERT ClauseType = iota
	CLAUSE_VALUES
	CLAUSE_SELECT
	CLAUSE_DISTINCT
	CLAUSE_FROM
	CLAUSE_UPDATE
	CLAUSE_DELETE
	CLAUSE_COUNT
	CLAUSE_WHERE
	CLAUSE_GROUPBY
	CLAUSE_HAVING
	CLAUSE_ORDERBY
	CLAUSE_LIMIT
)

type Statement

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

Statement defines the structure of SQL statement.

func NewStatement

func NewStatement(table string) *Statement

func (*Statement) Build

func (own *Statement) Build(types ...ClauseType) (string, []any)

Build generates the final SQL and SQLVars by the orders of SQL clauses.

func (*Statement) Reset

func (own *Statement) Reset(table ...string)

Reset initializes the parameters of the Statement.

func (*Statement) WithClause

func (own *Statement) WithClause(typ ClauseType, vars ...any) *Statement

WithClause adds the type and variables of a specific clause.

func (*Statement) WithTableName

func (own *Statement) WithTableName(name string) *Statement