Search for a record

/*
* Copyright (c) 2006-2010 North Concepts Inc.  All rights reserved.
* Proprietary and Confidential.  Use is subject to license terms.
*
* http://northconcepts.com/data-pipeline/licensing/
*
*/
package com.northconcepts.datapipeline.examples.cookbook;

import java.io.File;

import org.apache.log4j.Logger;

import com.northconcepts.datapipeline.core.DataEndpoint;
import com.northconcepts.datapipeline.core.DataReader;
import com.northconcepts.datapipeline.core.FieldList;
import com.northconcepts.datapipeline.core.RemoveDuplicatesReader;
import com.northconcepts.datapipeline.core.StreamWriter;
import com.northconcepts.datapipeline.csv.CSVReader;
import com.northconcepts.datapipeline.filter.FilterExpression;
import com.northconcepts.datapipeline.job.JobTemplate;
import com.northconcepts.datapipeline.memory.MemoryWriter;

public class SearchForARecord {
   
    public static final Logger log = DataEndpoint.log;

    public static void main(String[] args) throws Throwable {
        DataReader reader = new CSVReader(new File("example/data/input/credit-balance-01.csv"))
            .setFieldNamesInFirstRow(true);
       
        MemoryWriter memoryWriter = new  MemoryWriter();

        JobTemplate.DEFAULT.transfer(reader, memoryWriter);
       
        int index = memoryWriter.getRecordList().findFirst(
            new FilterExpression("Rating == 'B' && parseDouble(CreditLimit) > 1000"), 0);
       
        // this would work too: "Rating = 'B' and parseDouble(CreditLimit) > 1000"

        if (index >= 0) {
      log.info(memoryWriter.getRecordList().get(index));
    } else {
      log.info("no record found");
    }

       
    }
   
}

back to examples index