XMLIngestors

Class SolrXMLIngestor

java.lang.Object

com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

XMLIngestors.SolrXMLIngestor

public class SolrXMLIngestor
extends ExcelIngestorBase

The Class SolrXMLIngestor. This remote object is responsible for reading and ingesting ASCII files which already exists on the server in the 'fileuploader.uploadDirectory'. Several methods exist to help examine the worksheet and one final method, ingestFile, is used to ingest the designate columns in to the database.

See Also:

ExcelIngestorBase

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	filename The filename.
protected org.apache.log4j.Logger	logger The logger.
private boolean	merge The merge.
private Table	table The table.
private java.lang.String	tableName The table name.
private static java.lang.String	TEMP_FILE The Constant TEMP_FILE.

Fields inherited from class com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

illegalChars

Constructor Summary

Constructors

Constructor and Description
SolrXMLIngestor(java.lang.String tableName, java.lang.String filename, boolean merge) Instantiates a new solr xml ingestor.

Method Summary

Methods

Modifier and Type	Method and Description
private boolean	buildTable(org.dom4j.Document doc) Builds the table.
private void	findElementsByName(org.dom4j.Element root, java.lang.String name, java.util.ArrayList<org.dom4j.Element> list) Find elements by name.
java.util.ArrayList<java.lang.String>	getColumnHeaders() Gets the column headers.
java.util.ArrayList<java.lang.String>	getColumnHeaders(java.lang.String fileName) When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.
IngestResult	ingest() Ingest.
IngestResult	ingestFile(java.lang.String tableName, java.lang.String fileName, boolean merge) Ingests the requested columns in to tableName from the provided file.
java.util.ArrayList<Column>	listColumns(java.lang.String fileName) When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.
static void	main(java.lang.String[] args) The main method.
private void	makeRow(Table t, java.lang.String name, java.util.ArrayList<org.dom4j.Element> fields, java.lang.String columns) Make row.
org.dom4j.Document	parse(java.io.File file) Parses the.
private void	updateHeader(Table t, java.util.ArrayList<org.dom4j.Element> fields) Update header.

Methods inherited from class com.edgeti.VisibilityServer.Excel.ExcelIngestorBase

checkForDups, echo, fixString, trace

Methods inherited from class java.lang.Object

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

Field Detail

tableName

private java.lang.String tableName

The table name.

filename

private java.lang.String filename

The filename.

table

private Table table

The table.

merge

private boolean merge

The merge.

logger

protected org.apache.log4j.Logger logger

The logger.

TEMP_FILE

private static final java.lang.String TEMP_FILE

The Constant TEMP_FILE.

See Also:

Constant Field Values

Constructor Detail

SolrXMLIngestor

public SolrXMLIngestor(java.lang.String tableName,
               java.lang.String filename,
               boolean merge)

Instantiates a new solr xml ingestor.

Parameters:

tableName - the table name

filename - the filename

merge - the merge flag (true = merge, false = replace)

Method Detail

ingest

public IngestResult ingest()

Ingest.

Returns:

the ingest result

getColumnHeaders

public java.util.ArrayList<java.lang.String> getColumnHeaders()

Gets the column headers.

Returns:

the column headers

buildTable

private boolean buildTable(org.dom4j.Document doc)

Builds the table.

Parameters:

doc - the dom4j Document

Returns:

true, if successful

updateHeader

private void updateHeader(Table t,
                java.util.ArrayList<org.dom4j.Element> fields)

Update header.

Parameters:

t - the Table

fields - the fields

See Also:

Table

makeRow

private void makeRow(Table t,
           java.lang.String name,
           java.util.ArrayList<org.dom4j.Element> fields,
           java.lang.String columns)

Make row.

Parameters:

t - the Table

name - the name

fields - the fields

columns - the columns

findElementsByName

private void findElementsByName(org.dom4j.Element root,
                      java.lang.String name,
                      java.util.ArrayList<org.dom4j.Element> list)

Find elements by name.

Parameters:

root - the root

name - the name

list - the list

parse

public org.dom4j.Document parse(java.io.File file)
                         throws org.dom4j.DocumentException,
                                java.io.IOException

Parses the.

Parameters:

file - the file

Returns:

the dom4j Document

Throws:

org.dom4j.DocumentException

java.io.IOException - Signals that an I/O exception has occurred.

listColumns

public java.util.ArrayList<Column> listColumns(java.lang.String fileName)

Description copied from class: ExcelIngestorBase

When given the name of an existing file, returns the columns which exist in the top sheet of that excel file.

Specified by:

listColumns in class ExcelIngestorBase

Parameters:

fileName - the file name

Returns:

the array list

getColumnHeaders

public java.util.ArrayList<java.lang.String> getColumnHeaders(java.lang.String fileName)

Description copied from class: ExcelIngestorBase

When given the name of an existing file, returns the columns which exist in the top sheet of that excel file. Same as above, but returning as ArrayList

Specified by:

getColumnHeaders in class ExcelIngestorBase

Parameters:

fileName - the file name

Returns:

the column headers as ArrayList

ingestFile

public IngestResult ingestFile(java.lang.String tableName,
                      java.lang.String fileName,
                      boolean merge)

Description copied from class: ExcelIngestorBase

Ingests the requested columns in to tableName from the provided file. If tableName exists, it will be dropped and recreated.

Specified by:

ingestFile in class ExcelIngestorBase

Parameters:

tableName - the table name

fileName - the file name

merge - flag to merge with existing data in the table (true = merge, false = replace)

Returns:

the ingest result

main

public static void main(java.lang.String[] args)

The main method. For debugging only

Parameters:

args - the arguments