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); }
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); }
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); }
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); }
public JwList<AcMobileProfile> getAllWhere(String whereClause, Integer rowLimit) { JwSqlSelect st = getSelect(); if (JwUtility.hasValue(whereClause)) st.where().setCondition(whereClause); return composeList(st, rowLimit); }
public AcMobileProfile getMobileProfile(String name) { if (isPrimaryKeyNull(name)) return null; JwSqlSelect st = getSelect(); st.where().isEqual(ALIAS, NAME, name); return composeFirst(st); }
public void populateSelectColumns(JwSqlSelect st, String alias) { st.selectColumn(alias, NAME); }
public void populateSelectColumnsToCompose(JwSqlSelect st, String alias) { st.selectString(alias, NAME); }
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()); }
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; }
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); }
public JwList<AcGlobalAuditLog> getAllByUser(String user) { JwSqlSelect st = getSelect(); st.where().isEqual(ALIAS, USER, user); return composeList(st); }