[Freeswitch-users] Issue with database updates
Michael Jerris
mike at jerris.com
Mon Oct 9 18:34:19 UTC 2017
it updates them with the values in channel vars.
> On Oct 8, 2017, at 2:13 PM, Rick Jarvis <rick at magicmail.mooo.com> wrote:
>
> I had resorted to updating the table directly through SQL as FS doesn't appear to dynamically update the table if I use uuid_setvar :/
>
>> On 8 Oct 2017, at 19:05, Vallimamod Abdullah <vma at vallimamod.org <mailto:vma at vallimamod.org>> wrote:
>>
>> Hi,
>>
>> I am not sure how you are updating these columns but if you are doing it directly through sql, I don't think it's the correct way.
>> To set or update a value on a "presence data" column, you have to define or update a channel variable with the same name as the column. If there is no variable defined, the corresponding column will be set to NULL on the state change.
>>
>> Hope this helps.
>>
>> Best Regards,
>> --
>> Vallimamod Abdullah
>> SIP Solutions
>> vma at sipsolutions.fr <mailto:vma at sipsolutions.fr>
>> tel: +33 6 62 60 68 97
>> .
>>
>>> On 8 Oct 2017, at 16:50, Rick Jarvis <rick at magicmail.mooo.com <mailto:rick at magicmail.mooo.com>> wrote:
>>>
>>> Is there any reason why FS iterates through all the fields in the channels table, when it updates a field? I’ve created some custom columns (as per https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols <https://freeswitch.org/confluence/display/FREESWITCH/Variable+presence+data+cols>) but the values I’m writing to my new columns are being overwritten when FS changes the channel state - it appears from the logs that this is due to FS reading the values from the table, and then setting every column (including my custom fields) when it then updates … to me this is counter-intuitive as far as SQL goes!?
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20171009/45fd22e4/attachment.html>
More information about the FreeSWITCH-users
mailing list