public AcDomesticCandidateRouteTmp read(JwSqlResultSet rs) {
AcDomesticCandidateRouteTmp e;
e = getAccess().newDomesticCandidateRouteTmp();
e.setLogin(rs.getString());
e.setCreatedUtcTs(rs.getTimestamp());
e.setBlockBeginUtcDt(rs.getDate());
e.setBlockEndUtcDt(rs.getDate());
e.setRouteBeginUtcDt(rs.getDate());
e.setRouteEndUtcDt(rs.getDate());
e.setError(AcDomesticCandidateRouteErrorEnum.getFromCode(rs.getInteger()));
return e;
}
public JwSqlUpdate composeUpdate(AcDomesticCandidateRouteTmp e) {
JwSqlUpdate st = createUpdate();
st.setTable(TABLE);
st.setValue(CREATED_UTC_TS, e.getCreatedUtcTs());
st.setValue(BLOCK_BEGIN_UTC_DT, e.getBlockBeginUtcDt());
st.setValue(BLOCK_END_UTC_DT, e.getBlockEndUtcDt());
st.setValue(ROUTE_BEGIN_UTC_DT, e.getRouteBeginUtcDt());
st.setValue(ROUTE_END_UTC_DT, e.getRouteEndUtcDt());
st.setValue(ERROR, e.hasError() ? e.getError().getCode() : null);
st.where().isEqual(LOGIN, e.getLogin());
return st;
}
public void update(AcDomesticCandidateRouteTmp e) {
e.validate();
JwSqlUpdate st = composeUpdate(e);
int i = execute(st);
if (i != 1) error("Unable to update AcDomesticCandidateRouteTmp. Rows updated: %s.", i);
}
public JwSqlInsert _checkAndComposeInsert(JwList<AcDomesticCandidateRouteTmp> v) {
for (AcDomesticCandidateRouteTmp e : v) {
defaultUpdateCount(e);
e.validate();
verifyNoMatching(e);
}
JwSqlInsert st = createInsert();
st.setTable(TABLE);
populateInsertColumns(st);
for (AcDomesticCandidateRouteTmp e : v) {
st.startNewRow();
st.addStringValue(e.getLogin());
st.addTimestampValue(e.getCreatedUtcTs());
st.addDateValue(e.getBlockBeginUtcDt());
st.addDateValue(e.getBlockEndUtcDt());
st.addDateValue(e.getRouteBeginUtcDt());
st.addDateValue(e.getRouteEndUtcDt());
st.addIntegerValue(e.hasError() ? e.getError().getCode() : null);
}
return st;
}