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
