expr

package

v2.0.0-...-d0150a3 Latest Latest Go to latest Published: Aug 5, 2023 License: MIT Imports: 10 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/si3nloong/sqlike

Documentation ¶

Index ¶

func And(conds ...any) (g primitive.Group)
func Any[T any](values []T) (c primitive.C)
func As(src any, alias string) (as primitive.As)
func Asc[C ColumnConstraints](field C) (s primitive.Sort)
func Average(field any) (a primitive.Aggregate)
func Between(field, from, to any) (c primitive.C)
func Case() *primitive.Case
func CastAs(value any, datatype primitive.DataType) (cast primitive.CastAs)
func Collate(collate string, col any, charset ...string) (o primitive.Encoding)
func Column(name string, alias ...string) (c primitive.Column)
func ColumnValue[C ColumnConstraints](field C, value any) (kv primitive.KV)
func Count(field any) (a primitive.Aggregate)
func Decrement[V constraints.Unsigned](field string, value V) primitive.Math
func Desc[C ColumnConstraints](field C) (s primitive.Sort)
func Equal[C ColumnConstraints](field C, value any) (c primitive.C)
func Exists(subquery any) (grp primitive.Group)
func Field[T any](name string, val []T) (f primitive.Field)
func ForShare[C ColumnConstraints | *primitive.Lock](opts ...C) (l primitive.Lock)
func ForUpdate(opts ...func(l *primitive.Lock)) (l primitive.Lock)
func Func(name string, value any, others ...any) (f primitive.Func)
func GreaterOrEqual(field, value any) (c primitive.C)
func GreaterThan(field, value any) (c primitive.C)
func In[C ColumnConstraints](field C, values any) (c primitive.C)
func Increment[V constraints.Unsigned](field string, value V) primitive.Math
func IsNotNull[C ColumnConstraints](field C) (c primitive.Nil)
func IsNull[C ColumnConstraints](field C) (c primitive.Nil)
func JSONColumn(column string, nested ...string) (c primitive.JSONColumn)
func JSON_CONTAINS(target, candidate any, paths ...string) (f primitive.JSONFunc)
func JSON_EXTRACT(doc any, path string, otherPaths ...string) (f primitive.JSONFunc)
func JSON_INSERT(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)
func JSON_KEYS(doc any, paths ...string) (f primitive.JSONFunc)
func JSON_QUOTE(doc any) (f primitive.JSONFunc)
func JSON_REMOVE(doc any, path string, paths ...string) (f primitive.JSONFunc)
func JSON_REPLACE(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)
func JSON_SET(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)
func JSON_TYPE(val any) (f primitive.JSONFunc)
func JSON_UNQUOTE(doc any) (f primitive.JSONFunc)
func JSON_VALID(val any) (f primitive.JSONFunc)
func LesserOrEqual(field, value any) (c primitive.C)
func LesserThan(field, value any) (c primitive.C)
func Like[F ColumnConstraints, V string | primitive.Raw](field F, value V) (p primitive.L)
func Max(field any) (a primitive.Aggregate)
func MemberOf(val any, arr any) (f primitive.JSONFunc)
func Min(field any) (a primitive.Aggregate)
func Multiply(fields ...any) (grp primitive.Group)
func NoWait() func(l *primitive.Lock)
func NotBetween(field, from, to any) (c primitive.C)
func NotEqual[C ColumnConstraints](field C, value any) (c primitive.C)
func NotExists(subquery any) (grp primitive.Group)
func NotIn[C ColumnConstraints](field C, values any) (c primitive.C)
func NotLike[C ColumnConstraints](field C, value any) (p primitive.L)
func Or(conds ...any) (g primitive.Group)
func Pair(first, second string) (p primitive.Pair)
func Raw(value string) (r primitive.Raw)
func ST_AsText(g any) (f spatial.Func)
func ST_Distance(g1, g2 any, unit ...string) (f spatial.Func)
func ST_Equals(g1, g2 any) (f spatial.Func)
func ST_GeomFromText[S constraints.Unsigned](g any, srid ...S) (f spatial.Func)
func ST_Intersects(g1, g2 any) (f spatial.Func)
func ST_IsValid(g any) (f spatial.Func)
func ST_Within(g1, g2 any) (f spatial.Func)
func SkipLocked() func(l *primitive.Lock)
func Sum[T string | int](field T) (a primitive.Aggregate)
func Union(stmt1 selectStmt, stmt2 selectStmt, others ...selectStmt) (grp primitive.Group)
type ColumnConstraints

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func And ¶

