api.md

Programmatic API

Alongside with command line, you can use node-pg-migrate also programmatically. It exports runner function, which takes options argument with following structure (similar to command line arguments):

• databaseUrl [string or object] - Connection string or client config which is passed to new pg.Client
• migrationsTable [string] - The table storing which migrations have been run
• migrationsSchema [string] - The schema storing table which migrations have been run (defaults to same value as schema)
• schema [string] - The schema on which migration will be run (defaults to public)
• dir [string] - The directory containing your migration files
• checkOrder [boolean] - Check order of migrations before running them
• direction [enum] - up or down
• count [number] - Number of migration to run
• timestamp [boolean] - Treats count as timestamp
• ignorePattern [string] - Regex pattern for file names to ignore
• file [string] - Run only migration with this name
• singleTransaction [boolean] - Combines all pending migrations into a single transaction so that if any migration fails, all will be rolled back (defaults to true)
• createSchema [boolean] - Creates the configured schema if it doesn't exist
• createMigrationsSchema [boolean] - Creates the configured migration schema if it doesn't exist
• noLock [boolean] - Disables locking mechanism and checks
• dryRun [boolean]
• log [function] - Redirect log messages to this function, rather than console.log