postgres

Documentation

Overview

Package postgres contains repository implementations using PostgreSQL as the underlying database.

Index

• Variables
• func Connect(cfg Config) (*sqlx.DB, error)
• func NewRepository(db *sqlx.DB, log logger.Logger) certs.Repository
• type Cert
• type Config

Variables

var ErrMigrate = errors.New("error executing database migrations")

ErrMigrate indicates error during database migrations.

Functions

func Connect

func Connect(cfg Config) (*sqlx.DB, error)

Connect creates a connection to the PostgreSQL instance and applies any unapplied database migrations. A non-nil error is returned to indicate failure.

func NewRepository

func NewRepository(db *sqlx.DB, log logger.Logger) certs.Repository

NewRepository instantiates a PostgreSQL implementation of certs repository.

Types

type Cert

type Cert struct {
	ThingID string
	Serial  string
	Expire  time.Time
}

type Config

type Config struct {
	Host        string
	Port        string
	User        string
	Pass        string
	Name        string
	SSLMode     string
	SSLCert     string
	SSLKey      string
	SSLRootCert string
}

Config defines the options that are used when connecting to a PostgreSQL instance