Examples with ExcelParser org.drools.decisiontable.parser.xls.ExcelParser used on opensource projects

Example 21 with ExcelParser

use of org.drools.decisiontable.parser.xls.ExcelParser in project drools-wb by kiegroup.

the class GuidedDecisionTableGeneratorListenerTest method testActions.

@Test
public void testActions() {
    final ConversionResult result = new ConversionResult();
    final List<DataListener> listeners = new ArrayList<DataListener>();
    final GuidedDecisionTableGeneratorListener listener = new GuidedDecisionTableGeneratorListener(result, dmo);
    listeners.add(listener);
    // Convert
    final ExcelParser parser = new ExcelParser(listeners);
    final InputStream is = this.getClass().getResourceAsStream("Actions.xls");
    try {
        parser.parseFile(is);
    } finally {
        try {
            is.close();
        } catch (IOException ioe) {
            fail(ioe.getMessage());
        }
    }
    // Check conversion results
    assertEquals(0, result.getMessages().size());
    // Check basics
    List<GuidedDecisionTable52> dtables = listener.getGuidedDecisionTables();
    assertNotNull(dtables);
    assertEquals(1, dtables.size());
    GuidedDecisionTable52 dtable = dtables.get(0);
    assertEquals("ActionsTest", dtable.getTableName());
    assertEquals(GuidedDecisionTable52.TableFormat.EXTENDED_ENTRY, dtable.getTableFormat());
    // Check expanded columns
    List<BaseColumn> columns = dtable.getExpandedColumns();
    assertNotNull(columns);
    assertEquals(7, columns.size());
    assertTrue(columns.get(0) instanceof RowNumberCol52);
    assertTrue(columns.get(1) instanceof DescriptionCol52);
    assertTrue(columns.get(2) instanceof BRLActionVariableColumn);
    assertTrue(columns.get(3) instanceof BRLActionVariableColumn);
    assertTrue(columns.get(4) instanceof BRLActionVariableColumn);
    assertTrue(columns.get(5) instanceof BRLActionVariableColumn);
    assertTrue(columns.get(6) instanceof BRLActionVariableColumn);
    // Check individual action columns
    assertEquals(4, dtable.getActionCols().size());
    assertTrue(dtable.getActionCols().get(0) instanceof BRLActionColumn);
    assertTrue(dtable.getActionCols().get(1) instanceof BRLActionColumn);
    assertTrue(dtable.getActionCols().get(2) instanceof BRLActionColumn);
    assertTrue(dtable.getActionCols().get(3) instanceof BRLActionColumn);
    // Column 1
    BRLActionColumn actionCol0 = ((BRLActionColumn) dtable.getActionCols().get(0));
    assertEquals("Converted from ['Multi-parameters', 'Multi-parameters']", actionCol0.getHeader());
    assertEquals(2, actionCol0.getChildColumns().size());
    List<IAction> actionCol0definition = actionCol0.getDefinition();
    assertEquals(1, actionCol0definition.size());
    assertTrue(actionCol0definition.get(0) instanceof FreeFormLine);
    FreeFormLine actionCol0ffl = (FreeFormLine) actionCol0definition.get(0);
    assertEquals("policy.setBasePrice(@{param1}, @{param2});", actionCol0ffl.getText());
    // Column 1 - Variable 1
    BRLActionVariableColumn actionCol0param0 = actionCol0.getChildColumns().get(0);
    assertEquals("param1", actionCol0param0.getVarName());
    assertEquals("Multi-parameters", actionCol0param0.getHeader());
    assertEquals(DataType.TYPE_OBJECT, actionCol0param0.getFieldType());
    assertNull(actionCol0param0.getFactType());
    assertNull(actionCol0param0.getFactField());
    // Column 1 - Variable 2
    BRLActionVariableColumn actionCol0param1 = actionCol0.getChildColumns().get(1);
    assertEquals("param2", actionCol0param1.getVarName());
    assertEquals("Multi-parameters", actionCol0param1.getHeader());
    assertEquals(DataType.TYPE_OBJECT, actionCol0param1.getFieldType());
    assertNull(actionCol0param1.getFactType());
    assertNull(actionCol0param1.getFactField());
    // Column 2
    BRLActionColumn actionCol1 = ((BRLActionColumn) dtable.getActionCols().get(1));
    assertEquals("Converted from ['Single-parameter']", actionCol1.getHeader());
    assertEquals(1, actionCol1.getChildColumns().size());
    List<IAction> actionCol1definition = actionCol1.getDefinition();
    assertEquals(1, actionCol1definition.size());
    assertTrue(actionCol1definition.get(0) instanceof FreeFormLine);
    FreeFormLine actionCol1ffl = (FreeFormLine) actionCol1definition.get(0);
    assertEquals("policy.setSmurf(@{param3});", actionCol1ffl.getText());
    // Column 2 - Variable 1
    BRLActionVariableColumn actionCol1param0 = actionCol1.getChildColumns().get(0);
    assertEquals("param3", actionCol1param0.getVarName());
    assertEquals("Single-parameter", actionCol1param0.getHeader());
    assertEquals(DataType.TYPE_OBJECT, actionCol1param0.getFieldType());
    assertNull(actionCol1param0.getFactType());
    assertNull(actionCol1param0.getFactField());
    // Column 3
    BRLActionColumn actionCol2 = ((BRLActionColumn) dtable.getActionCols().get(2));
    assertEquals("Converted from ['Log-single-parameter']", actionCol2.getHeader());
    assertEquals(1, actionCol2.getChildColumns().size());
    List<IAction> actionCol2definition = actionCol2.getDefinition();
    assertEquals(1, actionCol2definition.size());
    assertTrue(actionCol2definition.get(0) instanceof FreeFormLine);
    FreeFormLine actionCol2ffl = (FreeFormLine) actionCol2definition.get(0);
    assertEquals("System.out.println(\"@{param4}\");", actionCol2ffl.getText());
    // Column 3 - Variable 1
    BRLActionVariableColumn actionCol2param0 = actionCol2.getChildColumns().get(0);
    assertEquals("param4", actionCol2param0.getVarName());
    assertEquals("Log-single-parameter", actionCol2param0.getHeader());
    assertEquals(DataType.TYPE_OBJECT, actionCol2param0.getFieldType());
    assertNull(actionCol2param0.getFactType());
    assertNull(actionCol2param0.getFactField());
    // Column 4
    BRLActionColumn actionCol3 = ((BRLActionColumn) dtable.getActionCols().get(3));
    assertEquals("Converted from ['Zero-parameters']", actionCol3.getHeader());
    assertEquals(1, actionCol3.getChildColumns().size());
    List<IAction> actionCol3definition = actionCol3.getDefinition();
    assertEquals(1, actionCol3definition.size());
    assertTrue(actionCol3definition.get(0) instanceof FreeFormLine);
    FreeFormLine actionCol3ffl = (FreeFormLine) actionCol3definition.get(0);
    assertEquals("System.out.println(\"Woot\");", actionCol3ffl.getText());
    // Column 3 - Variable 1
    BRLActionVariableColumn actionCol3param0 = actionCol3.getChildColumns().get(0);
    assertEquals("", actionCol3param0.getVarName());
    assertEquals("Zero-parameters", actionCol3param0.getHeader());
    assertEquals(DataType.TYPE_BOOLEAN, actionCol3param0.getFieldType());
    assertNull(actionCol3param0.getFactType());
    assertNull(actionCol3param0.getFactField());
    // Check data
    assertEquals(2, dtable.getData().size());
    assertTrue(isRowEquivalent(new Object[] { 1, "Row 1", "10", "20", "30", "hello", true }, dtable.getData().get(0)));
    assertTrue(isRowEquivalent(new Object[] { 2, "Row 2", "50", "60", "70", "goodbye", false }, dtable.getData().get(1)));
}

