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

[Michael Anstis]

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

> 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
>>
>>
>
> _______________________________________________
> 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/4cb80c27/attachment.html