private int getColumnCount(
String filename,
String rowSep,
String fieldSep,
int limitRows,
int headerRows,
String escapeChar,
String textEnclosure,
EShadowProcessType fileType) {
File config =
new File(
CorePlugin.getDefault()
.getPreferenceStore()
.getString(ITalendCorePrefConstants.FILE_PATH_TEMP)
+ "/conf.pl"); //$NON-NLS-1$
if (config.exists()) {
config.delete();
}
String modulepath = LibrariesManagerUtils.getLibrariesPath(ECodeLanguage.PERL);
FileWriter filewriter;
String str = "0"; // $NON-NLS-1$
File resultFile =
new File(
CorePlugin.getDefault()
.getPreferenceStore()
.getString(ITalendCorePrefConstants.FILE_PATH_TEMP)
+ "/result.txt"); //$NON-NLS-1$
if (resultFile.exists()) {
resultFile.delete();
}
try {
filewriter = new FileWriter(config, true);
switch (fileType) {
case FILE_DELIMITED:
filewriter.write("$conf{filename} = " + filename + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{row_separator} = " + rowSep + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write(
"$conf{field_separator} = " + fieldSep + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{header} = " + headerRows + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{limit} = " + limitRows + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write(
"$conf{result_file} =\'"
+ resultFile.toString()
+ "\';"); //$NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{type} = \'delimited\';"); // $NON-NLS-1$
break;
case FILE_CSV:
filewriter.write("$conf{filename} = " + filename + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{row_separator} = " + rowSep + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write(
"$conf{field_separator} = " + fieldSep + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{escape_char} = " + escapeChar + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write(
"$conf{text_enclosure} = " + textEnclosure + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{header} = " + headerRows + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{limit} = " + limitRows + ";"); // $NON-NLS-1$ //$NON-NLS-2$
filewriter.write(
"$conf{result_file} =\'"
+ resultFile.toString()
+ "\';"); //$NON-NLS-1$ //$NON-NLS-2$
filewriter.write("$conf{type} = \'CSV\';"); // $NON-NLS-1$
break;
default:
break;
}
filewriter.close();
modulepath = modulepath + "/column_counter_delimited.pl"; // $NON-NLS-1$
StringBuffer out = new StringBuffer();
StringBuffer err = new StringBuffer();
IRunProcessService service =
(IRunProcessService)
GlobalServiceRegister.getDefault().getService(IRunProcessService.class);
service.perlExec(
out,
err,
new Path(modulepath),
null,
Level.DEBUG,
"",
null,
-1,
-1,
new String[] {
"--conf=" //$NON-NLS-1$ //$NON-NLS-2$
+ config
});
FileReader filereader = new FileReader(resultFile);
BufferedReader reader = new BufferedReader(filereader);
str = reader.readLine();
} catch (IOException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
ExceptionHandler.process(e);
} catch (ProcessorException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
ExceptionHandler.process(e);
}
return Integer.parseInt(str);
}