Example 22 with ExcelParser

use of org.drools.decisiontable.parser.xls.ExcelParser in project drools-wb by kiegroup.

the class GuidedDecisionTableGeneratorListenerTest method testDurationWarnings.

@Test
public void testDurationWarnings() {
    final ConversionResult result = new ConversionResult();
    final List<DataListener> listeners = new ArrayList<DataListener>();
    final GuidedDecisionTableGeneratorListener listener = new GuidedDecisionTableGeneratorListener(result, dmo);
    listeners.add(listener);
    // Convert
    final ExcelParser parser = new ExcelParser(listeners);
    final InputStream is = this.getClass().getResourceAsStream("DurationWarnings.xls");
    try {
        parser.parseFile(is);
    } finally {
        try {
            is.close();
        } catch (IOException ioe) {
            fail(ioe.getMessage());
        }
    }
    // Check conversion results
    assertEquals(2, result.getMessages().size());
    assertEquals(ConversionMessageType.WARNING, result.getMessages().get(0).getMessageType());
    assertFalse(result.getMessages().get(0).getMessage().indexOf("Duration is not an long literal, in cell C7") == -1);
    assertEquals(ConversionMessageType.WARNING, result.getMessages().get(1).getMessageType());
    assertFalse(result.getMessages().get(1).getMessage().indexOf("Duration is not an long literal, in cell C8") == -1);
    // Check basics
    List<GuidedDecisionTable52> dtables = listener.getGuidedDecisionTables();
    assertNotNull(dtables);
    assertEquals(1, dtables.size());
    GuidedDecisionTable52 dtable = dtables.get(0);
    assertEquals("DurationWarningsTest", dtable.getTableName());
    assertEquals(GuidedDecisionTable52.TableFormat.EXTENDED_ENTRY, dtable.getTableFormat());
    // Check expanded columns
    List<BaseColumn> columns = dtable.getExpandedColumns();
    assertNotNull(columns);
    assertEquals(3, columns.size());
    assertTrue(columns.get(0) instanceof RowNumberCol52);
    assertTrue(columns.get(1) instanceof DescriptionCol52);
    assertTrue(columns.get(2) instanceof AttributeCol52);
    // Check attribute column
    AttributeCol52 attrCol2 = ((AttributeCol52) columns.get(2));
    assertEquals(GuidedDecisionTable52.DURATION_ATTR, attrCol2.getAttribute());
    assertFalse(attrCol2.isUseRowNumber());
    assertFalse(attrCol2.isReverseOrder());
    // Check data
    assertEquals(2, dtable.getData().size());
    assertTrue(isRowEquivalent(new Object[] { 1, "Rule 1", 0 }, dtable.getData().get(0)));
    assertTrue(isRowEquivalent(new Object[] { 2, "Rule 2", 0 }, dtable.getData().get(1)));
}

