public void csvToTransactions(String path) {
String csvFile = path;
BufferedReader br = null;
String line = "";
String cvsSplitBy = ",";
try {
br = new BufferedReader(new FileReader(csvFile));
br.readLine();
while ((line = br.readLine()) != null) {
// use comma as separator
String[] csvString = line.split(cvsSplitBy);
int tid = Integer.parseInt(csvString[0]);
int qty = Integer.parseInt(csvString[1]);
String status = csvString[2];
String t_date = csvString[3];
String process = csvString[4];
double price = Double.parseDouble(csvString[5]);
Transaction transaction = new Transaction();
Trader trader = traderD.findById(tid);
transaction.setPrice(price);
transaction.setProcess(process);
transaction.setQty(qty);
transaction.setStatus(status);
transaction.setT_date(t_date);
transaction.setTrader(trader);
commitTransaction(transaction);
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (br != null) {
try {
br.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
