public String expandBody(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFBindHasSecUserDefaultDevSecUserId";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext.getGenDef()");
}
if (genDef instanceof ICFAsteriskSecUserObj) {
UUID defaultDevSecUserId = ((ICFAsteriskSecUserObj) genDef).getOptionalDefaultDevSecUserId();
if (defaultDevSecUserId != null) {
return ("yes");
} else {
return ("no");
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "genContext.getGenDef()", genDef, "ICFAsteriskSecUserObj");
}
}
public ICFLibAnyObj dereference(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFReferenceTSecGroupTenant.dereference() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext.getGenDef()");
}
ICFAsteriskTenantObj obj;
if (genDef instanceof ICFAsteriskTSecGroupObj) {
obj = (ICFAsteriskTenantObj) ((ICFAsteriskTSecGroupObj) genDef).getRequiredContainerTenant();
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "genContext.getGenDef()", genDef, "ICFAsteriskTSecGroupObj");
}
return (obj);
}
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 String expandBody(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFBindSecAppSecAppId.expandBody() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext.getGenDef()");
}
String ret;
if (genDef instanceof ICFAsteriskSecAppObj) {
int secAppId = ((ICFAsteriskSecAppObj) genDef).getRequiredSecAppId();
ret = Integer.toString(secAppId);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), "expandBody", "genContext.getGenDef()", genDef, "ICFAsteriskSecAppObj");
}
return (ret);
}
public long nextTSecGroupMemberIdGen(
CFSecurityAuthorization Authorization, CFSecurityTenantPKey PKey) {
final String S_ProcName = "nextTSecGroupMemberIdGen";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Not in a transaction");
}
Connection cnx = schema.getCnx();
long Id = PKey.getRequiredId();
CallableStatement stmtSelectNextTSecGroupMemberIdGen = null;
try {
String sql = "{ call sp_next_tsecgroupmemberidgen( ?" + ", " + "?" + " ) }";
stmtSelectNextTSecGroupMemberIdGen = cnx.prepareCall(sql);
int argIdx = 1;
stmtSelectNextTSecGroupMemberIdGen.registerOutParameter(argIdx++, java.sql.Types.BIGINT);
stmtSelectNextTSecGroupMemberIdGen.setLong(argIdx++, Id);
stmtSelectNextTSecGroupMemberIdGen.execute();
long nextId = stmtSelectNextTSecGroupMemberIdGen.getLong(1);
return (nextId);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (stmtSelectNextTSecGroupMemberIdGen != null) {
try {
stmtSelectNextTSecGroupMemberIdGen.close();
} catch (SQLException e) {
}
stmtSelectNextTSecGroupMemberIdGen = null;
}
}
}
public Object getValueObject(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFBindServiceServiceTypeId.getValueObject() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), "expandBody", 1, "genContext.getGenDef()");
}
int serviceTypeId;
if (genDef instanceof ICFAsteriskServiceObj) {
serviceTypeId = ((ICFAsteriskServiceObj) genDef).getRequiredServiceTypeId();
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), "expandBody", "genContext.getGenDef()", genDef, "ICFAsteriskServiceObj");
}
return (serviceTypeId);
}
public ListIterator<ICFLibAnyObj> enumerateDetails(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFIterateTenantTSecGroup.enumerateDetails() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext.getGenDef()");
}
List<ICFLibAnyObj> list = new LinkedList<ICFLibAnyObj>();
if (genDef instanceof ICFAsteriskTenantObj) {
Iterator<ICFSecurityTSecGroupObj> elements =
((ICFAsteriskTenantObj) genDef).getOptionalComponentsTSecGroup().iterator();
while (elements.hasNext()) {
list.add(elements.next());
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "genContext.getGenDef()", genDef, "ICFAsteriskTenantObj");
}
return (list.listIterator());
}
public void deleteSysCluster(
CFSecurityAuthorization Authorization, CFSecuritySysClusterBuff Buff) {
final String S_ProcName = "deleteSysCluster";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
int SingletonId = Buff.getRequiredSingletonId();
final String sql = "CALL sp_delete_sysclus( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
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.setInt(argIdx++, SingletonId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
resultSet = stmtDeleteByPKey.executeQuery();
if (resultSet.next()) {
int deleteFlag = resultSet.getInt(1);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
} 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 deleteISOLanguageByCode2Idx(
CFSecurityAuthorization Authorization, String argISO6391Code) {
final String S_ProcName = "deleteISOLanguageByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_delete_iso_lang_by_code2idx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtDeleteByCode2Idx == null) {
stmtDeleteByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (argISO6391Code != null) {
stmtDeleteByCode2Idx.setString(argIdx++, argISO6391Code);
} else {
stmtDeleteByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
resultSet = stmtDeleteByCode2Idx.executeQuery();
if (resultSet.next()) {
int deleteFlag = resultSet.getInt(1);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
} 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 deleteTenantByUNameIdx(
CFSecurityAuthorization Authorization, long ClusterId, String TenantName) {
final String S_ProcName = "deleteTenantByUNameIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_delete_tenant_by_unameidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtDeleteByUNameIdx == null) {
stmtDeleteByUNameIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByUNameIdx.setLong(argIdx++, ClusterId);
stmtDeleteByUNameIdx.setString(argIdx++, TenantName);
Object stuff = null;
boolean moreResults = stmtDeleteByUNameIdx.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByUNameIdx.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByUNameIdx.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByUNameIdx.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityTenantBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityTenantPKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long Id = PKey.getRequiredId();
String sql = "exec sp_lock_tenant ?, ?, ?, ?, ?" + ", " + "?";
if (stmtLockBuffByPKey == null) {
stmtLockBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtLockBuffByPKey.setLong(argIdx++, Id);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityTenantBuff buff = unpackTenantResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityTenantBuff nextTenantCursor(CFSecurityCursor Cursor) {
final String S_ProcName = "nextTenantCursor";
try {
ResultSet resultSet = Cursor.getResultSet();
if (!resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "No more results available");
}
CFSecurityTenantBuff buff = unpackTenantResultSetToBuff(resultSet);
return (buff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
}
public CFSecurityTenantBuff readBuffByUNameIdx(
CFSecurityAuthorization Authorization, long ClusterId, String TenantName) {
final String S_ProcName = "readBuffByUNameIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tenant_by_unameidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtReadBuffByUNameIdx == null) {
stmtReadBuffByUNameIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUNameIdx.setLong(argIdx++, ClusterId);
stmtReadBuffByUNameIdx.setString(argIdx++, TenantName);
resultSet = stmtReadBuffByUNameIdx.executeQuery();
if (resultSet.next()) {
CFSecurityTenantBuff buff = unpackTenantResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityTenantBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tenant_all ?, ?, ?, ?, ?";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
resultSet = stmtReadAllBuff.executeQuery();
List<CFSecurityTenantBuff> buffList = new LinkedList<CFSecurityTenantBuff>();
while (resultSet.next()) {
CFSecurityTenantBuff buff = unpackTenantResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityTenantBuff[] retBuff = new CFSecurityTenantBuff[buffList.size()];
Iterator<CFSecurityTenantBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} 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 chose(ICFLibAnyObj value) {
final String S_ProcName = "chose";
Node cont;
ICFAsteriskSchemaObj schemaObj = (ICFAsteriskSchemaObj) javafxSchema.getSchema();
ICFAsteriskExtensionsConfObj focus = getJavaFXFocusAsExtensionsConf();
ICFAsteriskExtensionsConfEditObj editObj = (ICFAsteriskExtensionsConfEditObj) focus.getEdit();
if (editObj != null) {
focus = editObj;
}
ICFSecurityHostNodeObj referencedObj =
(ICFSecurityHostNodeObj) javafxReferenceParentHostNode.getReferencedObject();
java.util.List<ICFSecurityHostNodeObj> listOfHostNode = null;
CFSecurityAuthorization auth = schemaObj.getAuthorization();
long containingClusterId = auth.getSecClusterId();
listOfHostNode =
schemaObj.getHostNodeTableObj().readHostNodeByClusterIdx(containingClusterId);
if (listOfHostNode == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "listOfHostNode");
}
Collection<ICFSecurityHostNodeObj> cltn = listOfHostNode;
CFBorderPane form =
javafxSchema
.getHostNodeFactory()
.newPickerForm(
cfFormManager, referencedObj, null, cltn, new CallbackHostNodeChosen());
((ICFSecurityJavaFXHostNodePaneCommon) form).setPaneMode(CFPane.PaneMode.View);
cfFormManager.pushForm(form);
}
public void view(ICFLibAnyObj value) {
final String S_ProcName = "actionPerformed";
ICFAsteriskExtensionsConfObj focus = getJavaFXFocusAsExtensionsConf();
if (focus != null) {
ICFSecurityHostNodeObj referencedObj =
(ICFSecurityHostNodeObj) javafxReferenceParentHostNode.getReferencedObject();
CFBorderPane form = null;
if (referencedObj != null) {
String classCode = referencedObj.getClassCode();
if ("HSND".equals(classCode)) {
form =
javafxSchema
.getHostNodeFactory()
.newAddForm(cfFormManager, referencedObj, null, true);
ICFSecurityJavaFXHostNodePaneCommon spec = (ICFSecurityJavaFXHostNodePaneCommon) form;
spec.setJavaFXFocus(referencedObj);
spec.setPaneMode(CFPane.PaneMode.View);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "javaFXFocus", focus, "ICFAsteriskHostNodeObj");
}
cfFormManager.pushForm(form);
}
}
}
public void closeTenantCursor(CFSecurityCursor Cursor) {
try {
Cursor.getResultSet().close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), "closeTenantCursor", e);
}
}
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 setCFFormManager(ICFFormManager value) {
final String S_ProcName = "setCFFormManager";
if (value == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "value");
}
cfFormManager = value;
}
public void deleteTenant(CFSecurityAuthorization Authorization, CFSecurityTenantBuff Buff) {
final String S_ProcName = "deleteTenant";
try {
Connection cnx = schema.getCnx();
long Id = Buff.getRequiredId();
String sql = "exec sp_delete_tenant ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
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++, Id);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
Object stuff = null;
boolean moreResults = stmtDeleteByPKey.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByPKey.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByPKey.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByPKey.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
}
public CFSecurityISOLanguageBuff[] readDerivedByCode2Idx(
CFSecurityAuthorization Authorization, String ISO6391Code) {
final String S_ProcName = "readDerivedByCode2Idx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
CFSecurityISOLanguageBuff[] buffList = readBuffByCode2Idx(Authorization, ISO6391Code);
return (buffList);
}
public CFSecurityTenantBuff[] readDerivedByClusterIdx(
CFSecurityAuthorization Authorization, long ClusterId) {
final String S_ProcName = "readDerivedByClusterIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
CFSecurityTenantBuff[] buffList = readBuffByClusterIdx(Authorization, ClusterId);
return (buffList);
}
public CFSecurityTenantBuff readDerivedByIdIdx(CFSecurityAuthorization Authorization, long Id) {
final String S_ProcName = "CFAsteriskSybaseTenantTable.readDerivedByIdIdx() ";
CFSecurityTenantBuff buff;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buff = readBuffByIdIdx(Authorization, Id);
return (buff);
}
public CFSecurityTenantBuff[] readAllDerived(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllDerived";
CFSecurityTenantBuff[] buffArray;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buffArray = readAllBuff(Authorization);
return (buffArray);
}
public CFSecurityISOLanguageBuff readDerivedByCode3Idx(
CFSecurityAuthorization Authorization, String ISO6392Code) {
final String S_ProcName = "CFAsteriskDb2LUWISOLanguageTable.readDerivedByCode3Idx() ";
CFSecurityISOLanguageBuff buff;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buff = readBuffByCode3Idx(Authorization, ISO6392Code);
return (buff);
}
public CFSecuritySysClusterBuff readDerivedByIdIdx(
CFSecurityAuthorization Authorization, int SingletonId) {
final String S_ProcName = "CFAsteriskDb2LUWSysClusterTable.readDerivedByIdIdx() ";
CFSecuritySysClusterBuff buff;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buff = readBuffByIdIdx(Authorization, SingletonId);
return (buff);
}
public CFSecurityTenantBuff lockDerived(
CFSecurityAuthorization Authorization, CFSecurityTenantPKey PKey) {
final String S_ProcName = "lockDerived";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
CFSecurityTenantBuff buff;
buff = lockBuff(Authorization, PKey);
return (buff);
}
public void setJavaFXFocus(ICFLibAnyObj value) {
final String S_ProcName = "setJavaFXFocus";
if ((value == null) || (value instanceof ICFAsteriskExtensionsConfObj)) {
super.setJavaFXFocus(value);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "value", value, "ICFAsteriskExtensionsConfObj");
}
adjustFinderButtons();
}
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 CFSecurityISOLanguageBuff[] readBuffByCode2Idx(
CFSecurityAuthorization Authorization, String ISO6391Code) {
final String S_ProcName = "readBuffByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_iso_lang_by_code2idx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtReadBuffByCode2Idx == null) {
stmtReadBuffByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (ISO6391Code != null) {
stmtReadBuffByCode2Idx.setString(argIdx++, ISO6391Code);
} else {
stmtReadBuffByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
resultSet = stmtReadBuffByCode2Idx.executeQuery();
List<CFSecurityISOLanguageBuff> buffList = new LinkedList<CFSecurityISOLanguageBuff>();
while (resultSet.next()) {
CFSecurityISOLanguageBuff buff = unpackISOLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOLanguageBuff[] retBuff = new CFSecurityISOLanguageBuff[buffList.size()];
Iterator<CFSecurityISOLanguageBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}