And so is the usefulness of db_text proven :-)

On 13/11/2020 16:06, Ovidiu Sas wrote:
Take a look at db_text and sql_cacher modules!

Regards,
Ovidiu Sas

On Fri, Nov 13, 2020 at 09:50 Mark Allen <[email protected] <mailto:[email protected]>> wrote:

    Just would like to consult the hive mind. I want to read the
    contents of a multi-line text file to be used by my OpenSIPS
    config. Ideally, I'll get a key:value CSV pair from the file and
    store each pair in memcache - e.g.

    file contains:

    a, 113
    b, 214
    c, 771

    read it in line by line and cache_store() with the letter as the
    attribute and the number as the value.

    I was thinking that I could use exec() to 'cat' the contents of
    the file, storing stdout in an AVP, and then work through that
    array splitting letter and number with a string transformation
    ready for cache_store(). However, if I do this the full file
    contents are stored as a single string in the first value
    with "#012" added in place of the new lines.

    Obviously, I can use a string transform s.select{} using #012 as a
    delimiter in an intermediary step, but am I just doing this the
    hard way? Is there a better way to achieve this?
    _______________________________________________
    Users mailing list
    [email protected] <mailto:[email protected]>
    http://lists.opensips.org/cgi-bin/mailman/listinfo/users

--
VoIP Embedded, Inc.
http://www.voipembedded.com

_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to