Add a Decision Table to a Pipeline
Updated: Feb 21, 2022
package com.northconcepts.datapipeline.foundations.examples.decisiontable; import java.io.File; import java.util.ArrayList; import java.util.List; import com.northconcepts.datapipeline.core.DataReader; import com.northconcepts.datapipeline.core.DataWriter; import com.northconcepts.datapipeline.core.StreamWriter; import com.northconcepts.datapipeline.csv.CSVReader; import com.northconcepts.datapipeline.foundations.decisiontable.DecisionTable; import com.northconcepts.datapipeline.foundations.decisiontable.DecisionTableOutcome; import com.northconcepts.datapipeline.foundations.decisiontable.DecisionTableReader; import com.northconcepts.datapipeline.foundations.decisiontable.DecisionTableRule; import com.northconcepts.datapipeline.foundations.expression.CalculatedField; import com.northconcepts.datapipeline.job.Job; import com.northconcepts.datapipeline.transform.SelectFields; import com.northconcepts.datapipeline.transform.TransformingReader; public class AddADecisionTableToAPipeline { public static void main(String[] args) { Listoutcomes = new ArrayList<>(); outcomes.add(new DecisionTableOutcome("Total", "${Variant Price} + Shipping")); outcomes.add(new DecisionTableOutcome("Product Type", "Type")); DecisionTable table = new DecisionTable() .addField(new CalculatedField("Variant Price", "toBigDecimal(${Variant Price})")) .addRule(new DecisionTableRule() .addCondition("Variant Price", "? == null || ? < 20") .addOutcome("Shipping", "0.00") .addOutcome(outcomes) ) .addRule(new DecisionTableRule() .addCondition("Variant Price", "? < 50") .addOutcome("Shipping", "5.00") .addOutcome(outcomes) ) .addRule(new DecisionTableRule() .addCondition("Variant Price", "? < 100") .addOutcome("Shipping", "7.00") .addOutcome(outcomes) ) .addRule(new DecisionTableRule() .addCondition("Variant Price", "? >= 100") .addOutcome(new DecisionTableOutcome("Shipping", "${Variant Price} * 0.10")) .addOutcome(outcomes) ) ; DataReader reader = new CSVReader(new File("data/input/jewelry.csv")) .setAllowMultiLineText(true) .setFieldNamesInFirstRow(true); reader = new DecisionTableReader(reader, table); reader = new TransformingReader(reader).add(new SelectFields("Title", "Handle", "Variant Price", "Shipping", "Total", "Type")); DataWriter writer = StreamWriter.newSystemOutWriter(); Job.run(reader, writer); } }