Example usage for org.apache.commons.csv CSVRecord get

List of usage examples for org.apache.commons.csv CSVRecord get

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.csv.*
  5. CSVRecord
  6. get

Introduction

In this page you can find the example usage for org.apache.commons.csv CSVRecord get.

Prototype

public String get(final String name)

Source Link

Document

Returns a value by name.

Usage

From source file:com.sojw.TableNamesFinderExecutor.java

private static void extractTableNameByZql(final List<CSVRecord> fileContentList) {
    try {/*from  w ww .  j av a  2 s  . c  o  m*/
        for (final CSVRecord record : fileContentList) {
            String sqlStatement = record.get(3);

            ZqlParser p = new ZqlParser(
                    new DataInputStream(new ByteArrayInputStream(sqlStatement.getBytes("UTF-8"))));

            // Read all SQL statements from input
            ZStatement st;
            while ((st = p.readStatement()) != null) {
                System.out.println(st.toString()); // Display the statement

                if (st instanceof ZQuery) { // An SQL query: query the DB
                    System.out.println("ZQuery");
                    System.out.println("getFrom : " + ((ZQuery) st).getFrom());
                } else if (st instanceof ZInsert) { // An SQL insert
                    System.out.println("ZInsert");
                } else if (st instanceof ZUpdate) { // An SQL insert
                    System.out.println("ZUpdate");
                }
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

From source file:com.fbartnitzek.tasteemall.data.csv.CsvFileReader.java

/**
 * reads CSV file in data and headers with same count, uses CSV_Format RFC4180 (, and "")
 * @param file file to read/*  ww w .  ja v  a 2  s. co  m*/
 * @param headers expected columns
 * @return data
 */
public static List<List<String>> readCsvFileHeadingAndData(File file, List<String> headers) {

    List<List<String>> data = new ArrayList<>();

    CSVParser csvParser = null;
    Reader csvReader = null;
    try {
        csvReader = new FileReader(file);
        csvParser = new CSVParser(csvReader, CsvFileWriter.CSV_FORMAT_RFC4180.withHeader());
        Map<String, Integer> headerMap = csvParser.getHeaderMap();

        // print headerMap
        for (Map.Entry<String, Integer> entry : headerMap.entrySet()) {
            System.out.println(entry.getValue() + ": " + entry.getKey());
        }

        // should be same order!

        // 0 columns seems impossible, but valid

        // ordered columns instead unordered set (for insert)!
        headers.addAll(headerMap.keySet());
        for (CSVRecord record : csvParser) {
            List<String> dataEntry = new ArrayList<>();
            for (int i = 0; i < headers.size(); ++i) {
                if (i < record.size()) {
                    dataEntry.add(record.get(i));
                }
                //                    dataEntry.add(record.get(headers.get(i)));
            }
            data.add(dataEntry);
        }

    } catch (IOException e) {
        e.printStackTrace();
    } finally {
        try {
            if (csvReader != null) {
                csvReader.close();
            }
            if (csvParser != null) {
                csvParser.close();
            }
        } catch (IOException e) {
            //                System.out.println("Error while closing fileReader/csvFileParser !!!");
            e.printStackTrace();
        }
    }

    return data;
}

From source file:com.sojw.TableNamesFinderExecutor.java

/**
 * @param tableName/*from w w  w .j a va 2  s .c o m*/
 * @param fileContentList
 * @return
 */
private static List<String> extractTableNameByRegex(final String tableName,
        final List<CSVRecord> fileContentList) {
    List<String> searchList = new ArrayList<String>();
    searchList.add(CSV_SAVE_HEADER);

    for (CSVRecord record : fileContentList) {
        final String iteration = record.get(0).trim();
        final String groupno = record.get(1).trim();
        final String sqlStatement = record.get(3).trim();
        final String exPerSec = record.get(4).trim();
        final long recordNumber = record.getRecordNumber();

        /*
        final Pattern updatePattern = Pattern.compile("(?i)UPDATE[^\\S]+(?i)(dbo." + tableName + "|" + tableName
           + ")[^\\S]+(?i)SET");
        final Matcher updateMatcher = updatePattern.matcher(sqlStatement);
        if (updateMatcher.find()) {
           searchList.add(iteration + ", " + groupno + "," + tableName + "," + sqlStatement + "," + exPerSec);
        }
                
        final Pattern queryPattern = Pattern.compile("(?i)FROM[^\\S]+(?i)(dbo." + tableName + "|" + tableName
           + ")[^\\S]+");
        final Matcher queryMatcher = queryPattern.matcher(sqlStatement);
        if (queryMatcher.find()) {
           searchList.add(iteration + ", " + groupno + "," + tableName + "," + sqlStatement + "," + exPerSec);
        }
        */

        final Pattern queryPattern = Pattern
                .compile("(?i)UPDATE[^\\S]+(?i)(dbo." + tableName + "|" + tableName + ")[^\\S]+(?i)SET" + "|"
                        + "(?i)FROM[^\\S]+(?i)(dbo." + tableName + "|" + tableName + ")[^\\S]+");
        final Matcher queryMatcher = queryPattern.matcher(sqlStatement);
        if (queryMatcher.find()) {
            searchList.add(String.format(CSV_SAVE_FORMAT, iteration, groupno, tableName, sqlStatement, exPerSec,
                    recordNumber));
        }
    }

    return searchList;
}

From source file:com.sojw.TableNamesFinderExecutor.java

/**
 *
 *///w  w  w.  ja v a 2s .  com
private static void __select() {
    List<CSVRecord> fileContentList = null;
    try {
        fileContentList = getCSVFileContents(
                "D:\\BTS Task\\Cubrid\\ _Query__input.csv");
    } catch (IOException e) {
        System.out.println("  .");
        System.exit(-1);
    }

    if (fileContentList == null || fileContentList.isEmpty()) {
        System.out.println("  .");
        System.exit(1);
    }

    System.out.println("fileContents size : " + fileContentList.size());

    CCJSqlParserManager manager = new CCJSqlParserManager();

    int errorCount = 0;
    for (final CSVRecord record : fileContentList) {
        String sqlStatement = record.get(3);
        try {
            Statement statement = manager.parse(new StringReader(sqlStatement));
            if (statement != null) {
                List<String> tableNames = extractTableNameByJsql(statement);
                if (tableNames != null && !tableNames.isEmpty()) {
                    System.out.println("tableNames " + tableNames);
                }
            }
        } catch (Exception e) {
            System.out.println(e + ",  sqlStatement = " + sqlStatement);
            errorCount++;
        }
    }

    System.out.println("errorCount : " + errorCount);
}

From source file:com.miovision.oss.awsbillingtools.parser.DetailedLineItem.java

private static Map<String, String> extractTags(CSVRecord csvRecord, List<String> tags) {
    Map<String, String> mappedTags = new HashMap<>();
    for (int i = 0; i < tags.size(); ++i) {
        mappedTags.put(tags.get(i), csvRecord.get(20 + i));
    }//w ww . j a v  a  2s .  c  om
    return mappedTags;
}

From source file:net.iaeste.iws.core.transformers.CSVTransformer.java

static void transformBoolean(final Map<String, String> errors, final Verifiable obj, final OfferFields field,
        final CSVRecord record) {
    final String value = record.get(field.getField());

    if ((value != null) && !value.isEmpty()) {
        invokeMethodOnObject(errors, obj, field, convertBoolean(value));
    }/*from  w  w  w  . j  av  a  2  s .c om*/
}

From source file:net.iaeste.iws.core.transformers.CSVTransformer.java

static void transformStringSet(final Map<String, String> errors, final Verifiable obj, final OfferFields field,
        final CSVRecord record) {
    final String value = record.get(field.getField());
    final String parsedValue = PATTERN_UNWANTED_CHARACTERS.matcher(value).replaceAll(" ").trim();

    final Set<String> set = CollectionTransformer.explodeStringSet(parsedValue);
    invokeMethodOnObject(errors, obj, field, set);
}

From source file:net.iaeste.iws.core.transformers.CSVTransformer.java

static void transformInteger(final Map<String, String> errors, final Verifiable obj, final OfferFields field,
        final CSVRecord record) {
    final String value = record.get(field.getField());

    if ((value != null) && !value.isEmpty()) {
        try {//from   w w  w.  j a  va 2  s  .  com
            final Integer number = Integer.valueOf(value);
            invokeMethodOnObject(errors, obj, field, number);
        } catch (NumberFormatException e) {
            LOG.debug(e.getMessage(), e);
            errors.put(field.getField(), e.getMessage());
        }
    }
}

From source file:net.iaeste.iws.core.transformers.CSVTransformer.java

static void transformBigDecimal(final Map<String, String> errors, final Verifiable obj, final OfferFields field,
        final CSVRecord record) {
    final String value = record.get(field.getField());

    if ((value != null) && !value.isEmpty()) {
        try {/*from w  w  w .j  av  a  2 s .co  m*/
            final BigDecimal number = new BigDecimal(value);
            invokeMethodOnObject(errors, obj, field, number);
        } catch (NumberFormatException e) {
            LOG.debug(e.getMessage(), e);
            errors.put(field.getField(), e.getMessage());
        }
    }
}

From source file:net.iaeste.iws.core.transformers.CSVTransformer.java

static void transformFloat(final Map<String, String> errors, final Verifiable obj, final OfferFields field,
        final CSVRecord record) {
    final String value = record.get(field.getField());

    if ((value != null) && !value.isEmpty()) {
        try {//from  ww  w.j  av a  2  s . c  om
            final Float number = Float.valueOf(value);
            invokeMethodOnObject(errors, obj, field, number);
        } catch (NumberFormatException e) {
            LOG.debug(e.getMessage(), e);
            errors.put(field.getField(), e.getMessage());
        }
    }
}