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);
}