[Freeswitch-dev] Function to construct a SQL "IN ()" query like switch_mprintf
Hi, I would like to know if there exists any code that would solve constructing a SQL IN query. If not, I would like to contribute one. I think of implementing something ie `switch_sqlinmprintf` which would call `base_vprintf` with a callback accepting an array of char * and formatting them with '%Q' specifier. I would greatly appreciate any help or pointers on function names implementation... -- - Aron Podrigal
I don't think we have such a thing. Can you give an example of using the theoretical function so I can understand better? On Tue, Jan 3, 2017 at 2:24 PM, Podrigal, Aron <aronp@guaranteedplus.com> wrote:
Hi,
I would like to know if there exists any code that would solve constructing a SQL IN query. If not, I would like to contribute one.
I think of implementing something ie `switch_sqlinmprintf` which would call `base_vprintf` with a callback accepting an array of char * and formatting them with '%Q' specifier.
I would greatly appreciate any help or pointers on function names implementation...
--
- Aron Podrigal
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II ♬ @anthmfs ♬ @FreeSWITCH ♬ ☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>* ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900 https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA
Here [1] is an example, where the same query may have been executed only once using IN [1] https://freeswitch.org/stash/projects/FS/repos/freeswitch/browse/src/mod/app... On Tue, Jan 3, 2017, 6:06 PM Anthony Minessale <anthony.minessale@gmail.com> wrote:
I don't think we have such a thing. Can you give an example of using the theoretical function so I can understand better?
On Tue, Jan 3, 2017 at 2:24 PM, Podrigal, Aron <aronp@guaranteedplus.com> wrote:
Hi,
I would like to know if there exists any code that would solve constructing a SQL IN query. If not, I would like to contribute one.
I think of implementing something ie `switch_sqlinmprintf` which would call `base_vprintf` with a callback accepting an array of char * and formatting them with '%Q' specifier.
I would greatly appreciate any help or pointers on function names implementation...
--
- Aron Podrigal
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II ♬ @anthmfs ♬ @FreeSWITCH ♬
☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>*
ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900
https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
Hi, What I asked for was for you to give me an example of the proposed function and how you wanted to see the syntax being used as if the function exists. On Wed, Jan 4, 2017 at 1:41 AM, Aron Podrigal <aronp@guaranteedplus.com> wrote:
Here [1] is an example, where the same query may have been executed only once using IN
[1] https://freeswitch.org/stash/projects/FS/repos/freeswitch/ browse/src/mod/applications/mod_fifo/mod_fifo.c#1671
On Tue, Jan 3, 2017, 6:06 PM Anthony Minessale < anthony.minessale@gmail.com> wrote:
I don't think we have such a thing. Can you give an example of using the theoretical function so I can understand better?
On Tue, Jan 3, 2017 at 2:24 PM, Podrigal, Aron <aronp@guaranteedplus.com> wrote:
Hi,
I would like to know if there exists any code that would solve constructing a SQL IN query. If not, I would like to contribute one.
I think of implementing something ie `switch_sqlinmprintf` which would call `base_vprintf` with a callback accepting an array of char * and formatting them with '%Q' specifier.
I would greatly appreciate any help or pointers on function names implementation...
--
- Aron Podrigal
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II ♬ @anthmfs ♬ @FreeSWITCH ♬
☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>*
ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900 <(919)%20386-9900>
https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-dev mailing list FreeSWITCH-dev@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-dev UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-dev http://www.freeswitch.org
-- Anthony Minessale II ♬ @anthmfs ♬ @FreeSWITCH ♬ ☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>* ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900 https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA
participants (3)
-
Anthony Minessale
-
Aron Podrigal
-
Podrigal, Aron