save-sql.js

const save = (surveys = [], user) => {
  const promises = surveys.map(async (survey) => {
    const {user: currentUser} = await this.knex
      .select('user')
      .from('addresses')
      .where({
        user: user.id,
        id: survey.address,
      })
      .first();
    if (currentUser) {
      let situation = survey.situation;
      if (survey.readyToSync) {
        situation = situations.FINISHED_IN_FIELD;
      } else {
        if (survey.situation === situations.ASSIGNED) {
          situation = situations.SYNCHRONIZED;
        }
        if (user.roles[0] === roles.POLLSTER && survey.visits) {
          situation = situations.SURVEYING;
        }
        if (user.roles[0] === roles.TEAM_LEADER && survey.visits) {
          situation = situations.IN_RECOVERY;
        }
        if (survey.closed) {
          situation = situations.CLOSED;
        }
      }
      return [
        this.knex.update({data: survey}).from('surveys').where({id: survey.id}),
        this.knex
          .update({situation})
          .from('addresses')
          .where({id: survey.address}),
      ];
    }
  });
  return Promise.all(promises.flat());
};