sqlxb

Oct 27, 2025

Changes in this version

type BuilderX

+ func (x *BuilderX) Limit(limit int) *BuilderX

+ func (x *BuilderX) Offset(offset int) *BuilderX

type Built

+ LimitValue int

+ OffsetValue int

Oct 27, 2025

Changes in this version

+ const QDRANT_BATCH_SEARCH

+ const QDRANT_DISCOVER

+ const QDRANT_RECOMMEND

+ const QDRANT_SCROLL

type Built

+ func (built *Built) ToQdrantDiscoverJSON() (string, error)

+ func (built *Built) ToQdrantRecommendJSON() (string, error)

+ func (built *Built) ToQdrantScrollJSON() (string, error)

+ type DiscoverBuilder struct

+ func (db *DiscoverBuilder) Context(ids ...int64) *DiscoverBuilder

+ func (db *DiscoverBuilder) Limit(limit int) *DiscoverBuilder

type QdrantBuilderX

+ func (qx *QdrantBuilderX) Discover(fn func(db *DiscoverBuilder)) *QdrantBuilderX

+ func (qx *QdrantBuilderX) Recommend(fn func(rb *RecommendBuilder)) *QdrantBuilderX

+ func (qx *QdrantBuilderX) ScrollID(scrollID string) *QdrantBuilderX

+ type QdrantDiscoverRequest struct

+ Context []int64

+ Filter *QdrantFilter

+ Limit int

+ Offset int

+ Params *QdrantSearchParams

+ ScoreThreshold *float32

+ WithPayload interface{}

+ WithVector bool

+ type QdrantRecommendRequest struct

+ Filter *QdrantFilter

+ Limit int

+ Negative []int64

+ Offset int

+ Params *QdrantSearchParams

+ Positive []int64

+ ScoreThreshold *float32

+ Strategy string

+ WithPayload interface{}

+ WithVector bool

+ type QdrantScrollRequest struct

+ Filter *QdrantFilter

+ Limit int

+ ScrollID string

+ WithPayload interface{}

+ WithVector bool

+ type RecommendBuilder struct

+ func (rb *RecommendBuilder) Limit(limit int) *RecommendBuilder

+ func (rb *RecommendBuilder) Negative(ids ...int64) *RecommendBuilder

+ func (rb *RecommendBuilder) Positive(ids ...int64) *RecommendBuilder

Oct 27, 2025

Changes in this version

type BuilderX

+ func (x *BuilderX) Meta() *interceptor.Metadata

type Built

+ Meta *interceptor.Metadata

Oct 26, 2025

Changes in this version

+ const QDRANT_EXACT

+ const QDRANT_HNSW_EF

+ const QDRANT_SCORE_THRESHOLD

+ const QDRANT_WITH_VECTOR

+ const QDRANT_XX

type BuilderX

+ func (x *BuilderX) QdrantX(f func(qx *QdrantBuilderX)) *BuilderX

+ type QdrantBuilderX struct

+ func (qx *QdrantBuilderX) Balanced() *QdrantBuilderX

+ func (qx *QdrantBuilderX) Exact(exact bool) *QdrantBuilderX

+ func (qx *QdrantBuilderX) HighPrecision() *QdrantBuilderX

+ func (qx *QdrantBuilderX) HighSpeed() *QdrantBuilderX

+ func (qx *QdrantBuilderX) HnswEf(ef int) *QdrantBuilderX

+ func (qx *QdrantBuilderX) ScoreThreshold(threshold float32) *QdrantBuilderX

+ func (qx *QdrantBuilderX) WithVector(withVector bool) *QdrantBuilderX

+ func (qx *QdrantBuilderX) X(k string, v interface{}) *QdrantBuilderX

Oct 26, 2025

Changes in this version

+ func QdrantDistanceMetric(metric VectorDistance) string

type BuilderX

+ func (x *BuilderX) WithDiversity(strategy DiversityStrategy, params ...interface{}) *BuilderX

+ func (x *BuilderX) WithHashDiversity(hashField string) *BuilderX

+ func (x *BuilderX) WithMMR(lambda float32) *BuilderX

+ func (x *BuilderX) WithMinDistance(minDistance float32) *BuilderX

type Built

+ func (built *Built) ToQdrantJSON() (string, error)

+ func (built *Built) ToQdrantRequest() (*QdrantSearchRequest, error)

type CondBuilder

+ func (cb *CondBuilder) WithDiversity(strategy DiversityStrategy, params ...interface{}) *CondBuilder

