public void mReadRecordSet(RecordSetMD aInputRecordSetMD
, RecordSet aInputRecordSet
, String aPath
, String aFileName
, Boolean hasHeaderRow
, String dlm
, PrintWriter pw
)
//throws com.WDataSci.WDS.WDSException
{
try {
if (aInputRecordSetMD.FileMatter == null)
{
aInputRecordSetMD.FileMatter.cPointToFile(aInputRecordSetMD, aPath, aFileName, hasHeaderRow, dlm);
}
int nInputMap = aInputRecordSetMD.nColumns();
int i = -1;
int j = -1;
String aPathAndName = null;
//Java if ( this.__CSV == null || this.__CSV.isClosed() || !this.Path.equals(aPath) || !this.FileName.equals(aFileName) )
//C#
if (this.__CSV == null || !this.Path.equals(aPath) || !this.FileName.equals(aFileName))
{
aPathAndName = com.WDataSci.WDS.Util.PathAndName(aPath, aFileName);
//Java this.__CSV = new CSVParser(new FileReader(aPathAndName), CSVFormat.EXCEL);
//Java this.__CSVParserIterator = this.__CSVParser.iterator();
//C#
this.__CSV = new CsvParser(new StreamReader(aPathAndName));
}
if (aInputRecordSet.isEmpty())
{
//Java aInputRecordSet.Records = new ArrayList<>(0);
//C#
aInputRecordSet.Records = new List <Map <FieldName, Object> >(0);
//Java aInputRecordSet.Records_Orig = new ArrayList<>(0);
//C#
aInputRecordSet.Records_Orig = new List <Object[]>(0);
}
//Java CSVRecord inputLine;
//C#
String[] inputLine;
//Java if ( hasHeaderRow && this.__CSVParser.getCurrentLineNumber() == 0 )
//C#
if (hasHeaderRow && this.__CSV.Context.Row < 1)
{
//Java inputLine = this.__CSVParserIterator.next();
//C#
inputLine = this.__CSV.Read();
}
int row = -1;
//Java while (this.__CSVParserIterator.hasNext())
//C#
while (true)
{
//Java inputLine = this.__CSVParserIterator.next();
//C#
inputLine = this.__CSV.Read();
if (inputLine == null)
{
break;
}
int nIncomingFields = inputLine.size();
if (nIncomingFields == 0 || (nIncomingFields == 1 && nInputMap > 1))
{
break;
}
//if nIncomingFields<nInputMap, pad with nulls, otherwise throw
if (nIncomingFields > nInputMap)
{
//Java throw new com.WDataSci.WDS.WDSException(String.format("Error reading from delimited file, row %d has insufficient columns, stopping input!\n", row + 1));
//C#
throw new com.WDataSci.WDS.WDSException("Error reading from delimited file, row " + (row + 1) + " has insufficient columns, stopping input!\n");
}
row++;
//Java Map<FieldName, Object> inputRow = new LinkedHashMap<>();
//C#
Map <FieldName, Object> inputRow = new Map <FieldName, Object>();
Object[] inputRow_orig = new Object[nInputMap];
for (j = 0; j < nInputMap; j++)
{
String s = null;
if (j < nIncomingFields)
{
s = inputLine.get(j);
}
if (s == null || s.isEmpty())
{
inputRow_orig[j] = null;
if (aInputRecordSetMD.Column[j].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[j].MapKey, null);
}
}
else if (aInputRecordSetMD.Column[j].DTyp.equals(FieldMDEnums.eDTyp.Dbl))
{
//Java Double lv = Double.parseDouble(inputLine.get(j));
/* C# >>> */
double tmplv = double.NaN;
double?lv = null;
if (double.TryParse(inputLine.get(j), out tmplv))
{
lv = tmplv;
}
/* <<< C# */
inputRow_orig[j] = lv;
if (aInputRecordSetMD.Column[j].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[j].MapKey, lv);
}
}
else if (aInputRecordSetMD.Column[j].DTyp.equals(FieldMDEnums.eDTyp.Lng))
{
//Java Long lv = Long.parseLong(inputLine.get(j));
/* C# >>> */
long tmplv = long.MinValue;
long?lv = null;
if (long.TryParse(inputLine.get(j), out tmplv))
{
lv = tmplv;
}
/* <<< C# */
inputRow_orig[j] = lv;
if (aInputRecordSetMD.Column[j].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[j].MapKey, lv);
}
}
else if (aInputRecordSetMD.Column[j].DTyp.equals(FieldMDEnums.eDTyp.Int))
{
//Java Integer lv = Integer.parseInt(inputLine.get(j));
/* C# >>> */
int tmplv = int.MinValue;
int?lv = null;
if (int.TryParse(inputLine.get(j), out tmplv))
{
lv = tmplv;
}
/* <<< C# */
inputRow_orig[j] = lv;
if (aInputRecordSetMD.Column[j].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[j].MapKey, lv);
}
}
else
{
//Java String lv = com.WDataSci.JniPMML.Util.CleanAsToken(inputLine.get(j));
//C#
String lv = com.WDataSci.WDS.Util.CleanAsToken(inputLine.get(j));
inputRow_orig[j] = lv;
if (aInputRecordSetMD.Column[j].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[j].MapKey, lv);
}
}
}
aInputRecordSet.Records.add(inputRow);
aInputRecordSet.Records_Orig.add(inputRow_orig);
}
//Java this.__CSV.close();
//C#
this.__CSV.Dispose();
//C#? this.__StreamReader.Dispose();
}
catch (com.WDataSci.WDS.WDSException e) {
throw new com.WDataSci.WDS.WDSException("Error reading from delimited file:", e);
}
catch (Exception e) {
throw new com.WDataSci.WDS.WDSException("Error reading from delimited file:", e);
}
}
public void mReadRecordSet(RecordSetMD aInputRecordSetMD, RecordSet aInputRecordSet, PrintWriter pw)
//throws WDSException
{
int ri = 0;
try {
if (aInputRecordSet.isEmpty())
{
//Java aInputRecordSet.Records = new ArrayList<>(0);
//C#
aInputRecordSet.Records = new List <Map <FieldName, Object> >(0);
//Java aInputRecordSet.Records_Orig = new ArrayList<>(0);
//C#
aInputRecordSet.Records_Orig = new List <Object []>(0);
}
int nColumns = aInputRecordSetMD.nColumns();
int i = -1;
int j = -1;
int jj = -1;
DBB buf = aInputRecordSetMD.DBBMatter.RecordSet.Buffer;
int nRows = (int)aInputRecordSetMD.DBBMatter.RecordSet.Buffer.nRecords;
/* Java >>> *
* Double lvd = 0.0;
* Long lvl = 0L;
* Integer lvi = 0;
* Boolean lvbln = false;
* /* <<< Java */
/* C# >>> */
double? lvd = 0.0;
long? lvl = 0L;
int? lvi = 0;
Boolean?lvbln = false;
/* <<< C# */
String lvs = "";
int bptr = 0;
for (i = 0; i < nRows; i++, bptr += (int)aInputRecordSetMD.DBBMatter.RecordSet.Buffer.nRecordFLenBytes)
{
ri = i;
buf.position(buf.ptr, bptr, buf.vlenptr);
Object[] inputRow_orig = new Object[nColumns];
//Java Map<FieldName, Object> inputRow = new LinkedHashMap<>();
//C#
Map <FieldName, Object> inputRow = new Map <FieldName, Object>();
for (jj = 0; jj < nColumns; jj++)
{
switch (aInputRecordSetMD.Column[jj].DTyp)
{
//case Dbl:
case FieldMDEnums.eDTyp.Dbl:
lvd = buf.GetLayerDouble(1);
//Java if (lvd==null || lvd.isNaN() || Double.isInfinite(lvd) ) lvd=null;
//C#
if (lvd == null || Double.IsNaN(lvd.Value) || lvd == Double.MinValue || lvd == Double.MaxValue ||
Double.IsNegativeInfinity(lvd.Value) || Double.IsPositiveInfinity(lvd.Value))
{
lvd = null;
}
inputRow_orig[jj] = lvd;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvd);
}
break;
//case Lng:
case FieldMDEnums.eDTyp.Lng:
lvl = buf.GetLayerLong(1);
//Java if ( lvl == null || lvl.equals(Long.MIN_VALUE) || lvl.equals(Long.MAX_VALUE) ) lvl = null;
//C#
if (lvl == null || lvl == long.MinValue || lvl == long.MaxValue)
{
lvl = null;
}
inputRow_orig[jj] = lvl;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvl);
}
break;
//case Int:
case FieldMDEnums.eDTyp.Int:
lvi = buf.GetLayerInt(1);
//Java if ( lvi == null || lvi.equals(Integer.MIN_VALUE) || lvi.equals(Integer.MAX_VALUE) ) lvi = null;
//C#
if (lvi == null || lvi == int.MinValue || lvi == int.MaxValue)
{
lvi = null;
}
inputRow_orig[jj] = lvi;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvi);
}
break;
//case Str:
case FieldMDEnums.eDTyp.Str:
lvs = buf.GetLayerFLenString(1, aInputRecordSetMD.Column[jj].ByteMaxLength);
inputRow_orig[jj] = lvs;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvs);
}
break;
//case VLS:
case FieldMDEnums.eDTyp.VLS:
lvs = buf.GetLayerVLenString(1, aInputRecordSetMD.Column[jj].ByteMaxLength);
inputRow_orig[jj] = lvs;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvs);
}
break;
//case Bln:
case FieldMDEnums.eDTyp.Bln:
lvi = buf.GetLayerInt(1);
//Java if ( lvi == null || lvi.equals(Integer.MIN_VALUE) || lvi.equals(Integer.MAX_VALUE) ) lvi = null;
//C$
if (lvi == null || lvi == int.MinValue || lvi == int.MaxValue)
{
lvi = null;
}
lvbln = null;
if (lvi != null)
{
lvbln = (lvi != 0);
}
inputRow_orig[jj] = lvbln;
if (aInputRecordSetMD.Column[jj].hasMapKey())
{
inputRow.put(aInputRecordSetMD.Column[jj].MapKey, lvbln);
}
break;
//case Byt:
case FieldMDEnums.eDTyp.Byt:
default:
throw new com.WDataSci.WDS.WDSException("Error, column type not implemented");
}
}
aInputRecordSet.Records.add(inputRow);
aInputRecordSet.Records_Orig.add(inputRow_orig);
}
}
catch (Exception e) {
throw new com.WDataSci.WDS.WDSException("Error reading from DBB, row " + ri + ":", e);
}
}
