net.ontopia.persistence.rdbms

Class CSVImport

java.lang.Object

net.ontopia.persistence.rdbms.CSVImport

public class CSVImport
extends Object

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

Field Summary

Fields

Modifier and Type	Field and Description
protected boolean	cleartable
protected String[]	columns
protected Connection	conn
protected boolean	ignorecolumns
protected int	ignorelines
protected Project	project
protected String	separator
protected boolean	stripquotes
protected String	table

Constructor Summary

Constructors

Constructor and Description
CSVImport(Project project, Connection conn)

Method Summary

Modifier and Type	Method and Description
Project	getProject()
void	importCSV(InputStream csvfile)
static void	main(String[] argv)
void	setClearTable(boolean cleartable)
void	setColumns(String[] columns)
void	setIgnoreColumns(boolean ignorecolumns)
void	setIgnoreLines(int ignorelines)
void	setSeparator(String separator)
void	setStripQuotes(boolean stripquotes)
void	setTable(String table)
protected static void	usage()

Methods inherited from class java.lang.Object

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

Field Detail

project

protected Project project

conn

protected Connection conn

table

protected String table

columns

protected String[] columns

separator

protected String separator

cleartable

protected boolean cleartable

stripquotes

protected boolean stripquotes

ignorecolumns

protected boolean ignorecolumns

ignorelines

protected int ignorelines

Constructor Detail

CSVImport

public CSVImport(Project project,
                 Connection conn)

Method Detail

getProject

public Project getProject()

setTable

public void setTable(String table)

setColumns

public void setColumns(String[] columns)

setSeparator

public void setSeparator(String separator)

setClearTable

public void setClearTable(boolean cleartable)

setStripQuotes

public void setStripQuotes(boolean stripquotes)

setIgnoreColumns

public void setIgnoreColumns(boolean ignorecolumns)

setIgnoreLines

public void setIgnoreLines(int ignorelines)

main

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

Throws:

Exception

importCSV

public void importCSV(InputStream csvfile)
               throws Exception

Throws:

Exception

usage

protected static void usage()