Categorygithub.com/macinnir/dvccorelibutilsquery

package

1.8.94

Repository: https://github.com/macinnir/dvc.git

Documentation: pkg.go.dev

Query

Performance

# https://graphviz.org/download/#mac
brew install graphviz

go test -bench=. ./core/lib/utils/query/testgen/. -cpuprofile cpu.prof
go tool pprof -svg cpu.prof > cpu.svg

go test -bench=. -trace trace.out ./core/lib/utils/query/testgen/.
go tool trace trace.out

# Data Race: Two goroutines access the same variable concurrently 
# and at least one of the accesses is a write 
# https://golang.org/doc/articles/race_detector
go test -race

# Packages

testassets

No description provided by the author

testgen

No description provided by the author

And is an and statement with optional args that, if provided, are wrapped in parentheses Example: And() will result in the word `AND` being added to the where clause Example: And(EQ(1, 1), And(), And(2, 2)) will result in `AND ( 1 = 1 AND 2 = 2 )`.

Ands

Ands takes a list of args and separes them all by `AND` Example: Ands(query.EQ(1,1), query.EQ(2,2), query.EQ(3,3)) == 1 = 1 AND 2 = 2 AND 3 = 3.

Between

Between is a BETWEEN statement Example: Between("").

BitAnd

BitAnd `t`.`Field` & a = b Example: query.BitAnd("foo", 2, 1) -> `t`.`Foo` & 2 = 1.

Delete

No description provided by the author

EQ is an equals statement between a table column and a value.

EQF

EQF allows for one column to be equal to another Example for a subselect query.Select(&models.UserGroupUser{}).Alias("ugu").FieldRaw("1", "n").Where( query.EQF("UserID", "`u`.`UserID`"), query.And(), query.EQ("UserGroupID", groupID), query.And(), query.EQ("IsDeleted", 0), ),.

EscapeString

No description provided by the author

Exists

Exists is a where clause for the SQL EXISTS statement.

GT is a greater than statement between a table column and a value.

GTOE

GTOE is a greater than or equals statement (>=) between a table column and a value `t`.`Col` >= value.

IN is an IN clause Example: query.IN("col1", "foo", "bar", "baz").

INInt

INInt is a helper function for converting a slice of string arguments into a slice of interface arguments, passed into an IN clause and returned.

INInt64

INInt64 is a helper function for converting a slice of string arguments into a slice of interface arguments, passed into an IN clause and returned.

Insert

No description provided by the author

INString

INString is a helper function for converting a slice of string arguments into a slice of interface arguments, passed into an IN clause and returned.

No description provided by the author

LT is a less than statement between a table column and a value.

LTOE

LTOE is a less than or equals (<=) statement between a table column and a value `t`.`Col` <= value.

Mod

Mod is applies modulo operation on column and value testing if it equals remainder MOD(`t`.`Field`, value) = remainder.

Modf

Modf MOD(value, `t`.`Field`) = remainder Example: query.Mod("foo", 2, 1) -> `t`.`Foo` % 2 = 1.

NE is a not equals statement between a table column and a value.

NewField

NewField creates a new field.

NewRawField

NewRawField creates a new field.

NotExists

Exists is a where clause for the SQL EXISTS statement.

NOTIN

NOTIN is an NOT IN clause Example: query.NOTIN("col1", "foo", "bar", "baz") Example: queyr.NOTIN("col2", 1, 2, 3).

NotLike

No description provided by the author

OrderDirFromString

No description provided by the author

Ors

Ors takes a list of args and separes them all by `OR` Example: Ors(query.EQ(1,1), query.EQ(2,2), query.EQ(3,3)) == 1 = 1 OR 2 = 2 OR 3 = 3.

Paren

No description provided by the author

Parenthesis End.

Parenthesis Start.

Query

No description provided by the author

Raw

No description provided by the author

Rawf

Rawf is a raw SQL statement Example: query.Rawf("`t`.`LastRunDate` + 60000 < %d", seconds)),.

Select

No description provided by the author

Union

No description provided by the author

Update

No description provided by the author

WhereAll

WhereAll adds a WHERE clause of `1=1` used for convenience when conditionally adding WHERE clauses starting with a conjunction (AND/OR,etc) separating them.

# Constants

FieldTypeAvg

No description provided by the author

FieldTypeBasic

No description provided by the author

FieldTypeCount

No description provided by the author

FieldTypeMax

No description provided by the author

FieldTypeMin

No description provided by the author

FieldTypeRaw

No description provided by the author

FieldTypeSum

No description provided by the author

OrderDirASC

No description provided by the author

OrderDirDESC

No description provided by the author

QUERY_ERROR_EMPTY_WHERE_CLAUSE

No description provided by the author

QUERY_ERROR_INVALID_COLUMN

No description provided by the author

QUERY_ERROR_INVALID_VALUE

No description provided by the author

QueryTypeDelete

No description provided by the author

QueryTypeInsert

No description provided by the author

QueryTypeNotSet

No description provided by the author

QueryTypeRaw

No description provided by the author

QueryTypeSelect

No description provided by the author

QueryTypeUpdate

No description provided by the author

WhereTypeAll

WhereTypeAll is a WHERE clause of `1=1` used for convenience when conditionally adding WHERE clauses starting with a conjunction (AND/OR,etc) separating them.

WhereTypeAnd

No description provided by the author

WhereTypeBetween

No description provided by the author

WhereTypeBitAnd

No description provided by the author

WhereTypeEquals

No description provided by the author

WhereTypeEqualsField

No description provided by the author

WhereTypeExists

No description provided by the author

WhereTypeGreaterThan

No description provided by the author

WhereTypeGreaterThanOrEqualTo

No description provided by the author

WhereTypeIN

No description provided by the author

WhereTypeLessThan

No description provided by the author

WhereTypeLessThanOrEqualTo

No description provided by the author

WhereTypeLike

No description provided by the author

WhereTypeMod

No description provided by the author

WhereTypeModF

No description provided by the author

WhereTypeNone

WhereTypeNone indicates that the wherePart is a noop for the query, If, however, it contains any child clauses, they will be parsed as individual wherePart objects.

WhereTypeNotEquals

No description provided by the author

WhereTypeNotExists

No description provided by the author

WhereTypeNotIN

No description provided by the author

WhereTypeNotLike

No description provided by the author

WhereTypeOr

No description provided by the author

WhereTypeParenthesisEnd

No description provided by the author