(1) If you are looking for something simple my advice would be to define a database schema that can record your type of query:

(Company=CCC && Organisation=OOO and Dept=HR) OR (Country=UK)
(Company=CCC && Organisation=OOO )and (Dept=HR OR Country=UK)

e.g.
COMPARISON_ELEMENTS_TABLE = Field, Operator, Value
COMPARISONS_TABLE = OpenBracket, COMPARISON_ELEMENT_ID, Connector, CloseBracket

Then write Java code that can convert this into a DRL string that is then handled the normal way.

(2) Firstly, I got the class name wrong. It should be org.drools.ide.common.client.modeldriven.brl.RuleModel.

We already have code that converts the RuleModel object graph into DRL. However the object model is not tided to a database schema but you could write a layer that maps database tables to these objects.

This would be quite complex but I include here to explain what I was trying to say.

With kind regards,

Mike

2011/3/25 bilasini sahoo <s.bilasini@gmail.com>
Hi,
  Thanks for the reply.
But i can i get some more idea how to implement this.
 
I dont understand the "You could also look at writing a persistence layer over FactModel which is the foregoing object model; to re-hydrate direct from structured database tables with an ORM."
 
Can you please guide me something simple.
 
Thanks,
Bilasini

2011/3/25 Michael Anstis <michael.anstis@gmail.com>
The easiest suggestion would be to store DRL in your database ;)

These is a (dieing) BRL XML format but I believe its use is discouraged (as it's essentially an XStream output of a object model).

You could also look at writing a persistence layer over FactModel which is the foregoing object model; to re-hydrate direct from structured database tables with an ORM.

Looking however at your example rules; I believe the simplest approach would be to write your own parser that generates DRL.

Have you considered Guvnor which would suit your needs ideally?

With kind regards,

Mike

2011/3/25 bilasini sahoo <s.bilasini@gmail.com>
Hi All,
   I am new to this Drool rule ingine use.
Normal drl is working for me.
But mu requirement is i need to configure all the rules in Data base and from there i need to inject to the Rule engine.This is beacuse Rules can be configured any point of time.
 
Please let me know if is there any special foemat of rule configuration is required so that creating rule file would be easier
 
currently i have configured as
 
(Company=CCC && Organisation=OOO and Dept=HR) OR (Country=UK)
(Company=CCC && Organisation=OOO )and (Dept=HR OR Country=UK)
 
 
please advice. I am stuck with this proble since 2days
 
 
Thanks,
Bilasini
 

_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users



_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users



_______________________________________________
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users