database/commands/MigrateRefreshCommand.js

//--------------------------------------------------------
//-- Node IoC - Database - Command - Migrate Refresh
//--------------------------------------------------------

import Command from '../../console/Command';


/**
 * Command that resets and re-runs all migrations.
 *
 * @memberof database.commands
 * @augments console.Command
 * @hideconstructor
 */
class MigrateRefreshCommand extends Command {

	/**
	 * Class dependencies: <code>['config', 'db', 'terminal.interceptor']</code>.
	 *
	 * @type {Array<string>}
	 */
	static get dependencies() {
		return (super.dependencies || []).concat(['config', 'db', 'terminal.interceptor']);
	}

	/**
	 * @inheritdoc
	 */
	get policies() {
		return ['db'];
	}

	/**
	 * @inheritdoc
	 */
	get name() {
		return `${this.prefix}:migrate:refresh`;
	}

	/**
	 * @inheritdoc
	 */
	get description() {
		return this.t('commands.db-migrate-refresh.description');
	}

	/**
	 * Command prefix.
	 *
	 * @type {string}
	 */
	get prefix() {
		return this.config.get('database.command_namespace');
	}

	/**
	 * @inheritdoc
	 */
	get flags() {
		return [
			['seed', this.t('commands.db-migrate-refresh.flags.seed')]
		];
	}

	/**
	 * @inheritdoc
	 */
	async handle() {
		const connection = await this.db.getConnection();

		this.info(this.t('commands.db-migrate-refresh.messages.rolling-back'));
		const rollback = await this.rollback(connection);

		rollback.output.forEach((string) => {
			this.warning(string);
		});

		if (rollback.migrations.length > 0) {
			rollback.migrations.forEach((migration) => {
				this.success(this.t('commands.db-migrate-refresh.messages.rolled-back', { migration }));
			});
		}

		await this.call(`${this.prefix}:migrate${this.flag('seed') ? ' --seed' : ''}`);
	}

	/**
	 * Rollback all database migrations.
	 *
	 * @param {database.services.Connector} connection - The database connetion to use.
	 * @returns {Promise<{output: *, migrations: *}>} The migrations that ran and the output made by Knex.
	 */
	async rollback(connection) {
		this.terminalInterceptor.startCapture();
		const [, migrations] = await connection.migrate.rollback();
		const output         = this.terminalInterceptor.stopCapture();

		if (migrations.length > 0) {
			const { migrations: nextMigrations, output: nextOutput } = await this.rollback(connection);
			migrations.push(...nextMigrations);
			output.push(...nextOutput);
		}

		return { migrations, output };
	}

}


export default MigrateRefreshCommand;