void processServerCmd_Ver3(String strCmd, String strObject, String strAttriba, String strValuea) { CAttrValue oAttrValue = new CAttrValue(strAttriba, strValuea); if (strCmd.compareTo("insert") == 0) { if (!processBlob(strCmd, strObject, oAttrValue)) { return; } IDBResult resInsert = getDB().executeSQLReportNonUnique("INSERT INTO object_values " + "(attrib, source_id, object, value) VALUES(?,?,?,?)", oAttrValue.m_strAttrib, getID(), strObject, oAttrValue.m_strValue); if (resInsert.isNonUnique()) { getDB().executeSQL("UPDATE object_values " + "SET value=? WHERE object=? and attrib=? and source_id=?", oAttrValue.m_strValue, strObject, oAttrValue.m_strAttrib, getID()); if (getSyncType().compareTo("none") != 0) { // oo conflicts getDB().executeSQL("UPDATE changed_values SET sent=4 where object=? and attrib=? and source_id=? and sent>1", strObject, oAttrValue.m_strAttrib, getID()); // } } if (getSyncType().compareTo("none") != 0) { getNotify().onObjectChanged(getID(), strObject, SyncNotify.enUpdate); } m_nInserted++; } else if (strCmd.compareTo("delete") == 0) { getDB().executeSQL("DELETE FROM object_values where object=? and attrib=? and source_id=?", strObject, oAttrValue.m_strAttrib, getID()); if (getSyncType().compareTo("none") != 0) { getNotify().onObjectChanged(getID(), strObject, SyncNotify.enDelete); // oo conflicts getDB().executeSQL("UPDATE changed_values SET sent=3 where object=? and attrib=? and source_id=?", strObject, oAttrValue.m_strAttrib, getID()); // } m_nDeleted++; } else if (strCmd.compareTo("links") == 0) { processAssociations(strObject, oAttrValue.m_strValue); getDB().executeSQL("UPDATE object_values SET object=? where object=? and source_id=?", oAttrValue.m_strValue, strObject, getID()); getDB().executeSQL("UPDATE changed_values SET object=?,sent=3 where object=? and source_id=?", oAttrValue.m_strValue, strObject, getID()); getNotify().onObjectChanged(getID(), strObject, SyncNotify.enCreate); } }
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); } }