postgres

Documentation

Overview

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

Index

• func Connect(cfg Config) (*sqlx.DB, error)
• func NewGroupMembersRepository(db dbutil.Database) things.GroupMembersRepository
• func NewGroupRepository(db dbutil.Database) things.GroupRepository
• func NewProfileRepository(db dbutil.Database) things.ProfileRepository
• func NewThingRepository(db dbutil.Database) things.ThingRepository
• type Config

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 NewGroupMembersRepository

func NewGroupMembersRepository(db dbutil.Database) things.GroupMembersRepository

NewGroupMembersRepository instantiates a PostgreSQL implementation of members repository.

func NewGroupRepository

func NewGroupRepository(db dbutil.Database) things.GroupRepository

NewGroupRepository instantiates a PostgreSQL implementation of group repository.

func NewProfileRepository

func NewProfileRepository(db dbutil.Database) things.ProfileRepository

NewProfileRepository instantiates a PostgreSQL implementation of profile repository.

func NewThingRepository

func NewThingRepository(db dbutil.Database) things.ThingRepository

NewThingRepository instantiates a PostgreSQL implementation of thing repository.

Types

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