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

database

package

Go to main page

Versions in this module

v0

v0.93.0

Jun 4, 2025

Changes in this version

type GroupQuery

+ func ParseQueriesForTable(r *http.Request, o isObject, whereTable string) (*GroupQuery, error)

v0.92.0

Jan 15, 2025

v0.91.0

Jan 3, 2024

v0.91.0-rc3

May 11, 2023

v0.91.0-rc2

May 11, 2023

v0.91.0-rc1

May 11, 2023

v0.90.80

Mar 18, 2022

v0.90.78

Oct 1, 2021

v0.90.77

Aug 18, 2021

Changes in this version

+ var ByAverage = func(column string, multiplier int) By

+ var ByCount = By("COUNT(id) as amount")

+ func Available(db Database) bool

+ func Close(db Database) error

+ func Maintenance()

+ func Routine()

+ type By string

+ func (b By) String() string

+ type Database interface

+ AddError func(err error) error

+ AddForeignKey func(field string, dest string, onDelete string, onUpdate string) Database

+ AddIndex func(indexName string, column ...string) Database

+ AddUniqueIndex func(indexName string, column ...string) Database

+ Assign func(attrs ...interface{}) Database

+ Association func(column string) *gorm.Association

+ Attrs func(attrs ...interface{}) Database

+ AutoMigrate func(values ...interface{}) Database

+ Begin func() Database

+ Between func(time.Time, time.Time) Database

+ Callback func() *gorm.Callback

+ ChunkSize func() int

+ Close func() error

+ Commit func() Database

+ CommonDB func() gorm.SQLCommon

+ Count func(value interface{}) Database

+ Create func(value interface{}) Database

+ CreateTable func(values ...interface{}) Database

+ DB func() *sql.DB

+ DbType func() string

+ Debug func() Database

+ Delete func(value interface{}, where ...interface{}) Database

+ DropColumn func(column string) Database

+ DropTable func(values ...interface{}) Database

+ DropTableIfExists func(values ...interface{}) Database

+ Error func() error

+ Exec func(sql string, values ...interface{}) Database

+ Find func(out interface{}, where ...interface{}) Database

+ First func(out interface{}, where ...interface{}) Database

+ FirstOrCreate func(out interface{}, where ...interface{}) Database

+ FirstOrInit func(out interface{}, where ...interface{}) Database

+ FormatTime func(t time.Time) string

+ Get func(name string) (value interface{}, ok bool)

+ GetErrors func() (errors []error)

+ GormDB func() *gorm.DB

+ Group func(query string) Database

+ HasTable func(value interface{}) bool

+ Having func(query string, values ...interface{}) Database

+ InstantSet func(name string, value interface{}) Database

+ Joins func(query string, args ...interface{}) Database

+ Last func(out interface{}, where ...interface{}) Database

+ Limit func(value int) Database

+ LogMode func(enable bool) Database

+ Model func(value interface{}) Database

+ ModifyColumn func(column string, typ string) Database

+ MultipleSelects func(args ...string) Database

+ New func() Database

+ NewRecord func(value interface{}) bool

+ NewScope func(value interface{}) *gorm.Scope

+ Not func(query interface{}, args ...interface{}) Database

+ Offset func(value int) Database

+ Omit func(columns ...string) Database

+ Or func(query interface{}, args ...interface{}) Database

+ Order func(value string, reorder ...bool) Database

+ ParseTime func(t string) (time.Time, error)

+ Pluck func(column string, value interface{}) Database

+ Preload func(column string, conditions ...interface{}) Database

+ Raw func(sql string, values ...interface{}) Database

+ RecordNotFound func() bool

+ Related func(value interface{}, foreignKeys ...string) Database

+ RemoveIndex func(indexName string) Database

+ Rollback func() Database

+ Row func() *sql.Row

+ Rows func() (*sql.Rows, error)

+ RowsAffected func() int64

+ Save func(value interface{}) Database

