query

package
v0.18.0 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: May 30, 2024 License: Apache-2.0 Imports: 8 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	AllColumns = "*"
)

Variables

This section is empty.

Functions

func And 

func And(cn ...nsql.WhereWriter) *whereLogicWriter

func Between 

func Between(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func BindVar 

func BindVar() option.SetOptionFn

func Column 

func Column(col string, args ...interface{}) *columnWriter

func Columns 

func Columns(column1, column2 string, args ...interface{}) *columnSchemaWriter

func Count 

func Count(column string, args ...interface{}) *selectCountWriter

func Equal 

func Equal(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func EqualFilter added in v0.7.0 

func EqualFilter(s *schema.Schema, col string) nsql.FilterParser

func FloatGreaterThanEqualFilter added in v0.7.0 

func FloatGreaterThanEqualFilter(s *schema.Schema, col string) nsql.FilterParser

func FloatLessThanEqualFilter added in v0.7.0 

func FloatLessThanEqualFilter(s *schema.Schema, col string) nsql.FilterParser

func GreaterThan 

func GreaterThan(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func GreaterThanEqual 

func GreaterThanEqual(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func In 

func In(col nsql.ColumnWriter, argCount int, args ...interface{}) *whereCompareWriter

func IntGreaterThanEqualFilter added in v0.7.0 

func IntGreaterThanEqualFilter(s *schema.Schema, col string) nsql.FilterParser

func IntLessThanEqualFilter added in v0.7.0 

func IntLessThanEqualFilter(s *schema.Schema, col string) nsql.FilterParser

func IntVar 

func IntVar(i int) option.SetOptionFn

func IsNotNull added in v0.10.0 

func IsNotNull(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func IsNull added in v0.10.0 

func IsNull(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func LessThan 

func LessThan(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func LessThanEqual 

func LessThanEqual(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func Like 

func Like(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func LikeFilter 

func LikeFilter(col string, likeVar op.LikeVariable, args ...interface{}) nsql.FilterParser

func NotBetween 

func NotBetween(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func NotEqual 

func NotEqual(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func NotIn 

func NotIn(col nsql.ColumnWriter, argCount int, args ...interface{}) *whereCompareWriter

func NotLike 

func NotLike(col nsql.ColumnWriter, args ...interface{}) *whereCompareWriter

func On 

func On(col string, args ...interface{}) option.SetOptionFn

func Or 

func Or(cn ...nsql.WhereWriter) *whereLogicWriter

func TimeGreaterThanEqualFilter added in v0.7.0 

func TimeGreaterThanEqualFilter(s *schema.Schema, col string, args ...string) nsql.FilterParser

func TimeLessThanEqualFilter added in v0.7.0 

func TimeLessThanEqualFilter(s *schema.Schema, col string, args ...string) nsql.FilterParser

Types

type DeleteBuilder 

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

func Delete 

func Delete(s *schema.Schema) *DeleteBuilder

func (*DeleteBuilder) Build 

func (b *DeleteBuilder) Build(args ...interface{}) string

func (*DeleteBuilder) Where 

func (b *DeleteBuilder) Where(w nsql.WhereWriter) *DeleteBuilder

type FilterBuilder 

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

func NewFilter 

func NewFilter(qs map[string]string, funcMap map[string]nsql.FilterParser) *FilterBuilder

NewFilter create a FilterBuilder that convert querystring to WHERE conditions

func (*FilterBuilder) Args 

func (b *FilterBuilder) Args() []interface{}

func (*FilterBuilder) Conditions 

func (b *FilterBuilder) Conditions() nsql.WhereWriter

type InsertBuilder 

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

func Insert 

func Insert(s *schema.Schema, column string, columnN ...string) *InsertBuilder

func (*InsertBuilder) Build 

func (b *InsertBuilder) Build() string

type SchemaBuilder 

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

func Schema 

func Schema(s *schema.Schema) *SchemaBuilder

func (*SchemaBuilder) Count 

func (s *SchemaBuilder) Count(where nsql.WhereWriter) string

func (*SchemaBuilder) Delete 

func (s *SchemaBuilder) Delete() string

func (*SchemaBuilder) FindByPK 

func (s *SchemaBuilder) FindByPK() string

func (*SchemaBuilder) Insert 

func (s *SchemaBuilder) Insert() string

func (*SchemaBuilder) IsExists 

func (s *SchemaBuilder) IsExists(where nsql.WhereWriter) string

func (*SchemaBuilder) Schema 

func (s *SchemaBuilder) Schema() *schema.Schema

func (*SchemaBuilder) Update 

func (s *SchemaBuilder) Update() string

type SelectBuilder 

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

func From 

func From(s *schema.Schema, args ...interface{}) *SelectBuilder

func Select 

func Select(column1 nsql.SelectWriter, columnN ...nsql.SelectWriter) *SelectBuilder

func (*SelectBuilder) Build 

func (b *SelectBuilder) Build() string

func (*SelectBuilder) From 

func (b *SelectBuilder) From(s *schema.Schema, args ...interface{}) *SelectBuilder

func (*SelectBuilder) Join 

func (b *SelectBuilder) Join(s *schema.Schema, onCondition nsql.WhereWriter, args ...interface{}) *SelectBuilder

func (*SelectBuilder) Limit 

func (b *SelectBuilder) Limit(n int64) *SelectBuilder

func (*SelectBuilder) OrderBy 

func (b *SelectBuilder) OrderBy(col string, args ...interface{}) *SelectBuilder

func (*SelectBuilder) ResetLimit 

func (b *SelectBuilder) ResetLimit() *SelectBuilder

func (*SelectBuilder) ResetOrderBy 

func (b *SelectBuilder) ResetOrderBy() *SelectBuilder

func (*SelectBuilder) ResetSkip 

func (b *SelectBuilder) ResetSkip() *SelectBuilder

func (*SelectBuilder) Select 

func (b *SelectBuilder) Select(column1 nsql.SelectWriter, columnN ...nsql.SelectWriter) *SelectBuilder

func (*SelectBuilder) Skip 

func (b *SelectBuilder) Skip(n int64) *SelectBuilder

func (*SelectBuilder) Where 

func (b *SelectBuilder) Where(w1 nsql.WhereWriter, wn ...nsql.WhereWriter) *SelectBuilder

type UpdateBuilder 

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

func Update 

func Update(s *schema.Schema, column string, columnN ...string) *UpdateBuilder

func (*UpdateBuilder) Build 

func (b *UpdateBuilder) Build(args ...interface{}) string

func (*UpdateBuilder) Where 

func (b *UpdateBuilder) Where(w nsql.WhereWriter) *UpdateBuilder

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.