velocity-util-rds-utils.ts

export const rdsUtils = {
  toJsonObject(value) {
    const results = value.sqlStatementResults;
    const rs = [];
    results.forEach((result) => {
      const { records, columnMetadata } = result;
      const items = [];
      records.forEach((record) => {
        const r = {};
        let index = 0;
        record.forEach((column) => {
          const columnMap = column.toJSON();
          for (const key in columnMap) {
            const v = columnMap[key];
            r[columnMetadata[index].name] = v;
          }
          index++;
        })
        items.push(r);
      });
      rs.push(items);
    });
    console.log('-- toJsonObject', rs);
    return rs;
  },
  toJsonString(value) {
    return JSON.stringify(this.toJsonObject(value));
  }
};