func And(conds ...any) (g primitive.Group)

And :

func Any ¶

func Any[T any](values []T) (c primitive.C)

Any :

func As ¶

func As(src any, alias string) (as primitive.As)

As :

func Asc ¶

func Asc[C ColumnConstraints](field C) (s primitive.Sort)

Asc :

func Average ¶

func Average(field any) (a primitive.Aggregate)

Average :

func Between ¶

func Between(field, from, to any) (c primitive.C)

Between :

func Case ¶

func Case() *primitive.Case

Case :

func CastAs ¶

func CastAs(value any, datatype primitive.DataType) (cast primitive.CastAs)

CastAs :

func Collate ¶

func Collate(collate string, col any, charset ...string) (o primitive.Encoding)

Collate :

func Column ¶

func Column(name string, alias ...string) (c primitive.Column)

Column :

func ColumnValue ¶

func ColumnValue[C ColumnConstraints](field C, value any) (kv primitive.KV)

ColumnValue :

func Count ¶

func Count(field any) (a primitive.Aggregate)

Count :

func Decrement ¶

func Decrement[V constraints.Unsigned](field string, value V) primitive.Math

Decrement :

func Desc ¶

func Desc[C ColumnConstraints](field C) (s primitive.Sort)

Desc :

func Equal ¶

func Equal[C ColumnConstraints](field C, value any) (c primitive.C)

Equal :

func Exists ¶

func Exists(subquery any) (grp primitive.Group)

Exists :

func Field ¶

func Field[T any](name string, val []T) (f primitive.Field)

Field :

func ForShare ¶

func ForShare[C ColumnConstraints | *primitive.Lock](opts ...C) (l primitive.Lock)

ForShare :

func ForUpdate ¶

func ForUpdate(opts ...func(l *primitive.Lock)) (l primitive.Lock)

ForUpdate :

func Func ¶

func Func(name string, value any, others ...any) (f primitive.Func)

Func :

func GreaterOrEqual ¶

func GreaterOrEqual(field, value any) (c primitive.C)

GreaterOrEqual :

func GreaterThan ¶

func GreaterThan(field, value any) (c primitive.C)

GreaterThan :

func In ¶

func In[C ColumnConstraints](field C, values any) (c primitive.C)

In :

func Increment ¶

func Increment[V constraints.Unsigned](field string, value V) primitive.Math

Increment :

func IsNotNull ¶

func IsNotNull[C ColumnConstraints](field C) (c primitive.Nil)

IsNotNull :

func IsNull ¶

func IsNull[C ColumnConstraints](field C) (c primitive.Nil)

IsNull :

func JSONColumn ¶

func JSONColumn(column string, nested ...string) (c primitive.JSONColumn)

JSONColumn :

func JSON_CONTAINS ¶

func JSON_CONTAINS(target, candidate any, paths ...string) (f primitive.JSONFunc)

JSON_CONTAINS :

func JSON_EXTRACT ¶

func JSON_EXTRACT(doc any, path string, otherPaths ...string) (f primitive.JSONFunc)

JSON_EXTRACT :

func JSON_INSERT ¶

func JSON_INSERT(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)

JSON_INSERT :

func JSON_KEYS ¶

func JSON_KEYS(doc any, paths ...string) (f primitive.JSONFunc)

JSON_KEYS :

func JSON_QUOTE ¶

