postgres

package

v1.2.0 Latest Latest Go to latest Published: Feb 11, 2019 License: Apache-2.0 Imports: 5 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

View Source

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

ErrSQLNotFound happens when no rows were found

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

NewConnPool connects to db and return a connection pool

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

Config is a conf for the postgres database

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

QueryFilter allows for select filters

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

SQLNamedQueryer is used to do select queries

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 struct {
	CertPath     string
	KeyPath      string
	RootCertPath string
}

SSLConf Represent the ssl configuration