--
--  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