/usr/bin/db2 parser

parser.js

        if (output.code == null || output.code === 0) {
          let gotHeaders = false;
          let figuredLengths = false;
  
          let data = output.stdout.split(`\n`);
  
          /** @type {{name: string, from: number, length: number}[]} */
          let headers;
  
          let rows = [];
  
          data.forEach((line, index) => {
            if (line.trim().length === 0 || index === data.length - 1) return;
            if (gotHeaders === false) {
              headers = line.split(` `).filter((x) => x.length > 0).map((x) => {
                return {
                  name: x,
                  from: 0,
                  length: 0,
                };
              });
  
              gotHeaders = true;
            } else
            if (figuredLengths === false) {
              let base = 0;
              line.split(` `).forEach((x, i) => {
                headers[i].from = base;
                headers[i].length = x.length;
  
                base += x.length + 1;
              });
  
              figuredLengths = true;
            } else {
              let row = {};
  
              headers.forEach((header) => {
                /** @type {string|number} */
                let value = line.substring(header.from, header.from + header.length).trimEnd();
  
                // is value a number?
                if (value.startsWith(` `)) {
                  const asNumber = Number(value.trim());
                  if (!isNaN(asNumber)) {
                    value = asNumber;
                  }
                }
                
                row[header.name] = value;
              });
  
              rows.push(row);
            }
          });
  
          return rows;
        } else {
          const errorLines = output.stdout.split(`\n`);

          throw new Error(`${errorLines[3]} (${errorLines[1].trim()})`);
        }