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
