Using Server-side Jython Scripts

Function Support for Jython

• QExecutor.executeSql('sql_query'); The 'sql_query' will be executed and the result set will be converted to SqlResult. This method returns SqlResult.

• QExecutor.executeSql('sql_query', parameterList); The 'sql_query' is treated as prepared statement, parameterList should contain the values that should be used to set the variables of the prepared statement. The result set of execution will be converted to SqlResult. This method returns SqlResult.

• QExecutor.executeSql('sql_query', parameterList, convertToSqlResult); This is a convience function, the convertToSqlResult is a boolean variable which decides whether to convert the result set after execution to SqlResult or ignore it. Set to False, if don't need the SqlResult back. Converting result set to SqlResult might not be need if the result set is too large. This method returns SqlResult if convertToSqlResult is True otherwise it will return null.

• QExecutor.executeNQ('named_query_name', parameterMap); Executes other named query and will return the result.

Setting SQLRESULT

• You have to set SQLRESULT variable in JythonScript which will be sent to the client. If it is not set (or null) then the 'print statement' from the JythonScript will be captured and will be sent as text to client.

Handling Result on Client

• Jython Named Query can return either SqlResultSet or JythonResultSet, here is a generic handler.

   function handler(resultSet, error) {
       if(error != null) {
           alert("Error:" + error.message);
           return;
       } else {
           if(resultSet.type() == "JYTHON") {
               alert("RESULT: " + resultSet.getResult());
           } else if(resultSet.type() == "SQL") {
               // ... handle sql result set
           } 
       }
    }

Example1

Type: Jython

# insertNameList -- List of names to be inserted.
# selectNameList -- List of names to be selected.
# These inputs will be sent from javascript.

insertNameList = PARAMS["insertNameList"];
selectNameList = PARAMS["selectNameList"];

for insertName in insertNameList:
    QExecutor.executeSql('insert into sqljythonTable(name) values(?)', [insertName], False);

SQLRESULT = QExecutor.executeSql('select * from sqljythonTable where name in (?)', selectNameList);

In Javascript Client:

/* var params = { "insertNameList" : ["prasad", "tester"], "selectNameList" : ["prasad"] }; */

var params = new Object();
params["insertNameList"] =  ["prasad", "tester"];
params["selectNameList"] =  ["prasad"];

var ajaxdb = new Applibase.db.AjaxDb();
ajaxdb.query("testSqlJython", params, true, handler);
function handler(resultSet, error) {
    if(error != null) { alert("Error: " + error.message); }
    else {
        if(resultSet.type() == "SQL") {
            while(resultSet.next()) {
                // ...
            }
        } else if(resultSet.type() == "JYTHON") {
            alert("Result: " + resultSet.getResult());
        }
    }
}