[Freeswitch-users] Does nibble execute sql queries in single transaction ?

[Mohd Kamal Mustafa]

If not, is there a possibilities of reach condition where updates from
multiple channels override each other. For example, 2 incoming calls
at the same time to 2 different numbers, but owned by single user -
that mean nibble will be updating the same record in database.

I'm planning to add "FOR UPDATE" clause to the custom_sql_lookup:-

SELECT cash AS nibble_balance FROM accounts WHERE
account_code='${nibble_account} FOR UPDATE

But if each query run inside their own transaction, that would be no use.

Thank you.