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
