Function main

scripts/sendWeeklyExcelSheet.mjs:86–121

()

}

async function main() {
  let args = parseArgs({allowPositionals: true});
  let {startDate, endDate} = (() => {
    if (args.positionals.length === 0) {
      return getPreviousWeekRange();
    }
    if (args.positionals.length < 2) {
      console.error('Expected two date arguments: <startDate> <endDate>');
      process.exit(1);
    }
    let start = new Date(args.positionals[0]);
    let end = new Date(args.positionals[1]);
    if (isNaN(start.getTime()) || isNaN(end.getTime())) {
      console.error('Please verify that your dates are correctly formatted (YYYY-MM-DD)');
      process.exit(1);
    }
    return {startDate: args.positionals[0], endDate: args.positionals[1]};
  })();
  console.log(`Generating testing sheet for ${startDate} – ${endDate}...`);

  let {v3PRs, s2PRs, racPRs, otherPRs, offPRs, counts} = await generateData(startDate, endDate);
  console.log(
    `Found: V3=${counts.v3}, S2=${counts.s2}, RAC=${counts.rac}, Other=${counts.other}, Off PRs=${counts.offPRs}`
  );

  let buffer = await createTestingSheet({v3PRs, s2PRs, racPRs, otherPRs, offPRs});

  let startLabel = formatDateLabel(startDate);
  let endLabel = formatDateLabel(endDate);
  let total = counts.v3 + counts.s2 + counts.rac + counts.other;
  let filename = `${endLabel}.xlsx`;
  let message = `*Testing sheet for ${startLabel} – ${endLabel}*\nV3: ${counts.v3} | S2: ${counts.s2} | RAC: ${counts.rac} | Other: ${counts.other} | Off PR: ${counts.offPRs} | Total: ${total}`;

  await uploadToSlack(buffer, filename, message);
  console.log('Posted to Slack successfully.');
}

main().catch(err => {
  console.error(err);