Hi Chamin, Are you going to do the validation at client side. Or are you going to create a RDBMS, connect to it and get results and them compare those results with incoming stream? Can you please explain your approach?
On Mon, Oct 27, 2014 at 11:33 AM, Chamin Nalinda <[email protected]> wrote: > Hi Saneth, > > Thanks, it seems better I create db and tables and check the validity. > > Appreciate your help. > > On Mon, Oct 27, 2014 at 11:18 AM, Saneth Dharmakeerthi <[email protected]> > wrote: > >> HI Chamin, >> >> Try this and see.. [assuming that rejectedCount is a table] >> >> from inputStream [(pan == rejectedCount.pan and rejectedCount. >> rejected_count>=3) in rejectedCount)] >> select inputStream.pan >> insert into rejectedThreeTimesStream; >> >> Thanks and Best Regards, >> >> Saneth Dharmakeerthi >> Senior Software Engineer >> WSO2, Inc. >> Mobile: +94772325511 >> >> On Mon, Oct 27, 2014 at 11:09 AM, Chamin Nalinda <[email protected]> wrote: >> >>> follow the following query >>> >>> >>> // check pan count>=3 if yes rejectedThreeTimesStream >>> >>> from inputStream join rejectedCount[rejected_count>=3] >>> >>> on inputStream.pan = rejectedCount.pan >>> >>> select inputStream.pan >>> >>> insert into rejectedThreeTimesStream >>> >>> //else >>> >>> from inputStream join rejectedCount[rejectedCount <3] >>> >>> on inputStream.pan = rejectedCount.pan >>> >>> select * >>> >>> insert into OutStream >>> >>> >>> On Mon, Oct 27, 2014 at 11:04 AM, Chamin Nalinda <[email protected]> >>> wrote: >>> >>>> Hi All, >>>> >>>> What I need from the below query to check, >>>> >>>> if the rejected_count >= 3, >>>> forward stream to rejectedThreeTimesStream >>>> else >>>> forward to outStream >>>> >>>> Here, rejectedCount table is a mysql table. >>>> >>>> Is this valid (below query) ? >>>> >>>> >>>> from inputStream join rejectedCount[rejected_count>=3] >>>> >>>> on inputStream.pan = countTable.pan >>>> >>>> select inputStream.pan >>>> insert into rejectedThreeTimesStream >>>> >>>> >>>> What is the recommended way of checking a mysql db table condition with >>>> incoming stream ? >>>> >>>> Regards >>>> >>>> >>>> -- >>>> *Chamin Nalinda* >>>> >>>> Intern - Engineering >>>> WSO2 Inc. http://www.wso2.com >>>> lean.enterprise.middleware >>>> >>>> Mobile: (+94) 77 241 66 04 >>>> Linkedin: https://www.linkedin.com/in/chaminnalinda >>>> Web: http://www.ckreativity.com >>>> Blog: http://techspiro.blogspot.com/ >>>> >>>> >>> >>> >>> -- >>> *Chamin Nalinda* >>> >>> Intern - Engineering >>> WSO2 Inc. http://www.wso2.com >>> lean.enterprise.middleware >>> >>> Mobile: (+94) 77 241 66 04 >>> Linkedin: https://www.linkedin.com/in/chaminnalinda >>> Web: http://www.ckreativity.com >>> Blog: http://techspiro.blogspot.com/ >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> > > > -- > *Chamin Nalinda* > > Intern - Engineering > WSO2 Inc. http://www.wso2.com > lean.enterprise.middleware > > Mobile: (+94) 77 241 66 04 > Linkedin: https://www.linkedin.com/in/chaminnalinda > Web: http://www.ckreativity.com > Blog: http://techspiro.blogspot.com/ > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Tishan Dahanayakage Software Engineer WSO2, Inc. Mobile:+94 716481328 Disclaimer: This communication may contain privileged or other confidential information and is intended exclusively for the addressee/s. If you are not the intended recipient/s, or believe that you may have received this communication in error, please reply to the sender indicating that fact and delete the copy you received and in addition, you should not print, copy, re-transmit, disseminate, or otherwise use the information contained in this communication. Internet communications cannot be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
