postgres

Documentation

Index

• type DB
  • func New(ctx context.Context, config *config.DB) (*DB, error)
  • func (db *DB) Close()
  • func (db *DB) ErrorCode(err error) string
  • func (db *DB) Migrate() error

Types

type DB

type DB struct {
	*pgxpool.Pool
	QueryBuilder *squirrel.StatementBuilderType
	// contains filtered or unexported fields
}

*

• DB is a wrapper for PostgreSQL database connection
• that uses pgxpool as database driver.
• It also holds a reference to squirrel.StatementBuilderType
• which is used to build SQL queries that compatible with PostgreSQL syntax

func New

func New(ctx context.Context, config *config.DB) (*DB, error)

New creates a new PostgreSQL database instance

func (*DB) Close

func (db *DB) Close()

Close closes the database connection

func (*DB) ErrorCode

func (db *DB) ErrorCode(err error) string

ErrorCode returns the error code of the given error

func (*DB) Migrate

func (db *DB) Migrate() error

Migrate runs the database migration