public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectString(alias, PATH);
   st.selectString(alias, FILE_NAME);
   st.selectString(alias, DESCRIPTION);
   st.selectTimestamp(alias, CREATED_UTC_TS);
 }
 public void populateSelectColumns(JwSqlSelect st, String alias) {
   st.selectColumn(alias, ID);
   st.selectColumn(alias, PATH);
   st.selectColumn(alias, FILE_NAME);
   st.selectColumn(alias, DESCRIPTION);
   st.selectColumn(alias, CREATED_UTC_TS);
 }
예제 #3
0
 public JwList<AcGlobalAuditLog> getAllById(Collection<Integer> ids) {
   JwList<AcGlobalAuditLog> v = new JwList<AcGlobalAuditLog>();
   for (Integer id : ids) {
     JwSqlSelect st = getSelect();
     st.where().isEqual(ALIAS, ID, id);
     v.addAll(composeList(st));
   }
   return v;
 }
 public JwList<AcUploadDownloadFile> getAllById(Collection<Integer> ids) {
   JwList<AcUploadDownloadFile> v = new JwList<AcUploadDownloadFile>();
   for (Integer id : ids) {
     JwSqlSelect st = getSelect();
     st.where().isEqual(ALIAS, ID, id);
     v.addAll(composeList(st));
   }
   return v;
 }
 public void populateSelectColumns(JwSqlSelect st, String alias) {
   st.selectColumn(alias, LOGIN);
   st.selectColumn(alias, CREATED_UTC_TS);
   st.selectColumn(alias, BLOCK_BEGIN_UTC_DT);
   st.selectColumn(alias, BLOCK_END_UTC_DT);
   st.selectColumn(alias, ROUTE_BEGIN_UTC_DT);
   st.selectColumn(alias, ROUTE_END_UTC_DT);
   st.selectColumn(alias, ERROR);
 }
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectString(alias, LOGIN);
   st.selectTimestamp(alias, CREATED_UTC_TS);
   st.selectDate(alias, BLOCK_BEGIN_UTC_DT);
   st.selectDate(alias, BLOCK_END_UTC_DT);
   st.selectDate(alias, ROUTE_BEGIN_UTC_DT);
   st.selectDate(alias, ROUTE_END_UTC_DT);
   st.selectInteger(alias, ERROR);
 }
예제 #7
0
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectTimestamp(alias, MODIFIED_UTC_TS);
   st.selectString(alias, USER);
   st.selectInteger(alias, TYPE);
   st.selectString(alias, TYPE_NAME);
   st.selectString(alias, SUBJECT_1);
   st.selectString(alias, SUBJECT_2);
   st.selectString(alias, SUBJECT_3);
   st.selectString(alias, OLD_VALUE);
   st.selectString(alias, NEW_VALUE);
 }
예제 #8
0
 public void populateSelectColumns(JwSqlSelect st, String alias) {
   st.selectColumn(alias, ID);
   st.selectColumn(alias, MODIFIED_UTC_TS);
   st.selectColumn(alias, USER);
   st.selectColumn(alias, TYPE);
   st.selectColumn(alias, TYPE_NAME);
   st.selectColumn(alias, SUBJECT_1);
   st.selectColumn(alias, SUBJECT_2);
   st.selectColumn(alias, SUBJECT_3);
   st.selectColumn(alias, OLD_VALUE);
   st.selectColumn(alias, NEW_VALUE);
 }
예제 #9
0
 public JwList<AcMobileProfile> getAllWhere(String whereClause, Integer rowLimit) {
   JwSqlSelect st = getSelect();
   if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
   return composeList(st, rowLimit);
 }
예제 #10
0
 public AcMobileProfile getMobileProfile(String name) {
   if (isPrimaryKeyNull(name)) return null;
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, NAME, name);
   return composeFirst(st);
 }
예제 #11
0
 public void populateSelectColumns(JwSqlSelect st, String alias) {
   st.selectColumn(alias, NAME);
 }
예제 #12
0
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectString(alias, NAME);
 }
예제 #13
0
 public void verifyNoName(AcMobileProfile e) {
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, NAME, e.getName());
   AcMobileProfile o = composeFirst(st);
   if (o != null) JwErrorUtility.throwNewUniqueError("AcMobileProfile", "Name", e.getName());
 }
