package droolsbook.decisiontables.bank; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertNull; import java.io.IOException; import java.io.StringReader; import java.math.BigDecimal; import org.drools.KnowledgeBase; import org.drools.KnowledgeBaseFactory; import org.drools.RuleBase; import org.drools.RuleBaseFactory; import org.drools.StatelessSession; import org.drools.builder.DecisionTableConfiguration; import org.drools.builder.DecisionTableInputType; import org.drools.builder.KnowledgeBuilder; import org.drools.builder.KnowledgeBuilderFactory; import org.drools.builder.ResourceType; import org.drools.compiler.DecisionTableFactory; import org.drools.compiler.PackageBuilder; import org.drools.decisiontable.InputType; import org.drools.decisiontable.SpreadsheetCompiler; import org.drools.io.ResourceFactory; import org.drools.rule.Package; import org.drools.runtime.StatelessKnowledgeSession; import org.joda.time.DateMidnight; import org.junit.Before; import org.junit.BeforeClass; import org.junit.Test; import droolsbook.decisiontables.bank.model.Account; public class InterestRateDecisionTableTest { // @extract-start 04 36 static StatelessKnowledgeSession session; Account account; static DateMidnight DATE; @BeforeClass public static void setUpClass() throws Exception { KnowledgeBase knowledgeBase = createKnowledgeBaseFromSpreadsheet(); session = knowledgeBase.newStatelessKnowledgeSession(); DATE = new DateMidnight(2008, 1, 1); } @Before public void setUp() throws Exception { account = new Account(); } // @extract-end // @extract-start 04 39 private static KnowledgeBase createKnowledgeBaseFromSpreadsheet() throws Exception { DecisionTableConfiguration dtconf =KnowledgeBuilderFactory .newDecisionTableConfiguration(); dtconf.setInputType( DecisionTableInputType.XLS ); //dtconf.setInputType( DecisionTableInputType.CSV ); KnowledgeBuilder knowledgeBuilder = KnowledgeBuilderFactory.newKnowledgeBuilder(); knowledgeBuilder.add(ResourceFactory.newClassPathResource( "interest calculation.xls"), ResourceType.DTABLE, dtconf); //knowledgeBuilder.add(ResourceFactory // .newClassPathResource("interest calculation.csv"), // ResourceType.DTABLE, dtconf); if (knowledgeBuilder.hasErrors()) { throw new RuntimeException(knowledgeBuilder.getErrors() .toString()); } KnowledgeBase knowledgeBase = KnowledgeBaseFactory .newKnowledgeBase(); knowledgeBase.addKnowledgePackages( knowledgeBuilder.getKnowledgePackages()); return knowledgeBase; } // @extract-end //todo note that the xls is behind the scenes converted into a drl; it is done by the // DecisiontableFactory.loadFromInputStream method; // you can use this drl and examine its contents if it looks as you're expecting private static void method(DecisionTableConfiguration dtconf) throws Exception { // @extract-start 04 75 String drlString = DecisionTableFactory .loadFromInputStream(ResourceFactory .newClassPathResource("interest calculation.xls") .getInputStream(), dtconf); // @extract-end System.out.println(drlString); } // @extract-start 04 37 @Test public void deposit125EURfor40Days() throws Exception { account.setType(Account.Type.SAVINGS); account.setBalance(new BigDecimal("125.00")); account.setCurrency("EUR"); account.setStartDate(DATE.minusDays(40)); account.setEndDate(DATE); session.execute(account); assertEquals(new BigDecimal("3.00"), account .getInterestRate()); } // @extract-end @Test public void deposit20USDfor10Days() throws Exception { account.setType(Account.Type.SAVINGS); account.setBalance(new BigDecimal("20.00")); account.setCurrency("USD"); account.setStartDate(DATE); account.setEndDate(DATE.plusDays(10)); session.execute(account); assertEquals(BigDecimal.ZERO.setScale(2), account .getInterestRate()); } @Test public void deposit9000EURfor11months() throws Exception { account.setType(Account.Type.SAVINGS); account.setBalance(new BigDecimal("9000.00")); account.setCurrency("EUR"); account.setStartDate(DATE.minusMonths(11)); account.setEndDate(DATE); session.execute(account); assertEquals(new BigDecimal("3.75"), account .getInterestRate()); } @Test public void noInterestRate() throws Exception { account.setType(Account.Type.SAVINGS); account.setBalance(new BigDecimal("1000000.00")); account.setCurrency("EUR"); account.setStartDate(DATE.minusMonths(12)); account.setEndDate(DATE); session.execute(account); assertNull(account.getInterestRate()); } // @extract-start 04 38 @Test public void defaultTransactionalRate() throws Exception { account.setType(Account.Type.TRANSACTIONAL); account.setCurrency("EUR"); session.execute(account); assertEquals(new BigDecimal("0.01"), account .getInterestRate()); } // @extract-end @Test public void defaultStudentRate() throws Exception { account.setType(Account.Type.STUDENT); account.setBalance(new BigDecimal("150.00")); account.setCurrency("EUR"); session.execute(account); assertEquals(new BigDecimal("1.00"), account .getInterestRate()); } }