[Freeswitch-users] Using Lua to extract TOD conditions from Database

[Jonathan Hunter]

Hi Guys,
Wonder if anyone can help.
I am testing with time of day routing, and I want to be able to check yearly/monthly conditions before weekly conditions are picked up.
I can do this successfully by just inputting XML into the dialplan, and works as expected, my issue is now when extracting the detail required from a database using lua.
I for example have 3 entries below for different times of the year;

+------------+-------+------+----------------+| dayofmonth | month | year | dayofmonthtime |+------------+-------+------+----------------+| 25         | 12    | 0    | 0              || 1          | 1     | 2016 | 540-1050       || 10-18      | 9     | 2015 | 600-840        |


So when creating directly using xml I get;
table.insert(xml, [[<condition  mon="12" mday="25"  break="on-true">]]);table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);table.insert(xml, [[</condition>]]);table.insert(xml, [[<condition year="2016" mon="1" mday="1"  break="on-true">]]);table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);table.insert(xml, [[</condition>]]);table.insert(xml, [[<condition year="2015" mon="9" mday="10-18"  break="on-true">]]);table.insert(xml, [[<action application="set" data="TOD=sales" inline="true"/>]]);table.insert(xml, [[<action application="set" data="Status=closed inline="true"/>]]);table.insert(xml, [[</condition>]]);



However my issue is when my lua script extracts them, it loops through the 3 entries (each row) , so that only the 3rd entry is available for on-wards routing as it is populating the dialplan 3 seperate times.
Can someone let me know what Im doing wrong?
Im just doing a query as;
local todnew_query = string.format("select * from timeofday_new where todname='sales' and context_name='xx.xx.xx' order by priority")                                   assert (dbh:query(todnew_query,function(todresult)
And using the result with some if statements, I wondered if anyone had any advice on this?
Thanks
Jon 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150910/2ee580f2/attachment.html