{"size": 405, "ext": "js", "max_stars_repo_path": "lib/Employee.js", "max_stars_repo_name": "0Blockaye0/Employee-Tracker", "max_stars_repo_stars_event_min_datetime": null, "max_stars_repo_stars_event_max_datetime": null, "max_issues_repo_path": "lib/Employee.js", "max_issues_repo_name": "0Blockaye0/Employee-Tracker", "max_issues_repo_issues_event_min_datetime": null, "max_issues_repo_issues_event_max_datetime": null, "max_forks_repo_path": "lib/Employee.js", "max_forks_repo_name": "0Blockaye0/Employee-Tracker", "max_forks_repo_forks_event_min_datetime": null, "max_forks_repo_forks_event_max_datetime": null}
{"max_stars_count": null, "max_issues_count": null, "max_forks_count": null, "avg_line_length": 23.8235294118, "max_line_length": 68, "alphanum_fraction": 0.6222222222}
const db = require("../db/connection");

async function returnEmployeeList() {
  const sql = `SELECT CONCAT(first_name, ' ', last_name) AS name, id
    FROM employee`;

  return db
    .promise()
    .query(sql)
    .then(([rows, fields]) => {
    //   console.log('useerFile/returnEmployeeList:', rows);
      return rows;
    }).catch((e) => console.log(e));
}

module.exports = { returnEmployeeList };