+ Scan func(dest interface{}) Database

+ ScanRows func(rows *sql.Rows, result interface{}) error

+ Scopes func(funcs ...func(*gorm.DB) *gorm.DB) Database

+ Select func(query interface{}, args ...interface{}) Database

+ SelectByTime func(time.Duration) string

+ Set func(name string, value interface{}) Database

+ SetJoinTableHandler func(source interface{}, column string, handler gorm.JoinTableHandlerInterface)

+ SetLogger func(l gorm.Logger)

+ Since func(time.Time) Database

+ SingularTable func(enable bool)

+ Status func() int

+ Table func(name string) Database

+ Unscoped func() Database

+ Update func(attrs ...interface{}) Database

+ UpdateColumn func(attrs ...interface{}) Database

+ UpdateColumns func(values interface{}) Database

+ Updates func(values interface{}, ignoreProtectedAttrs ...bool) Database

+ Where func(query interface{}, args ...interface{}) Database

+ func Begin(db Database, model interface{}) Database

+ func LogMode(db Database, b bool) Database

+ func OpenTester() (Database, error)

+ func Openw(dialect string, args ...interface{}) (db Database, err error)

+ func Wrap(db *gorm.DB) Database

+ type Db struct

+ Database *gorm.DB

+ ReadOnly bool

+ Type string

+ func (it *Db) AddError(err error) error

+ func (it *Db) AddForeignKey(field string, dest string, onDelete string, onUpdate string) Database

+ func (it *Db) AddIndex(indexName string, columns ...string) Database

+ func (it *Db) AddUniqueIndex(indexName string, columns ...string) Database

+ func (it *Db) Assign(attrs ...interface{}) Database

+ func (it *Db) Association(column string) *gorm.Association

+ func (it *Db) Attrs(attrs ...interface{}) Database

+ func (it *Db) AutoMigrate(values ...interface{}) Database

+ func (it *Db) Begin() Database

+ func (it *Db) Between(t1 time.Time, t2 time.Time) Database

+ func (it *Db) Callback() *gorm.Callback

+ func (it *Db) ChunkSize() int

+ func (it *Db) Close() error

+ func (it *Db) Commit() Database

+ func (it *Db) CommonDB() gorm.SQLCommon

+ func (it *Db) Count(value interface{}) Database

+ func (it *Db) Create(value interface{}) Database

+ func (it *Db) CreateTable(values ...interface{}) Database

+ func (it *Db) DB() *sql.DB

+ func (it *Db) DbType() string

+ func (it *Db) Debug() Database

+ func (it *Db) Delete(value interface{}, where ...interface{}) Database

+ func (it *Db) DropColumn(column string) Database

+ func (it *Db) DropTable(values ...interface{}) Database

+ func (it *Db) DropTableIfExists(values ...interface{}) Database

+ func (it *Db) Error() error

+ func (it *Db) Exec(sql string, values ...interface{}) Database

+ func (it *Db) Find(out interface{}, where ...interface{}) Database

+ func (it *Db) First(out interface{}, where ...interface{}) Database

+ func (it *Db) FirstOrCreate(out interface{}, where ...interface{}) Database

+ func (it *Db) FirstOrInit(out interface{}, where ...interface{}) Database

+ func (it *Db) FormatTime(t time.Time) string

+ func (it *Db) Get(name string) (interface{}, bool)

+ func (it *Db) GetErrors() (errors []error)

+ func (it *Db) GormDB() *gorm.DB

+ func (it *Db) Group(query string) Database

+ func (it *Db) HasTable(value interface{}) bool

+ func (it *Db) Having(query string, values ...interface{}) Database

+ func (it *Db) InstantSet(name string, value interface{}) Database

+ func (it *Db) Joins(query string, args ...interface{}) Database

+ func (it *Db) Last(out interface{}, where ...interface{}) Database

+ func (it *Db) Limit(value int) Database

