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 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 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.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);
}
private JwSqlSelect getFlightNumberExistsSelect(String flightNumber) {
JwSqlSelect st = createSelect();
st.selectInteger(AcDomesticNominatedRouteLegDb.ALIAS, AcDomesticNominatedRouteLegDb.ID);
st.from(AcDomesticNominatedRouteLegDb.TABLE, AcDomesticNominatedRouteLegDb.ALIAS);
st.where()
.isEqualColumn(
AcDomesticNominatedRouteLegDb.ALIAS,
AcDomesticNominatedRouteLegDb.DOMESTIC_NOMINATED_ROUTE_ID,
ALIAS,
ID);
st.where()
.isEqual(
AcDomesticNominatedRouteLegDb.ALIAS,
AcDomesticNominatedRouteLegDb.FLIGHT_NUMBER,
AcFlightUtility.normalizeFlightNumber(flightNumber));
return st;
}
public JwList<Integer> getAllIds() {
JwSqlSelect st = createSelect();
st.selectInteger(ALIAS, ID);
st.from(TABLE, ALIAS);
return composeIntegerList(st);
}