postgres

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(ctx context.Context, config *config.DB) (*DB, error)

func (db *DB) Close()

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

func (db *DB) Migrate() error