sqlutil

Documentation

Index

• type And
  • func (a And) SQL() string
• type Column
  • func (c Column) SQL() string
  • func (c Column) String() string
• type Columns
  • func (c Columns) Names() []string
  • func (c Columns) SQLs() []string
  • func (c Columns) Strings() []string
• type Condition
  • func (c *Condition) And(exprs ...string) *Condition
  • func (c *Condition) Append(val string) *Condition
  • func (c *Condition) Close() *Condition
  • func (c *Condition) Eq(column, value string) *Condition
  • func (c *Condition) Ge(column, value string) *Condition
  • func (c *Condition) Gt(column, value string) *Condition
  • func (c *Condition) Le(column, value string) *Condition
  • func (c *Condition) Like(column, value string) *Condition
  • func (c *Condition) Lt(column, value string) *Condition
  • func (c *Condition) Open() *Condition
  • func (c *Condition) Or(exprs ...string) *Condition
  • func (c *Condition) Repeat(delim string, exprs ...string) *Condition
  • func (c *Condition) String() string
• type Conditions
  • func (c Conditions) Strings() []string
• type Index
  • func (i Index) Name() string
  • func (i Index) SQL() string
  • func (i Index) String() string
• type Insert
  • func (i Insert) SQL() string
• type Or
  • func (o Or) SQL() string
• type Select
  • func (s Select) SQL() string
• type Sequeliser
• type Table
  • func (t Table) SQL() string
  • func (t Table) String() string
• type Values
  • func (v Values) Assignment() []string
  • func (v Values) Columns() []string
  • func (v Values) Placeholders() []string
  • func (v Values) Values() []any

Types

type And

type And Conditions

func (And) SQL

func (a And) SQL() string

type Column

type Column struct {
	Name    string
	Type    string
	Options string
}

func (Column) SQL

func (c Column) SQL() string

func (Column) String

func (c Column) String() string

type Columns

type Columns []Column

func (Columns) Names

func (c Columns) Names() []string

func (Columns) SQLs

func (c Columns) SQLs() []string

func (Columns) Strings

func (c Columns) Strings() []string

type Condition

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

func (*Condition) And

func (c *Condition) And(exprs ...string) *Condition

func (*Condition) Append

func (c *Condition) Append(val string) *Condition

func (*Condition) Close

func (c *Condition) Close() *Condition

func (*Condition) Eq

func (c *Condition) Eq(column, value string) *Condition

func (*Condition) Ge

func (c *Condition) Ge(column, value string) *Condition

func (*Condition) Gt

func (c *Condition) Gt(column, value string) *Condition

func (*Condition) Le

func (c *Condition) Le(column, value string) *Condition

func (*Condition) Like

func (c *Condition) Like(column, value string) *Condition

func (*Condition) Lt

func (c *Condition) Lt(column, value string) *Condition

func (*Condition) Open

func (c *Condition) Open() *Condition

func (*Condition) Or

func (c *Condition) Or(exprs ...string) *Condition

func (*Condition) Repeat

func (c *Condition) Repeat(delim string, exprs ...string) *Condition

func (*Condition) String

func (c *Condition) String() string

type Conditions

type Conditions []any

func (Conditions) Strings

func (c Conditions) Strings() []string

type Index

type Index struct {
	Unique  bool
	Table   string
	Columns []string
}

func (Index) Name

func (i Index) Name() string

func (Index) SQL

func (i Index) SQL() string

func (Index) String

func (i Index) String() string

type Insert

type Insert struct {
	Table   string
	Values  Values
	Options string
	Upsert  bool
}

func (Insert) SQL

func (i Insert) SQL() string

type Or

type Or Conditions

func (Or) SQL

func (o Or) SQL() string

type Select

type Select struct {
	Table   string
	Columns []string
	Filter  string
	Limit   int
}

func (Select) SQL

func (s Select) SQL() string

type Sequeliser

type Sequeliser interface{ SQL() string }

type Table

type Table struct {
	Name    string
	Options string
	Columns Columns
}

func (Table) SQL

func (t Table) SQL() string

func (Table) String

func (t Table) String() string

type Values

type Values map[string]any

func (Values) Assignment

func (v Values) Assignment() []string

func (Values) Columns

func (v Values) Columns() []string

func (Values) Placeholders

func (v Values) Placeholders() []string

func (Values) Values

func (v Values) Values() []any