+ func (cb *CondBuilder) WithHashDiversity(hashField string) *CondBuilder

+ func (cb *CondBuilder) WithMMR(lambda float32) *CondBuilder

+ func (cb *CondBuilder) WithMinDistance(minDistance float32) *CondBuilder

+ type DiversityParams struct

+ Enabled bool

+ HashField string

+ Lambda float32

+ MinDistance float32

+ OverFetchFactor int

+ Strategy DiversityStrategy

+ type DiversityStrategy string

+ const DiversityByDistance

+ const DiversityByHash

+ const DiversityByMMR

+ type QdrantCondition struct

+ Key string

+ Match *QdrantMatchCondition

+ Range *QdrantRangeCondition

+ type QdrantFilter struct

+ Must []QdrantCondition

+ MustNot []QdrantCondition

+ Should []QdrantCondition

+ type QdrantMatchCondition struct

+ Any []interface{}

+ Value interface{}

+ type QdrantRangeCondition struct

+ Gt *float64

+ Gte *float64

+ Lt *float64

+ Lte *float64

+ type QdrantSearchParams struct

+ Exact bool

+ HnswEf int

+ IndexedOnly bool

+ type QdrantSearchRequest struct

+ Filter *QdrantFilter

+ Limit int

+ Offset int

+ Params *QdrantSearchParams

+ ScoreThreshold *float32

+ Vector []float32

+ WithPayload interface{}

+ WithVector bool

type VectorSearchParams

+ Diversity *DiversityParams

Oct 26, 2025

Changes in this version

+ const VECTOR_DISTANCE_FILTER

+ const VECTOR_SEARCH

type BuilderX

+ func (x *BuilderX) VectorDistance(metric VectorDistance) *BuilderX

+ func (x *BuilderX) VectorDistanceFilter(field string, queryVector Vector, op string, threshold float32) *BuilderX

+ func (x *BuilderX) VectorSearch(field string, queryVector Vector, topK int) *BuilderX

type Built

+ func (built *Built) SqlOfVectorSearch() (string, []interface{})

type CondBuilder

+ func (cb *CondBuilder) VectorDistance(metric VectorDistance) *CondBuilder

+ func (cb *CondBuilder) VectorDistanceFilter(field string, queryVector Vector, op string, threshold float32) *CondBuilder

+ func (cb *CondBuilder) VectorSearch(field string, queryVector Vector, topK int) *CondBuilder

+ type Vector []float32

+ func (v *Vector) Scan(value interface{}) error

+ func (v Vector) Dim() int

+ func (v Vector) Distance(other Vector, metric VectorDistance) float32

+ func (v Vector) Normalize() Vector

+ func (v Vector) Value() (driver.Value, error)

+ type VectorDistance string

+ const CosineDistance

+ const InnerProduct

+ const L2Distance

+ type VectorDistanceFilterParams struct

+ DistanceMetric VectorDistance

+ Operator string

+ QueryVector Vector

+ Threshold float32

+ type VectorSearchParams struct

+ DistanceMetric VectorDistance

+ QueryVector Vector

+ TopK int

Jul 10, 2024

Changes in this version

type Built

+ Delete bool

+ func (built *Built) SqlOfDelete() (string, []interface{})

Jul 9, 2024

Changes in this version

type BuilderX

+ func (x *BuilderX) Insert(f func(b *InsertBuilder)) *BuilderX

type Built

+ Inserts *[]Bb

+ func (built *Built) SqlOfInsert() (string, []interface{})

+ type InsertBuilder struct

+ func (b *InsertBuilder) Set(k string, v interface{}) *InsertBuilder

Jul 9, 2024

Changes in this version

type Built

+ func (built *Built) SqlOfPage() (string, string, []interface{}, map[string]string)

+ func (built *Built) SqlOfSelect() (string, []interface{}, map[string]string)

Feb 15, 2024

Changes in this version

type BuilderX

+ func (x *BuilderX) Update(f func(ub *UpdateBuilder)) *BuilderX

type Built

+ Updates *[]Bb

+ func (built *Built) SqlOfUpdate() (string, []interface{})

+ type UpdateBuilder struct

+ func (ub *UpdateBuilder) Any(f func(*UpdateBuilder)) *UpdateBuilder

+ func (ub *UpdateBuilder) Bool(preCond BoolFunc, f func(cb *UpdateBuilder)) *UpdateBuilder

+ func (ub *UpdateBuilder) Set(k string, v interface{}) *UpdateBuilder

