public void deleteByUspsInternationalCgrSubmissionId(Integer uspsInternationalCgrSubmissionId) {
JwSqlDelete st = createDelete();
st.from(ALIAS);
st.using(TABLE, ALIAS);
st.using(AcUspsInternationalCgrWorkOfferDb.TABLE, AcUspsInternationalCgrWorkOfferDb.ALIAS);
st.where()
.isEqual(
AcUspsInternationalCgrWorkOfferDb.ALIAS,
AcUspsInternationalCgrWorkOfferDb.USPS_INTERNATIONAL_CGR_SUBMISSION_ID,
uspsInternationalCgrSubmissionId);
st.where()
.isEqualColumn(
ALIAS,
ID,
AcUspsInternationalCgrWorkOfferDb.ALIAS,
AcUspsInternationalCgrWorkOfferDb.USPS_INTERNATIONAL_CGR_WORK_DUPLICATE_ID);
execute(st);
}
public void deleteAll() {
JwSqlDelete st = createDelete();
st.setTable(TABLE);
execute(st);
}
public void delete(String login) {
JwSqlDelete st = createDelete();
st.setTable(TABLE);
st.where().isEqual(LOGIN, login);
execute(st);
}
private void _deleteByHostname(String hostname) {
JwSqlDelete st = createDelete();
st.setTable(TABLE);
st.where().isEqual(HOSTNAME, hostname);
execute(st);
}
public void delete(String name) {
JwSqlDelete st = createDelete();
st.setTable(TABLE);
st.where().isEqual(NAME, name);
execute(st);
}
public void delete(Integer id) {
JwSqlDelete st = createDelete();
st.setTable(TABLE);
st.where().isEqual(ID, id);
execute(st);
}