datagrip php array extractor

PHP-Array.groovy

/*
 * Available context bindings:
 *   COLUMNS     List<DataColumn>
 *   ROWS        Iterable<DataRow>
 *   OUT         { append() }
 *   FORMATTER   { format(row, col); formatValue(Object, col) }
 *   TRANSPOSED  Boolean
 * plus ALL_COLUMNS, TABLE, DIALECT
 *
 * where:
 *   DataRow     { rowNumber(); first(); last(); data(): List<Object>; value(column): Object }
 *   DataColumn  { columnNumber(), name() }
 */

SEPARATOR = ","
QUOTE     = "\'"
NEWLINE   = System.getProperty("line.separator")
count = 0;

def printRow = { values, valueToString ->
  OUT.append("[\n")
  values.eachWithIndex { value, idx ->
    def str = valueToString(value)
    OUT.append("    '").append(value.name()).append("' => ")
    if(str == "NULL" || str.isNumber()) {
        OUT.append(str).append(",")
    } else {
        OUT.append("'").append(str).append("',")
    }
    OUT.append(NEWLINE)
  }
  OUT.append("],\n")
}
ROWS.each { row -> printRow(COLUMNS, { FORMATTER.format(row, it) }) }

I added the str.isNumber() so that numbers do not have apostrophes.
Also a little bit of formatting for readability.