knex-upsert2 v0.0.6

knex-upsert2

An upsert function for knex. A fork of knex-upsert with support for mysql

Installation

npm install knex-upsert2 --save

Usage

const knex = require('knex')
const upsert = require('knex-upsert2')

const db = knex({
  dialect: 'sqlite3', //or mysql
  connection: { filename: './data.db' }
})
db.schema.createTable('users', table => {
  table.increments('id')
  table.string('user_name')
})

upsert({
  db,
  table: 'users',
  object: { id: 1, user_name: 'happy-user' },
  key: 'id',
}).then(res=>{
//callback
}).catch(err=>{
//error handling
})