Your data and processes, turned into secure applications.

export const exportSales = async ({ month }: { month: string }) => {
  const env = ketrics.environment;
  const db = await ketrics.Database.connect(env["ERP_DB_CONNECTION"]);
  try {
    const { rows } = await db.query(
      `SELECT region, SUM(total) AS total FROM sales
        WHERE month = $1 GROUP BY region`,
      [month],
    );

    const excel = ketrics.Excel.create();
    const sheet = excel.addWorksheet("Sales");
    sheet.addRows(rows.map((r) => [r.region, r.total]));

    const volume = await ketrics.Volume.connect(env["EXPORTS_VOLUME"]);
    const key = `${ketrics.application.id}/sales-${month}.xlsx`;
    await volume.put(key, await excel.toBuffer());
    return volume.generateDownloadUrl(key);
  } finally {
    await db.close();
  }
};