private void determineAffectedAddressing() throws OseeCoreException { gammaJoin.store(); try { console.writeln("counter: [%s]", counter); console.writeln("query id: [%s]", gammaJoin.getQueryId()); chStmt.runPreparedQuery(10000, SELECT_RELATION_ADDRESSING, gammaJoin.getQueryId()); while (chStmt.next()) { long obsoleteGammaId = chStmt.getLong("gamma_id"); int transactionId = chStmt.getInt("transaction_id"); long netGammaId = chStmt.getLong("net_gamma_id"); int modType = chStmt.getInt("mod_type"); TxChange txCurrent = TxChange.getChangeType(chStmt.getInt("tx_current")); if (isNextAddressing(netGammaId, transactionId)) { if (updateAddressing) { updateAddressingData.add( new Object[] { previousNetGammaId, netModType.getValue(), netTxCurrent.getValue(), previousTransactionId, previousObsoleteGammaId }); } updateAddressing = obsoleteGammaId != netGammaId; previousNetGammaId = netGammaId; previousObsoleteGammaId = obsoleteGammaId; previousTransactionId = transactionId; netModType = ModificationType.getMod(modType); netTxCurrent = txCurrent; } else { addressingToDelete.add( new Object[] {chStmt.getInt("branch_id"), transactionId, obsoleteGammaId}); computeNetAddressing(ModificationType.getMod(modType), txCurrent); } writeAddressingBackup(obsoleteGammaId, transactionId, netGammaId, modType, txCurrent); } } finally { chStmt.close(); } gammaJoin.delete(); }
private void findObsoleteRelations() throws OseeCoreException { try { chStmt.runPreparedQuery(10000, SELECT_RELATIONS); while (chStmt.next()) { int relationTypeId = chStmt.getInt("rel_link_type_id"); int artifactAId = chStmt.getInt("a_art_id"); int artiafctBId = chStmt.getInt("b_art_id"); if (isNextConceptualRelation(relationTypeId, artifactAId, artiafctBId)) { consolidate(); initNextConceptualRelation(relationTypeId, artifactAId, artiafctBId); } else { obsoleteGammas.add(chStmt.getLong("gamma_id")); relationMateriallyDiffers(chStmt); } } } finally { chStmt.close(); } }