Move Records From Table To Another Using Knex Migration

[Solved] Move Records From Table To Another Using Knex Migration | Actionscript - Code Explorer | yomemimo.com
Question : move records from table to another using knex migration

Answered by : emmanuel-mahuni

// modified by Emmanuel Mahuni to use async/await more readable code
exports.up = async function(knex) {	await knex.schema.createTable('table_b', t => { t.string('col_a') t.string('col_b') }) await knex.schema.createTable('table_c', t => { t.string('col_c') t.string('col_d') }) let rows = await knex('table_a').select('col_a', 'col_b') await knex('table_b').insert(rows)	rows = await knex('table_a').select('col_c', 'col_d') await knex('table_c').insert(rows) await knex.schema.dropTableIfExists('table_a'))
};
exports.down = async function(knex) { await knex.schema.createTable('table_a', t => { t.string('col_a') t.string('col_b') t.string('col_c') t.string('col_d') }) let rows = await knex('table_b').select('col_a', 'col_b') await knex('table_a').insert(rows) rows = await knex('table_c').select('col_c', 'col_d') await knex('table_a').insert(rows) await knex.schema.dropTableIfExists('table_b') await knex.schema.dropTableIfExists('table_c')
};

Source : https://stackoverflow.com/questions/45144377/knex-js-migrations-copy-existing-data-to-other-table | Last Update : Fri, 20 Nov 20

Answers related to move records from table to another using knex migration

Code Explorer Popular Question For Actionscript