+ func (ub *UpdateBuilder) X(s string) *UpdateBuilder

Feb 1, 2024

Changes in this version

type Built

+ Last string

Feb 1, 2024

Changes in this version

type BuilderX

+ func (x *BuilderX) Last(last string) *BuilderX

+ type TotalRows struct

+ Count int64

Jan 9, 2024

Changes in this version

type BuilderX

+ func (x *BuilderX) Any(any func(x *BuilderX)) *BuilderX

Jan 1, 2024

Changes in this version

+ const XX

+ type CondBuilderX struct

+ func (x *CondBuilderX) Sub(s string, sub func(sb *BuilderX)) *CondBuilderX

Dec 6, 2023

Changes in this version

+ func LikeLeft() string

type BuilderX

+ func (x *BuilderX) As(alia string) *BuilderX

+ func (x *BuilderX) LikeLeft(k string, v string) *BuilderX

type CondBuilder

+ func (builder *CondBuilder) LikeLeft(k string, v string) *CondBuilder

type FromBuilder

+ func (sb *FromBuilder) As(alia string) *FromBuilder

Nov 7, 2023

Changes in this version

type Built

+ Conds []Bb

+ Fxs []*FromX

+ func (built *Built) SqlOfCond() (string, string, []interface{})

Nov 6, 2023

Changes in this version

type BuilderX

+ func (x *BuilderX) From(orFromSql string) *BuilderX

+ func (x *BuilderX) FromX(fromX func(sb *FromBuilder)) *BuilderX

type Built

+ OrFromSql string

Nov 6, 2023

Changes in this version

type BuilderX

+ func (x *BuilderX) FromScript(sqlScript string) *BuilderX

+ func (x *BuilderX) Select(resultKeys ...string) *BuilderX

+ type FromBuilder struct

+ func (sb *FromBuilder) Alia(alia string) *FromBuilder

+ func (sb *FromBuilder) Cond(on func(on *ON)) *FromBuilder

+ func (sb *FromBuilder) JOIN(join JOIN) *FromBuilder

+ func (sb *FromBuilder) Of(po Po) *FromBuilder

+ func (sb *FromBuilder) On(onStr string) *FromBuilder

+ func (sb *FromBuilder) Sub(sub func(sub *BuilderX)) *FromBuilder

+ func (sb *FromBuilder) Using(key string) *FromBuilder

+ type FromX struct

Nov 5, 2023

Changes in this version

type BuilderX

+ func Of(po Po) *BuilderX

+ func (x *BuilderX) Alia(alia string) *BuilderX

+ func (x *BuilderX) And(sub func(sub *CondBuilder)) *BuilderX

+ func (x *BuilderX) Bool(preCond BoolFunc, then func(cb *CondBuilder)) *BuilderX

+ func (x *BuilderX) Eq(k string, v interface{}) *BuilderX

+ func (x *BuilderX) Gt(k string, v interface{}) *BuilderX

+ func (x *BuilderX) Gte(k string, v interface{}) *BuilderX

+ func (x *BuilderX) In(k string, vs ...interface{}) *BuilderX

+ func (x *BuilderX) IsNull(key string) *BuilderX

+ func (x *BuilderX) Like(k string, v string) *BuilderX

+ func (x *BuilderX) LikeRight(k string, v string) *BuilderX

+ func (x *BuilderX) Lt(k string, v interface{}) *BuilderX

+ func (x *BuilderX) Lte(k string, v interface{}) *BuilderX

+ func (x *BuilderX) Ne(k string, v interface{}) *BuilderX

+ func (x *BuilderX) Nin(k string, vs ...interface{}) *BuilderX

+ func (x *BuilderX) NonNull(key string) *BuilderX

+ func (x *BuilderX) NotLike(k string, v string) *BuilderX

+ func (x *BuilderX) OR() *BuilderX

+ func (x *BuilderX) Of(po Po) *BuilderX

+ func (x *BuilderX) OfX(source func(sb *SourceBuilder)) *BuilderX

+ func (x *BuilderX) Or(sub func(sub *CondBuilder)) *BuilderX

+ func (x *BuilderX) Paged(page func(pb *PageBuilder)) *BuilderX

+ func (x *BuilderX) Sort(orderBy string, direction Direction) *BuilderX

+ func (x *BuilderX) X(k string, vs ...interface{}) *BuilderX

+ type Qr struct

+ Cs []Bb

+ Po Po

+ Rs []Bb

+ Svs []interface{}

type SourceBuilder

+ func (sb *SourceBuilder) Of(po Po) *SourceBuilder

