build: refactor to handle commas in error messages

Planeshifter · Planeshifter · commit b7e463b30dd4 · 2023-08-11T16:54:32.000-04:00
diff --git a/.github/workflows/update_error_databases.yml b/.github/workflows/update_error_databases.yml
@@ -80,39 +80,33 @@ jobs:
       # Generate comment with Markdown table of added error codes:
       - name: 'Generate comment body with Markdown table of added error codes'
         run: |
-          # Get the diff of the CSV file:
-          git_diff=$(git diff lib/node_modules/@stdlib/error/tools/database/data/data.csv)
+          # Save the added lines from the diff to a temporary file: 
+          git diff lib/node_modules/@stdlib/error/tools/database/data/data.csv | grep '^+' | grep -v '^\+\+' | sed 's/^+//' > /tmp/diff.csv
+          
+          # Convert the CSV file to a TSV file (and drop first line and double quotes):
+          awk -F '",' 'NR > 1 && !/^++/ { gsub(/^"|"$/, "", $1); gsub(/^"|"$/, "", $2); gsub(/^"|"$/, "", $3); print $1 "\t" $2 "\t" $3 }' /tmp/diff.csv > /tmp/diff.tsv
 
           # Create the Markdown table header:
           table="| Code | Error Message | Type |\n|--------|---------------|------|\n"
 
           # Extract added lines from the diff and append them to the Markdown table:
-          while IFS= read -r line; do
+          while IFS=$'\t' read -r code error_message type; do
             # Check if the table length exceeds a maximum length:
             if [ ${#table} -gt 65000 ]; then
               table+="| ... | ... | ... |\nThis table has been truncated due to GitHub's comment character limit.\n"
               break
             fi
-
-            # Check if the line starts with '+', indicating it's an added line:
-            if [[ $line == +* ]]; then
-              # Remove the '+' symbol:
-              line="${line#+}"
-              # Check if the line is not part of the CSV header:
-              if [[ $line != \"Code\"* ]]; then
-                # Split the CSV row into fields and format it as a Markdown table row:
-                IFS=',' read -ra fields <<< "$line"
-                table+="| ${fields[0]} | ${fields[1]} | ${fields[2]} |\n"
-              fi
-            fi
-          done <<< "$git_diff"
           
-          # Remove double quotes from the Markdown table:
-          table="${table//\"/}"
+            # Append the TSV row to the Markdown table:
+            table+="| ${code} | ${error_message} | ${type} |\n"
+          done < /tmp/diff.tsv
 
           # Generate a comment body:
           body="This PR\n\n-   updates the error databases\n\nThe following error codes were added:\n\n${table}"
           
+          # Escape '%' characters, which are interpreted as format specifiers by `printf`:
+          body="${body//%/%%}"
+          
           # Write the comment body to a temporary file:
           printf "$body" > /tmp/body.md
         shell: bash
