postgres

README

Webhooks - DB Schema

CREATE TABLE IF NOT EXISTS webhooks (
    id          UUID UNIQUE, 
    thing_id    UUID NOT NULL,
    group_id    UUID NOT NULL,
    name        VARCHAR(254) NOT NULL,
    url         VARCHAR(254) NOT NULL,
    headers     JSONB,
    metadata    JSONB,    
    PRIMARY KEY (thing_id, name)
);

Documentation

Index

• func Connect(cfg Config) (*sqlx.DB, error)
• func NewWebhookRepository(db dbutil.Database) webhooks.WebhookRepository
• 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 NewWebhookRepository

func NewWebhookRepository(db dbutil.Database) webhooks.WebhookRepository

NewWebhookRepository instantiates a PostgreSQL implementation of webhook 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