public CSqliteCopyResult(IDBResult res)
{
for( int i = 0; i < res.getColCount(); i++)
m_arColumns.addElement(res.getColName(i));
for( ; !res.isEnd(); res.next() )
{
m_arRows.addElement(res.getCurData());
}
}
public CSqliteCopyResult(IDBResult res)
{
for (int i = 0; i < res.getColCount(); i++)
{
m_arColumns.addElement(res.getColName(i));
}
for ( ; !res.isEnd(); res.next())
{
m_arRows.addElement(res.getCurData());
}
}
private String createInsertStatement(IDBResult res, String tableName)
{
String strInsert = "INSERT INTO ";
strInsert += tableName;
strInsert += "(";
String strQuest = ") VALUES(";
for (int i = 0; i < res.getColCount(); i++)
{
if (i > 0)
{
strInsert += ",";
strQuest += ",";
}
strInsert += res.getColName(i);
strQuest += "?";
}
strInsert += strQuest + ")";
return(strInsert);
}
public void updateAllAttribChanges()
{
//Check for attrib = object
IDBResult res = executeSQL("SELECT object, source_id, update_type " +
"FROM changed_values where attrib = 'object' and sent=0");
if (res.isEnd())
{
return;
}
startTransaction();
Vector <String> arObj = new Vector <String>(), arUpdateType = new Vector <String>();
Vector <int> arSrcID = new Vector <int>();
for ( ; !res.isEnd(); res.next())
{
arObj.addElement(res.getStringByIdx(0));
arSrcID.addElement(res.getIntByIdx(1));
arUpdateType.addElement(res.getStringByIdx(2));
}
for (int i = 0; i < (int)arObj.size(); i++)
{
IDBResult resSrc = executeSQL("SELECT name, schema FROM sources where source_id=?", arSrcID.elementAt(i));
boolean bSchemaSource = false;
String strTableName = "object_values";
if (!resSrc.isEnd())
{
bSchemaSource = resSrc.getStringByIdx(1).length() > 0;
if (bSchemaSource)
{
strTableName = resSrc.getStringByIdx(0);
}
}
if (bSchemaSource)
{
IDBResult res2 = executeSQL("SELECT * FROM " + strTableName + " where object=?", arObj.elementAt(i));
for (int j = 0; j < res2.getColCount(); j++)
{
String strAttrib = res2.getColName(j);
String value = res2.getStringByIdx(j);
String attribType = getAttrMgr().isBlobAttr(arSrcID.elementAt(i), strAttrib) ? "blob.file" : "";
executeSQLReportNonUnique("INSERT INTO changed_values (source_id,object,attrib,value,update_type,attrib_type,sent) VALUES(?,?,?,?,?,?,?)",
arSrcID.elementAt(i), arObj.elementAt(i), strAttrib, value, arUpdateType.elementAt(i), attribType, 0);
}
}
else
{
IDBResult res2 = executeSQL("SELECT attrib, value FROM " + strTableName + " where object=? and source_id=?",
arObj.elementAt(i), arSrcID.elementAt(i));
for ( ; !res2.isEnd(); res2.next())
{
String strAttrib = res2.getStringByIdx(0);
String value = res2.getStringByIdx(1);
String attribType = getAttrMgr().isBlobAttr(arSrcID.elementAt(i), strAttrib) ? "blob.file" : "";
executeSQLReportNonUnique("INSERT INTO changed_values (source_id,object,attrib,value,update_type,attrib_type,sent) VALUES(?,?,?,?,?,?,?)",
arSrcID.elementAt(i), arObj.elementAt(i), strAttrib, value, arUpdateType.elementAt(i), attribType, 0);
}
}
}
executeSQL("DELETE FROM changed_values WHERE attrib='object'");
endTransaction();
}
private void processDelete(String tableName, IDBResult rows2Delete, int[] cols)
{
if (tableName.equalsIgnoreCase("changed_values") || tableName.equalsIgnoreCase("sources") ||
tableName.equalsIgnoreCase("client_info"))
{
return;
}
boolean bProcessTable = tableName.equalsIgnoreCase("object_values");
boolean bSchemaSrc = false;
int nSrcID = 0;
if (!bProcessTable)
{
nSrcID = m_db.getAttrMgr().getSrcIDHasBlobsByName(tableName);
bProcessTable = nSrcID != 0;
bSchemaSrc = bProcessTable;
}
if (!bProcessTable)
{
return;
}
if (!bSchemaSrc && !isChangedCol(cols, 3)) //value
{
return;
}
for ( ; !rows2Delete.isEnd(); rows2Delete.next())
{
if (!bSchemaSrc)
{
nSrcID = rows2Delete.getIntByIdx(0);
String attrib = rows2Delete.getStringByIdx(1);
String value = rows2Delete.getStringByIdx(3);
//if (cols == null) //delete
// m_db.getAttrMgr().remove(nSrcID, attrib);
if (m_db.getAttrMgr().isBlobAttr(nSrcID, attrib))
{
processBlobDelete(nSrcID, attrib, value);
}
}
else
{
Object[] data = rows2Delete.getCurData();
for (int i = 0; i < rows2Delete.getColCount(); i++)
{
if (!isChangedCol(cols, i))
{
continue;
}
String attrib = rows2Delete.getColName(i);
if (!(data[i] is String))
{
continue;
}
String value = (String)data[i];
if (m_db.getAttrMgr().isBlobAttr(nSrcID, attrib))
{
processBlobDelete(nSrcID, attrib, value);
}
}
}
}
}
private String createInsertStatement(IDBResult res, String tableName)
{
String strInsert = "INSERT INTO ";
strInsert += tableName;
strInsert += "(";
String strQuest = ") VALUES(";
for (int i = 0; i < res.getColCount(); i++ )
{
if ( i > 0 )
{
strInsert += ",";
strQuest += ",";
}
strInsert += res.getColName(i);
strQuest += "?";
}
strInsert += strQuest + ")";
return strInsert;
}
private void processDelete(String tableName, IDBResult rows2Delete, int[] cols)
{
if ( tableName.equalsIgnoreCase("changed_values") || tableName.equalsIgnoreCase("sources") ||
tableName.equalsIgnoreCase("client_info"))
return;
boolean bProcessTable = tableName.equalsIgnoreCase("object_values");
boolean bSchemaSrc = false;
int nSrcID = 0;
if ( !bProcessTable )
{
nSrcID = m_db.getAttrMgr().getSrcIDHasBlobsByName(tableName);
bProcessTable = nSrcID != 0;
bSchemaSrc = bProcessTable;
}
if ( !bProcessTable)
return;
if ( !bSchemaSrc && !isChangedCol(cols, 3))//value
return;
for( ; !rows2Delete.isEnd(); rows2Delete.next() )
{
if ( !bSchemaSrc )
{
nSrcID = rows2Delete.getIntByIdx(0);
String attrib = rows2Delete.getStringByIdx(1);
String value = rows2Delete.getStringByIdx(3);
//if (cols == null) //delete
// m_db.getAttrMgr().remove(nSrcID, attrib);
if ( m_db.getAttrMgr().isBlobAttr(nSrcID, attrib) )
processBlobDelete(nSrcID, attrib, value);
}else
{
Object[] data = rows2Delete.getCurData();
for ( int i = 0; i < rows2Delete.getColCount(); i++ )
{
if (!isChangedCol(cols, i))
continue;
String attrib = rows2Delete.getColName(i);
if ( !(data[i] is String ) )
continue;
String value = (String)data[i];
if ( m_db.getAttrMgr().isBlobAttr(nSrcID, attrib) )
processBlobDelete(nSrcID, attrib, value);
}
}
}
}
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);
}
}
