[jira] [Updated] (CSV-174) Adding methods to support JSON-CSV interchangeability and adding a class/methods to support direct cell modification

["Joey Pinto (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CSV-174?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joey Pinto updated CSV-174:
---------------------------
    Labels: gsoc2016  (was: )

> Adding methods to support JSON-CSV interchangeability and adding a class/methods to support direct cell modification
> --------------------------------------------------------------------------------------------------------------------
>
>                 Key: CSV-174
>                 URL: https://issues.apache.org/jira/browse/CSV-174
>             Project: Commons CSV
>          Issue Type: Improvement
>          Components: Build
>            Reporter: Joey Pinto
>              Labels: gsoc2016
>
> I wish to introduce some major features in the Commons CSV that I found really necessary while dealing with CSV file parsing requirements of an ERP for a University.
> 1.Custom Exceptions:
>   Exceptions to be raised when incorrectly formatted CSVs are parsed specifying the row number mentioning reasons like incorrect number of columns.
> 2. Export to JSON:
> PostgreSQL Supports direct import of JSON Code. So to insert data from a CSV into the database I had to first convert it to JSON and then make the insert. If we could have an option to do this directly it would be a lot more time saving.
> 3.New Class CSVFile
> I wish to introduce a new class CSVFile which shall have the entire contents of the CSV stored in nested Array Lists.
> I shall have the following methods in the class:
> Constructors:
> void CSVFile(CSVParser);
> void CSVFile(Object [][],boolean has_headers);
> void CSVFile(JSON Array,boolean allow_blanks);
> void CSVFile(String text,String cell_delimiter,String line_delimiter,boolean force_headerSchema);
> Printers:
> String CSVFile.toString();
> JSONArray CSVFile.toJSONArray();
> Object[][] CSVFile.toArray();
> ResultSet CSVFile.toResultSet();
> ArrayList<Object[]> CSVFile.toArrayList();
> ArrayList<ArrayList<Object>> CSVFile.toNestedArrayList();
> String CSVFile.toString();
> Access:
> CSVFile.setColumnHeader(int col_number);
> String CSVFile.getCell(int row_number,String header);
> String CSVFile.getCell(int row_number,int col_number);
> CSVFile.setCell(int row_number,int col_number,String value);
> CSVFile.setCell(int row_number,String header,String value);
> CSVFile.getRowArray();
> JSONObject CSVFile.getRowJSON();
> Sorting:
> CSVFile.sort(Comparator());
> Extraction:
> CSVFile CSVFile.getColumns(Arraylist<String> headers);
> CSVFile CSVFile.getRows(extractor());
> @override 
> public boolean include(CSVRecord record){
> //if satisfies Condition then include
>       return true;
> //else return false
>    }
> Delete:
> void CSVFile.removeRow(int row_number);
> void CSVFile.remove Section(int start_row,int end_row);
> void CSVFile.CSVFile.removeRows(extractor());
> void CSVFile.removeColumn(int col_number);
> void CSVFile.removeColumn(String header);



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)