Re: [rules-users] [Drools Interest] Dynamic rule loading from DB

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