sql

Documentation

Index

• func Clause(op LogicalOperator, mods ...string) string
• func Column(table, column string) string
• func ConvertQuestionMarks(sql string) string
• func Expr(s string) string
• func GeneratePlaceholders(count int) []string
• func Group(s ...string) string
• func Query(c ...string) string
• func QueryEnd(s string) string
• func Where(s string, op Operator, v ...string) string
• func WhereComposite[T any](op Operator, cols []T, f func(c T) string) string
• func WhereEndsWith(s string, v any) (string, any)
• func WhereIn(s string, v any) (string, any)
• func WhereLike(s string, v any) (string, any)
• func WhereNotIn(s string, v any) (string, any)
• func WhereNotLike(s string, v any) (string, any)
• func WhereStartsWith(s string, v any) (string, any)
• type LogicalOperator
  • func (lo LogicalOperator) String(space bool) string
• type Operator
  • func (o Operator) String() string
• type Order
  • func (o Order) IsValid() bool
  • func (o Order) String() string

Functions

func Clause

func Clause(op LogicalOperator, mods ...string) string

func Column

func Column(table, column string) string

func ConvertQuestionMarks

func ConvertQuestionMarks(sql string) string

func Expr

func Expr(s string) string

func GeneratePlaceholders

func GeneratePlaceholders(count int) []string

func Group

func Group(s ...string) string

func Query

func Query(c ...string) string

func QueryEnd

func QueryEnd(s string) string

func Where

func Where(s string, op Operator, v ...string) string

func WhereComposite

func WhereComposite[T any](op Operator, cols []T, f func(c T) string) string

func WhereEndsWith

func WhereEndsWith(s string, v any) (string, any)

func WhereIn

func WhereIn(s string, v any) (string, any)

func WhereLike

func WhereLike(s string, v any) (string, any)

func WhereNotIn

func WhereNotIn(s string, v any) (string, any)

func WhereNotLike

func WhereNotLike(s string, v any) (string, any)

func WhereStartsWith

func WhereStartsWith(s string, v any) (string, any)

Types

type LogicalOperator

type LogicalOperator string

const (
	AND      LogicalOperator = "AND"
	OR       LogicalOperator = "OR"
	ORDER_BY LogicalOperator = "ORDER BY"
)

func (LogicalOperator) String

func (lo LogicalOperator) String(space bool) string

type Operator

type Operator string

const (
	Equal              Operator = "="
	NotEqual           Operator = "!="
	GreaterThan        Operator = ">"
	GreaterThanOrEqual Operator = ">="
	LessThan           Operator = "<"
	LessThanOrEqual    Operator = "<="
	In                 Operator = "IN"
	NotIn              Operator = "NOT IN"
	Like               Operator = "LIKE"
	ILike              Operator = "ILIKE"
	NotLike            Operator = "NOT LIKE"
	IsNull             Operator = "IS NULL"
	IsNotNull          Operator = "IS NOT NULL"
)

func (Operator) String

func (o Operator) String() string

type Order

type Order string

var (
	ASC  Order = "ASC"
	DESC Order = "DESC"
)

func (Order) IsValid

func (o Order) IsValid() bool

func (Order) String

func (o Order) String() string