Dump CSV using H2 CSV tools

dumpCSVH2.groovy

#!/usr/bin/env groovy

@Grapes([
	@Grab(group = 'com.h2database', module = 'h2', version = '1.4.194'),
	@GrabConfig(systemClassLoader=true)
])

import java.sql.*;
import org.h2.tools.Csv;


def dumpCSV() {
	def csvFile = "bel/bel_reaction_data.txt"
	def csv = new Csv()
	csv.setFieldDelimiter('\t' as char)
	ResultSet rs = csv.read(csvFile, null, null)
	ResultSetMetaData meta = rs.getMetaData()
	while (rs.next()) {
		for (int i = 0; i < meta.getColumnCount(); i++) {
			println meta.getColumnLabel(i + 1) + ": " + rs.getString(i + 1)
		}
		println ''
	}
	rs.close()
}

dumpCSV()