You mean the problem with meta-data? That's still unsolved :( We're theorizing about a possible improvement for SQLbox to make it able to run custom queries.
Regards, -- Alejandro Guerrieri aguerri...@kannel.org On 02/06/2010, at 12:57, sangprabv wrote: > Hi Alex, > Is it now stable with the current CVS or SVN? > > > > sangprabv > sangpr...@gmail.com > > > On Jun 2, 2010, at 5:51 PM, Alejandro Guerrieri wrote: > >> I'd add a "default" query, so if you don't need it it would work just as it >> is now, but if you need to modify it it would be just a matter of adding the >> configuration parameters. >> >> We could also add an example with your time-aware query on the configuration >> file. >> >> Regards, >> -- >> Alejandro Guerrieri >> aguerri...@kannel.org >> >> >> >> On 02/06/2010, at 12:06, Rene Kluwen wrote: >> >>> You have a valid point there. Even two of them : ). >>> Maybe, if there has to be an extra configuration parameter, your suggestion >>> makes sense and better make the whole SQL query configurable. >>> >>> What do the others think about it? >>> >>> =+= Rene >>> >>> From: alejandro.guerri...@gmail.com [mailto:alejandro.guerri...@gmail.com] >>> Sent: woensdag 2 juni 2010 10:50 >>> To: Rene Kluwen; 'Emmanuel CHANSON' >>> Cc: Kannel Devel >>> Subject: Re: Sqlbox and scheduled pushes >>> >>> If you don't need the scheduling, the query would be heavier and would >>> break backward-compatibility. >>> BlackBerry de movistar, allí donde estés está tu oficin@ >>> >>> From: "Rene Kluwen" <rene.klu...@chimit.nl> >>> Date: Wed, 2 Jun 2010 10:47:53 +0200 >>> To: <alejandro.guerri...@gmail.com>; 'Emmanuel >>> CHANSON'<emmanuelchan...@gmail.com> >>> Cc: 'Kannel Devel'<devel@kannel.org> >>> Subject: RE: Sqlbox and scheduled pushes >>> >>> Do we really need a configuration parameter? Just a question. >>> >>> From: alejandro.guerri...@gmail.com [mailto:alejandro.guerri...@gmail.com] >>> Sent: woensdag 2 juni 2010 10:07 >>> To: Rene Kluwen; 'Emmanuel CHANSON' >>> Cc: Kannel Devel >>> Subject: Re: Sqlbox and scheduled pushes >>> >>> Hey, I've told Emmanuel already, I don't claim the copyright ;) >>> >>> I agree on adding it as is, we only need to add it to all db engines and >>> put a configuration parameter to enable it. >>> >>> Regards, >>> >>> Alex >>> BlackBerry de movistar, allí donde estés está tu oficin@ >>> >>> From: "Rene Kluwen" <rene.klu...@chimit.nl> >>> Date: Wed, 2 Jun 2010 09:08:44 +0200 >>> To: 'Emmanuel CHANSON'<emmanuelchan...@gmail.com> >>> Cc: 'Alejandro Guerrieri'<alejandro.guerri...@gmail.com>; <devel@kannel.org> >>> Subject: RE: Sqlbox and scheduled pushes >>> >>> *smile* I am having a deja-vu. I sent this patch to Alex to begin with. Heh… >>> >>> @Emmanuel: I agree with you and will suggest this on your behalf to the >>> devel mailinglist. >>> >>> @devel: Alex suggested to make this even more configurable by putting the >>> SELECT query in kannel.conf (/sqlbox.conf). >>> However, I think this gives that much extra flexibility (and maintaining >>> backward compatibility) that this quick patch can be incorporated already. >>> It is useful for a lot of persons and it is just a quick patch. >>> >>> Todo: also patch the sql statements for other storage types. >>> >>> Rene Kluwen >>> Chimit >>> >>> >>> >>> From: Emmanuel CHANSON [mailto:emmanuelchan...@gmail.com] >>> Sent: woensdag 2 juni 2010 2:46 >>> To: rene.klu...@chimit.nl >>> Cc: Alejandro Guerrieri >>> Subject: Re: Sqlbox and scheduled pushes >>> >>> Hello Rene I had sent my email to a wrong person... >>> >>> Emmanuel >>> >>> 2010/5/31 Emmanuel CHANSON <emmanuelchan...@gmail.com> >>> Hello Rene, >>> >>> I would like to tell you about sqlbox and a requirement I have done on >>> sqlbox source advised by Alex :) >>> My need was to be able to send a scheduled batch using sqlbox. >>> Alex told me first that sqlbox could not and I have to do this from the >>> application but after a while he advised me to try to patch the source like >>> this: >>> >>> in gw/sqlbox_mysql.h >>> something like: >>> SELECT sql_id, momt, sender, receiver, udhdata, \ >>> msgdata, time, smsc_id, service, account, id, sms_type, mclass, mwi, >>> coding, \ >>> compress, validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, \ >>> charset, boxc_id, binfo, meta_data FROM %S WHERE time < >>> UNIX_TIMESTAMP(NOW()) LIMIT 0,1" >>> >>> That is what I have done and it seems to work like a charm :) >>> So I wonder if this can not be proposed to others because it is something >>> very usefull...for me at least.. >>> >>> Regards, >>> >>> Emmanuel >>> >>> >>> >>> -- >>> Emmanuel >>> >>> CHANSON Emmanuel >>> Mobile Nouvelle-Calédonie: +687.77.35.02 >>> Mobile France: +33 (0) 6.68.03.89.56 >>> @email : emmanuelchan...@gmail.com >>> >>> >>> >>> -- >>> Emmanuel >>> >>> CHANSON Emmanuel >>> Mobile Nouvelle-Calédonie: +687.77.35.02 >>> Mobile France: +33 (0) 6.68.03.89.56 >>> @email : emmanuelchan...@gmail.com >> >
