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

[bilasini sahoo]

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 at gmail.com>

> (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 at gmail.com>
>
>> 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 at gmail.com>
>>
>>> 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 at gmail.com>
>>>
>>>>   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 at lists.jboss.org
>>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> rules-users mailing list
>>> rules-users at lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>
>>>
>>
>> _______________________________________________
>> rules-users mailing list
>> rules-users at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20110325/726d54bc/attachment.html