postgres

type Client struct {
	// contains filtered or unexported fields
}

type Config struct {
	Host            string
	Port            int
	User            string
	Password        string
	DBName          string
	SSLMode         string
	MaxOpenConns    int32
	MaxIdleConns    int32
	ConnMaxLifetime time.Duration
	ConnMaxIdleTime time.Duration
	ConnectTimeout  time.Duration
}

type DBClientInterface interface {
	// Query executes a query that returns rows
	Query(ctx context.Context, query string, args ...interface{}) (pgx.Rows, error)
	// QueryRow executes a query that returns at most one row
	QueryRow(ctx context.Context, query string, args ...interface{}) pgx.Row
	// Exec executes a query without returning any rows
	Exec(ctx context.Context, query string, args ...interface{}) (pgconn.CommandTag, error)
	// Begin starts a new transaction
	Begin(ctx context.Context) (pgx.Tx, error)
	// Builder returns a pre-configured squirrel StatementBuilderType for Postgres ($N placeholders)
	Builder() sq.StatementBuilderType
	// Ping verifies the connection to the database is still alive
	Ping(ctx context.Context) error
	// Close closes the connection pool
	Close()
}