knex migrate:reset for pg

reset.js

'use strict';

var chalk = require('chalk');

/**
 * @todo - Display error message when there are no tables to drop
 * @todo - Get the migrations to display on CLI like when you run
 * 
 *       knex migrate:latest
 * 
 * @param  {[type]} knex    [description]
 * @param  {[type]} Promise [description]
 */
exports.seed = function(knex, Promise) {

	var query  = 'SELECT table_schema,table_name FROM information_schema.tables;';

	return knex
		.raw(query)
		.then(function(resp) {

			return Promise
				.map(resp.rows, function(row){
					if (row.table_schema === 'public') {
						var table = row.table_name
						console.log(chalk.red("Dropping :"), table)
						return knex.schema.dropTable(table).exec();
					}
				})

		})
		.finally(function() {

			console.log(chalk.green("Running all migrations :"))

			return knex.migrate.latest(knex.client.migrationConfig);

		})

};