/******************************************************************************* * Copyright (c) 2012, Directors of the Tyndale STEP Project * All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions * are met: * * Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in * the documentation and/or other materials provided with the * distribution. * Neither the name of the Tyndale House, Cambridge (www.TyndaleHouse.com) * nor the names of its contributors may be used to endorse or promote * products derived from this software without specific prior written * permission. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE * COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING * IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF * THE POSSIBILITY OF SUCH DAMAGE. ******************************************************************************/ package com.tyndalehouse.step.core.data.loaders; import static com.tyndalehouse.step.core.utils.IOUtils.closeQuietly; import java.io.BufferedReader; import java.io.FileReader; import java.io.IOException; import java.io.Reader; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import au.com.bytecode.opencsv.CSVReader; import com.tyndalehouse.step.core.data.entities.impl.EntityIndexWriterImpl; import com.tyndalehouse.step.core.exceptions.StepInternalException; /** * Loads modules straight from a CSV file to a database form * * @author chrisburrell */ public class StreamingCsvModuleLoader extends AbstractClasspathBasedModuleLoader { private static final Logger LOG = LoggerFactory.getLogger(StreamingCsvModuleLoader.class); private char separator = ','; private final EntityIndexWriterImpl writer; /** * @param writer the writer to the index * @param resourcePath the resource path to load */ public StreamingCsvModuleLoader(final EntityIndexWriterImpl writer, final String resourcePath) { super(resourcePath); this.writer = writer; } @Override protected void parseFile(final Reader reader, int skipLines) { CSVReader csvReader = null; try { LOG.debug("Parsing file with a CsvReader"); csvReader = new CSVReader(reader, this.separator, '"', skipLines); parseCsvFile(csvReader); } finally { closeQuietly(csvReader); } } /** * Default method for parsing file, uses column strategy * * @param csvReader the csv reader */ protected void parseCsvFile(final CSVReader csvReader) { String[] line = null; String[] headerLine; try { headerLine = csvReader.readNext(); while ((line = csvReader.readNext()) != null) { processFields(line, headerLine); this.writer.save(); } } catch (final IOException e) { throw new StepInternalException("Failed to read file", e); } } /** * @param line line read from a csv file * @param headerLine the headers */ protected void processFields(final String[] line, final String[] headerLine) { for (int ii = 0; ii < line.length; ii++) { this.writer.addFieldToCurrentDocument(headerLine[ii], line[ii]); } } /** * @return the writer */ public EntityIndexWriterImpl getWriter() { return this.writer; } /** * @param separator the separator to set */ public void setSeparator(final char separator) { this.separator = separator; } }