Track when the migration is applied

[gauravarora]

Perhaps with a column in sequelize_meta? This is just for informational purposes really.

[jukkah]

Yeah, it is possible with events.

[gauravarora]

I should have been clearer with my question. I would like to know the timestamp when the migration was applied.

[jukkah]

Aha, it is possible if and only if storage supports it. Currently official storages don't save timestamp but you can always write your own storage.

I think someone else would appreciate timestamps too. I add this to v2.0 backlog.

[geosaj]

easy with CustomStorage (and sequelize)

const sequelize = require('sequelize'); //your sequelize instance with models

class CustomStorage {
    logMigration(migrationName) {
        return sequelize.models.Migration.create({name: migrationName, finished_at: new Date()})
    }

    unlogMigration(migrationName) {
        return sequelize.models.Migration.findOne({name: migrationName})
        .then((model) => {
            return model.destroy();
        })
    }

    executed() {
        return sequelize.models.Migration.findAll()
        .then((results) => {
            return results.map((item) => {
                return item.name;
            })
        })
    }
}

let umzug = new Umzug({
    storage: new CustomStorage(),
    //possible other options
});

...and migrations table

const Sequelize = require('sequelize');
let sequelize = new Sequelize(...);
sequelize.define('Migration', {
    id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true},
    name: Sequelize.STRING(255),
    finished_at: Sequelize.DATE
}, {tableName: 'migrations', timestamps: false})

[demeter-macik]

@geosaj great example, thnx.

But it doesn't work for down. You should order it by id:DESC in executed method:

    executed() {
        return sequelize.models.Migration.findAll({ order: [ ['id', 'DESC'] ] })
        .then((results) => {
            return results.map((item) => {
                return item.name;
            })
        })
    }

[wzoom]

Ordering by "id DESC" should not be needed as the down command takes care of that by itself