net.ontopia.persistence.rdbms
Class CSVExport

java.lang.Object
  net.ontopia.persistence.rdbms.CSVExport

public class CSVExport
extends java.lang.Object

INTERNAL: Command line tool for exporting comma- or semicolon separated files into a database.

Field Summary

protected java.sql.Connection	conn
protected java.lang.String	separator

Constructor Summary

CSVExport(java.sql.Connection conn)

Method Summary

protected java.lang.String	escape(java.lang.String value)
void	exportCSV(java.io.Writer writer, java.lang.String table, java.lang.String[] columns)
static void	main(java.lang.String[] argv)
void	setSeparator(java.lang.String separator)
protected static void	usage()

Methods inherited from class java.lang.Object

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

Field Detail

conn

protected java.sql.Connection conn

separator

protected java.lang.String separator

Constructor Detail

CSVExport

public CSVExport(java.sql.Connection conn)

Method Detail

setSeparator

public void setSeparator(java.lang.String separator)

escape

protected java.lang.String escape(java.lang.String value)

exportCSV

public void exportCSV(java.io.Writer writer,
                      java.lang.String table,
                      java.lang.String[] columns)
               throws java.sql.SQLException,
                      java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

main

public static void main(java.lang.String[] argv)
                 throws java.lang.Exception

Throws:

java.lang.Exception

usage

protected static void usage()