import Db from 'database' // Db.query ? async method

export default {
  async getAvailableUsers () {
    let users = await Db.query('SELECT * FROM users WHERE occupied = FALSE')

    let promises = users.map( user => {
      // return new Promise((resolve, reject)=> {
      //   return this.getUserGroup(user).then(group => {
      //     resolve({...user, group: group})
      //   })
      // })
   })

   return Promise.all(promises)
  },

  async getUserGroup () {
    return await Db.query(`SELECT * FROM groups WHERE userId = ?`, [user.id])
    // return this.formatGroup(group)
  },

  formatGroup (group) {
    return group.name = group.name.replace('"', '\'')
  }
}