sqlite.js

var fs = require('fs')
var file = 'test.db'
var exists = fs.existsSync(file)

var sqlite3 = require('sqlite3').verbose()
var db = new sqlite3.Database(file)

// ---------------------------------------
// create the table we'll use later
// ---------------------------------------

db.serialize(function () {
    if(!exists) {
      db.run("CREATE TABLE students ( lastname varchar(200), firstname varchar(200), cohort varchar(200), phase int);")
    }
})

// ---------------------------------------
// INSERT
// ---------------------------------------

var faker = require('Faker')

console.log("inserting some data...")

db.serialize(function () {
  db.run("INSERT INTO students VALUES ('Lubaway', 'Topher', 'Fence Lizard', 14);")
})

// Using faker

for (var i = 0; i < 10; i++) {
  var firstName = faker.Name.firstName()
  var lastName = faker.Name.lastName()
  var company = faker.Company.bs()
  var phase = Math.floor(Math.random() * 1000)

  db.run(`INSERT INTO students (firstname, lastname, cohort, phase) VALUES ('${firstName}', '${lastName}', '${company}', ${phase})`)
}

console.log("inserting done!")

// ---------------------------------------
// SELECT
// ---------------------------------------

console.log("selecting some data")

db.all("SELECT * FROM students", (err, rows) =>
    console.log(rows)
    )

console.log("selecting done!")

// ---------------------------------------
// UPDATE
// ---------------------------------------

console.log("Updating some data...")

db.run("UPDATE students SET firstname='Homer', lastname='Simpson' WHERE phase = 14")

console.log("done updating")

db.all("SELECT * FROM students", (err, rows) =>
    console.log(rows)
    )

// ---------------------------------------
// DELETE
// ---------------------------------------

console.log("Delete some data...")
db.run("DELETE FROM students WHERE phase = 14")
console.log("done deleting...")

db.all("SELECT * FROM students", (err, rows) =>
    console.log(rows)
    )