Full Stack Web Development with Raspberry Pi 3

Adding a new temperature to the database

In order to insert a value into one of our tables, we need only two pieces of information:

• The value
• The type of reading taken (whether temperature or humidity)

Let's construct a function that takes these two as parameters and performs the insert operation:

    const insertReading = (type, reading) => {
      db.run(`INSERT INTO ${type} VALUES (datetime('now'),         ${reading});`)
    }

The date and time of the reading are handled by SQLite's datetime function.

The query is generated with ES6 template strings.