package integrationTest.issue3189428;
   
   
   import com.opencsv.CSVReader;
   import com.opencsv.CSVReaderBuilder;
   import com.opencsv.CSVWriter;
   import com.opencsv.ICSVWriter;
   import com.opencsv.bean.ColumnPositionMappingStrategy;
   import com.opencsv.bean.CsvToBean;
  import com.opencsv.bean.CsvToBeanBuilder;
  import com.opencsv.exceptions.CsvValidationException;
  
  import java.io.FileNotFoundException;
  import java.io.FileReader;
  import java.io.FileWriter;
  import java.io.IOException;
  import java.util.List;
  
  public class CsvSample {
     String filePath = "test/integrationTest/issue3189428/mysample.csv";
  
     public CsvSample() {
     }
  
     public static void main(String[] args) throws Exception {
        CsvSample sample = new CsvSample();
        sample.doSample();
     }
  
     public void doSample() throws Exception {
        String[] fields = new String[5];
        fields[0] = "field1";
        fields[1] = "3.0";
        fields[2] = "3,147.25";
        fields[3] = "$3,147.26";
        // failing string
        fields[4] = "Joe said, \"This is a test of a \nlong broken string,\" and Sally said, \"I bet it won't work.\" ";
        // working string
        // fields[4] = "Joe said, \"This is a test of a \nlong broken string,\" and Sally said, \"I bet it won't work.\"";
  
        ICSVWriter writer = new CSVWriter(new FileWriter(filePath));
        writer.writeNext(fields); // let's make 3 rows so we can see it cleanly in Excel.
        writer.writeNext(fields);
        writer.writeNext(fields);
        writer.close();
  
        testRawCsvRead(fields[4]);
        testMappingStrategyRead(fields[4]);
  
        System.out.println("\nComplete.  File written out to " + filePath);
  
     }
  
     /**
      * This approach seems to work correctly, even with embedded newlines.
      *
      * @param originalCommentText No idea
      * @throws IOException But not really
      */
     protected void testRawCsvRead(String originalCommentText) throws IOException, CsvValidationException {
        CSVReader reader = new CSVReader(new FileReader(filePath));
        String[] nextLine;
        int count = 0;
        while ((nextLine = reader.readNext()) != null) {
           if (!nextLine[0].equals("field1")) {
              System.out.println("RawCsvRead Assert Error: Name is wrong.");
           }
           if (!nextLine[1].equals("3.0")) {
              System.out.println("RawCsvRead Assert Error: Value is wrong.");
           }
           if (!nextLine[2].equals("3,147.25")) {
              System.out.println("RawCsvRead Assert Error: Amount1 is wrong.");
           }
           if (!nextLine[3].equals("$3,147.26")) {
              System.out.println("RawCsvRead Assert Error: Currency is wrong.");
           }
           System.out.println("Field 4 read: " + nextLine[4]);
           if (!nextLine[4].equals(originalCommentText)) {
              System.out.println("RawCsvRead Assert Error: Comment is wrong.");
           }
           count++;
        }
        if (count != 3) {
           System.out.println("RawCsvRead Assert Error: Count of lines is wrong.");
        }
  
     }
  
     /**
      * This approach seems to fail with embedded newlines; that might be a weakness of
      * the mapping strategy support classes.
      *
      * @param originalCommentText No idea
      * @throws FileNotFoundException But not really
      */
     protected void testMappingStrategyRead(String originalCommentText)
             throws FileNotFoundException {
        ColumnPositionMappingStrategy<MyBean> mappingStrategy = new ColumnPositionMappingStrategy<>();
        mappingStrategy.setType(MyBean.class);
       String[] columns = new String[]{"name", "value", "amount1", "currency", "comments"}; // the fields to bind to in your JavaBean
       mappingStrategy.setColumnMapping(columns);
 
       CSVReader reader = new CSVReaderBuilder(new FileReader(filePath))
               .build();
       CsvToBean<MyBean> csv = new CsvToBeanBuilder<MyBean>(reader)
               .withMappingStrategy(mappingStrategy)
               .withStrictQuotes(false)
               .withIgnoreLeadingWhiteSpace(false)
               .build();
       List<MyBean> list = csv.parse();
 
       if (list.size() != 3) {
          System.out.println("Error - list size is wrong.");
       }
       MyBean myBean = list.get(2);
       if (!myBean.getName().equals("field1")) {
          System.out.println("MappingStrategy Assert Error: Name is wrong.");
       }
       if (!myBean.getValue().equals("3.0")) {
          System.out.println("MappingStrategy Assert Error: Value is wrong.");
       }
       if (!myBean.getAmount1().equals("3,147.25")) {
          System.out.println("MappingStrategy Assert Error: Amount1 is wrong.");
       }
       if (!myBean.getCurrency().equals("$3,147.26")) {
          System.out.println("MappingStrategy Assert Error: Currency is wrong.");
       }
       printfield("MyBeanComments:         ", myBean.getComments());
       printfield("OriginalCommentText:    ", originalCommentText);
       if (!myBean.getComments().equals(originalCommentText)) {
          System.out.println("MappingStrategy Assert Error: Comment is wrong.");
       }
    }
 
    private void printfield(String header, String field) {
       System.out.println(header + field);
       System.out.println("fieldlen: " + field.length());
    }
 
    public static class MyBean {
       String name;
       String value;
       String amount1;
       String currency;
       String comments;
 
       public MyBean() {
       }
 
       public String getName() {
          return name;
       }
 
       public void setName(String name) {
          this.name = name;
       }
 
       public String getValue() {
          return value;
       }
 
       public void setValue(String value) {
          this.value = value;
       }
 
       public String getAmount1() {
          return amount1;
       }
 
       public void setAmount1(String amount1) {
          this.amount1 = amount1;
       }
 
       public String getCurrency() {
          return currency;
       }
 
       public void setCurrency(String currency) {
          this.currency = currency;
       }
 
       public String getComments() {
          return comments;
       }
 
       public void setComments(String comments) {
          this.comments = comments;
       }
 
    }
 }