public void deleteSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
final String S_ProcName = "CFAsteriskRamSecDeviceTable.deleteSecDevice() ";
CFSecuritySecDevicePKey pkey = schema.getFactorySecDevice().newPKey();
pkey.setRequiredSecUserId(Buff.getRequiredSecUserId());
pkey.setRequiredDevName(Buff.getRequiredDevName());
CFSecuritySecDeviceBuff existing = dictByPKey.get(pkey);
if (existing == null) {
return;
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "deleteSecDevice", pkey);
}
CFSecuritySecDeviceByUserIdxKey keyUserIdx = schema.getFactorySecDevice().newUserIdxKey();
keyUserIdx.setRequiredSecUserId(existing.getRequiredSecUserId());
// Validate reverse foreign keys
// Delete is valid
Map<CFSecuritySecDevicePKey, CFSecuritySecDeviceBuff> subdict;
dictByPKey.remove(pkey);
subdict = dictByUserIdx.get(keyUserIdx);
subdict.remove(pkey);
}
public void updateSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
CFSecuritySecDevicePKey pkey = schema.getFactorySecDevice().newPKey();
pkey.setRequiredSecUserId(Buff.getRequiredSecUserId());
pkey.setRequiredDevName(Buff.getRequiredDevName());
CFSecuritySecDeviceBuff existing = dictByPKey.get(pkey);
if (existing == null) {
throw CFLib.getDefaultExceptionFactory()
.newStaleCacheDetectedException(
getClass(), "updateSecDevice", "Existing record not found", "SecDevice", pkey);
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "updateSecDevice", pkey);
}
Buff.setRequiredRevision(Buff.getRequiredRevision() + 1);
CFSecuritySecDeviceByUserIdxKey existingKeyUserIdx =
schema.getFactorySecDevice().newUserIdxKey();
existingKeyUserIdx.setRequiredSecUserId(existing.getRequiredSecUserId());
CFSecuritySecDeviceByUserIdxKey newKeyUserIdx = schema.getFactorySecDevice().newUserIdxKey();
newKeyUserIdx.setRequiredSecUserId(Buff.getRequiredSecUserId());
// Check unique indexes
// Validate foreign keys
{
boolean allNull = true;
if (allNull) {
if (null
== schema
.getTableSecUser()
.readDerivedByIdIdx(Authorization, Buff.getRequiredSecUserId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), "updateSecDevice", "Container", "SecDeviceSecUser", "SecUser", null);
}
}
}
// Update is valid
Map<CFSecuritySecDevicePKey, CFSecuritySecDeviceBuff> subdict;
dictByPKey.remove(pkey);
dictByPKey.put(pkey, Buff);
subdict = dictByUserIdx.get(existingKeyUserIdx);
if (subdict != null) {
subdict.remove(pkey);
}
if (dictByUserIdx.containsKey(newKeyUserIdx)) {
subdict = dictByUserIdx.get(newKeyUserIdx);
} else {
subdict = new HashMap<CFSecuritySecDevicePKey, CFSecuritySecDeviceBuff>();
dictByUserIdx.put(newKeyUserIdx, subdict);
}
subdict.put(pkey, Buff);
}
public void deleteSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
final String S_ProcName = "deleteSecDevice";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
UUID SecUserId = Buff.getRequiredSecUserId();
String DevName = Buff.getRequiredDevName();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_secdev( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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.setString(argIdx++, SecUserId.toString());
stmtDeleteByPKey.setString(argIdx++, DevName);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
stmtDeleteByPKey.executeUpdate();
} 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 createSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
final String S_ProcName = "createSecDevice";
CFSecuritySecDevicePKey pkey = schema.getFactorySecDevice().newPKey();
pkey.setRequiredSecUserId(Buff.getRequiredSecUserId());
pkey.setRequiredDevName(Buff.getRequiredDevName());
Buff.setRequiredSecUserId(pkey.getRequiredSecUserId());
Buff.setRequiredDevName(pkey.getRequiredDevName());
CFSecuritySecDeviceByUserIdxKey keyUserIdx = schema.getFactorySecDevice().newUserIdxKey();
keyUserIdx.setRequiredSecUserId(Buff.getRequiredSecUserId());
// Validate unique indexes
if (dictByPKey.containsKey(pkey)) {
throw CFLib.getDefaultExceptionFactory()
.newPrimaryKeyNotNewException(getClass(), S_ProcName, pkey);
}
// Validate foreign keys
{
boolean allNull = true;
allNull = false;
if (!allNull) {
if (null
== schema
.getTableSecUser()
.readDerivedByIdIdx(Authorization, Buff.getRequiredSecUserId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), S_ProcName, "Container", "SecDeviceSecUser", "SecUser", null);
}
}
}
// Proceed with adding the new record
dictByPKey.put(pkey, Buff);
Map<CFSecuritySecDevicePKey, CFSecuritySecDeviceBuff> subdictUserIdx;
if (dictByUserIdx.containsKey(keyUserIdx)) {
subdictUserIdx = dictByUserIdx.get(keyUserIdx);
} else {
subdictUserIdx = new HashMap<CFSecuritySecDevicePKey, CFSecuritySecDeviceBuff>();
dictByUserIdx.put(keyUserIdx, subdictUserIdx);
}
subdictUserIdx.put(pkey, Buff);
}
public void updateSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
final String S_ProcName = "updateSecDevice";
ResultSet resultSet = null;
try {
UUID SecUserId = Buff.getRequiredSecUserId();
String DevName = Buff.getRequiredDevName();
String PubKey = Buff.getOptionalPubKey();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_update_secdev( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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++, "SDEV");
stmtUpdateByPKey.setString(argIdx++, SecUserId.toString());
stmtUpdateByPKey.setString(argIdx++, DevName);
if (PubKey != null) {
stmtUpdateByPKey.setString(argIdx++, PubKey);
} else {
stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.VARCHAR);
}
stmtUpdateByPKey.setInt(argIdx++, Revision);
try {
resultSet = stmtUpdateByPKey.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
if ((resultSet != null) && resultSet.next()) {
CFSecuritySecDeviceBuff updatedBuff = unpackSecDeviceResultSetToBuff(resultSet);
if ((resultSet != null) && resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setOptionalPubKey(updatedBuff.getOptionalPubKey());
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;
}
}
}
public void deleteSecDevice(CFSecurityAuthorization Authorization, CFSecuritySecDeviceBuff Buff) {
final String S_ProcName = "deleteSecDevice";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
UUID SecUserId = Buff.getRequiredSecUserId();
String DevName = Buff.getRequiredDevName();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_secdev( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) 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.setString(argIdx++, SecUserId.toString());
stmtDeleteByPKey.setString(argIdx++, DevName);
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;
}
}
}
