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

sqldb

package

Go to main page

Versions in this module

v0

v0.10.0

Mar 29, 2025

v0.1.1

Mar 29, 2025

v0.1.0

Mar 29, 2025

Changes in this version

+ const SQL_PLACEHOLDER

+ var ErrBreak = fmt.Errorf("%woperation break", ErrError)

+ var ErrClosed = fmt.Errorf("%wconnection closed", ErrError)

+ var ErrDBAddr = fmt.Errorf("%winvalid database address", ErrDBConfig)

+ var ErrDBConfig = fmt.Errorf("%winvalid database config", ErrError)

+ var ErrDBEngine = fmt.Errorf("%winvalid database engine", ErrError)

+ var ErrDBHandler = fmt.Errorf("%winvalid database handler", ErrError)

+ var ErrDBName = fmt.Errorf("%winvalid database name", ErrDBConfig)

+ var ErrDBPath = fmt.Errorf("%winvalid database path", ErrDBConfig)

+ var ErrDBSession = fmt.Errorf("%winvalid database session", ErrError)

+ var ErrError = errors.New("")

+ var ErrOpen = fmt.Errorf("%wconnection failed", ErrError)

+ var ErrOperation = fmt.Errorf("%woperation error", ErrError)

+ var ErrTimeout = fmt.Errorf("%woperation timeout", ErrError)

+ func InitializeModels(db *Database, metainfo []ModelMeta) error

+ func NewGuid() string

+ func SqlIdent(s string) bool

+ type BaseModel struct

+ AutoGuid bool

+ DefaultColumns []string

+ DefaultLimit int

+ DefaultOrders []string

+ DefaultTable string

+ func (m *BaseModel) Columns() []string

+ func (m *BaseModel) DataDecode([]Data) error

+ func (m *BaseModel) DataEncode([]Data) error

+ func (m *BaseModel) InitialData(dbs *Session, tablename string) error

+ func (m *BaseModel) IsAutoGuid() bool

+ func (m *BaseModel) Limit() int

+ func (m *BaseModel) Orders() []string

+ func (m *BaseModel) PostSchema(dbs *Session, meta *ModelMeta) error

+ func (m *BaseModel) PreSchema(dbs *Session, meta *ModelMeta) error

+ func (m *BaseModel) TableName() string

+ type ColumnMeta struct

+ Index bool

+ Name string

+ Primary bool

+ Type string

+ Unique bool

+ type ConstraintMeta struct

+ Definition string

+ Name string

+ type Data = map[string]any

+ type Database struct

+ Log *logging.Logger

+ OperationTimeout float64

+ RetryInterval float64

+ func NewDatabase(log *logging.Logger, engine Engine, opts dictx.Dict) *Database

+ func (db *Database) Backend() string

+ func (db *Database) Ping() bool

+ func (db *Database) Query(model Model) *Query

+ func (db *Database) Session() *Session

+ func (db *Database) Shutdown()

+ type Engine interface

+ Backend func() string

+ CanRetryErr func(err error) bool

+ Close func(*sql.DB) error

+ Release func(*sql.DB) error

+ SqlDB func() (*sql.DB, error)

+ SqlGenerator func() SqlGenerator

+ type Model interface

+ Columns func() []string

+ DataDecode func([]Data) error

+ DataEncode func([]Data) error

+ InitialData func(dbs *Session, tablename string) error

+ IsAutoGuid func() bool

+ Limit func() int

+ Orders func() []string

+ PostSchema func(dbs *Session, meta *ModelMeta) error

+ PreSchema func(dbs *Session, meta *ModelMeta) error

+ TableMeta func() *TableMeta

+ TableName func() string

+ type ModelMeta struct

+ Model Model

+ Table string

+ type Query struct

+ func NewQuery(dbs *Session, model Model) *Query

+ func (q *Query) All() ([]Data, error)

+ func (q *Query) Columns(columns ...string) *Query

+ func (q *Query) Count() (int, error)

+ func (q *Query) Delete() (int, error)

+ func (q *Query) DeleteGuid(guid string) error

+ func (q *Query) FilterBy(column string, value any) *Query

+ func (q *Query) Filters(expr string, args ...any) *Query

+ func (q *Query) First() (Data, error)

+ func (q *Query) GetGuid(guid string) (Data, error)

+ func (q *Query) GroupBy(columns ...string) *Query

+ func (q *Query) Having(expr string, args ...any) *Query

+ func (q *Query) Insert(data Data) (string, error)

+ func (q *Query) Limit(limit int) *Query

+ func (q *Query) Offset(offset int) *Query

+ func (q *Query) One() (Data, error)

+ func (q *Query) OrderBy(orders ...string) *Query

+ func (q *Query) Session() *Session

+ func (q *Query) TableName(name string) *Query

+ func (q *Query) Update(data Data) (int, error)

+ func (q *Query) UpdateGuid(guid string, data Data) error

+ type Session struct

+ OperationTimeout float64

+ RetryInterval float64

+ func NewSession(db *Database) *Session

+ func (s *Session) Begin() error

+ func (s *Session) Cancel()

+ func (s *Session) Commit() error

+ func (s *Session) Database() *Database

+ func (s *Session) Exec(stmt string, params ...any) (int, error)

+ func (s *Session) Fetch(stmt string, params ...any) ([]Data, error)

+ func (s *Session) Ping() bool

+ func (s *Session) Query(model Model) *Query

+ func (s *Session) RollBack() error

+ type SqlGenerator interface

+ Count func(attrs *StmtAttrs) (string, []any)

+ Delete func(attrs *StmtAttrs) (string, []any)

+ FormatStmt func(stmt string) string

+ Insert func(attrs *StmtAttrs, data Data) (string, []any)

+ Schema func(tablename string, meta *TableMeta) []string

+ Select func(attrs *StmtAttrs) (string, []any)

+ Update func(attrs *StmtAttrs, data Data) (string, []any)

+ type StdSqlGenerator struct

+ func (*StdSqlGenerator) Count(attrs *StmtAttrs) (string, []any)

+ func (*StdSqlGenerator) Delete(attrs *StmtAttrs) (string, []any)

+ func (*StdSqlGenerator) FormatStmt(stmt string) string

+ func (*StdSqlGenerator) Insert(attrs *StmtAttrs, data Data) (string, []any)

+ func (*StdSqlGenerator) Schema(tablename string, meta *TableMeta) []string

+ func (*StdSqlGenerator) Select(attrs *StmtAttrs) (string, []any)

+ func (*StdSqlGenerator) Update(attrs *StmtAttrs, data Data) (string, []any)

+ type StmtAttrs struct

+ Columns []string

+ Filters string

+ FiltersArgs []any

+ Groupby []string

+ Having string

+ HavingArgs []any

+ Limit int

+ Offset int

+ Orderby []string

+ Tablename string

+ type TableMeta struct

+ Args dictx.Dict

+ AutoGuid bool

+ Columns []ColumnMeta

+ Constraints []ConstraintMeta