+ func (it *Db) LogMode(enable bool) Database

+ func (it *Db) Loggable() bool

+ func (it *Db) Model(value interface{}) Database

+ func (it *Db) ModifyColumn(column string, typ string) Database

+ func (it *Db) MultipleSelects(args ...string) Database

+ func (it *Db) New() Database

+ func (it *Db) NewRecord(value interface{}) bool

+ func (it *Db) NewScope(value interface{}) *gorm.Scope

+ func (it *Db) Not(query interface{}, args ...interface{}) Database

+ func (it *Db) Offset(value int) Database

+ func (it *Db) Omit(columns ...string) Database

+ func (it *Db) Or(query interface{}, args ...interface{}) Database

+ func (it *Db) Order(value string, reorder ...bool) Database

+ func (it *Db) ParseTime(t string) (time.Time, error)

+ func (it *Db) Pluck(column string, value interface{}) Database

+ func (it *Db) Preload(column string, conditions ...interface{}) Database

+ func (it *Db) Raw(sql string, values ...interface{}) Database

+ func (it *Db) RecordNotFound() bool

+ func (it *Db) Related(value interface{}, foreignKeys ...string) Database

+ func (it *Db) RemoveIndex(indexName string) Database

+ func (it *Db) Rollback() Database

+ func (it *Db) Row() *sql.Row

+ func (it *Db) Rows() (*sql.Rows, error)

+ func (it *Db) RowsAffected() int64

+ func (it *Db) Save(value interface{}) Database

+ func (it *Db) Scan(dest interface{}) Database

+ func (it *Db) ScanRows(rows *sql.Rows, result interface{}) error

+ func (it *Db) Scopes(funcs ...func(*gorm.DB) *gorm.DB) Database

+ func (it *Db) Select(query interface{}, args ...interface{}) Database

+ func (it *Db) SelectByTime(increment time.Duration) string

+ func (it *Db) Set(name string, value interface{}) Database

+ func (it *Db) SetJoinTableHandler(source interface{}, column string, handler gorm.JoinTableHandlerInterface)

+ func (it *Db) SetLogger(log gorm.Logger)

+ func (it *Db) Since(ago time.Time) Database

+ func (it *Db) SingularTable(enable bool)

+ func (it *Db) Status() int

+ func (it *Db) Table(name string) Database

+ func (it *Db) Unscoped() Database

+ func (it *Db) Update(attrs ...interface{}) Database

+ func (it *Db) UpdateColumn(attrs ...interface{}) Database

+ func (it *Db) UpdateColumns(values interface{}) Database

+ func (it *Db) Updates(values interface{}, ignoreProtectedAttrs ...bool) Database

+ func (it *Db) Where(query interface{}, args ...interface{}) Database

+ type DbObject interface

+ Create func() error

+ Delete func() error

+ Update func() error

+ type GroupBy struct

+ type GroupByer interface

+ ToTimeValue func() (*TimeVar, error)

+ type GroupQuery struct

+ End time.Time

+ FillEmpty bool

+ Group time.Duration

+ Limit int

+ Offset int

+ Order string

+ Start time.Time

+ func ParseQueries(r *http.Request, o isObject) (*GroupQuery, error)

+ func ParseRequest(r *http.Request) (*GroupQuery, error)

+ func (b *GroupQuery) GraphData(by By) ([]*TimeValue, error)

+ func (b *GroupQuery) ToTimeValue() (*TimeVar, error)

+ func (b GroupQuery) Database() Database

+ func (b GroupQuery) Find(data interface{}) error

+ type Sampler interface

+ Sample func() DbObject

+ type TimeGroup interface

+ type TimeValue struct

+ Amount int64

+ Timeframe string

+ type TimeVar struct

+ func (t *TimeVar) FillMissing(current, end time.Time) ([]*TimeValue, error)

+ func (t *TimeVar) ToValues() ([]*TimeValue, error)