net.ucanaccess.console

Class Exporter

java.lang.Object

net.ucanaccess.console.Exporter

public final class Exporter
extends Object

Class that exports the given ResultSet to CSV format. Use the Exporter.Builder to configure the Exporter before calling its csvDump() method. For example:

 Exporter exporter = new Exporter.Builder()
     .setDelimiter(",")
     .build();
 ResultSet rs = ...;
 exporter.csvDump(rs, System.out);
 

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Exporter.Builder Builder for Exporter.

Method Summary

Modifier and Type	Method and Description
void	dumpCsv(ResultSet rs, PrintStream out) Prints the ResultSet rs in CSV format to the output file out.
void	dumpSchema(ResultSet rs, PrintStream out) Prints the Google BigQuery schema of the table given by rs in JSON format to the out stream.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

dumpCsv

public void dumpCsv(ResultSet rs,
                    PrintStream out)
             throws SQLException,
                    IOException

Prints the ResultSet rs in CSV format to the output file out.

Throws:

SQLException

IOException

dumpSchema

public void dumpSchema(ResultSet rs,
                       PrintStream out)
                throws SQLException,
                       IOException

Prints the Google BigQuery schema of the table given by rs in JSON format to the out stream. See https://cloud.google.com/bigquery/bq-command-line-tool for a description of the JSON schema format.

Throws:

SQLException

IOException