protected CFSecurityTenantBuff unpackTenantResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackTenantResultSetToBuff";
int idxcol = 1;
CFSecurityTenantBuff buff = schema.getFactoryTenant().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(CFAsteriskSybaseSchema.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(CFAsteriskSybaseSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredClusterId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredId(resultSet.getLong(idxcol));
idxcol++;
buff.setRequiredTenantName(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
public void updateTenant(CFSecurityAuthorization Authorization, CFSecurityTenantBuff Buff) {
final String S_ProcName = "updateTenant";
ResultSet resultSet = null;
try {
long ClusterId = Buff.getRequiredClusterId();
long Id = Buff.getRequiredId();
String TenantName = Buff.getRequiredTenantName();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"exec sp_update_tenant ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?";
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++, "TENT");
stmtUpdateByPKey.setLong(argIdx++, ClusterId);
stmtUpdateByPKey.setLong(argIdx++, Id);
stmtUpdateByPKey.setString(argIdx++, TenantName);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityTenantBuff updatedBuff = unpackTenantResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredClusterId(updatedBuff.getRequiredClusterId());
Buff.setRequiredTenantName(updatedBuff.getRequiredTenantName());
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;
}
}
}
