package Producer;

        import org.apache.commons.csv.CSVFormat;
        import org.apache.commons.csv.CSVParser;
        import org.apache.commons.csv.CSVRecord;

        import java.io.Reader;
        import java.nio.file.Files;
        import java.nio.file.Paths;
        import java.time.LocalDateTime;
        import java.time.format.DateTimeFormatter;
        import java.util.ArrayList;

public class ParserCSV{

    private String CSV_FILE_PATH;

    private ArrayList<Object> dataToSend = new ArrayList<Object>();

    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

    public ParserCSV(String path)
    {
        this.CSV_FILE_PATH  = path;

    }

    public ArrayList<Object> parseFile(){

        try (

                Reader reader = Files.newBufferedReader(Paths.get(CSV_FILE_PATH));
                CSVParser csvParser = new CSVParser(reader, CSVFormat.DEFAULT
                        .withFirstRecordAsHeader()
                        .withIgnoreHeaderCase()
                        .withTrim())

        ) {
            for (CSVRecord csvRecord : csvParser) {
                // Accessing Values by Column Index
                String DATE = csvRecord.get("date");

                LocalDateTime formatDateTime = LocalDateTime.parse(DATE, formatter);
                double NO = Double.valueOf(csvRecord.get("NO"));

                dataToSend.clear();
                dataToSend.add(formatDateTime);
                dataToSend.add(NO);


            }

        } catch (Exception | Error e) {
            e.printStackTrace();
        }

        return dataToSend;

    }
}