public void deleteFeeByAcctIdx( CFSecurityAuthorization Authorization, long argTenantId, long argAccountId) { CFAccFeeByAcctIdxKey key = schema.getFactoryFee().newAcctIdxKey(); key.setRequiredTenantId(argTenantId); key.setRequiredAccountId(argAccountId); deleteFeeByAcctIdx(Authorization, key); }
public void deleteFee(CFSecurityAuthorization Authorization, CFAccFeeBuff Buff) { final String S_ProcName = "CFAccRamFeeTable.deleteFee() "; CFAccFeePKey pkey = schema.getFactoryFee().newPKey(); pkey.setRequiredTenantId(Buff.getRequiredTenantId()); pkey.setRequiredFeeId(Buff.getRequiredFeeId()); CFAccFeeBuff existing = dictByPKey.get(pkey); if (existing == null) { return; } if (existing.getRequiredRevision() != Buff.getRequiredRevision()) { throw CFLib.getDefaultExceptionFactory() .newCollisionDetectedException(getClass(), "deleteFee", pkey); } CFAccFeeByDateIdxKey keyDateIdx = schema.getFactoryFee().newDateIdxKey(); keyDateIdx.setRequiredTenantId(existing.getRequiredTenantId()); keyDateIdx.setRequiredAccountId(existing.getRequiredAccountId()); keyDateIdx.setRequiredFeeDate(existing.getRequiredFeeDate()); CFAccFeeByTenantIdxKey keyTenantIdx = schema.getFactoryFee().newTenantIdxKey(); keyTenantIdx.setRequiredTenantId(existing.getRequiredTenantId()); CFAccFeeByAcctIdxKey keyAcctIdx = schema.getFactoryFee().newAcctIdxKey(); keyAcctIdx.setRequiredTenantId(existing.getRequiredTenantId()); keyAcctIdx.setRequiredAccountId(existing.getRequiredAccountId()); CFAccFeeByLedgerIdxKey keyLedgerIdx = schema.getFactoryFee().newLedgerIdxKey(); keyLedgerIdx.setOptionalLedgerTenantId(existing.getOptionalLedgerTenantId()); keyLedgerIdx.setOptionalLedgerId(existing.getOptionalLedgerId()); // Validate reverse foreign keys // Delete is valid schema .getTableFeeDetail() .deleteFeeDetailByFeeIdx( Authorization, Buff.getRequiredTenantId(), Buff.getRequiredFeeId()); Map<CFAccFeePKey, CFAccFeeBuff> subdict; dictByPKey.remove(pkey); subdict = dictByDateIdx.get(keyDateIdx); subdict.remove(pkey); subdict = dictByTenantIdx.get(keyTenantIdx); subdict.remove(pkey); subdict = dictByAcctIdx.get(keyAcctIdx); subdict.remove(pkey); subdict = dictByLedgerIdx.get(keyLedgerIdx); subdict.remove(pkey); }
public CFSecurityCursor openFeeCursorByAcctIdx( CFSecurityAuthorization Authorization, long TenantId, long AccountId) { CFSecurityCursor cursor; CFAccFeeByAcctIdxKey key = schema.getFactoryFee().newAcctIdxKey(); key.setRequiredTenantId(TenantId); key.setRequiredAccountId(AccountId); if (dictByAcctIdx.containsKey(key)) { Map<CFAccFeePKey, CFAccFeeBuff> subdictAcctIdx = dictByAcctIdx.get(key); cursor = new CFAccRamFeeCursor(Authorization, schema, subdictAcctIdx.values()); } else { cursor = new CFAccRamFeeCursor(Authorization, schema, new ArrayList<CFAccFeeBuff>()); } return (cursor); }
public CFAccFeeBuff[] readDerivedByAcctIdx( CFSecurityAuthorization Authorization, long TenantId, long AccountId) { final String S_ProcName = "CFAccRamFee.readDerivedByAcctIdx"; CFAccFeeByAcctIdxKey key = schema.getFactoryFee().newAcctIdxKey(); key.setRequiredTenantId(TenantId); key.setRequiredAccountId(AccountId); CFAccFeeBuff[] recArray; if (dictByAcctIdx.containsKey(key)) { Map<CFAccFeePKey, CFAccFeeBuff> subdictAcctIdx = dictByAcctIdx.get(key); recArray = new CFAccFeeBuff[subdictAcctIdx.size()]; Iterator<CFAccFeeBuff> iter = subdictAcctIdx.values().iterator(); int idx = 0; while (iter.hasNext()) { recArray[idx++] = iter.next(); } } else { Map<CFAccFeePKey, CFAccFeeBuff> subdictAcctIdx = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByAcctIdx.put(key, subdictAcctIdx); recArray = new CFAccFeeBuff[0]; } return (recArray); }
public void createFee(CFSecurityAuthorization Authorization, CFAccFeeBuff Buff) { final String S_ProcName = "createFee"; CFAccFeePKey pkey = schema.getFactoryFee().newPKey(); pkey.setRequiredTenantId(Buff.getRequiredTenantId()); pkey.setRequiredFeeId( ((CFAccRamTenantTable) schema.getTableTenant()) .nextFeeIdGen(Authorization, Buff.getRequiredTenantId())); Buff.setRequiredTenantId(pkey.getRequiredTenantId()); Buff.setRequiredFeeId(pkey.getRequiredFeeId()); CFAccFeeByDateIdxKey keyDateIdx = schema.getFactoryFee().newDateIdxKey(); keyDateIdx.setRequiredTenantId(Buff.getRequiredTenantId()); keyDateIdx.setRequiredAccountId(Buff.getRequiredAccountId()); keyDateIdx.setRequiredFeeDate(Buff.getRequiredFeeDate()); CFAccFeeByTenantIdxKey keyTenantIdx = schema.getFactoryFee().newTenantIdxKey(); keyTenantIdx.setRequiredTenantId(Buff.getRequiredTenantId()); CFAccFeeByAcctIdxKey keyAcctIdx = schema.getFactoryFee().newAcctIdxKey(); keyAcctIdx.setRequiredTenantId(Buff.getRequiredTenantId()); keyAcctIdx.setRequiredAccountId(Buff.getRequiredAccountId()); CFAccFeeByLedgerIdxKey keyLedgerIdx = schema.getFactoryFee().newLedgerIdxKey(); keyLedgerIdx.setOptionalLedgerTenantId(Buff.getOptionalLedgerTenantId()); keyLedgerIdx.setOptionalLedgerId(Buff.getOptionalLedgerId()); // Validate unique indexes if (dictByPKey.containsKey(pkey)) { throw CFLib.getDefaultExceptionFactory() .newPrimaryKeyNotNewException(getClass(), S_ProcName, pkey); } // Validate foreign keys { boolean allNull = true; allNull = false; allNull = false; if (!allNull) { if (null == schema .getTableAccount() .readDerivedByIdIdx( Authorization, Buff.getRequiredTenantId(), Buff.getRequiredAccountId())) { throw CFLib.getDefaultExceptionFactory() .newUnresolvedRelationException( getClass(), S_ProcName, "Container", "Account", "Account", null); } } } { boolean allNull = true; allNull = false; if (!allNull) { if (null == schema .getTableTenant() .readDerivedByIdIdx(Authorization, Buff.getRequiredTenantId())) { throw CFLib.getDefaultExceptionFactory() .newUnresolvedRelationException( getClass(), S_ProcName, "Owner", "Tenant", "Tenant", null); } } } // Proceed with adding the new record dictByPKey.put(pkey, Buff); Map<CFAccFeePKey, CFAccFeeBuff> subdictDateIdx; if (dictByDateIdx.containsKey(keyDateIdx)) { subdictDateIdx = dictByDateIdx.get(keyDateIdx); } else { subdictDateIdx = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByDateIdx.put(keyDateIdx, subdictDateIdx); } subdictDateIdx.put(pkey, Buff); Map<CFAccFeePKey, CFAccFeeBuff> subdictTenantIdx; if (dictByTenantIdx.containsKey(keyTenantIdx)) { subdictTenantIdx = dictByTenantIdx.get(keyTenantIdx); } else { subdictTenantIdx = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByTenantIdx.put(keyTenantIdx, subdictTenantIdx); } subdictTenantIdx.put(pkey, Buff); Map<CFAccFeePKey, CFAccFeeBuff> subdictAcctIdx; if (dictByAcctIdx.containsKey(keyAcctIdx)) { subdictAcctIdx = dictByAcctIdx.get(keyAcctIdx); } else { subdictAcctIdx = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByAcctIdx.put(keyAcctIdx, subdictAcctIdx); } subdictAcctIdx.put(pkey, Buff); Map<CFAccFeePKey, CFAccFeeBuff> subdictLedgerIdx; if (dictByLedgerIdx.containsKey(keyLedgerIdx)) { subdictLedgerIdx = dictByLedgerIdx.get(keyLedgerIdx); } else { subdictLedgerIdx = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByLedgerIdx.put(keyLedgerIdx, subdictLedgerIdx); } subdictLedgerIdx.put(pkey, Buff); }
public void updateFee(CFSecurityAuthorization Authorization, CFAccFeeBuff Buff) { CFAccFeePKey pkey = schema.getFactoryFee().newPKey(); pkey.setRequiredTenantId(Buff.getRequiredTenantId()); pkey.setRequiredFeeId(Buff.getRequiredFeeId()); CFAccFeeBuff existing = dictByPKey.get(pkey); if (existing == null) { throw CFLib.getDefaultExceptionFactory() .newStaleCacheDetectedException( getClass(), "updateFee", "Existing record not found", "Fee", pkey); } if (existing.getRequiredRevision() != Buff.getRequiredRevision()) { throw CFLib.getDefaultExceptionFactory() .newCollisionDetectedException(getClass(), "updateFee", pkey); } Buff.setRequiredRevision(Buff.getRequiredRevision() + 1); CFAccFeeByDateIdxKey existingKeyDateIdx = schema.getFactoryFee().newDateIdxKey(); existingKeyDateIdx.setRequiredTenantId(existing.getRequiredTenantId()); existingKeyDateIdx.setRequiredAccountId(existing.getRequiredAccountId()); existingKeyDateIdx.setRequiredFeeDate(existing.getRequiredFeeDate()); CFAccFeeByDateIdxKey newKeyDateIdx = schema.getFactoryFee().newDateIdxKey(); newKeyDateIdx.setRequiredTenantId(Buff.getRequiredTenantId()); newKeyDateIdx.setRequiredAccountId(Buff.getRequiredAccountId()); newKeyDateIdx.setRequiredFeeDate(Buff.getRequiredFeeDate()); CFAccFeeByTenantIdxKey existingKeyTenantIdx = schema.getFactoryFee().newTenantIdxKey(); existingKeyTenantIdx.setRequiredTenantId(existing.getRequiredTenantId()); CFAccFeeByTenantIdxKey newKeyTenantIdx = schema.getFactoryFee().newTenantIdxKey(); newKeyTenantIdx.setRequiredTenantId(Buff.getRequiredTenantId()); CFAccFeeByAcctIdxKey existingKeyAcctIdx = schema.getFactoryFee().newAcctIdxKey(); existingKeyAcctIdx.setRequiredTenantId(existing.getRequiredTenantId()); existingKeyAcctIdx.setRequiredAccountId(existing.getRequiredAccountId()); CFAccFeeByAcctIdxKey newKeyAcctIdx = schema.getFactoryFee().newAcctIdxKey(); newKeyAcctIdx.setRequiredTenantId(Buff.getRequiredTenantId()); newKeyAcctIdx.setRequiredAccountId(Buff.getRequiredAccountId()); CFAccFeeByLedgerIdxKey existingKeyLedgerIdx = schema.getFactoryFee().newLedgerIdxKey(); existingKeyLedgerIdx.setOptionalLedgerTenantId(existing.getOptionalLedgerTenantId()); existingKeyLedgerIdx.setOptionalLedgerId(existing.getOptionalLedgerId()); CFAccFeeByLedgerIdxKey newKeyLedgerIdx = schema.getFactoryFee().newLedgerIdxKey(); newKeyLedgerIdx.setOptionalLedgerTenantId(Buff.getOptionalLedgerTenantId()); newKeyLedgerIdx.setOptionalLedgerId(Buff.getOptionalLedgerId()); // Check unique indexes // Validate foreign keys { boolean allNull = true; if (allNull) { if (null == schema .getTableAccount() .readDerivedByIdIdx( Authorization, Buff.getRequiredTenantId(), Buff.getRequiredAccountId())) { throw CFLib.getDefaultExceptionFactory() .newUnresolvedRelationException( getClass(), "updateFee", "Container", "Account", "Account", null); } } } { boolean allNull = true; if (allNull) { if (null == schema .getTableTenant() .readDerivedByIdIdx(Authorization, Buff.getRequiredTenantId())) { throw CFLib.getDefaultExceptionFactory() .newUnresolvedRelationException( getClass(), "updateFee", "Owner", "Tenant", "Tenant", null); } } } // Update is valid Map<CFAccFeePKey, CFAccFeeBuff> subdict; dictByPKey.remove(pkey); dictByPKey.put(pkey, Buff); subdict = dictByDateIdx.get(existingKeyDateIdx); if (subdict != null) { subdict.remove(pkey); } if (dictByDateIdx.containsKey(newKeyDateIdx)) { subdict = dictByDateIdx.get(newKeyDateIdx); } else { subdict = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByDateIdx.put(newKeyDateIdx, subdict); } subdict.put(pkey, Buff); subdict = dictByTenantIdx.get(existingKeyTenantIdx); if (subdict != null) { subdict.remove(pkey); } if (dictByTenantIdx.containsKey(newKeyTenantIdx)) { subdict = dictByTenantIdx.get(newKeyTenantIdx); } else { subdict = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByTenantIdx.put(newKeyTenantIdx, subdict); } subdict.put(pkey, Buff); subdict = dictByAcctIdx.get(existingKeyAcctIdx); if (subdict != null) { subdict.remove(pkey); } if (dictByAcctIdx.containsKey(newKeyAcctIdx)) { subdict = dictByAcctIdx.get(newKeyAcctIdx); } else { subdict = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByAcctIdx.put(newKeyAcctIdx, subdict); } subdict.put(pkey, Buff); subdict = dictByLedgerIdx.get(existingKeyLedgerIdx); if (subdict != null) { subdict.remove(pkey); } if (dictByLedgerIdx.containsKey(newKeyLedgerIdx)) { subdict = dictByLedgerIdx.get(newKeyLedgerIdx); } else { subdict = new HashMap<CFAccFeePKey, CFAccFeeBuff>(); dictByLedgerIdx.put(newKeyLedgerIdx, subdict); } subdict.put(pkey, Buff); }