Hi all, This extension is added to siddhi-store-rdbms repo with the PR[1]
[1] https://github.com/wso2-extensions/siddhi-store-rdbms/pull/91 Best Regards, *Niveathika Rajendran,* *Software Engineer.* *Mobile : +94 077 903 7536* On Tue, Jun 26, 2018 at 3:11 PM Niveathika Rajendran <[email protected]> wrote: > Hi all, > > Please find the code review notes here[1]. > > [1] Updated invitation: [Code Review] Siddhi-execution-rdbms @ Tue Jun > 26, 2018 1pm - 2pm (IST) (Analytics Group) > > Best Regards, > *Niveathika Rajendran,* > *Software Engineer.* > *Mobile : +94 077 903 7536* > > > > > > On Tue, Jun 26, 2018 at 3:03 PM Niveathika Rajendran <[email protected]> > wrote: > >> 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