예제 #14
0
 public AcGlobalAuditLog getGlobalAuditLog(Integer id) {
   if (isPrimaryKeyNull(id)) return null;
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, ID, id);
   return composeFirst(st);
 }
 public JwList<AcScheduledFlightUpload> getAllByOriginAirportCode(String originAirportCode) {
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, ORIGIN_AIRPORT_CODE, originAirportCode);
   return composeList(st);
 }
 public AcDomesticCandidateRouteTmp getDomesticCandidateRouteTmp(String login) {
   if (isPrimaryKeyNull(login)) return null;
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, LOGIN, login);
   return composeFirst(st);
 }
 public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) {
   st.selectInteger(alias, ID);
   st.selectString(alias, OPERATOR_CARRIER_CODE);
   st.selectString(alias, OPERATOR_NUMBER);
   st.selectString(alias, RELATIONSHIP);
   st.selectString(alias, ORIGIN_AIRPORT_CODE);
   st.selectString(alias, DESTINATION_AIRPORT_CODE);
   st.selectTime(alias, DEPARTURE_LOCAL_TM);
   st.selectTime(alias, ARRIVAL_LOCAL_TM);
   st.selectInteger(alias, DAY_OFFSET);
   st.selectDate(alias, BOUNDING_START_LOCAL_DT);
   st.selectDate(alias, BOUNDING_END_LOCAL_DT);
   st.selectDayFrequency(alias, FREQUENCY);
   st.selectString(alias, EQUIPMENT_CODE);
   st.selectString(alias, SOURCE);
   st.selectString(alias, ABSOLUTE_SOURCE);
   st.selectBoolean(alias, CANCEL);
   st.selectTimestamp(alias, CREATED_UTC_TS);
   st.selectInteger(alias, SEQUENCE);
 }
 /** Return the maximum ID; return null if the table is empty. */
 public Integer getMaximumId() {
   JwSqlSelect st = createSelect();
   st.selectMaximum(ALIAS, ID);
   st.from(TABLE, ALIAS);
   return composeFirstInteger(st);
 }
 public JwList<Integer> getAllIds() {
   JwSqlSelect st = createSelect();
   st.selectInteger(ALIAS, ID);
   st.from(TABLE, ALIAS);
   return composeIntegerList(st);
 }
 public AcScheduledFlightUpload getScheduledFlightUpload(Integer id) {
   if (isPrimaryKeyNull(id)) return null;
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, ID, id);
   return composeFirst(st);
 }
 public JwList<AcScheduledFlightUpload> getAllByDestinationAirportCode(
     String destinationAirportCode) {
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, DESTINATION_AIRPORT_CODE, destinationAirportCode);
   return composeList(st);
 }
 public JwSqlSelect getSelect() {
   JwSqlSelect st = createSelect();
   populateSelectColumnsToCompose(st, ALIAS);
   st.from(TABLE, ALIAS);
   return st;
 }
예제 #23
0
 public JwList<AcGlobalAuditLog> getAllByType(Integer type) {
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, TYPE, type);
   return composeList(st);
 }
 public void populateSelectColumns(JwSqlSelect st, String alias) {
   st.selectColumn(alias, ID);
   st.selectColumn(alias, OPERATOR_CARRIER_CODE);
   st.selectColumn(alias, OPERATOR_NUMBER);
   st.selectColumn(alias, RELATIONSHIP);
   st.selectColumn(alias, ORIGIN_AIRPORT_CODE);
   st.selectColumn(alias, DESTINATION_AIRPORT_CODE);
   st.selectColumn(alias, DEPARTURE_LOCAL_TM);
   st.selectColumn(alias, ARRIVAL_LOCAL_TM);
   st.selectColumn(alias, DAY_OFFSET);
   st.selectColumn(alias, BOUNDING_START_LOCAL_DT);
   st.selectColumn(alias, BOUNDING_END_LOCAL_DT);
   st.selectColumn(alias, FREQUENCY);
   st.selectColumn(alias, EQUIPMENT_CODE);
   st.selectColumn(alias, SOURCE);
   st.selectColumn(alias, ABSOLUTE_SOURCE);
   st.selectColumn(alias, CANCEL);
   st.selectColumn(alias, CREATED_UTC_TS);
   st.selectColumn(alias, SEQUENCE);
 }
 public JwSqlSelect getSelectCount() {
   JwSqlSelect st = createSelect();
   st.selectCount();
   st.from(TABLE, ALIAS);
   return st;
 }
 public AcUploadDownloadFile getUploadDownloadFile(Integer id) {
   if (isPrimaryKeyNull(id)) return null;
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, ID, id);
   return composeFirst(st);
 }
 public JwList<AcDomesticCandidateRouteTmp> getAllWhere(String whereClause, Integer rowLimit) {
   JwSqlSelect st = getSelect();
   if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause);
   return composeList(st, rowLimit);
 }
예제 #28
0
 public JwList<AcGlobalAuditLog> getAllByUser(String user) {
   JwSqlSelect st = getSelect();
   st.where().isEqual(ALIAS, USER, user);
   return composeList(st);
 }