Jetbrains Intellij / Datagrip: Data Extractor - allows export of row data into Liquibase compatible insert statements

Liquibase-XML-inserts.xml.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() }
 */


import java.util.regex.Pattern

NEWLINE = System.getProperty("line.separator")

pattern = Pattern.compile("[^\\w\\d]")
def escapeTag(name) {
    name = pattern.matcher(name).replaceAll("_")
    return name.isEmpty() || !Character.isLetter(name.charAt(0)) ? "_$name" : name
}
def printRow = { values, rowTag, namer, valueToString ->
    OUT.append("""$NEWLINE\t<${rowTag} tableName="${TABLE.name}">$NEWLINE""")
    values.eachWithIndex { it, index ->
        def colName = namer(it, index)
        def str = valueToString(it)
        OUT.append("""\t\t<column name="${colName}" value="${str}"/>$NEWLINE""")
    }
    OUT.append("\t</$rowTag>")
}

OUT.append(
        """
<changeSet id="xxx"
               author="xxx">
\t<comment>Extracted changeset</comment>
""")

if (!TRANSPOSED) {
    ROWS.each { row -> printRow(COLUMNS, "insert", {it, _ -> escapeTag(it.name())}) { FORMATTER.format(row, it) } }
}
else {
    def values = COLUMNS.collect { new ArrayList<String>() }
    ROWS.each { row -> COLUMNS.eachWithIndex { col, i -> values[i].add(FORMATTER.format(row, col)) } }
    values.eachWithIndex { it, index -> printRow(it, escapeTag(COLUMNS[index].name()), { _, i -> "row${i + 1}" }, { it }) }
}

OUT.append("""
</changeSet>
""")