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

[bilasini sahoo]

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 at gmail.com>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 at gmail.com>
>
>> "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
>>>
>>>
>>
>> _______________________________________________
>> 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/20110326/7453d888/attachment.html