Versions in this module Expand all Collapse all v1 v1.0.0 Jul 3, 2026 Changes in this version + var ErrNotFound = fmt.Errorf("database: record not found") + func SetDefault(db *DB) + type Builder struct + func Raw(query string, args ...any) *Builder + func Table(table string) *Builder + func (b *Builder) All(dest any) error + func (b *Builder) Avg(col string) (float64, error) + func (b *Builder) Chunk(size int, fn func(batch []map[string]any) error) error + func (b *Builder) ChunkByID(size int, fn func(batch []map[string]any) error) error + func (b *Builder) Count() (int64, error) + func (b *Builder) Ctx(ctx context.Context) *Builder + func (b *Builder) CursorPaginate(col string, after any, perPage int, dest any) (any, error) + func (b *Builder) Decrement(col string, by int) error + func (b *Builder) Delete() error + func (b *Builder) Exec() error + func (b *Builder) Exists() (bool, error) + func (b *Builder) First(dest any) error + func (b *Builder) FirstOrCreateMap(match Map, extra Map, dest any) error + func (b *Builder) ForceDelete() error + func (b *Builder) GroupBy(cols ...string) *Builder + func (b *Builder) GroupByRaw(expr string) *Builder + func (b *Builder) Having(clause string, args ...any) *Builder + func (b *Builder) Increment(col string, by int) error + func (b *Builder) Insert(dest any) error + func (b *Builder) InsertMany(src any) error + func (b *Builder) InsertMap(data map[string]any) error + func (b *Builder) InsertMaps(rows []map[string]any) error + func (b *Builder) Join(clause string) *Builder + func (b *Builder) LeftJoin(clause string) *Builder + func (b *Builder) Limit(n int) *Builder + func (b *Builder) Max(col string) (float64, error) + func (b *Builder) Min(col string) (float64, error) + func (b *Builder) Offset(n int) *Builder + func (b *Builder) OnlyTrashed() *Builder + func (b *Builder) OrWhere(clause string, args ...any) *Builder + func (b *Builder) OrWhereGroup(fn func(*Builder)) *Builder + func (b *Builder) OrderBy(clause string) *Builder + func (b *Builder) OrderByRaw(clause string) *Builder + func (b *Builder) Paginate(page, perPage int, dest any) (*Page[any], error) + func (b *Builder) Pluck(col string, dest any) error + func (b *Builder) Restore() error + func (b *Builder) Save(dest any) error + func (b *Builder) Scan(dest any) error + func (b *Builder) Select(cols ...string) *Builder + func (b *Builder) SelectRaw(expr string) *Builder + func (b *Builder) SoftDelete() *Builder + func (b *Builder) Sum(col string) (float64, error) + func (b *Builder) ToSQL() (string, []any, error) + func (b *Builder) Update(data Map) error + func (b *Builder) UpdateOrCreateMap(match Map, values Map) error + func (b *Builder) UpsertMap(data map[string]any, conflictCols []string, updateCols []string) error + func (b *Builder) Where(clause string, args ...any) *Builder + func (b *Builder) WhereGroup(fn func(*Builder)) *Builder + func (b *Builder) WhereIn(col string, values ...any) *Builder + func (b *Builder) WhereInSub(col string, sub *Builder) *Builder + func (b *Builder) WhereNotIn(col string, values ...any) *Builder + func (b *Builder) WhereNotNull(col string) *Builder + func (b *Builder) WhereNull(col string) *Builder + func (b *Builder) WhereRaw(clause string, args ...any) *Builder + func (b *Builder) With(relations ...string) *Builder + func (b *Builder) WithTrashed() *Builder + type Config struct + Driver Driver + Host string + MaxIdle int + MaxLifetime time.Duration + MaxOpen int + Name string + Password string + PgxConfig *pgxpool.Config + Port int + SSLMode string + User string + func DefaultConfig() Config + type DB struct + func Default() *DB + func MustOpen(cfg Config) *DB + func Open(cfg Config) (*DB, error) + func (db *DB) Close() error + func (db *DB) Driver() Driver + func (db *DB) Load(dest any, relations ...string) error + func (db *DB) LoadContext(ctx context.Context, dest any, relations ...string) error + func (db *DB) Ping(ctx context.Context) error + func (db *DB) QuoteIdentifier(s string) string + func (db *DB) Raw(sql string, args ...any) *Builder + func (db *DB) SQLDB() *sql.DB + func (db *DB) SetLogLevel(level slog.Level) + func (db *DB) Table(table string) *Builder + func (db *DB) Transaction(fn func(tx *DB) error) error + func (db *DB) TransactionContext(ctx context.Context, fn func(tx *DB) error) error + func (db *DB) WithLogger(l *slog.Logger) *DB + type Driver string + const DriverMySQL + const DriverPostgres + type Grammar interface + Placeholder func(n int) string + QuoteIdent func(s string) string + type Map = map[string]any + type Page struct + CurrentPage int + From int64 + Items []T + LastPage int + PerPage int + To int64 + Total int64
Go to main page