Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sql

package

Go to main page

Versions in this module

v1

v1.0.21

Mar 21, 2026

v1.0.20

Mar 14, 2026

Changes in this version

+ func MergeToKeyValue(left []et.Json, key string, value any) []et.Json

+ func MergeToMap(left, right []et.Json) []et.Json

+ func Prefixer(item et.Json, as string) et.Json

+ type Iterator interface

+ Add func(item et.Json)

+ As func() string

+ Data func(int) et.Json

+ Next func() (et.Json, bool)

+ func Joingy(left, right Iterator, keys map[string]string, joinType JoinType) Iterator

+ type Join struct

+ Keys map[string]string

+ To Iterator

+ Type JoinType

+ type JoinType int

+ const FullJoin

+ const InnerJoin

+ const LeftJoin

+ const RightJoin

+ func (j JoinType) String() string

+ type Source struct

+ func (s *Source) Add(item et.Json)

+ func (s *Source) As() string

+ func (s *Source) Data(index int) et.Json

+ func (s *Source) Next() (et.Json, bool)

type Where

+ func (s *Where) FullJoin(to []et.Json, as string, keys map[string]string) *Where

+ func (s *Where) LeftJoin(to []et.Json, as string, keys map[string]string) *Where

+ func (s *Where) RightJoin(to []et.Json, as string, keys map[string]string) *Where

v1.0.19

Feb 27, 2026

v1.0.18

Feb 27, 2026

v1.0.17

Feb 27, 2026

v1.0.16

Feb 27, 2026

Changes in this version

+ var ErrorDataNotFound = errors.New(msg.MSG_DATA_NOT_FOUND)

+ var ErrorFieldNotFound = errors.New(msg.MSG_FIELD_NOT_FOUND)

+ func JoinToKeyValue(left []et.Json, key string, value any) []et.Json

+ func JoinToMap(left, right []et.Json) []et.Json

+ func Validate(item et.Json, conditions []*Condition) bool

+ type BetweenValue struct

+ Max any

+ Min any

+ type Command string

+ const DELETE

+ const FROM

+ const INSERT

+ const UPDATE

+ const UPSERT

+ type Condition struct

+ Connector Connector

+ Field string

+ Operator Operator

+ Value any

+ func Between(field string, min, max any) *Condition

+ func Eq(field string, value interface{}) *Condition

+ func In(field string, value []interface{}) *Condition

+ func Is(field string, value interface{}) *Condition

+ func IsNot(field string, value interface{}) *Condition

+ func Less(field string, value interface{}) *Condition

+ func LessEq(field string, value interface{}) *Condition

+ func Like(field string, value interface{}) *Condition

+ func More(field string, value interface{}) *Condition

+ func MoreEq(field string, value interface{}) *Condition

+ func Neg(field string, value interface{}) *Condition

+ func NotBetween(field string, min, max any) *Condition

+ func NotIn(field string, value []interface{}) *Condition

+ func NotNull(field string) *Condition

+ func Null(field string) *Condition

+ func ToCondition(json et.Json) *Condition

+ func (s *Condition) ApplyToIndex(keys []string) []string

+ func (s *Condition) ApplyToObject(obj et.Json) bool

+ func (s *Condition) ApplyToValue(val any) bool

+ func (s *Condition) ToJson() et.Json

+ type Connector string

+ const And

+ const NaC

+ const Or

+ func (s Connector) Str() string

+ type Model struct

+ Database string

+ Hidden []string

+ Host string

+ IdxField string

+ Name string

+ Schema string

+ func (s *Model) GetIndex(field, key string, dest map[string]bool) (bool, error)

+ func (s *Model) GetObjet(idx string, dest et.Json) (bool, error)

+ func (s *Model) Key() string

+ func (s *Model) Next(fn func(idx string, item et.Json) (bool, error), asc bool, ...) error

+ func (s *Model) OnGetIndex(getIndexFn func(field, key string, dest map[string]bool) (bool, error))

+ func (s *Model) OnGetObject(getObjectFn func(idx string, dest et.Json) (bool, error))

+ func (s *Model) OnNext(...)

+ type NextFn func(fn func(idx string, item et.Json) (bool, error), asc bool, ...) error

+ type Operator string

+ const OpBetween

+ const OpEq

+ const OpIn

+ const OpIs

+ const OpIsNot

+ const OpLess

+ const OpLessEq

+ const OpLike

+ const OpMore

+ const OpMoreEq

+ const OpNeg

+ const OpNotBetween

+ const OpNotIn

+ const OpNotNull

+ const OpNull

+ func ToOperator(s string) Operator

+ func (s Operator) Str() string

+ type Status string

+ const Active

+ const Approved

+ const Archived

+ const Canceled

+ const Connected

+ const Disconnected

+ const Failed

+ const ForDelete

+ const OfSystem

+ const Pending

+ const Processed

+ const Rejected

+ type Transaction struct

+ Command Command

+ Data map[string]et.Json

+ Model *Model

+ Status Status

+ type Tx struct

+ ID string

+ LastUpdateAt time.Time

+ StartedAt time.Time

+ Transactions []*Transaction

+ func GetTx(tx *Tx) (*Tx, bool)

+ func (s *Tx) AddTransaction(from *Model, cmd Command, idx string, data et.Json) error

+ func (s *Tx) GetCache(from *Model) []et.Json

+ func (s *Tx) OnChange(fn func(*Tx) error)

+ func (s *Tx) SetStatus(idx int, status Status) error

+ func (s *Tx) ToJson() (et.Json, error)

+ type Where struct

+ Conditions []*Condition

+ From []et.Json

+ Hiddens []string

+ Joins []string

+ Limits int

+ Offset int

+ OrderBy map[string]bool

+ Result []et.Json

+ Selects []string

+ Workers int

+ func From(itmes []et.Json) *Where

+ func (s *Where) Add(condition *Condition) *Where

+ func (s *Where) AdddResult(item et.Json) (next bool)

+ func (s *Where) And(condition *Condition) *Where

+ func (s *Where) Asc(field string) *Where

+ func (s *Where) Desc(field string) *Where

+ func (s *Where) First(tx *Tx) et.Json

+ func (s *Where) Hidden(fields ...string) *Where

+ func (s *Where) IsDebug() *Where

+ func (s *Where) Join(fields ...string) *Where

+ func (s *Where) Last(tx *Tx) et.Json

+ func (s *Where) Limit(page int, rows int) *Where

+ func (s *Where) One(tx *Tx, idx int) et.Json

+ func (s *Where) Or(condition *Condition) *Where

+ func (s *Where) Order(field string, asc bool) *Where

+ func (s *Where) Run(tx *Tx) []et.Json

+ func (s *Where) Select(fields ...string) *Where

+ func (s *Where) ToJson() (et.Json, error)

+ func (s *Where) Where(condition *Condition) *Where