public int compareTo(Object obj) {
if (obj == null) {
return (1);
} else if (obj instanceof CFSecurityISOCountryLanguageByCountryIdxKey) {
CFSecurityISOCountryLanguageByCountryIdxKey rhs =
(CFSecurityISOCountryLanguageByCountryIdxKey) obj;
if (getRequiredISOCountryId() < rhs.getRequiredISOCountryId()) {
return (-1);
} else if (getRequiredISOCountryId() > rhs.getRequiredISOCountryId()) {
return (1);
}
return (0);
} else if (obj instanceof CFSecurityISOCountryLanguageBuff) {
CFSecurityISOCountryLanguageBuff rhs = (CFSecurityISOCountryLanguageBuff) obj;
if (getRequiredISOCountryId() < rhs.getRequiredISOCountryId()) {
return (-1);
} else if (getRequiredISOCountryId() > rhs.getRequiredISOCountryId()) {
return (1);
}
return (0);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(getClass(), "compareTo", "obj", obj, null);
}
}
public void copyPKeyToBuff() {
if (buff != null) {
buff.setRequiredISOCountryId(getPKey().getRequiredISOCountryId());
buff.setRequiredISOLanguageId(getPKey().getRequiredISOLanguageId());
}
if (edit != null) {
edit.copyPKeyToBuff();
}
}
public ICFSecuritySecUserObj getUpdatedBy() {
if (updatedBy == null) {
CFSecurityISOCountryLanguageBuff buff = getBuff();
updatedBy =
((ICFSecuritySchemaObj) getSchema())
.getSecUserTableObj()
.readSecUserByIdIdx(buff.getUpdatedByUserId());
}
return (updatedBy);
}
public void deleteISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "deleteISOCountryLanguage";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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.setShort(argIdx++, ISOCountryId);
stmtDeleteByPKey.setShort(argIdx++, ISOLanguageId);
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 CFSecurityISOCountryLanguageEditObj(ICFSecurityISOCountryLanguageObj argOrig) {
orig = argOrig;
getBuff();
CFSecurityISOCountryLanguageBuff origBuff = orig.getBuff();
buff.set(origBuff);
requiredContainerCountry = null;
requiredParentLanguage = null;
}
public CFSecurityISOCountryLanguageBuff getBuff() {
if (buff == null) {
buff =
((ICFSecuritySchema) getOrigAsISOCountryLanguage().getSchema().getBackingStore())
.getFactoryISOCountryLanguage()
.newBuff();
buff.set(orig.getBuff());
}
return (buff);
}
public boolean equals(Object obj) {
if (obj == null) {
return (false);
} else if (obj instanceof CFSecurityISOCountryLanguageByCountryIdxKey) {
CFSecurityISOCountryLanguageByCountryIdxKey rhs =
(CFSecurityISOCountryLanguageByCountryIdxKey) obj;
if (getRequiredISOCountryId() != rhs.getRequiredISOCountryId()) {
return (false);
}
return (true);
} else if (obj instanceof CFSecurityISOCountryLanguageBuff) {
CFSecurityISOCountryLanguageBuff rhs = (CFSecurityISOCountryLanguageBuff) obj;
if (getRequiredISOCountryId() != rhs.getRequiredISOCountryId()) {
return (false);
}
return (true);
} else {
return (false);
}
}
public void copyBuffToPKey() {
getPKey().setRequiredISOCountryId(buff.getRequiredISOCountryId());
getPKey().setRequiredISOLanguageId(buff.getRequiredISOLanguageId());
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFSecurityXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
String attrRevision = null;
// ISOCountryLanguage Attributes
String attrISOCountryId = null;
String attrISOLanguageId = null;
String attrCreatedAt = null;
String attrCreatedBy = null;
String attrUpdatedAt = null;
String attrUpdatedBy = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstISOCountryLanguageCreate");
CFSecurityXMsgRqstHandler xmsgRqstHandler = (CFSecurityXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFSecuritySchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Instantiate an edit buffer for the parsed information
ICFSecurityISOCountryLanguageEditObj editBuff =
(ICFSecurityISOCountryLanguageEditObj)
schemaObj.getISOCountryLanguageTableObj().newInstance().beginEdit();
CFSecurityISOCountryLanguageBuff dataBuff =
(CFSecurityISOCountryLanguageBuff) editBuff.getISOCountryLanguageBuff();
// Extract Attributes
numAttrs = attrs.getLength();
for (idxAttr = 0; idxAttr < numAttrs; idxAttr++) {
attrLocalName = attrs.getLocalName(idxAttr);
if (attrLocalName.equals("Id")) {
if (attrId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("schemaLocation")) {
// ignored
} else if (attrLocalName.equals("Revision")) {
if (attrRevision != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrRevision = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedAt")) {
if (attrCreatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedBy")) {
if (attrCreatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedAt")) {
if (attrUpdatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedBy")) {
if (attrUpdatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("ISOCountryId")) {
if (attrISOCountryId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrISOCountryId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("ISOLanguageId")) {
if (attrISOLanguageId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrISOLanguageId = attrs.getValue(idxAttr);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnrecognizedAttributeException(
getClass(), S_ProcName, getParser().getLocationInfo(), attrLocalName);
}
}
// Ensure that required attributes have values
if ((attrISOCountryId == null) || (attrISOCountryId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ISOCountryId");
}
if ((attrISOLanguageId == null) || (attrISOLanguageId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ISOLanguageId");
}
// Save named attributes to context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Convert string attributes to native Java types
// and apply the converted attributes to the editBuff.
short natISOCountryId = Short.parseShort(attrISOCountryId);
dataBuff.setRequiredISOCountryId(natISOCountryId);
short natISOLanguageId = Short.parseShort(attrISOLanguageId);
dataBuff.setRequiredISOLanguageId(natISOLanguageId);
UUID createdBy = null;
if (attrCreatedBy != null) {
createdBy = UUID.fromString(attrCreatedBy);
}
Calendar createdAt = null;
if (attrCreatedAt != null) {
createdAt = CFLibXmlUtil.parseTimestamp(attrCreatedAt);
}
UUID updatedBy = null;
if (attrUpdatedBy != null) {
updatedBy = UUID.fromString(attrUpdatedBy);
}
Calendar updatedAt = null;
if (attrUpdatedAt != null) {
updatedAt = CFLibXmlUtil.parseTimestamp(attrUpdatedAt);
}
if (createdBy != null) {
dataBuff.setCreatedByUserId(createdBy);
}
if (createdAt != null) {
dataBuff.setCreatedAt(createdAt);
}
if (updatedBy != null) {
dataBuff.setUpdatedByUserId(updatedBy);
}
if (updatedAt != null) {
dataBuff.setUpdatedAt(updatedAt);
}
// Attempt the create
editBuff.copyBuffToPKey(); // Allow for predefined ids
ICFSecurityISOCountryLanguageObj created =
(ICFSecurityISOCountryLanguageObj) editBuff.create();
editBuff.endEdit();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFSecurityXMsgISOCountryLanguageMessageFormatter
.formatISOCountryLanguageRspnCreated(
"\n\t\t\t", created.getISOCountryLanguageBuff())
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
((CFSecurityXMsgRqstHandler) getParser()).appendResponse(response);
} catch (RuntimeException e) {
CFSecurityXMsgRqstHandler xmsgRqstHandler = ((CFSecurityXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFSecurityXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFSecurityXMsgRqstHandler xmsgRqstHandler = ((CFSecurityXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFSecurityXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}
public void copyOrigToBuff() {
CFSecurityISOCountryLanguageBuff origBuff =
getOrigAsISOCountryLanguage().getISOCountryLanguageBuff();
CFSecurityISOCountryLanguageBuff myBuff = getISOCountryLanguageBuff();
myBuff.set(origBuff);
}
public void copyPKeyToBuff() {
buff.setRequiredISOCountryId(getPKey().getRequiredISOCountryId());
buff.setRequiredISOLanguageId(getPKey().getRequiredISOLanguageId());
}
public void deleteISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "deleteISOCountryLanguage";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) 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.setShort(argIdx++, ISOCountryId);
stmtDeleteByPKey.setShort(argIdx++, ISOLanguageId);
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 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;
}
}
}
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);
}