Skip to content

Instantly share code, notes, and snippets.

@moscas
Created December 8, 2020 13:38
Show Gist options
  • Star 6 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save moscas/10718dd35c94db5d91b5a87d200a18d8 to your computer and use it in GitHub Desktop.
Save moscas/10718dd35c94db5d91b5a87d200a18d8 to your computer and use it in GitHub Desktop.
Data extractor for IntelliJ which counts the sum of numeric values
/*
* Available context bindings:
* COLUMNS List<DataColumn>
* ROWS Iterable<DataRow>
* OUT { append() }
* FORMATTER { format(row, col); formatValue(Object, col); getTypeName(Object, col); isStringLiteral(Object, col); }
* TRANSPOSED Boolean
* plus ALL_COLUMNS, TABLE, DIALECT
*
* where:
* DataRow { rowNumber(); first(); last(); data(): List<Object>; value(column): Object }
* DataColumn { columnNumber(), name() }
*/
def RES = 0G
ROWS.each { row ->
COLUMNS.each { column ->
def value = row.value(column)
if (value instanceof Number) {
RES += value
}
else if (value.toString().isBigDecimal()) {
RES += value.toString().toBigDecimal()
}
}
}
OUT.append(RES.toString())
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment