const projectsData = require ('./data/projects.js');
const usersData = require ('./data/users');
const timeSheetsData = require ('./data/timesheets');

exports.seed = async function (knex) {
  await Promise.all ([knex ('users').del (), knex ('projects').del ()]);
  await knex ('projects').insert (projectsData);

  // met promises
  await Promise.all (
    usersData.map (user =>
      knex ('users')
        .insert ({email: user.email})
        .returning ('id')
        .then (userId =>
          Promise.all (
            user.projects.map (projectTitle =>
              knex ('projects')
                .where ('titre', projectTitle)
                .first ()
                .then (projectRecord => {
                  return knex ('projects_users').insert ({
                    user_id: userId[0],
                    project_id: projectRecord.id,
                  });
                })
            )
          )
        )
    )
  );

  await Promise.all (
    timeSheetsData.map (async timeSheet => {
      const projectRecord = await knex ('projects')
        .where ('titre', timeSheet.projet)
        .first ();

      const userRecord = await knex ('users')
        .where ('email', timeSheet.collaborateur)
        .first ();

      delete timeSheet.projet;
      delete timeSheet.collaborateur;

      const newTimeSheet = Object.assign (
        {
          project_id: projectRecord.id,
          user_id: userRecord.id,
        },
        timeSheet
      );

      //  console.log (newTimeSheet);
      return knex ('timesheets').insert (newTimeSheet);
    })
  );
};