Nov 4, 2023

Changes in this version

+ func ASOF() string

+ func CROSS() string

+ func FULL_OUTER() string

+ func GLOBAL() string

+ func INNER() string

+ func LEFT() string

+ func NON_JOIN() string

+ func RIGHT() string

type SourceBuilder

+ func (sb *SourceBuilder) JOIN(join JOIN) *SourceBuilder

+ func (sb *SourceBuilder) On(onStr string) *SourceBuilder

+ func (sb *SourceBuilder) Using(key string) *SourceBuilder

Nov 4, 2023

Changes in this version

+ const SUB

type BuilderX

+ func (x *BuilderX) Sub(s string, sub func(sub *BuilderX)) *BuilderX

Nov 2, 2023

Changes in this version

type SourceBuilder

+ func (sb *SourceBuilder) Cond(on func(on *On)) *SourceBuilder

+ func (sb *SourceBuilder) ON(onStr string) *SourceBuilder

+ func (sb *SourceBuilder) USING(key string) *SourceBuilder

+ type SourceX struct

Nov 1, 2023

Changes in this version

type BuilderX

+ func (x *BuilderX) SourceScript(sqlScript string) *BuilderX

+ func (x *BuilderX) SourceX(source func(*SourceBuilder)) *BuilderX

type Built

+ OrSourceSql string

+ type CondBuilder struct

+ func SubCond() *CondBuilder

+ func (builder *CondBuilder) And(subCond *CondBuilder) *CondBuilder

+ func (builder *CondBuilder) Bool(preCond BoolFunc, then func(cb *CondBuilder)) *CondBuilder

+ func (builder *CondBuilder) Eq(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) Gt(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) Gte(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) In(k string, vs ...interface{}) *CondBuilder

+ func (builder *CondBuilder) IsNull(key string) *CondBuilder

+ func (builder *CondBuilder) Like(k string, v string) *CondBuilder

+ func (builder *CondBuilder) LikeRight(k string, v string) *CondBuilder

+ func (builder *CondBuilder) Lt(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) Lte(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) Ne(k string, v interface{}) *CondBuilder

+ func (builder *CondBuilder) Nin(k string, vs ...interface{}) *CondBuilder

+ func (builder *CondBuilder) NonNull(key string) *CondBuilder

+ func (builder *CondBuilder) NotLike(k string, v string) *CondBuilder

+ func (builder *CondBuilder) OR() *CondBuilder

+ func (builder *CondBuilder) Or(subCond *CondBuilder) *CondBuilder

+ func (builder *CondBuilder) X(k string, vs ...interface{}) *CondBuilder

type Join

+ func (join *Join) Alia(alia string) *Join

+ func (join *Join) ON(k string) *On

+ func (join *Join) USING(key string)

type PageBuilder

+ func (pb *PageBuilder) SetTotalRowsIgnored(ignored bool) *PageBuilder

type SourceBuilder

+ func Source() *SourceBuilder

+ func (sb *SourceBuilder) Join(join JOIN, po Po) *Join

+ func (sb *SourceBuilder) JoinScript(joinScript string)

Jun 15, 2022

Changes in this version

+ const AGG

type BuilderX

+ func (x *BuilderX) Agg(fn string, vs ...interface{}) *BuilderX

type Built

+ Aggs []Bb

+ type Using struct

+ func USING(key string) *Using

Jun 10, 2022

Changes in this version

+ const AND

+ const AND_SUB

+ const EQ

+ const GT

+ const GTE

+ const IN

+ const IS_NULL

+ const LIKE

+ const LT

+ const LTE

+ const NE

+ const NIN

+ const NON_NULL

+ const NOT_LIKE

+ const OR

+ const OR_SUB

+ const X

+ func ASC() string

+ func Bool(b bool) *bool

+ func Byte(b byte) *byte

+ func DESC() string

+ func Eq() string

+ func Float32(f float32) *float32

+ func Float64(f float64) *float64

+ func Gt() string

+ func Gte() string

+ func INNER_JOIN() string

+ func Int(v int) *int

+ func Int16(v int16) *int16

+ func Int32(v int32) *int32

+ func Int64(v int64) *int64

+ func Int8(v int8) *int8

+ func IsNull() string

+ func LEFT_JOIN() string

+ func Like() string

+ func LikeRight() string

+ func Lt() string

+ func Lte() string

+ func N2s(p interface{}) string

+ func Ne() string

+ func NilOrNumber(p interface{}) (bool, interface{})

