Knex: Javascript to SQL query generator

Date: 2018-05-29

Source: https://knexjs.org/

var knex = require('knex')({
  dialect: 'sqlite3',
  connection: {
    filename: './data.db'
  }
});

// Create a table
knex.schema.createTable('users', table => {
  table.increments('id');
  table.string('user_name');
})

// ...and another
.createTable('accounts', table => {
  table.increments('id');
  table.string('account_name');
  table.integer('user_id').unsigned().references('users.id');
})

// Then query the table...
.then(() =>
  return knex.insert({user_name: 'Tim'}).into('users');
})

// ...and using the insert id, insert into the other table.
.then((rows) =>
  return knex.table('accounts').insert({account_name: 'knex', user_id: rows[0]});
})

// Query both of the rows.
.then(() =>
  return knex('users')
    .join('accounts', 'users.id', 'accounts.user_id')
    .select('users.user_name as user', 'accounts.account_name as account');
})

// .map over the results
.map((row) =>
  console.log(row);
})

// Finally, add a .catch handler for the promise chain
.catch((e) =>
  console.error(e);
});

 

11200cookie-checkKnex: Javascript to SQL query generator