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); }