--set default variables
        max_digits = 15;
        digit_timeout = 5000;
        debug["sql"] = true;

--connect to the database
--      require "resources.functions.database_handle";
--      dbh = database_handle('system');

DBHOST = '127.0.0.1'
DBNAME = 'fusion'
DBUSER = 'dbusername'
DBPASS = 'dbpassword'
DBPORT = 5432

local env = assert (luasql.postgres())
local dbcon = env:connect(DBNAME, DBUSER, DBPASS, DBHOST, DBPORT)
--set the api
        api = freeswitch.API();

--get the argv values
        action = argv[2];

--get the session variables
        if (session:ready()) then
                session:answer();
        end

--get the session variables
        if (session:ready()) then
                --general variables
                        dnfrom = session:getVariable("dnfrom");
                        rnoroute = session:getVariable("rnoroute");

        end


--get the routing code
        sql = "SELECT rnoroute FROM ported_number ";
        sql = sql .. "WHERE dnfrom = '" .. dnfrom .."' ";
                --set the variables

--show the results
 if (dnfrom) then
                freeswitch.consoleLog("notice", "routing code " .. dnfrom .. " dnfrom: " .. dnfrom .. "\n");
        end