/ActionScript/Move records from table to another using knex migration

Move records from table to another using knex migration

// 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: stackoverflow.com

Similar codes

0 vote480 views1 answer
Mass transit logging to seq
ActionScript
0 vote379 views1 answer
Solve parse error for .ashx
ActionScript
0 vote405 views1 answer
Octahedron
ActionScript
-9 votes374 views3 answers
Download debian
ActionScript
0 vote439 views1 answer
ModuleNotFoundError: No module named 'PySimpleGUI'
ActionScript
1 vote468 views2 answers
How to disable foreign key constraint in postgresql
ActionScript
0 vote393 views1 answer
Read pdf web on android
ActionScript
1 vote453 views1 answer
How can I get the status code from an http error in Axios?
ActionScript
0 vote449 views3 answers
How to take value only from the checked checkbox
ActionScript
0 vote381 views1 answer
Vivo y11 not connecting to wifi after update
ActionScript