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