You could also make MySQL trigger... in mysql triggers can call external applications trough UDF.
On Tue, May 18, 2010 at 12:16 AM, Nicolas Trani <[email protected]> wrote: > Hi, > > if your data are added to MySQL with PHP (or any other language) you can > push change to APE Server with inlinepush. > > Check the controller demo for more informations : > http://github.com/APE-Project/APE_JSF/tree/master/Demos/Controller > > Cheers. > > [email protected] a écrit : > > Hi again and thnx for your time to reply. >> >> So i guess this is not really possible. ( But ain't it a great >> idea? :D ) >> >> Thanx again for your time. >> >> On May 17, 9:04 pm, Manas B <[email protected]> wrote: >> >> >>> Hi there, >>> As i understand you are trying to push data to Ape Server when data is >>> inserted into mysql. Please make note APE is a event driven server. >>> Either there are system events or you create events by command. In the >>> instant case your event is generated at mysql side which APE server >>> has no method of knowing unless you run a process (module) on APE >>> server which will search for records in mysql. If it find record it >>> will pick and then broad cast on the channel. >>> A theoritical example would be >>> >>> function() { >>> sql.query('SELECT new_record FROM data WHERE ape_pickup = 0', >>> function(res, errorNo) { >>> if(res) { >>> Broadcast on Channel >>> sql.query('UPDATE data set ape_pickup =1 >>> } >>> }.bind(this)); >>> }).periodical(1000*60*2); >>> >>> On May 13, 1:02 am, "[email protected]" <[email protected]> >>> wrote: >>> >>> >>> >>> >>> >>> >>> >>>> Hello, >>>> i am working with APE Engine (http://www.ape-project.org) and up >>>> until >>>> now i had no actual problem. >>>> The problem is that i would like to use the MySQL module and push >>>> data >>>> to a channel each time a row is inserted into a table. >>>> I've tried to setup a server side module, i created an SQL query >>>> but >>>> data is fetched only when the server boots. >>>> How can i make this work? >>>> I've searched the entire discussion group and the docs but didn't >>>> find >>>> such a thing. Only someone that just said "It's possible" >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "APE Project" group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected]<ape-project%[email protected]> >>>> For more options, visit this group athttp:// >>>> groups.google.com/group/ape-project?hl=en >>>> --- >>>> APE Project (Ajax Push Engine) >>>> Official website :http://www.ape-project.org/ >>>> Git Hub :http://github.com/APE-Project/ >>>> >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "APE Project" group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected]<ape-project%[email protected]> >>> For more options, visit this group athttp:// >>> groups.google.com/group/ape-project?hl=en >>> --- >>> APE Project (Ajax Push Engine) >>> Official website :http://www.ape-project.org/ >>> Git Hub :http://github.com/APE-Project/ >>> >>> >> >> >> > > -- > You received this message because you are subscribed to the Google > Groups "APE Project" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<ape-project%[email protected]> > For more options, visit this group at > http://groups.google.com/group/ape-project?hl=en > --- > APE Project (Ajax Push Engine) > Official website : http://www.ape-project.org/ > Git Hub : http://github.com/APE-Project/ > -- Best regards, Žiga Ham -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ape-project?hl=en --- APE Project (Ajax Push Engine) Official website : http://www.ape-project.org/ Git Hub : http://github.com/APE-Project/
