RemoteDataAdapter

Overview

The RemoteDataAdapter component provides client-side access to a set of data tables published on the server. It encapsulates all the information needed to communicate with the server (via a Remote Service) and to encode and decode data for the wire via a Data Streamer.

Creation

Create an instance of RemoteDataAdapter before actually getting the data from the server.

New API:

var rda = new RemObjects.DataAbstract.RemoteDataAdapter("http://" + window.location.host + "/JSON");
//Defautls are:
//data service name = "DataService"
//login service name = "LoginService"
//sreamer class = Bin2DataStreamer

var rda = new RemObjects.DataAbstract.RemoteDataAdapter("http://" + window.location.host + "/JSON", "MyDataService", "MyLoginService", RemObjects.DataAbstract.JSONDataStreamer);

Old API:

var channel = new RemObjects.SDK.HTTPClientChannel("http://" + window.location.host + "/JSON");
var message = new RemObjects.SDK.JSONMessage();
var service = new RemObjects.SDK.RemoteService(channel, message, "DASampleService");
var loginService = new RemObjects.SDK.RemoteService(channel, message, "LoginService");
var rda = new RemObjects.DataAbstract.RemoteDataAdapter(service, loginService, RemObjects.DataAbstract.Bin2DataStreamer);

Retrieving the data

var workersTable = new RemObjects.DataAbstract.DataTable("workers");

rda.getData([workersTable], RemObjects.DataAbstract.Util.createRequestInfo(true, -1, `, []), function() {
    alert("Table Workers has " workersTable.rows.length + " records";
}, RemObjects.UTIL.showError);

Updating the data

workersTable.first();
workersTable.setFieldValue("FirstName", "John");

rda.applyUpdates([workersTable], function() {
    alert("Updated successfully";
}, RemObjects.UTIL.showError);

DA SQL

var workersTable = new RemObjects.DataAbstract.DataTable("workers");

rda.getSQLData(workersTable, "select * from workers where name ='John'", function() {
    if (workersTable.rows.length > 0) 
        alert("found!")
    else
        alert("not found");
}, RemObjects.UTIL.showError);

Please note that getSQLData can accept TableRequestInfoV6 as a second parameter where you can set SQL query and params.

var userTable = new RemObjects.DataAbstract.DataTable("");
var param = new DataParameter();
param.Name.value = "p_name";
param.Value.value = "John Smith";
adapter.getSQLData(userTable,
    RemObjects.DataAbstract.Util.createRequestInfoV6("select id from users where displayname = :p_name", -1, "", [param]),
    function () {
        userTable.first();
        alert(userTable.getFieldValue("id"));
}, RemObjects.UTIL.showError);

Location

DataAbstract.js

• Ancestry: RemoteDataAdapter

function constructor RemoteDataAdapter(aURL, aDataServiceName, aLoginServiceName, aStreamerClass)

function applyUpdates(aTable, onSuccess, onError)

function createStreamer()

function createTableFromSchema(aTableName, aTable, aCallback)

function executeCommand(aName, aParameters, onSuccess, onError)

function getAutoGetScripts()

function getData(aTable, aRequestInfo, onSuccess, onError)

function getDataService()

function getLoginService()

function getSchema(aFilter, aCallback, onFailure)

function getSQLData(aTable, aSQL, onSuccess, onError)

function login(aUserID, aPassword, aConnectionName, onSuccessFunction, onErrorFunction)

function logout(onSuccessFunction, onErrorFunction)

function onChangeFail(aData)

adapter.onLoginNeeded = function (aCallback) { 
    this.login("John", "John", function(msg) {
        if (aCallback)
                aCallback();
    }, RemObjects.UTIL.showError);
}

function onLoginNeeded(aCallback)

function setAutoGetScripts(aValue)

function setSendReducedDelta(aValue)