func JSON_QUOTE(doc any) (f primitive.JSONFunc)

JSON_QUOTE : SELECT JSON_QUOTE(`Column` -> '$.type') FROM test;

func JSON_REMOVE ¶

func JSON_REMOVE(doc any, path string, paths ...string) (f primitive.JSONFunc)

JSON_REMOVE :

func JSON_REPLACE ¶

func JSON_REPLACE(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)

JSON_REPLACE :

func JSON_SET ¶

func JSON_SET(doc any, path string, value any, pathValues ...any) (f primitive.JSONFunc)

JSON_SET :

func JSON_TYPE ¶

func JSON_TYPE(val any) (f primitive.JSONFunc)

JSON_TYPE :

func JSON_UNQUOTE ¶

func JSON_UNQUOTE(doc any) (f primitive.JSONFunc)

JSON_UNQUOTE :

func JSON_VALID ¶

func JSON_VALID(val any) (f primitive.JSONFunc)

JSON_VALID :

func LesserOrEqual ¶

func LesserOrEqual(field, value any) (c primitive.C)

LesserOrEqual :

func LesserThan ¶

func LesserThan(field, value any) (c primitive.C)

LesserThan :

func Like ¶

func Like[F ColumnConstraints, V string | primitive.Raw](field F, value V) (p primitive.L)

Like :

func Max ¶

func Max(field any) (a primitive.Aggregate)

Max :

func MemberOf ¶

func MemberOf(val any, arr any) (f primitive.JSONFunc)

MemberOf : mysql 8.0.17

func Min ¶

func Min(field any) (a primitive.Aggregate)

Min :

func Multiply ¶

func Multiply(fields ...any) (grp primitive.Group)

Multiply :

func NoWait ¶

func NoWait() func(l *primitive.Lock)

func NotBetween ¶

func NotBetween(field, from, to any) (c primitive.C)

NotBetween :

func NotEqual ¶

func NotEqual[C ColumnConstraints](field C, value any) (c primitive.C)

NotEqual :

func NotExists ¶

func NotExists(subquery any) (grp primitive.Group)

NotExists :

func NotIn ¶

func NotIn[C ColumnConstraints](field C, values any) (c primitive.C)

NotIn :

func NotLike ¶

func NotLike[C ColumnConstraints](field C, value any) (p primitive.L)

NotLike :

func Or ¶

func Or(conds ...any) (g primitive.Group)

Or :

func Pair ¶

func Pair(first, second string) (p primitive.Pair)

Pair :

func Raw ¶

func Raw(value string) (r primitive.Raw)

Raw :

func ST_AsText ¶

func ST_AsText(g any) (f spatial.Func)

ST_AsText :

func ST_Distance ¶

func ST_Distance(g1, g2 any, unit ...string) (f spatial.Func)

column, value, ST_GeomFromText(column), ST_GeomFromText(value) ST_Distance :

func ST_Equals ¶

func ST_Equals(g1, g2 any) (f spatial.Func)

ST_Equals :

func ST_GeomFromText ¶

func ST_GeomFromText[S constraints.Unsigned](g any, srid ...S) (f spatial.Func)

ST_GeomFromText :

func ST_Intersects ¶

func ST_Intersects(g1, g2 any) (f spatial.Func)

ST_Intersects :

func ST_IsValid ¶

func ST_IsValid(g any) (f spatial.Func)

ST_IsValid :

func ST_Within ¶

func ST_Within(g1, g2 any) (f spatial.Func)

ST_Within :

func SkipLocked ¶

func SkipLocked() func(l *primitive.Lock)

func Sum ¶

func Sum[T string | int](field T) (a primitive.Aggregate)

Sum :

func Union ¶

func Union(stmt1 selectStmt, stmt2 selectStmt, others ...selectStmt) (grp primitive.Group)

Union :

Types ¶

type ColumnConstraints ¶

type ColumnConstraints interface {
	~string | primitive.Column | primitive.Pair | primitive.JSONColumn
}

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL