/**
* Licensed to JumpMind Inc under one or more contributor
* license agreements. See the NOTICE file distributed
* with this work for additional information regarding
* copyright ownership. JumpMind Inc licenses this file
* to you under the GNU General Public License, version 3.0 (GPLv3)
* (the "License"); you may not use this file except in compliance
* with the License.
*
* You should have received a copy of the GNU General Public License,
* version 3.0 (GPLv3) along with this library; if not, see
* <http://www.gnu.org/licenses/>.
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.jumpmind.symmetric.io.data;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.Reader;
import java.io.StringReader;
import java.io.Writer;
import org.jumpmind.exception.IoException;
import org.jumpmind.symmetric.csv.CsvReader;
import org.jumpmind.symmetric.csv.CsvWriter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class CsvUtils {
static final Logger log = LoggerFactory.getLogger(CsvUtils.class);
public static final String DELIMITER = ", ";
public static final String LINE_SEPARATOR = System.getProperty("line.separator");
public static CsvReader getCsvReader(Reader reader) {
CsvReader csvReader = new CsvReader(reader);
csvReader.setEscapeMode(CsvReader.ESCAPE_MODE_BACKSLASH);
csvReader.setSafetySwitch(false);
csvReader.setCaptureRawRecord(false);
return csvReader;
}
public static String[] tokenizeCsvData(String csvData) {
String[] tokens = null;
if (csvData != null) {
CsvReader csvReader = getCsvReader(new StringReader(csvData));
try {
if (csvReader.readRecord()) {
tokens = csvReader.getValues();
}
} catch (IOException e) {
}
}
return tokens;
}
/**
* This escapes backslashes but doesn't wrap the data in a text qualifier.
*/
public static String escapeCsvData(String data) {
ByteArrayOutputStream out = new ByteArrayOutputStream();
CsvWriter writer = new CsvWriter(new OutputStreamWriter(out), ',');
writer.setEscapeMode(CsvWriter.ESCAPE_MODE_BACKSLASH);
try {
writer.write(data);
writer.close();
out.close();
} catch (IOException e) {
}
return out.toString();
}
public static String escapeCsvData(String[] data) {
ByteArrayOutputStream out = new ByteArrayOutputStream();
CsvWriter writer = new CsvWriter(new OutputStreamWriter(out), ',');
writer.setEscapeMode(CsvWriter.ESCAPE_MODE_BACKSLASH);
writer.setTextQualifier('\"');
writer.setUseTextQualifier(true);
writer.setForceQualifier(true);
for (String s : data) {
try {
writer.write(s, true);
} catch (IOException e) {
throw new IoException();
}
}
writer.close();
return out.toString();
}
public static String escapeCsvData(String[] data, char recordDelimiter, char textQualifier) {
return escapeCsvData(data, recordDelimiter, textQualifier, CsvWriter.ESCAPE_MODE_BACKSLASH);
}
public static String escapeCsvData(String[] data, char recordDelimiter, char textQualifier, int escapeMode) {
return escapeCsvData(data, recordDelimiter, textQualifier, escapeMode, null);
}
public static String escapeCsvData(String[] data, char recordDelimiter, char textQualifier, int escapeMode, String nullString) {
ByteArrayOutputStream out = new ByteArrayOutputStream();
CsvWriter writer = new CsvWriter(new OutputStreamWriter(out), ',');
writer.setEscapeMode(escapeMode);
if (recordDelimiter != '\0') {
writer.setRecordDelimiter(recordDelimiter);
}
if (textQualifier != '\0') {
writer.setTextQualifier(textQualifier);
writer.setUseTextQualifier(true);
writer.setForceQualifier(true);
}
if (nullString != null) {
writer.setNullString(nullString);
}
try {
writer.writeRecord(data);
} catch (IOException e) {
throw new IoException();
}
writer.close();
return out.toString();
}
public static int write(Writer writer, String... data) {
try {
StringBuilder buffer = new StringBuilder();
for (String string : data) {
buffer.append(string);
}
writer.write(buffer.toString());
if (log.isDebugEnabled()) {
log.debug(buffer.toString());
}
return buffer.length();
} catch (IOException ex) {
throw new IoException(ex);
}
}
public static void writeSql(String sql, Writer writer) {
write(writer, CsvConstants.SQL, DELIMITER, sql);
writeLineFeed(writer);
}
public static void writeBsh(String script, Writer writer) {
write(writer, CsvConstants.BSH, DELIMITER, script);
writeLineFeed(writer);
}
public static void writeLineFeed(Writer writer) {
try {
writer.write(LINE_SEPARATOR);
} catch (IOException ex) {
throw new IoException(ex);
}
}
}