postgres

Documentation

Index

• Variables
• func NewConnPool(postgresDBConf Config) (*sqlx.DB, error)
• type Config
• type QueryFilter
• type SQLNamedQueryer
• type SQLPrepareNamed
• type SSLConf

Variables

var ErrSQLNotFound = errors.New("not found")

ErrSQLNotFound happens when no rows were found

Functions

func NewConnPool

func NewConnPool(postgresDBConf Config) (*sqlx.DB, error)

NewConnPool connects to db and return a connection pool

Types

type Config

type Config struct {
	Host     string
	Port     string
	User     string
	Password string
	DbName   string
	SSLConf
}

Config is a conf for the postgres database

type QueryFilter

type QueryFilter struct {
	FilterSQL   string
	NamedParams map[string]interface{}
}

QueryFilter allows for select filters

type SQLNamedQueryer

type SQLNamedQueryer interface {
	NamedQueryContext(ctx context.Context, query string, arg interface{}) (
		*sqlx.Rows, error,
	)
}

SQLNamedQueryer is used to do select queries

type SQLPrepareNamed

type SQLPrepareNamed interface {
	PrepareNamed(query string) (*sqlx.NamedStmt, error)
}

SQLPrepareNamed is THE most useful interface as postgres requires two phase to insert, with a prepare stmt

type SSLConf

type SSLConf struct {
	CertPath     string
	KeyPath      string
	RootCertPath string
}

SSLConf Represent the ssl configuration