That should be possible if you are using RDBMS datastore On Wed, Jul 4, 2018 at 2:04 PM Silmy Hasan <[email protected]> wrote:
> Hi Niveathika, > > Can we write this type of join queries when creating custom widgets(in > widgetConf.json)? > > Shilmy Hasan > Associate Software Engineer | WSO2 > > E-mail :[email protected] > Phone :0779188653 > web : http://www.wso2.com > > [image: https://wso2.com/signature] <https://wso2.com/signature> > > On Wed, Jul 4, 2018 at 1:06 PM, Niveathika Rajendran <[email protected]> > wrote: > >> 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 >>>>>> >>>>> -- >> 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. >> > > -- *S. Suhothayan* Director *WSO2 Inc. * http://wso2.com <http://wso2.com/> *cell: (+94) 779 756 757 | blog: http://suhothayan.blogspot.com/ <http://suhothayan.blogspot.com/>twitter: http://twitter.com/suhothayan <http://twitter.com/suhothayan> | linked-in: http://lk.linkedin.com/in/suhothayan <http://lk.linkedin.com/in/suhothayan>*
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
