Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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.2.1

Jan 8, 2024

v0.1.4

Jan 8, 2024

v0.1.3

Jan 8, 2024

v0.1.2

Jan 8, 2024

v0.1.1

Jan 8, 2024

Changes in this version

+ var ErrAlreadyExists = errors.New("already exists")

+ var ErrInvalidQuery = errors.New("invalid query")

+ var ErrNotFound = errors.New("not found")

+ var ErrWrongInputData = errors.New("wrong input data")

+ func Error(err error) error

+ func Get[T any](ctx context.Context, database *Database, builder squirrel.SelectBuilder) (*T, error)

+ func NewConfig(url string, l *zap.Logger) (*pgxpool.Config, error)

+ func Select[T any](ctx context.Context, database *Database, builder squirrel.SelectBuilder) ([]T, error)

+ type Database struct

+ func NewForURL(url string, l *zap.Logger) (*Database, error)

+ func (r Database) Delete(ctx context.Context, builder squirrel.DeleteBuilder) (rowsAffected int64, err error)

+ func (r Database) ExecuteRaw(ctx context.Context, query string, args ...any) (rowsAffected int64, err error)

+ func (r Database) GetRaw(ctx context.Context, dst any, query string, args ...any) error

+ func (r Database) Insert(ctx context.Context, builder squirrel.InsertBuilder) (rowsAffected int64, err error)

+ func (r Database) QueryBuilder() QueryBuilder

+ func (r Database) SelectRaw(ctx context.Context, dst any, query string, args ...any) error

+ func (r Database) Transaction(ctx context.Context) (pgx.Tx, error)

+ func (r Database) Update(ctx context.Context, builder squirrel.UpdateBuilder) (rowsAffected int64, err error)

+ func (r Database) WithTx(ctx context.Context, ...) error

+ type Logger struct

+ func NewLogger(l *zap.Logger) Logger

+ func (l Logger) Log(_ context.Context, level tracelog.LogLevel, msg string, ...)

+ type QueryBuilder struct

+ func NewQueryBuilder() QueryBuilder

+ type QueryExecutor struct

+ func NewQueryExecutor(executor QueryRunner) *QueryExecutor

+ func (r QueryExecutor) Delete(ctx context.Context, builder squirrel.DeleteBuilder) (int64, error)

+ func (r QueryExecutor) ExecuteRaw(ctx context.Context, query string, args ...any) (rowsAffected int64, err error)

+ func (r QueryExecutor) GetRaw(ctx context.Context, dst any, query string, args ...any) error

+ func (r QueryExecutor) Insert(ctx context.Context, builder squirrel.InsertBuilder) (int64, error)

+ func (r QueryExecutor) SelectRaw(ctx context.Context, dst any, query string, args ...any) error

+ func (r QueryExecutor) Update(ctx context.Context, builder squirrel.UpdateBuilder) (int64, error)

+ type QueryRunner interface

+ Exec func(ctx context.Context, sql string, arguments ...any) (pgconn.CommandTag, error)

+ Query func(ctx context.Context, sql string, args ...any) (pgx.Rows, error)

+ QueryRow func(ctx context.Context, sql string, args ...any) pgx.Row

+ type Table string

+ func (t Table) String() string

+ type TransactionExecutor struct

+ func NewTransactionExecutor(tx pgx.Tx) *TransactionExecutor

+ func (txex *TransactionExecutor) Commit() error

+ func (txex *TransactionExecutor) Rollback() error