void processSyncCommand(String strCmd, JSONEntry oCmdEntry, boolean bCheckUIRequest)
{
JSONStructIterator objIter = new JSONStructIterator(oCmdEntry);
for ( ; !objIter.isEnd() && getSync().isContinueSync(); objIter.next())
{
String strObject = objIter.getCurKey();
JSONStructIterator attrIter = new JSONStructIterator(objIter.getCurValue());
try
{
if (m_bSchemaSource)
{
processServerCmd_Ver3_Schema(strCmd, strObject, attrIter);
}
else
{
for ( ; !attrIter.isEnd() && getSync().isContinueSync(); attrIter.next())
{
String strAttrib = attrIter.getCurKey();
String strValue = attrIter.getCurString();
processServerCmd_Ver3(strCmd, strObject, strAttrib, strValue);
}
}
}catch (DBException exc)
{
LOG.ERROR("Sync of server changes failed for " + getName() + ";object: " + strObject, exc);
}
if (getSyncType().compareTo("none") == 0)
{
continue;
}
if (bCheckUIRequest)
{
int nSyncObjectCount = getNotify().incLastSyncObjectCount(getID());
if (getProgressStep() > 0 && (nSyncObjectCount % getProgressStep() == 0))
{
getNotify().fireSyncNotification(this, false, RhoAppAdapter.ERR_NONE, "");
}
if (getDB().isUIWaitDB())
{
LOG.INFO("Commit transaction because of UI request.");
getDB().endTransaction();
SyncThread.sleep(1000);
getDB().startTransaction();
}
}
}
}
void processServerCmd_Ver3_Schema(String strCmd, String strObject, JSONStructIterator attrIter)
{
if (strCmd.compareTo("insert") == 0)
{
Vector <String> vecValues = new Vector <String>(), vecAttrs = new Vector <String>();
String strCols = "", strQuest = "", strSet = "";
for ( ; !attrIter.isEnd() && getSync().isContinueSync(); attrIter.next())
{
CAttrValue oAttrValue = new CAttrValue(attrIter.getCurKey(), attrIter.getCurString());
if (!processBlob(strCmd, strObject, oAttrValue))
{
continue;
}
if (strCols.length() > 0)
{
strCols += ",";
}
if (strQuest.length() > 0)
{
strQuest += ",";
}
if (strSet.length() > 0)
{
strSet += ",";
}
strCols += oAttrValue.m_strAttrib;
strQuest += "?";
strSet += oAttrValue.m_strAttrib + "=?";
vecAttrs.addElement(oAttrValue.m_strAttrib);
vecValues.addElement(oAttrValue.m_strValue);
}
vecValues.addElement(strObject);
if (strCols.length() > 0)
{
strCols += ",";
}
if (strQuest.length() > 0)
{
strQuest += ",";
}
strCols += "object";
strQuest += "?";
String strSqlInsert = "INSERT INTO ";
strSqlInsert += getName() + " (";
strSqlInsert += strCols + ") VALUES(" + strQuest + ")";
if (!getSync().isContinueSync())
{
return;
}
IDBResult resInsert = getDB().executeSQLReportNonUniqueEx(strSqlInsert, vecValues);
if (resInsert.isNonUnique())
{
String strSqlUpdate = "UPDATE ";
strSqlUpdate += getName() + " SET " + strSet + " WHERE object=?";
getDB().executeSQLEx(strSqlUpdate, vecValues);
if (getSyncType().compareTo("none") != 0)
{
// oo conflicts
for (int i = 0; i < (int)vecAttrs.size(); i++)
{
getDB().executeSQL("UPDATE changed_values SET sent=4 where object=? and attrib=? and source_id=? and sent>1",
strObject, vecAttrs.elementAt(i), getID());
}
//
}
}
if (getSyncType().compareTo("none") != 0)
{
getNotify().onObjectChanged(getID(), strObject, SyncNotify.enUpdate);
}
m_nInserted++;
}
else if (strCmd.compareTo("delete") == 0)
{
Vector <String> vecAttrs = new Vector <String>();
String strSet = "";
for ( ; !attrIter.isEnd() && getSync().isContinueSync(); attrIter.next())
{
CAttrValue oAttrValue = new CAttrValue(attrIter.getCurKey(), attrIter.getCurString());
if (strSet.length() > 0)
{
strSet += ",";
}
vecAttrs.addElement(oAttrValue.m_strAttrib);
strSet += oAttrValue.m_strAttrib + "=NULL";
}
String strSqlUpdate = "UPDATE ";
strSqlUpdate += getName() + " SET " + strSet + " WHERE object=?";
if (strSet.length() == 0 || !getSync().isContinueSync())
{
return;
}
getDB().executeSQL(strSqlUpdate, strObject);
//Remove item if all nulls
String strSelect = "SELECT * FROM " + getName() + " WHERE object=?";
IDBResult res = getDB().executeSQL(strSelect, strObject);
if (!res.isEnd())
{
boolean bAllNulls = true;
for (int i = 0; i < res.getColCount(); i++)
{
if (!res.isNullByIdx(i) && res.getColName(i).compareTo("object") != 0)
{
bAllNulls = false;
break;
}
}
if (bAllNulls)
{
String strDelete = "DELETE FROM " + getName() + " WHERE object=?";
getDB().executeSQL(strDelete, strObject);
}
}
if (getSyncType().compareTo("none") != 0)
{
getNotify().onObjectChanged(getID(), strObject, SyncNotify.enDelete);
// oo conflicts
for (int i = 0; i < (int)vecAttrs.size(); i++)
{
getDB().executeSQL("UPDATE changed_values SET sent=3 where object=? and attrib=? and source_id=?",
strObject, vecAttrs.elementAt(i), getID());
}
//
}
m_nDeleted++;
}
else if (strCmd.compareTo("links") == 0)
{
String strValue = attrIter.getCurString();
processAssociations(strObject, strValue);
String strSqlUpdate = "UPDATE ";
strSqlUpdate += getName() + " SET object=? WHERE object=?";
getDB().executeSQL(strSqlUpdate, strValue, strObject);
getDB().executeSQL("UPDATE changed_values SET object=?,sent=3 where object=? and source_id=?", strValue, strObject, getID());
getNotify().onObjectChanged(getID(), strObject, SyncNotify.enCreate);
}
}
//{"create-error":{"0_broken_object_id":{"name":"wrongname","an_attribute":"error create"},"0_broken_object_id-error":{"message":"error create"}}}
boolean processServerErrors(JSONEntry oCmds)
{
String[] arErrTypes = { "source-error", "search-error", "create-error", "update-error", "delete-error", null };
boolean bRes = false;
for (int i = 0; ; i++)
{
if (arErrTypes[i] == null)
{
break;
}
if (!oCmds.hasName(arErrTypes[i]))
{
continue;
}
bRes = true;
m_nErrCode = RhoAppAdapter.ERR_CUSTOMSYNCSERVER;
JSONEntry errSrc = oCmds.getEntry(arErrTypes[i]);
JSONStructIterator errIter = new JSONStructIterator(errSrc);
for ( ; !errIter.isEnd(); errIter.next())
{
String strKey = errIter.getCurKey();
if (i == 0 || i == 1) //"source-error", "search-error"
{
if (errIter.getCurValue().hasName("message"))
{
if (m_strServerError.length() > 0)
{
m_strServerError += "&";
}
m_strServerError += "server_errors[" + URI.urlEncode(strKey) + "][message]=" + URI.urlEncode(errIter.getCurValue().getString("message"));
}
}
else
{
//"create-error", "update-error", "delete-error"
String strObject = strKey;
if (strObject.endsWith("-error"))
{
strObject = strObject.substring(0, strKey.length() - 6);
if (m_strServerError.length() > 0)
{
m_strServerError += "&";
}
m_strServerError += "server_errors[" + arErrTypes[i] + "][" + URI.urlEncode(strObject) + "][message]=" + URI.urlEncode(errIter.getCurValue().getString("message"));
}
else
{
JSONStructIterator attrIter = new JSONStructIterator(errIter.getCurValue());
for ( ; !attrIter.isEnd(); attrIter.next())
{
String strAttrName = attrIter.getCurKey();
String strAttrValue = attrIter.getCurString();
if (m_strServerError.length() > 0)
{
m_strServerError += "&";
}
m_strServerError += "server_errors[" + arErrTypes[i] + "][" + URI.urlEncode(strObject) + "][attributes][" + URI.urlEncode(strAttrName) + "]=" + URI.urlEncode(strAttrValue);
}
}
}
}
}
return(bRes);
}