Knex-CRUD-commands.md

---

Knex CRUD commands

LIST

select * from allergies

knex('allergies')  
 .then(data => {
   console.log("SELECT", data)
})
 .catch(err => {
   console.log("BAD THING...", err)
})

CREATE

knex('allergies')
 .insert([{ allergen: 'grasses', pollen_count: 5},
    {allergen: 'more grasses', pollen_count: 10}])
 .returning('*')
 .then(data => {
    console.log("RETURN FROM INSERT", data)
 })

READ

let userId = '; drop table allergies;' 
let userId = 8;

knex('allergies')
  .select('id', 'allergen')
  .where('id', +(userId))
  .then(data => {
    console.log("SELECT WITH WHERE CLAUSE", data)
  })

UPDATE

knex('allergies')
 .update({ allergen: 'grasses'})
 .where('id', 8)
 .then(data => console.log("RETURN FROM UPDATE", data))

DELETE

knex('allergies')
 .delete()
 .where('id', 7)
 .returning('*')
 .then(data => console.log("RETURN FROM DELETE", data))