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 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 JwList<AcDomesticCandidateRouteTmp> getAllWhere(String whereClause, Integer rowLimit) {
   JwSqlSelect st = getSelect();
   if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
   return composeList(st, rowLimit);
 }
 public JwList<AcMobileProfile> getAllWhere(String whereClause, Integer rowLimit) {
   JwSqlSelect st = getSelect();
   if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
   return composeList(st, rowLimit);
 }