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

[bilasini sahoo]

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/ce6b348c/attachment.html