queries.js

const database = require("./database-connection");

module.exports = {
  list(table) {
    return database(table).select();
  },
  read(id, table) {
    return database(table)
      .where("id", id)
      .first();
  },
  getTrends(id, table) {
    return database(table)
      .where("WOE_ID", id)
      .returning("*")
      .first();
  },
  createLocations(personalLocations) {
    return database("personalLocations")
      .insert(personalLocations)
      .returning("*")
      .then(record => record[0]);
  },
  updateLocations(id, request) {
    return database("personalLocations")
      .update(request)
      .where("id", id)
      .returning("*")
      .then(record => record);
  },
  deleteLocations(id) {
    return database("personalLocations")
      .delete()
      .where("id", id);
  }
};