[rules-users] Hibernate Configuration with Drools 5.4

[Wolfgang Laun]

On 19/06/2012, zeeshan <zeeshan.spring at gmail.com> wrote:
> Hi Laune,
>
>
>
> Thanks very much for your response.  We would like to try and implement
> Option 3.
>
> We assume that the implementation involves setting up individual rows in
> the
> excel as a collection of objects and using the From keyword to look up the
> output value/row we want based on the input parameter values.

Huh? You leave the Excel data as it is except for throwing away the
header lines.

>  Is it
> possible for you to share the relevant code you have created to implement
> this option?

This is the rule:

rule calculatePremium
when
$pfc: PremiumCalculatorFactBean( $age: age,
                          $policyTerm: policyTerm,
                          $interestRate: interestRate,
                          $gender: gender,
                          $smokingStatus: smokingStatus,
                          $channel: channel,
                          premiumRate == 0.0 )
$p: Premium( age == $age,
        policyTerm == $policyTerm,
        interestRate == $interestRate,
        gender == $gender,
        smokingStatus == $smokingStatus,
        channel == $channel )
then
   modify( $pfc ){ setPremiumRate( $p.getPremiumRate() ) }
end


And a few lines of Java code:

    private void makeRates( String csvPath ) throws Exception {
        File f = new File( csvPath );
        InputStream is = new FileInputStream( f );
        Reader rdr = new InputStreamReader( is );
	LineNumberReader lnrdr = new LineNumberReader( rdr );

        String line;
        while( (line = lnrdr.readLine()) != null ){
            if( line.charAt(0) == '"' ) continue;
            String[] tokens = line.split( ";" );
            if( tokens.length != 7 ) continue;
            int age = Integer.parseInt( tokens[0] );
            int policyTerm  = Integer.parseInt( tokens[1] );
            int interestRate = Integer.parseInt( tokens[2] );
            String gender = tokens[3].substring( 1, 2 );
            String smokingStatus = tokens[4].substring( 1, 2 );
            int channel = Integer.parseInt( tokens[5] );
            double premiumRate = Double.parseDouble( tokens[6] );

            Premium p = new Premium( age, policyTerm, interestRate,
gender, smokingStatus, channel, premiumRate );
            kSession.insert( p );
	}
	close( rdr );
    }

-W


>
> Thanks !
>
>
> --
> View this message in context:
> http://drools.46999.n3.nabble.com/Hibernate-Configuration-with-Drools-5-4-tp4017981p4018051.html
> Sent from the Drools: User forum mailing list archive at Nabble.com.
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>