migration

Documentation

Overview

Package migration contains all the necessary code for the creation and population of the database.

Index

• Constants
• func ExecuteSQLFile(filename string, args ...string) fn
• func Migrate(db *sql.DB, catalog string) error
• func MigrateToNextVersion(tx *sql.Tx, nextVersion *int64, m Migrations, catalog string) error
• func NewMigrationContext(ctx context.Context) context.Context
• type Migrations
  • func GetMigrations() Migrations

Constants

const AdvisoryLockID = 42

AdvisoryLockID is a random number that should be used within the application by anybody who wants to modify the "version" table.

Functions

func ExecuteSQLFile

func ExecuteSQLFile(filename string, args ...string) fn

ExecuteSQLFile loads the given filename from the packaged SQL files and executes it on the given database. Golang text/template module is used to handle all the optional arguments passed to the sql files

func Migrate

func Migrate(db *sql.DB, catalog string) error

Migrate executes the required migration of the database on startup. For each successful migration, an entry will be written into the "version" table, that states when a certain version was reached.

func MigrateToNextVersion

func MigrateToNextVersion(tx *sql.Tx, nextVersion *int64, m Migrations, catalog string) error

MigrateToNextVersion migrates the database to the nextVersion. If the database is already at nextVersion or higher, the nextVersion will be set to the actual next version.

func NewMigrationContext

func NewMigrationContext(ctx context.Context) context.Context

NewMigrationContext aims to create a new goa context where to initialize the request and req_id context keys. NOTE: We need this function to initialize the goa.ContextRequest

Types

type Migrations

type Migrations []steps

Migrations defines all a collection of all the steps

func GetMigrations

func GetMigrations() Migrations

GetMigrations returns the migrations all the migrations we have. Add your own migration to the end of this function. IMPORTANT: ALWAYS APPEND AT THE END AND DON'T CHANGE THE ORDER OF MIGRATIONS!