@Override
public Long getValue(JwSqlResultSet rs, int column, Long def) {
long i = rs._getLong(column);
if (rs.wasNull()) return def;
return new Long(i);
}
@Override
public String getValue(JwSqlResultSet rs, int column, String def) {
String s = rs._getString(column);
if (rs.wasNull()) return def;
s = JwUtility.trimTrailing(s);
return s;
}
public AcUploadDownloadFile read(JwSqlResultSet rs) {
AcUploadDownloadFile e;
e = getAccess().newUploadDownloadFile();
e.setId(rs.getInteger());
e.setPath(rs.getString());
e.setFileName(rs.getString());
e.setDescription(rs.getString());
e.setCreatedUtcTs(rs.getTimestamp());
return e;
}
public static AcDomesticNominatedRouteSummaryVo readNominatedRouteSummaryVo(JwSqlResultSet rs) {
JwDate blockBeginUtcDt = rs.getDate();
JwDate blockEndUtcDt = rs.getDate();
JwTimestamp minCreatedUtcTs = rs.getTimestamp();
Integer countNew = rs.getInteger();
AcDomesticNominatedRouteSummaryVo vo = new AcDomesticNominatedRouteSummaryVo();
vo.setBlockBeginUtcDt(blockBeginUtcDt);
vo.setBlockEndUtcDt(blockEndUtcDt);
vo.setMinimumCreatedUtcTs(minCreatedUtcTs);
vo.setUnhandledRoutesCount(countNew);
return vo;
}
public static AcDomesticCandidateRouteSummaryVo readSummaryVo(JwSqlResultSet rs) {
JwDate blockBeginUtcDt = rs.getDate();
JwDate blockEndUtcDt = rs.getDate();
Integer count = rs.getInteger();
String statuses = rs.getString();
AcDomesticCandidateRouteSummaryVo vo = new AcDomesticCandidateRouteSummaryVo();
vo.setBlockBeginUtcDt(blockBeginUtcDt);
vo.setBlockEndUtcDt(blockEndUtcDt);
vo.setCandidateRoutesCount(0);
vo.setNominatedRoutesCount(count);
vo.setNominatedRouteStatusDisplayLabelFromDelimitedString(statuses);
vo.setRequestedRoutesCount(0);
return vo;
}
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 AcGlobalAuditLog read(JwSqlResultSet rs) {
AcGlobalAuditLog e;
e = getAccess().newGlobalAuditLog();
e.setId(rs.getInteger());
e.setModifiedUtcTs(rs.getTimestamp());
e.setUser(rs.getString());
e.setType(rs.getInteger());
e.setTypeName(rs.getString());
e.setSubject1(rs.getString());
e.setSubject2(rs.getString());
e.setSubject3(rs.getString());
e.setOldValue(rs.getString());
e.setNewValue(rs.getString());
return e;
}
public AcMobileProfile read(JwSqlResultSet rs) {
AcMobileProfile e;
e = getAccess().newMobileProfile();
e.setName(rs.getString());
return e;
}
public AcScheduledFlightUpload read(JwSqlResultSet rs) {
AcScheduledFlightUpload e;
e = getAccess().newScheduledFlightUpload();
e.setId(rs.getInteger());
e.setOperatorCarrierCode(rs.getString());
e.setOperatorNumber(rs.getString());
e.setRelationship(AcFlightRelationshipEnum.getFromCode(rs.getString()));
e.setOriginAirportCode(rs.getString());
e.setDestinationAirportCode(rs.getString());
e.setDepartureLocalTm(rs.getTime());
e.setArrivalLocalTm(rs.getTime());
e.setDayOffset(rs.getInteger());
e.setBoundingStartLocalDt(rs.getDate());
e.setBoundingEndLocalDt(rs.getDate());
e.setFrequency(rs.getDayFrequency());
e.setEquipmentCode(rs.getString());
e.setSource(AcScheduledFlightCalendarSourceEnum.getFromCode(rs.getString()));
e.setAbsoluteSource(AcScheduledFlightCalendarAbsoluteSourceEnum.getFromCode(rs.getString()));
e.setCancel(rs.getBoolean());
e.setCreatedUtcTs(rs.getTimestamp());
e.setSequence(rs.getInteger());
return e;
}
