Danny Lagrouw dannylagrouw

dannylagrouw / Liquibase-XML-inserts.xml.groovy

Created November 15, 2021 10:28 — forked from davidwatkins73/Liquibase-XML-inserts.xml.groovy

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

	/*
	* 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:

dannylagrouw / alternative, using regex

Created December 14, 2009 20:37 — forked from ArtemGr/alternative, using regex

	val pattern = java.util.regex.Pattern.compile ("""(?xs) ("(.?)"\|) ; ("(.?)"\|) (?: \r?\n \| \z ) """)
	val matcher = pattern.matcher (input)
	while (matcher.find) {
	val col1 = matcher.group (2)
	val col2 = matcher.group (4)
	// ...
	}