--
-- Initialization
--
-- Connect to skdb
skdb = freeswitch.Dbh("skdb");
-- Exit script if not connected
assert(skdb:connected());
--
-- Methods
--
-- Query database returning all rows
function skdbGetAll(text)
local results = {};
skdb:query(
-- Query text
text,
-- Dbh callback to iterate result set
function(row)
table.insert(results, row);
end
);
-- Return results table
return results;
end
-- Query database returning single row
function skdbGetRow(text)
return skdbGetAll(text)[1];
end