[OpenSIPS-Users] Reading contents of a file - OpenSIPS 3.1

[Maxim Sobolev]

Who doubted it?! I personally think db_text is absolutely brilliant, cuts
devtesting effort 10x easily.

-Max

On Fri., Nov. 13, 2020, 7:31 a.m. johan, <johan at democon.be> wrote:

> 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 <mark at allenclan.co.uk> 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
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
> --
> VoIP Embedded, Inc.
> http://www.voipembedded.com
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20201113/b77e25ad/attachment.html>