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(a)gmail.com&gt; > 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(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

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(a)gmail.com&gt; > 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(a)gmail.com&gt; > >> 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(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

(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(a)gmail.com&gt; > 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(a)gmail.com&gt; > >> 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(a)gmail.com&gt; >> >>> 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(a)lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

"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 <s.bilasini(a)gmail.com&gt; > 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 <michael.anstis(a)gmail.com&gt; > >> (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(a)gmail.com&gt; >> >>> 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(a)gmail.com&gt; >>> >>>> 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(a)gmail.com&gt; >>>> >>>>> 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(a)lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> rules-users(a)lists.jboss.org >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>> >>> _______________________________________________ >>> rules-users mailing list >>> rules-users(a)lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

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 <s.bilasini(a)gmail.com&gt;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 <michael.anstis(a)gmail.com&gt; > >> "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 <s.bilasini(a)gmail.com&gt; >> >>> 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 <michael.anstis(a)gmail.com&gt; >>> >>>> (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(a)gmail.com&gt; >>>> >>>>> 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(a)gmail.com&gt; >>>>> >>>>>> 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(a)gmail.com&gt; >>>>>> >>>>>>> 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(a)lists.jboss.org >>>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> rules-users mailing list >>>>>> rules-users(a)lists.jboss.org >>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> rules-users mailing list >>>>> rules-users(a)lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> rules-users(a)lists.jboss.org >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>> >>> _______________________________________________ >>> rules-users mailing list >>> rules-users(a)lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/rules-users >>> >>> >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users