freeswitch js

sachin

use("ODBC");

try {

    if (!session) {
        console_log("ERR", "No session provided!\n");
        throw "No session provided!";
    }

    var callerId = session.getVariable("caller_id_number");
    var dialedNumber = session.getVariable("destination_number");

    console_log("INFO", "Caller: " + callerId + ", Dialed: " + dialedNumber + "\n");

    var DSN = "odbc-connector";
    var DB_USER = "user";
    var DB_PASS = "password";

    var db = new ODBC(DSN, DB_USER, DB_PASS);

    if( !db.connect() ){
        console_log("error", "SQL query failed!\n");
        throw "No session provided!";

    }else{
        var sql_query = `select cn.id_client, cn.number from client cn where cn.number = '${dialedNumber}' limit 1;`;

        if (!db.query(sql_query)) {
            console_log("error", "SQL query failed!\n");
            throw "SQL query failed!";


        } else {
            let fs_script_error = "1";
            while (db.nextRow()) {
                fs_script_error = "0";

                var row = db.getData();

                console_log("INFO", Object.keys(row).length + "\n");
                console_log("INFO", "User id_client: " + row["id_client"] + "\n");
                console_log("INFO", "User number: " + row["number"] + "\n");
                
            }

        }

        db.close();

        console_log("INFO", "DB connection closed.\n");
        session.setVariable("fs_script_error", "0");
    }

} catch (err) {
    console_log("ERR", JSON.stringify(err) + "\n");
    session.setVariable("fs_script_error", "1");
    session.setVariable("gw_priorities", "[]");

}