Have a look at org.drools.ide.common.server.util.BRDRLPersistenceTest for examples.
With regard to using a Decision Table; if you're writing the code to generate the decision table from a database then you could look at the mechanisms used in org.drools.ide.common.server.util.GuidedDTDRLPersistenceTest. I stress again however, with whatever approach you use, you need to write the code that'll build the required model from a database. With kind regards, Mike 2011/3/26 bilasini sahoo <[email protected]> > For this knid of rules in DB, Is DessionTable will help... > Please let me know > > On Sat, Mar 26, 2011 at 7:01 AM, bilasini sahoo <[email protected]>wrote: > >> Hi, >> I am asking about this code >> "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" >> >> can u please let me know >> >> Thanks >> >> 2011/3/26 Michael Anstis <[email protected]> >> >>> "I am not able to get the code that creste drl file" >>> >>> This will be code that *you* write. Nothing is provided by the Drools >>> project that can generate DRL from a database. >>> >>> >>> 2011/3/25 bilasini sahoo <[email protected]> >>> >>>> Hi, >>>> Thanks for the explanation. >>>> But i am sorry still also i am not able to see the clear pictures. >>>> I am not able to get the code that creste drl file >>>> Again as far i got to know Guvnor provided an UI where rules can be >>>> configured, which is not allowed my case. >>>> >>>> Please give some more deatils >>>> >>>> 2011/3/25 Michael Anstis <[email protected]> >>>> >>>>> (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 <[email protected]> >>>>> >>>>>> 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 <[email protected]> >>>>>> >>>>>>> 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 <[email protected]> >>>>>>> >>>>>>>> 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 >>>>>>>> [email protected] >>>>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> rules-users mailing list >>>>>>> [email protected] >>>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> rules-users mailing list >>>>>> [email protected] >>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> rules-users mailing list >>>>> [email protected] >>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> [email protected] >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>> >>> _______________________________________________ >>> rules-users mailing list >>> [email protected] >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> > > _______________________________________________ > rules-users mailing list > [email protected] > https://lists.jboss.org/mailman/listinfo/rules-users > >
_______________________________________________ rules-users mailing list [email protected] https://lists.jboss.org/mailman/listinfo/rules-users
