const db = require('./db')
const pgp = require('pg-promise')()

const userQueries = {
  createUser: (name, email, password) => {
    return db.one(`
      INSERT INTO users (name, email, password)
      VALUES ($1, $2, $3)
      RETURNING id`,
      [name, email, password])
    .then(pgp.end())
    .catch((error) => {
      console.log("\nError in user-queries.js createUser\n")
      throw error
    })
  }
}

module.exports = userQueries

const db = require('./db')
const pgp = require('pg-promise')()

// NOTE: remove pgp.end and .catch once they are handled elsewhere
const userQueries = {
  createUser: (name, email, password) => {
    return db.(`
      INSERT INTO users (name, email, password)
      VALUES ($1, $2, $3)
      RETURNING id`,
      [name, email, password])
    .then(pgp.end())
    .catch((error) => {
      console.log("\nError in user-queries.js createUser\n")
      throw error
    })
  }
}

module.exports = userQueries

Add note for refactoring once other parts are built