public CFSecurityISOCountryLanguageBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguagePKey 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();
short ISOCountryId = PKey.getRequiredISOCountryId();
short ISOLanguageId = PKey.getRequiredISOLanguageId();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_lock_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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.setShort(argIdx++, ISOCountryId);
stmtLockBuffByPKey.setShort(argIdx++, ISOLanguageId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
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 void deleteISOCountryLanguageByIdIdx(
CFSecurityAuthorization Authorization, short argISOCountryId, short argISOLanguageId) {
final String S_ProcName = "deleteISOCountryLanguageByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng_by_ididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByIdIdx == null) {
stmtDeleteByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByIdIdx.setShort(argIdx++, argISOCountryId);
stmtDeleteByIdIdx.setShort(argIdx++, argISOLanguageId);
resultSet = stmtDeleteByIdIdx.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 CFSecurityISOCountryLanguageBuff[] readBuffByLanguageIdx(
CFSecurityAuthorization Authorization, short ISOLanguageId) {
final String S_ProcName = "readBuffByLanguageIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_iso_cntrylng_by_languageidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByLanguageIdx == null) {
stmtReadBuffByLanguageIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByLanguageIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByLanguageIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByLanguageIdx.setShort(argIdx++, ISOLanguageId);
resultSet = stmtReadBuffByLanguageIdx.executeQuery();
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while (resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOCountryLanguageBuff[] retBuff =
new CFSecurityISOCountryLanguageBuff[buffList.size()];
Iterator<CFSecurityISOCountryLanguageBuff> 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;
}
}
}
protected CFSecurityISOCountryLanguageBuff unpackISOCountryLanguageResultSetToBuff(
ResultSet resultSet) throws SQLException {
final String S_ProcName = "unpackISOCountryLanguageResultSetToBuff";
int idxcol = 1;
CFSecurityISOCountryLanguageBuff buff = schema.getFactoryISOCountryLanguage().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(CFFreeSwitchPgSqlSchema.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(CFFreeSwitchPgSqlSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredISOCountryId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredISOLanguageId(resultSet.getShort(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
public CFSecurityISOCountryLanguageBuff[] readDerivedByCountryIdx(
CFSecurityAuthorization Authorization, short ISOCountryId) {
final String S_ProcName = "readDerivedByCountryIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
CFSecurityISOCountryLanguageBuff[] buffList = readBuffByCountryIdx(Authorization, ISOCountryId);
return (buffList);
}
public CFSecurityISOCountryLanguageBuff[] readAllDerived(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllDerived";
CFSecurityISOCountryLanguageBuff[] buffArray;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buffArray = readAllBuff(Authorization);
return (buffArray);
}
public CFSecurityISOCountryLanguageBuff readDerivedByIdIdx(
CFSecurityAuthorization Authorization, short ISOCountryId, short ISOLanguageId) {
final String S_ProcName = "CFFreeSwitchPgSqlISOCountryLanguageTable.readDerivedByIdIdx() ";
CFSecurityISOCountryLanguageBuff buff;
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
buff = readBuffByIdIdx(Authorization, ISOCountryId, ISOLanguageId);
return (buff);
}
public String getSqlSelectISOCountryLanguageDistinctClassCode() {
if (S_sqlSelectISOCountryLanguageDistinctClassCode == null) {
S_sqlSelectISOCountryLanguageDistinctClassCode =
"SELECT "
+ "DISTINCT iscl.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".iso_cntrylng AS iscl ";
}
return (S_sqlSelectISOCountryLanguageDistinctClassCode);
}
public CFSecurityISOCountryLanguageBuff lockDerived(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguagePKey PKey) {
final String S_ProcName = "lockDerived";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
CFSecurityISOCountryLanguageBuff buff;
buff = lockBuff(Authorization, PKey);
return (buff);
}
public String getSqlSelectISOCountryLanguageBuff() {
if (S_sqlSelectISOCountryLanguageBuff == null) {
S_sqlSelectISOCountryLanguageBuff =
"SELECT "
+ "iscl.ISOCountryId, "
+ "iscl.ISOLanguageId, "
+ "iscl.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".iso_cntrylng AS iscl ";
}
return (S_sqlSelectISOCountryLanguageBuff);
}
public void updateISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "updateISOCountryLanguage";
ResultSet resultSet = null;
try {
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"select * from "
+ schema.getLowerDbSchemaName()
+ ".sp_update_iso_cntrylng( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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++, "ISCL");
stmtUpdateByPKey.setShort(argIdx++, ISOCountryId);
stmtUpdateByPKey.setShort(argIdx++, ISOLanguageId);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOCountryLanguageBuff updatedBuff =
unpackISOCountryLanguageResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
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;
}
}
}