db

Documentation

Overview

Package db provides generic Postgres plumbing, connection plus migration running, with no app-specific schema. Migrations live in a consumer-owned directory of NN_name.up.sql files applied in numeric order.

Index

• func Init(connStr string) (*sql.DB, error)
• func Migrate(d *sql.DB, dir string) error
• func MigrationFiles(dir string) ([]string, error)

Functions

func Init

func Init(connStr string) (*sql.DB, error)

Init opens and pings a pgx-backed *sql.DB.

func Migrate

func Migrate(d *sql.DB, dir string) error

Migrate applies any not-yet-applied migration files in dir, tracking applied versions in synckit_migrations.

func MigrationFiles

func MigrationFiles(dir string) ([]string, error)

MigrationFiles returns *.up.sql paths in dir ordered by integer filename prefix.