60 lines
1.2 KiB
JavaScript
60 lines
1.2 KiB
JavaScript
|
import { migrate as logger } from "../logger.js";
|
||
|
|
|
||
|
|
const migrateName = "identifier_for_migrate";
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Migrate
|
||
|
|
*
|
||
|
|
* @see http://knexjs.org/#Schema
|
||
|
|
*
|
||
|
|
* @param {Object} knex
|
||
|
|
* @returns {Promise}
|
||
|
|
*/
|
||
|
|
const up = (_knex) => {
|
||
|
|
logger.info(`[${migrateName}] Migrating Up...`);
|
||
|
|
|
||
|
|
// Create Table example:
|
||
|
|
|
||
|
|
/*
|
||
|
|
return knex.schema.createTable('notification', (table) => {
|
||
|
|
table.increments().primary();
|
||
|
|
table.string('name').notNull();
|
||
|
|
table.string('type').notNull();
|
||
|
|
table.integer('created_on').notNull();
|
||
|
|
table.integer('modified_on').notNull();
|
||
|
|
})
|
||
|
|
.then(function () {
|
||
|
|
logger.info('[' + migrateName + '] Notification Table created');
|
||
|
|
});
|
||
|
|
*/
|
||
|
|
|
||
|
|
logger.info(`[${migrateName}] Migrating Up Complete`);
|
||
|
|
|
||
|
|
return Promise.resolve(true);
|
||
|
|
};
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Undo Migrate
|
||
|
|
*
|
||
|
|
* @param {Object} knex
|
||
|
|
* @returns {Promise}
|
||
|
|
*/
|
||
|
|
const down = (_knex) => {
|
||
|
|
logger.info(`[${migrateName}] Migrating Down...`);
|
||
|
|
|
||
|
|
// Drop table example:
|
||
|
|
|
||
|
|
/*
|
||
|
|
return knex.schema.dropTable('notification')
|
||
|
|
.then(() => {
|
||
|
|
logger.info(`[${migrateName}] Notification Table dropped`);
|
||
|
|
});
|
||
|
|
*/
|
||
|
|
|
||
|
|
logger.info(`[${migrateName}] Migrating Down Complete`);
|
||
|
|
|
||
|
|
return Promise.resolve(true);
|
||
|
|
};
|
||
|
|
|
||
|
|
export { up, down };
|