+ func NonJoin() string

+ func NonNull() string

+ func NotLike() string

+ func Np2s(p interface{}) (string, bool)

+ func RIGHT_JOIN() string

+ func Uint(v uint) *uint

+ func Uint64(v uint64) *uint64

+ type Bb struct

+ type BoolFunc func() bool

+ type Builder struct

+ func NewBuilder(poOrNil Po) *Builder

+ func (builder *Builder) Build() *Built

+ func (builder *Builder) Paged() *PageBuilder

+ func (builder *Builder) Sort(orderBy string, direction Direction) *Builder

+ type BuilderX struct

+ func NewBuilderX(po Po, alia string) *BuilderX

+ func Sub() *BuilderX

+ func (builder *BuilderX) Build() *Built

+ func (builder *BuilderX) WithoutOptimization() *BuilderX

+ func (x *BuilderX) GroupBy(groupBy string) *BuilderX

+ func (x *BuilderX) Having(op Op, k string, v interface{}) *BuilderX

+ func (x *BuilderX) ResultKey(resultKey string) *BuilderX

+ func (x *BuilderX) ResultKeys(resultKeys ...string) *BuilderX

+ func (x *BuilderX) Source(po Po) *BuilderX

+ func (x *BuilderX) SourceBuilder() *SourceBuilder

+ type Built struct

+ ConditionX *[]*Bb

+ GroupBys *[]string

+ Havings *[]*Bb

+ PageCondition *PageCondition

+ Po Po

+ ResultKeys *[]string

+ Sbs *[]*SourceBuilder

+ Sorts *[]*Sort

+ Svs *[]interface{}

+ func (built *Built) Sql() (*[]interface{}, *string, *string, *map[string]string)

+ func (built *Built) SqlOfCondition() (*[]interface{}, *string)

+ type ConditionBuilder struct

+ func SubCondition() *ConditionBuilder

+ func (builder *ConditionBuilder) And(subCondition *ConditionBuilder) *ConditionBuilder

+ func (builder *ConditionBuilder) Bool(preCondition BoolFunc, then func(cb *ConditionBuilder)) *ConditionBuilder

+ func (builder *ConditionBuilder) Build() *Built

+ func (builder *ConditionBuilder) Eq(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) Gt(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) Gte(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) In(k string, vs ...interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) IsNull(key string) *ConditionBuilder

+ func (builder *ConditionBuilder) Like(k string, v string) *ConditionBuilder

+ func (builder *ConditionBuilder) LikeRight(k string, v string) *ConditionBuilder

+ func (builder *ConditionBuilder) Lt(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) Lte(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) Ne(k string, v interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) Nin(k string, vs ...interface{}) *ConditionBuilder

+ func (builder *ConditionBuilder) NonNull(key string) *ConditionBuilder

+ func (builder *ConditionBuilder) NotLike(k string, v string) *ConditionBuilder

+ func (builder *ConditionBuilder) OR() *ConditionBuilder

+ func (builder *ConditionBuilder) Or(sub *ConditionBuilder) *ConditionBuilder

+ func (builder *ConditionBuilder) X(k string, vs ...interface{}) *ConditionBuilder

+ type Direction func() string

+ type JOIN func() string

+ type Join struct

+ type LongId interface

+ GetId func() uint64

+ type On struct

+ func ON(key string, targetOrAlia string, targetKey string) *On

+ type Op func() string

+ type PageBuilder struct

+ func (pb *PageBuilder) IgnoreTotalRows(ignored bool) *PageBuilder

+ func (pb *PageBuilder) Last(last uint64) *PageBuilder

+ func (pb *PageBuilder) Page(page uint) *PageBuilder

+ func (pb *PageBuilder) Paged() *PageBuilder

+ func (pb *PageBuilder) Rows(rows uint) *PageBuilder

+ type PageCondition struct

+ type Po interface

+ TableName func() string

+ type Sort struct

+ type SourceBuilder struct

+ func (sb *SourceBuilder) Alia(alia string) *SourceBuilder

+ func (sb *SourceBuilder) JoinOn(join JOIN, on *On) *SourceBuilder

+ func (sb *SourceBuilder) JoinUsing(join JOIN, key string) *SourceBuilder

+ func (sb *SourceBuilder) More(cb *ConditionBuilder)

+ func (sb *SourceBuilder) Source(po Po) *SourceBuilder

+ func (sb *SourceBuilder) Sub(sub *BuilderX) *SourceBuilder

+ type StringId interface

+ GetId func() string