Example 23 with ExcelParser

use of org.drools.decisiontable.parser.xls.ExcelParser in project drools-wb by kiegroup.

the class GuidedDecisionTableGeneratorListenerTest method testRowDescriptions.

@Test
public void testRowDescriptions() {
    final ConversionResult result = new ConversionResult();
    final List<DataListener> listeners = new ArrayList<DataListener>();
    final GuidedDecisionTableGeneratorListener listener = new GuidedDecisionTableGeneratorListener(result, dmo);
    listeners.add(listener);
    // Convert
    final ExcelParser parser = new ExcelParser(listeners);
    final InputStream is = this.getClass().getResourceAsStream("MultipleRuleTables.xls");
    try {
        parser.parseFile(is);
    } finally {
        try {
            is.close();
        } catch (IOException ioe) {
            fail(ioe.getMessage());
        }
    }
    // Check conversion results
    assertEquals(0, result.getMessages().size());
    // Check basics
    final List<GuidedDecisionTable52> dtables = listener.getGuidedDecisionTables();
    assertNotNull(dtables);
    assertEquals(2, dtables.size());
    GuidedDecisionTable52 dtable = dtables.get(0);
    assertEquals(2, dtable.getData().size());
    assertEquals("Created from row 7", dtable.getData().get(0).get(1).getStringValue());
    assertEquals("Row 2", dtable.getData().get(1).get(1).getStringValue());
    dtable = dtables.get(1);
    assertEquals(2, dtable.getData().size());
    assertEquals("Row 1", dtable.getData().get(0).get(1).getStringValue());
    assertEquals("Created from row 16", dtable.getData().get(1).get(1).getStringValue());
}

