public CFSecurityHostNodeBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey PKey) {
final String S_ProcName = "lockBuff";
CFSecurityHostNodeBuff buff = readDerived(Authorization, PKey);
if ((buff != null) && (!buff.getClassCode().equals("HSND"))) {
buff = null;
}
return (buff);
}
public CFSecurityHostNodeBuff readBuffByHostNameIdx(
CFSecurityAuthorization Authorization, long ClusterId, String HostName) {
final String S_ProcName = "CFAccRamHostNode.readBuffByHostNameIdx() ";
CFSecurityHostNodeBuff buff = readDerivedByHostNameIdx(Authorization, ClusterId, HostName);
if ((buff != null) && buff.getClassCode().equals("HSND")) {
return ((CFSecurityHostNodeBuff) buff);
} else {
return (null);
}
}
public CFSecurityHostNodeBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "CFAccRamHostNode.readAllBuff";
CFSecurityHostNodeBuff buff;
ArrayList<CFSecurityHostNodeBuff> filteredList = new ArrayList<CFSecurityHostNodeBuff>();
CFSecurityHostNodeBuff[] buffList = readAllDerived(Authorization);
for (int idx = 0; idx < buffList.length; idx++) {
buff = buffList[idx];
if ((buff != null) && buff.getClassCode().equals("HSND")) {
filteredList.add(buff);
}
}
return (filteredList.toArray(new CFSecurityHostNodeBuff[0]));
}
public CFDbTestHostNodeEditObj(ICFSecurityHostNodeObj argOrig) {
orig = argOrig;
getBuff();
CFSecurityHostNodeBuff origBuff = orig.getBuff();
buff.set(origBuff);
requiredContainerCluster = null;
}
public CFSecurityHostNodeBuff getBuff() {
if (buff == null) {
buff =
((ICFDbTestSchema) getOrigAsHostNode().getSchema().getBackingStore())
.getFactoryHostNode()
.newBuff();
buff.set(orig.getBuff());
}
return (buff);
}
public void createHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "createHostNode";
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(
((CFAccRamClusterTable) schema.getTableCluster())
.nextHostNodeIdGen(Authorization, Buff.getRequiredClusterId()));
Buff.setRequiredClusterId(pkey.getRequiredClusterId());
Buff.setRequiredHostNodeId(pkey.getRequiredHostNodeId());
CFSecurityHostNodeByClusterIdxKey keyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
keyClusterIdx.setRequiredClusterId(Buff.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey keyUDescrIdx = schema.getFactoryHostNode().newUDescrIdxKey();
keyUDescrIdx.setRequiredClusterId(Buff.getRequiredClusterId());
keyUDescrIdx.setRequiredDescription(Buff.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey keyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
keyHostNameIdx.setRequiredClusterId(Buff.getRequiredClusterId());
keyHostNameIdx.setRequiredHostName(Buff.getRequiredHostName());
// Validate unique indexes
if (dictByPKey.containsKey(pkey)) {
throw CFLib.getDefaultExceptionFactory()
.newPrimaryKeyNotNewException(getClass(), S_ProcName, pkey);
}
if (dictByUDescrIdx.containsKey(keyUDescrIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, "HostNodeUDescrIdx", keyUDescrIdx);
}
if (dictByHostNameIdx.containsKey(keyHostNameIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, "HostNodeUHostNameIdx", keyHostNameIdx);
}
// Validate foreign keys
{
boolean allNull = true;
allNull = false;
if (!allNull) {
if (null
== schema
.getTableCluster()
.readDerivedByIdIdx(Authorization, Buff.getRequiredClusterId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), S_ProcName, "Container", "HostNodeCluster", "Cluster", null);
}
}
}
// Proceed with adding the new record
dictByPKey.put(pkey, Buff);
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdictClusterIdx;
if (dictByClusterIdx.containsKey(keyClusterIdx)) {
subdictClusterIdx = dictByClusterIdx.get(keyClusterIdx);
} else {
subdictClusterIdx = new HashMap<CFSecurityHostNodePKey, CFSecurityHostNodeBuff>();
dictByClusterIdx.put(keyClusterIdx, subdictClusterIdx);
}
subdictClusterIdx.put(pkey, Buff);
dictByUDescrIdx.put(keyUDescrIdx, Buff);
dictByHostNameIdx.put(keyHostNameIdx, Buff);
}
public void deleteHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "CFAccRamHostNodeTable.deleteHostNode() ";
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(Buff.getRequiredHostNodeId());
CFSecurityHostNodeBuff existing = dictByPKey.get(pkey);
if (existing == null) {
return;
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "deleteHostNode", pkey);
}
CFSecurityHostNodeByClusterIdxKey keyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
keyClusterIdx.setRequiredClusterId(existing.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey keyUDescrIdx = schema.getFactoryHostNode().newUDescrIdxKey();
keyUDescrIdx.setRequiredClusterId(existing.getRequiredClusterId());
keyUDescrIdx.setRequiredDescription(existing.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey keyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
keyHostNameIdx.setRequiredClusterId(existing.getRequiredClusterId());
keyHostNameIdx.setRequiredHostName(existing.getRequiredHostName());
// Validate reverse foreign keys
// Delete is valid
schema
.getTableService()
.deleteServiceByHostIdx(
Authorization, Buff.getRequiredClusterId(), Buff.getRequiredHostNodeId());
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdict;
dictByPKey.remove(pkey);
subdict = dictByClusterIdx.get(keyClusterIdx);
subdict.remove(pkey);
dictByUDescrIdx.remove(keyUDescrIdx);
dictByHostNameIdx.remove(keyHostNameIdx);
}
public void updateHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(Buff.getRequiredHostNodeId());
CFSecurityHostNodeBuff existing = dictByPKey.get(pkey);
if (existing == null) {
throw CFLib.getDefaultExceptionFactory()
.newStaleCacheDetectedException(
getClass(), "updateHostNode", "Existing record not found", "HostNode", pkey);
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "updateHostNode", pkey);
}
Buff.setRequiredRevision(Buff.getRequiredRevision() + 1);
CFSecurityHostNodeByClusterIdxKey existingKeyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
existingKeyClusterIdx.setRequiredClusterId(existing.getRequiredClusterId());
CFSecurityHostNodeByClusterIdxKey newKeyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
newKeyClusterIdx.setRequiredClusterId(Buff.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey existingKeyUDescrIdx =
schema.getFactoryHostNode().newUDescrIdxKey();
existingKeyUDescrIdx.setRequiredClusterId(existing.getRequiredClusterId());
existingKeyUDescrIdx.setRequiredDescription(existing.getRequiredDescription());
CFSecurityHostNodeByUDescrIdxKey newKeyUDescrIdx =
schema.getFactoryHostNode().newUDescrIdxKey();
newKeyUDescrIdx.setRequiredClusterId(Buff.getRequiredClusterId());
newKeyUDescrIdx.setRequiredDescription(Buff.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey existingKeyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
existingKeyHostNameIdx.setRequiredClusterId(existing.getRequiredClusterId());
existingKeyHostNameIdx.setRequiredHostName(existing.getRequiredHostName());
CFSecurityHostNodeByHostNameIdxKey newKeyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
newKeyHostNameIdx.setRequiredClusterId(Buff.getRequiredClusterId());
newKeyHostNameIdx.setRequiredHostName(Buff.getRequiredHostName());
// Check unique indexes
if (!existingKeyUDescrIdx.equals(newKeyUDescrIdx)) {
if (dictByUDescrIdx.containsKey(newKeyUDescrIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), "updateHostNode", "HostNodeUDescrIdx", newKeyUDescrIdx);
}
}
if (!existingKeyHostNameIdx.equals(newKeyHostNameIdx)) {
if (dictByHostNameIdx.containsKey(newKeyHostNameIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), "updateHostNode", "HostNodeUHostNameIdx", newKeyHostNameIdx);
}
}
// Validate foreign keys
{
boolean allNull = true;
if (allNull) {
if (null
== schema
.getTableCluster()
.readDerivedByIdIdx(Authorization, Buff.getRequiredClusterId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), "updateHostNode", "Container", "HostNodeCluster", "Cluster", null);
}
}
}
// Update is valid
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdict;
dictByPKey.remove(pkey);
dictByPKey.put(pkey, Buff);
subdict = dictByClusterIdx.get(existingKeyClusterIdx);
if (subdict != null) {
subdict.remove(pkey);
}
if (dictByClusterIdx.containsKey(newKeyClusterIdx)) {
subdict = dictByClusterIdx.get(newKeyClusterIdx);
} else {
subdict = new HashMap<CFSecurityHostNodePKey, CFSecurityHostNodeBuff>();
dictByClusterIdx.put(newKeyClusterIdx, subdict);
}
subdict.put(pkey, Buff);
dictByUDescrIdx.remove(existingKeyUDescrIdx);
dictByUDescrIdx.put(newKeyUDescrIdx, Buff);
dictByHostNameIdx.remove(existingKeyHostNameIdx);
dictByHostNameIdx.put(newKeyHostNameIdx, Buff);
}
public void copyOrigToBuff() {
CFSecurityHostNodeBuff origBuff = getOrigAsHostNode().getHostNodeBuff();
CFSecurityHostNodeBuff myBuff = getHostNodeBuff();
myBuff.set(origBuff);
}
public void copyBuffToOrig() {
CFSecurityHostNodeBuff origBuff = getOrigAsHostNode().getHostNodeBuff();
CFSecurityHostNodeBuff myBuff = getHostNodeBuff();
origBuff.set(myBuff);
}
public void copyBuffToPKey() {
getPKey().setRequiredClusterId(buff.getRequiredClusterId());
getPKey().setRequiredHostNodeId(buff.getRequiredHostNodeId());
}
public void copyPKeyToBuff() {
buff.setRequiredClusterId(getPKey().getRequiredClusterId());
buff.setRequiredHostNodeId(getPKey().getRequiredHostNodeId());
}
public void deleteHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "deleteHostNode";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long ClusterId = Buff.getRequiredClusterId();
long HostNodeId = Buff.getRequiredHostNodeId();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_hostnode( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setLong(argIdx++, ClusterId);
stmtDeleteByPKey.setLong(argIdx++, HostNodeId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
resultSet = stmtDeleteByPKey.executeQuery();
if (resultSet.next()) {
boolean deleteFlag = resultSet.getBoolean(1);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 record result set to be returned by delete, not 0 rows");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void updateHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "updateHostNode";
ResultSet resultSet = null;
try {
long ClusterId = Buff.getRequiredClusterId();
long HostNodeId = Buff.getRequiredHostNodeId();
String Description = Buff.getRequiredDescription();
String HostName = Buff.getRequiredHostName();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"select * from "
+ schema.getLowerDbSchemaName()
+ ".sp_update_hostnode( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "HSND");
stmtUpdateByPKey.setLong(argIdx++, ClusterId);
stmtUpdateByPKey.setLong(argIdx++, HostNodeId);
stmtUpdateByPKey.setString(argIdx++, Description);
stmtUpdateByPKey.setString(argIdx++, HostName);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityHostNodeBuff updatedBuff = unpackHostNodeResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
Buff.setRequiredHostName(updatedBuff.getRequiredHostName());
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
protected CFSecurityHostNodeBuff unpackHostNodeResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackHostNodeResultSetToBuff";
int idxcol = 1;
CFSecurityHostNodeBuff buff = schema.getFactoryHostNode().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecurityPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecurityPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredClusterId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredHostNodeId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredHostName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
