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;
 }
예제 #2
0
 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(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(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;
 }