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

(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