Example 24 with ExcelParser

use of org.drools.decisiontable.parser.xls.ExcelParser in project drools-wb by kiegroup.

the class GuidedDecisionTableGeneratorListenerTest method testProperties.

@Test
public void testProperties() {
    final ConversionResult result = new ConversionResult();
    final List<DataListener> listeners = new ArrayList<DataListener>();
    final GuidedDecisionTableGeneratorListener listener = new GuidedDecisionTableGeneratorListener(result, dmo);
    listeners.add(listener);
    // Convert
    final ExcelParser parser = new ExcelParser(listeners);
    final InputStream is = this.getClass().getResourceAsStream("Properties.xls");
    try {
        parser.parseFile(is);
    } finally {
        try {
            is.close();
        } catch (IOException ioe) {
            fail(ioe.getMessage());
        }
    }
    // Check conversion results
    assertEquals(0, result.getMessages().size());
    // Check properties
    List<String> functions = listener.getFunctions();
    assertNotNull(functions);
    assertEquals(1, functions.size());
    assertEquals("function a() { }", functions.get(0));
    List<Global> globals = listener.getGlobals();
    assertNotNull(globals);
    assertEquals(1, globals.size());
    assertEquals("java.util.List", globals.get(0).getClassName());
    assertEquals("list", globals.get(0).getIdentifier());
    List<Import> imports = listener.getImports();
    assertNotNull(imports);
    assertEquals(2, imports.size());
    assertEquals("org.yourco.model.*", imports.get(0).getClassName());
    assertEquals("java.util.Date", imports.get(1).getClassName());
    List<String> queries = listener.getQueries();
    assertNotNull(queries);
    assertEquals(1, queries.size());
    assertEquals("A query", queries.get(0));
    List<String> types = listener.getTypeDeclarations();
    assertNotNull(types);
    assertEquals(1, types.size());
    assertEquals("declare Smurf name : String end", types.get(0));
}

Example 25 with ExcelParser

use of org.drools.decisiontable.parser.xls.ExcelParser in project drools-wb by kiegroup.

the class GuidedDecisionTableGeneratorListenerTest method testMultipleRuleTables.

