public JwSqlInsert _checkAndComposeInsert(JwList<AcScheduledFlightUpload> v, boolean insertIds) {
    for (AcScheduledFlightUpload e : v) {
      defaultUpdateCount(e);
      e.validate();
      verifyNoMatching(e);
    }

    JwSqlInsert st = createInsert();
    st.setTable(TABLE);
    populateInsertColumns(st, insertIds);

    for (AcScheduledFlightUpload e : v) {
      st.startNewRow();
      if (insertIds) st.addIntegerValue(e.getId());
      st.addStringValue(e.getOperatorCarrierCode());
      st.addStringValue(e.getOperatorNumber());
      st.addStringValue(e.getRelationship().getCode());
      st.addStringValue(e.getOriginAirportCode());
      st.addStringValue(e.getDestinationAirportCode());
      st.addTimeValue(e.getDepartureLocalTm());
      st.addTimeValue(e.getArrivalLocalTm());
      st.addIntegerValue(e.getDayOffset());
      st.addDateValue(e.getBoundingStartLocalDt());
      st.addDateValue(e.getBoundingEndLocalDt());
      st.addDayFrequencyValue(e.getFrequency());
      st.addStringValue(e.getEquipmentCode());
      st.addStringValue(e.getSource().getCode());
      st.addStringValue(e.hasAbsoluteSource() ? e.getAbsoluteSource().getCode() : null);
      st.addBooleanValue(e.getCancel());
      st.addTimestampValue(e.getCreatedUtcTs());
      st.addIntegerValue(e.getSequence());
    }
    return st;
  }
예제 #2
0
  public JwSqlInsert _checkAndComposeInsert(JwList<AcGlobalAuditLog> v, boolean insertIds) {
    for (AcGlobalAuditLog e : v) {
      defaultUpdateCount(e);
      e.validate();
      verifyNoMatching(e);
    }

    JwSqlInsert st = createInsert();
    st.setTable(TABLE);
    populateInsertColumns(st, insertIds);

    for (AcGlobalAuditLog e : v) {
      st.startNewRow();
      if (insertIds) st.addIntegerValue(e.getId());
      st.addTimestampValue(e.getModifiedUtcTs());
      st.addStringValue(e.getUser());
      st.addIntegerValue(e.getType());
      st.addStringValue(e.getTypeName());
      st.addStringValue(e.getSubject1());
      st.addStringValue(e.getSubject2());
      st.addStringValue(e.getSubject3());
      st.addStringValue(e.getOldValue());
      st.addStringValue(e.getNewValue());
    }
    return st;
  }
  public JwSqlInsert _checkAndComposeInsert(JwList<AcUploadDownloadFile> v, boolean insertIds) {
    for (AcUploadDownloadFile e : v) {
      defaultUpdateCount(e);
      e.validate();
      verifyNoMatching(e);
    }

    JwSqlInsert st = createInsert();
    st.setTable(TABLE);
    populateInsertColumns(st, insertIds);

    for (AcUploadDownloadFile e : v) {
      st.startNewRow();
      if (insertIds) st.addIntegerValue(e.getId());
      st.addStringValue(JwUtility.truncate(e.getPath(), PATH_MAX_LENGTH, true));
      st.addStringValue(JwUtility.truncate(e.getFileName(), FILE_NAME_MAX_LENGTH, true));
      st.addStringValue(JwUtility.truncate(e.getDescription(), DESCRIPTION_MAX_LENGTH, true));
      st.addTimestampValue(e.getCreatedUtcTs());
    }
    return st;
  }
  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;
  }