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 JwSqlUpdate composeUpdate(AcUploadDownloadFile e) { JwSqlUpdate st = createUpdate(); st.setTable(TABLE); st.setValue(PATH, JwUtility.truncate(e.getPath(), PATH_MAX_LENGTH, true)); st.setValue(FILE_NAME, JwUtility.truncate(e.getFileName(), FILE_NAME_MAX_LENGTH, true)); st.setValue(DESCRIPTION, JwUtility.truncate(e.getDescription(), DESCRIPTION_MAX_LENGTH, true)); st.setValue(CREATED_UTC_TS, e.getCreatedUtcTs()); st.where().isEqual(ID, e.getId()); return st; }
public JwSqlUpdate composeUpdate(AcGlobalAuditLog e) { JwSqlUpdate st = createUpdate(); st.setTable(TABLE); st.setValue(MODIFIED_UTC_TS, e.getModifiedUtcTs()); st.setValue(USER, e.getUser()); st.setValue(TYPE, e.getType()); st.setValue(TYPE_NAME, e.getTypeName()); st.setValue(SUBJECT_1, e.getSubject1()); st.setValue(SUBJECT_2, e.getSubject2()); st.setValue(SUBJECT_3, e.getSubject3()); st.setValue(OLD_VALUE, e.getOldValue()); st.setValue(NEW_VALUE, e.getNewValue()); st.where().isEqual(ID, e.getId()); return st; }
public JwSqlUpdate composeUpdate(AcMobileProfile e) { JwSqlUpdate st = createUpdate(); st.setTable(TABLE); st.where().isEqual(NAME, e.getName()); return st; }
public JwSqlUpdate composeUpdate(AcScheduledFlightUpload e) { JwSqlUpdate st = createUpdate(); st.setTable(TABLE); st.setValue(OPERATOR_CARRIER_CODE, e.getOperatorCarrierCode()); st.setValue(OPERATOR_NUMBER, e.getOperatorNumber()); st.setValue(RELATIONSHIP, e.getRelationship().getCode()); st.setValue(ORIGIN_AIRPORT_CODE, e.getOriginAirportCode()); st.setValue(DESTINATION_AIRPORT_CODE, e.getDestinationAirportCode()); st.setValue(DEPARTURE_LOCAL_TM, e.getDepartureLocalTm()); st.setValue(ARRIVAL_LOCAL_TM, e.getArrivalLocalTm()); st.setValue(DAY_OFFSET, e.getDayOffset()); st.setValue(BOUNDING_START_LOCAL_DT, e.getBoundingStartLocalDt()); st.setValue(BOUNDING_END_LOCAL_DT, e.getBoundingEndLocalDt()); st.setValue(FREQUENCY, e.getFrequency()); st.setValue(EQUIPMENT_CODE, e.getEquipmentCode()); st.setValue(SOURCE, e.getSource().getCode()); st.setValue(ABSOLUTE_SOURCE, e.hasAbsoluteSource() ? e.getAbsoluteSource().getCode() : null); st.setValue(CANCEL, e.getCancel()); st.setValue(CREATED_UTC_TS, e.getCreatedUtcTs()); st.setValue(SEQUENCE, e.getSequence()); st.where().isEqual(ID, e.getId()); return st; }