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;
      }

   }
}