pms

README

pms

Postgres Migration System

Documentation

Index

• Constants
• type Direction
• type Migration
  • func (m *Migration) Down() error
  • func (m *Migration) Up() error
  • func (m *Migration) Version(version int) error
• type Migrator
  • func New(db *sqlx.DB, path string) (Migrator, error)

Constants

const (
	TABLE_NAME         = "migrations"
	QUERY_CREATE_TABLE = `CREATE TABLE %s (
		version VARCHAR(255) NOT NULL DEFAULT 0
	);
	INSERT INTO migrations (version) VALUES (0);`
	QUERY_UPDATE_VERSION = "UPDATE %s SET version=%d"
	ERROR_EQUAL_VERSION  = "current version %d equals current"
)

const (
	SELECT_VERSION = "SELECT version FROM migrations"
)

Types

type Direction

type Direction string

const (
	DIRECTION_UP   Direction = "up"
	DIRECTION_DOWN Direction = "down"
)

type Migration

type Migration struct {
	// contains filtered or unexported fields
}

func (*Migration) Down

func (m *Migration) Down() error

func (*Migration) Up

func (m *Migration) Up() error

func (*Migration) Version

func (m *Migration) Version(version int) error

type Migrator

type Migrator interface {
	Up() error
	Down() error
	Version(int) error
}

func New

func New(db *sqlx.DB, path string) (Migrator, error)