@Test
public void testMultipleRuleTables() {
    final ConversionResult result = new ConversionResult();
    final List<DataListener> listeners = new ArrayList<DataListener>();
    final GuidedDecisionTableGeneratorListener listener = new GuidedDecisionTableGeneratorListener(result, dmo);
    listeners.add(listener);
    // Convert
    final ExcelParser parser = new ExcelParser(listeners);
    final InputStream is = this.getClass().getResourceAsStream("MultipleRuleTables.xls");
    try {
        parser.parseFile(is);
    } finally {
        try {
            is.close();
        } catch (IOException ioe) {
            fail(ioe.getMessage());
        }
    }
    // Check conversion results
    assertEquals(0, result.getMessages().size());
    // Check basics
    List<GuidedDecisionTable52> dtables = listener.getGuidedDecisionTables();
    assertNotNull(dtables);
    assertEquals(2, dtables.size());
    GuidedDecisionTable52 dtable0 = dtables.get(0);
    assertEquals("Table1", dtable0.getTableName());
    assertEquals(GuidedDecisionTable52.TableFormat.EXTENDED_ENTRY, dtable0.getTableFormat());
    GuidedDecisionTable52 dtable1 = dtables.get(1);
    assertEquals("Table2", dtable1.getTableName());
    assertEquals(GuidedDecisionTable52.TableFormat.EXTENDED_ENTRY, dtable1.getTableFormat());
    // Check expanded columns
    List<BaseColumn> columns0 = dtable0.getExpandedColumns();
    assertNotNull(columns0);
    assertEquals(5, columns0.size());
    assertTrue(columns0.get(0) instanceof RowNumberCol52);
    assertTrue(columns0.get(1) instanceof DescriptionCol52);
    assertTrue(columns0.get(2) instanceof AttributeCol52);
    assertTrue(columns0.get(3) instanceof BRLConditionVariableColumn);
    assertTrue(columns0.get(4) instanceof BRLActionVariableColumn);
    AttributeCol52 attrCol0_2 = ((AttributeCol52) columns0.get(2));
    assertEquals(GuidedDecisionTable52.AGENDA_GROUP_ATTR, attrCol0_2.getAttribute());
    // Check individual condition columns
    assertEquals(1, dtable0.getConditions().size());
    assertTrue(dtable0.getConditions().get(0) instanceof BRLConditionColumn);
    // Column 1
    BRLConditionColumn conditionCol0_0 = ((BRLConditionColumn) dtable0.getConditions().get(0));
    assertEquals("Converted from ['Person's name']", conditionCol0_0.getHeader());
    assertEquals(1, conditionCol0_0.getChildColumns().size());
    List<IPattern> conditionCol0_0definition = conditionCol0_0.getDefinition();
    assertEquals(1, conditionCol0_0definition.size());
    assertTrue(conditionCol0_0definition.get(0) instanceof FactPattern);
    FactPattern conditionCol0_0fp = (FactPattern) conditionCol0_0definition.get(0);
    assertEquals("Person", conditionCol0_0fp.getFactType());
    assertEquals(1, conditionCol0_0fp.getNumberOfConstraints());
    assertTrue(conditionCol0_0fp.getConstraint(0) instanceof SingleFieldConstraint);
    final SingleFieldConstraint conditionCol0_0fpsfc0 = (SingleFieldConstraint) conditionCol0_0fp.getConstraint(0);
    assertEquals("name", conditionCol0_0fpsfc0.getFieldName());
    assertEquals("==", conditionCol0_0fpsfc0.getOperator());
    assertEquals("param1", conditionCol0_0fpsfc0.getValue());
    assertEquals(SingleFieldConstraint.TYPE_TEMPLATE, conditionCol0_0fpsfc0.getConstraintValueType());
    // Column 1 - Variable 1
    BRLConditionVariableColumn conditionCol0_0param0 = conditionCol0_0.getChildColumns().get(0);
    assertEquals("param1", conditionCol0_0param0.getVarName());
    assertEquals("Person's name", conditionCol0_0param0.getHeader());
    assertEquals(DataType.TYPE_STRING, conditionCol0_0param0.getFieldType());
    assertEquals("Person", conditionCol0_0param0.getFactType());
    assertEquals("name", conditionCol0_0param0.getFactField());
    // Column 2
    BRLActionColumn actionCol0_0 = ((BRLActionColumn) dtable0.getActionCols().get(0));
    assertEquals("Converted from ['Salutation']", actionCol0_0.getHeader());
    assertEquals(1, actionCol0_0.getChildColumns().size());
    List<IAction> actionCol0_0definition = actionCol0_0.getDefinition();
    assertEquals(1, actionCol0_0definition.size());
    assertTrue(actionCol0_0definition.get(0) instanceof FreeFormLine);
    FreeFormLine actionCol0_0ffl = (FreeFormLine) actionCol0_0definition.get(0);
    assertEquals("System.out.println(\"@{param2}\");", actionCol0_0ffl.getText());
    // Column 1 - Variable 1
    BRLActionVariableColumn actionCol0_0param0 = actionCol0_0.getChildColumns().get(0);
    assertEquals("param2", actionCol0_0param0.getVarName());
    assertEquals("Salutation", actionCol0_0param0.getHeader());
    assertEquals(DataType.TYPE_OBJECT, actionCol0_0param0.getFieldType());
    assertNull(actionCol0_0param0.getFactType());
    assertNull(actionCol0_0param0.getFactField());
    // Check data
    assertEquals(2, dtable0.getData().size());
    assertTrue(isRowEquivalent(new Object[] { 1, "Created from row 7", "AG1", "John", "Hello Sir" }, dtable0.getData().get(0)));
    assertTrue(isRowEquivalent(new Object[] { 2, "Row 2", "AG2", "Jane", "Hello Madam" }, dtable0.getData().get(1)));
    // Check expanded columns
    List<BaseColumn> columns1 = dtable1.getExpandedColumns();
    assertNotNull(columns1);
    assertEquals(4, columns1.size());
    assertTrue(columns1.get(0) instanceof RowNumberCol52);
    assertTrue(columns1.get(1) instanceof DescriptionCol52);
    assertTrue(columns1.get(2) instanceof BRLConditionVariableColumn);
    assertTrue(columns1.get(3) instanceof BRLConditionVariableColumn);
    // Check individual condition columns
    assertEquals(1, dtable0.getConditions().size());
    assertTrue(dtable0.getConditions().get(0) instanceof BRLConditionColumn);
    // Column 1
    BRLConditionColumn conditionCol1_0 = ((BRLConditionColumn) dtable1.getConditions().get(0));
    assertEquals("Converted from ['Person’s name', 'Person’s age']", conditionCol1_0.getHeader());
    assertEquals(2, conditionCol1_0.getChildColumns().size());
    List<IPattern> conditionCol1_0definition = conditionCol1_0.getDefinition();
    assertEquals(1, conditionCol1_0definition.size());
    assertTrue(conditionCol1_0definition.get(0) instanceof FactPattern);
    FactPattern conditionCol1_0fp = (FactPattern) conditionCol1_0definition.get(0);
    assertEquals("Person", conditionCol1_0fp.getFactType());
    assertEquals(2, conditionCol1_0fp.getNumberOfConstraints());
    assertTrue(conditionCol1_0fp.getConstraint(0) instanceof SingleFieldConstraint);
    final SingleFieldConstraint conditionCol1_0fpsfc0 = (SingleFieldConstraint) conditionCol1_0fp.getConstraint(0);
    assertEquals("name", conditionCol1_0fpsfc0.getFieldName());
    assertEquals("==", conditionCol1_0fpsfc0.getOperator());
    assertEquals("param1", conditionCol1_0fpsfc0.getValue());
    assertEquals(SingleFieldConstraint.TYPE_TEMPLATE, conditionCol1_0fpsfc0.getConstraintValueType());
    assertTrue(conditionCol1_0fp.getConstraint(1) instanceof SingleFieldConstraint);
    final SingleFieldConstraint conditionCol1_0fpsfc1 = (SingleFieldConstraint) conditionCol1_0fp.getConstraint(1);
    assertEquals("age", conditionCol1_0fpsfc1.getFieldName());
    assertEquals("==", conditionCol1_0fpsfc1.getOperator());
    assertEquals("param2", conditionCol1_0fpsfc1.getValue());
    assertEquals(SingleFieldConstraint.TYPE_TEMPLATE, conditionCol1_0fpsfc1.getConstraintValueType());
    // Column 1 - Variable 1
    BRLConditionVariableColumn conditionCol1_0param0 = conditionCol1_0.getChildColumns().get(0);
    assertEquals("param1", conditionCol1_0param0.getVarName());
    assertEquals("Person’s name", conditionCol1_0param0.getHeader());
    assertEquals(DataType.TYPE_STRING, conditionCol1_0param0.getFieldType());
    assertEquals("Person", conditionCol1_0param0.getFactType());
    assertEquals("name", conditionCol1_0param0.getFactField());
    // Column 1 - Variable 2
    BRLConditionVariableColumn conditionCol1_0param1 = conditionCol1_0.getChildColumns().get(1);
    assertEquals("param2", conditionCol1_0param1.getVarName());
    assertEquals("Person’s age", conditionCol1_0param1.getHeader());
    assertEquals(DataType.TYPE_STRING, conditionCol1_0param1.getFieldType());
    assertEquals("Person", conditionCol1_0param1.getFactType());
    assertEquals("age", conditionCol1_0param1.getFactField());
    // Check data
    assertEquals(2, dtable1.getData().size());
    assertTrue(isRowEquivalent(new Object[] { 1, "Row 1", "John", "25" }, dtable1.getData().get(0)));
    assertTrue(isRowEquivalent(new Object[] { 2, "Created from row 16", "Jane", "29" }, dtable1.getData().get(1)));
}