sql

Documentation

Index

• type DeleteStmt
  • func (stmt *DeleteStmt) From() *DeleteStmt
  • func (stmt *DeleteStmt) Limit(num uint) *DeleteStmt
  • func (stmt *DeleteStmt) OrderBy(fields ...interface{}) *DeleteStmt
  • func (stmt *DeleteStmt) Where(fields ...interface{}) *DeleteStmt
• type SelectStmt
  • func Select(fields ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) Distinct() *SelectStmt
  • func (stmt *SelectStmt) From(values ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) GroupBy(fields ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) Having(fields ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) Limit(num uint) *SelectStmt
  • func (stmt *SelectStmt) Offset(num uint) *SelectStmt
  • func (stmt *SelectStmt) OrderBy(fields ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) Select(fields ...interface{}) *SelectStmt
  • func (stmt *SelectStmt) Where(fields ...interface{}) *SelectStmt
• type UpdateStmt
  • func Update(tables ...interface{}) *UpdateStmt
  • func (stmt *UpdateStmt) Limit(num uint) *UpdateStmt
  • func (stmt *UpdateStmt) OrderBy(fields ...interface{}) *UpdateStmt
  • func (stmt *UpdateStmt) Set(values ...primitive.KV) *UpdateStmt
  • func (stmt *UpdateStmt) Update(fields ...interface{}) *UpdateStmt
  • func (stmt *UpdateStmt) Where(fields ...interface{}) *UpdateStmt

Types

type DeleteStmt

type DeleteStmt struct {
	Tables     []interface{}
	Conditions primitive.Group
	Sorts      []interface{}
	Max        uint
}

DeleteStmt :

func (*DeleteStmt) From

func (stmt *DeleteStmt) From() *DeleteStmt

From :

func (*DeleteStmt) Limit

func (stmt *DeleteStmt) Limit(num uint) *DeleteStmt

Limit :

func (*DeleteStmt) OrderBy

func (stmt *DeleteStmt) OrderBy(fields ...interface{}) *DeleteStmt

OrderBy :

func (*DeleteStmt) Where

func (stmt *DeleteStmt) Where(fields ...interface{}) *DeleteStmt

Where :

type SelectStmt

type SelectStmt struct {
	DistinctOn  bool
	Tables      []interface{}
	Projections []interface{}
	Joins       []interface{}
	IndexHints  string
	Conditions  primitive.Group
	Havings     primitive.Group
	Groups      []interface{}
	Sorts       []interface{}
	Max         uint
	Skip        uint
}

SelectStmt :

func Select

func Select(fields ...interface{}) *SelectStmt

Select :

func (*SelectStmt) Distinct

func (stmt *SelectStmt) Distinct() *SelectStmt

Distinct :

func (*SelectStmt) From

func (stmt *SelectStmt) From(values ...interface{}) *SelectStmt

From :

func (*SelectStmt) GroupBy

func (stmt *SelectStmt) GroupBy(fields ...interface{}) *SelectStmt

GroupBy :

func (*SelectStmt) Having

func (stmt *SelectStmt) Having(fields ...interface{}) *SelectStmt

Having :

func (*SelectStmt) Limit

func (stmt *SelectStmt) Limit(num uint) *SelectStmt

Limit :

func (*SelectStmt) Offset

func (stmt *SelectStmt) Offset(num uint) *SelectStmt

Offset :

func (*SelectStmt) OrderBy

func (stmt *SelectStmt) OrderBy(fields ...interface{}) *SelectStmt

OrderBy :

func (*SelectStmt) Select

func (stmt *SelectStmt) Select(fields ...interface{}) *SelectStmt

Select :

func (*SelectStmt) Where

func (stmt *SelectStmt) Where(fields ...interface{}) *SelectStmt

Where :

type UpdateStmt

type UpdateStmt struct {
	Database   string
	Table      string
	Conditions primitive.Group
	Values     []primitive.KV
	Sorts      []interface{}
	Max        uint
}

UpdateStmt :

func Update

func Update(tables ...interface{}) *UpdateStmt

Update :

func (*UpdateStmt) Limit

func (stmt *UpdateStmt) Limit(num uint) *UpdateStmt

Limit :

func (*UpdateStmt) OrderBy

func (stmt *UpdateStmt) OrderBy(fields ...interface{}) *UpdateStmt

OrderBy :

func (*UpdateStmt) Set

func (stmt *UpdateStmt) Set(values ...primitive.KV) *UpdateStmt

Set :

func (*UpdateStmt) Update

func (stmt *UpdateStmt) Update(fields ...interface{}) *UpdateStmt

Update :

func (*UpdateStmt) Where

func (stmt *UpdateStmt) Where(fields ...interface{}) *UpdateStmt

Where :