/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

44 votes189 views2 answers
Btn-info color code
ActionScript
0 vote157 views1 answer
Truncate restart identity - syntax error at or near "identity"
ActionScript
0 vote134 views1 answer
<%@ WebHandler Language="C#" CodeBehind="img.ashx.cs" Class="ReInsuranceSolution.Core.img" %>
ActionScript
3 votes182 views1 answer
TypeError: Cannot read property 'version' of undefined
ActionScript
0 vote146 views1 answer
Rabbitmq docker cant connect localhost
ActionScript
0 vote166 views3 answers
DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead.
ActionScript
0 vote190 views1 answer
How to go to codefile in .ashx
ActionScript
0 vote147 views2 answers
Docker compose enable rabbitmq enable plugins
ActionScript
0 vote191 views1 answer
Microsoft.visualstudio.web.codegeneration.design 3.1.0
ActionScript
4 votes170 views2 answers
Php get session variable from table
ActionScript