Hi all,
As per the offline discussion, the functionality of the extension will be
changed as follows,
1. Running retrieval queries
> #rdbms:query('<datasource.name>, <query>, <atttribute.defintion.list>)
2. Running CUD queries (INSERT, UPDATE, DELETE)
> #rdbms:cud('<datasource.name>', <query>)
*This extension function should be enabled through configurations
> ('perform.cud.operation' : true) , this is disabled by default.
Moreover, in both functions, queries will be validated to disable users
performing, DROP/CREATE/ ALTER operations
Best Regards,
*Niveathika Rajendran,*
*Software Engineer.*
*Mobile : +94 077 903 7536*
On Mon, Jun 25, 2018 at 11:30 AM Niveathika Rajendran <[email protected]>
wrote:
> Hi Dilini,
>
> For now, we are supporting the following siddhi data types,
>
>
> *Siddhi DatatypeJDBC DatatypeSQL DatatypeSTRING STRINGCHAR,
> VARCHAR,
> LONGVARCHARINTINTINTEGERLONGLONGBIGINTDOUBLEDOUBLEDOUBLEFLOATFLOATREALBOOLEANBOOLEANBIT*
>
> Best Regards,
> *Niveathika Rajendran,*
> *Software Engineer.*
> *Mobile : +94 077 903 7536*
>
>
>
>
>
> On Fri, Jun 22, 2018 at 1:10 PM Dilini Muthumala <[email protected]> wrote:
>
>> Hi Niveathika,
>>
>> How does a user supposed to map the data types from RDBMS types to Siddhi
>> types? Any guidance we could provide?
>>
>> Thanks,
>> Dilini
>>
>> On Fri, Jun 22, 2018 at 1:02 PM Niveathika Rajendran <[email protected]>
>> wrote:
>>
>>> Hi Damith,
>>>
>>> We are only verifying that the query is doing only a select operation,
>>> other than that we are not doing any validation on the SQL query defined in
>>> the function. In the essence, the user can define any joins he/ she wants.
>>>
>>> The query I have added in the user story is a sample, and contains
>>> 'INNER JOIN'.
>>>
>>> Best Regards,
>>> *Niveathika Rajendran,*
>>> *Software Engineer.*
>>> *Mobile : +94 077 903 7536*
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Jun 22, 2018 at 12:55 PM Damith Wickramasinghe <[email protected]>
>>> wrote:
>>>
>>>> + architecture
>>>>
>>>> Hi Niveathika ,
>>>>
>>>> What types of joining are we supporting ? is it only INNER JOIN for
>>>> now
>>>>
>>>> Thanks,
>>>> Damith
>>>>
>>>>
>>>> On Fri, Jun 22, 2018 at 7:17 AM, Niveathika Rajendran <
>>>> [email protected]> wrote:
>>>>
>>>>> Hi all,
>>>>>
>>>>> I am currently working on $subject for Siddhi which will enable a
>>>>> Siddhi developer to run select queries with table joins on the database.
>>>>>
>>>>> The syntax of the execution extension will be as follows,
>>>>>
>>>>>> *rdbms:query(<datasource name>, <query>, <comma separated list of
>>>>> (attributeName attribute Type)>)*
>>>>>
>>>>> Please find the user story here [1].
>>>>>
>>>>> [1]
>>>>> https://docs.google.com/document/d/1mPySJKVy8-Wq3L8o6PJmtKhyY-jMjN72aLuyVivW_lc/edit?usp=sharing
>>>>>
>>>>> Best Regards,
>>>>> *Niveathika Rajendran,*
>>>>> *Software Engineer.*
>>>>> *Mobile : +94 077 903 7536*
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google
>>>>> Groups "WSO2 Engineering Group" group.
>>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>>> an email to [email protected].
>>>>> For more options, visit https://groups.google.com/a/wso2.com/d/optout.
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Senior Software Engineer
>>>> WSO2 Inc.; http://wso2.com
>>>> <http://www.google.com/url?q=http%3A%2F%2Fwso2.com&sa=D&sntz=1&usg=AFQjCNEZvyc0uMD1HhBaEGCBxs6e9fBObg>
>>>> lean.enterprise.middleware
>>>>
>>>> mobile: *+94728671315*
>>>>
>>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "WSO2 Engineering Group" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/a/wso2.com/d/optout.
>>>
>>
>>
>> --
>> *Dilini Muthumala*
>> Senior Software Engineer,
>> WSO2 Inc.
>>
>> *E-mail :* [email protected]
>> *Mobile: *+94 713-400-029
>>
>
_______________________________________________
Architecture mailing list
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
