@Override
public List<? extends Instance> listNonRemovedInstances(Account account, boolean forService) {
List<? extends Instance> serviceInstances =
create()
.select(INSTANCE.fields())
.from(INSTANCE)
.join(SERVICE_EXPOSE_MAP)
.on(SERVICE_EXPOSE_MAP.INSTANCE_ID.eq(INSTANCE.ID))
.where(INSTANCE.ACCOUNT_ID.eq(account.getId()))
.and(INSTANCE.REMOVED.isNull())
.fetchInto(InstanceRecord.class);
if (forService) {
return serviceInstances;
}
List<? extends Instance> allInstances =
create()
.select(INSTANCE.fields())
.from(INSTANCE)
.where(INSTANCE.ACCOUNT_ID.eq(account.getId()))
.and(INSTANCE.REMOVED.isNull())
.fetchInto(InstanceRecord.class);
allInstances.removeAll(serviceInstances);
return allInstances;
}
@Override
public List<? extends Service> findServicesFor(Instance instance) {
return create()
.select(SERVICE.fields())
.from(SERVICE)
.join(SERVICE_EXPOSE_MAP)
.on(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(SERVICE.ID))
.where(SERVICE_EXPOSE_MAP.INSTANCE_ID.eq(instance.getId()))
.fetchInto(ServiceRecord.class);
}
@Override
public List<? extends Instance> findInstancesFor(Service service) {
return create()
.select(INSTANCE.fields())
.from(INSTANCE)
.join(SERVICE_EXPOSE_MAP)
.on(
SERVICE_EXPOSE_MAP
.INSTANCE_ID
.eq(INSTANCE.ID)
.and(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(service.getId()))
.and(
SERVICE_EXPOSE_MAP.STATE.in(
CommonStatesConstants.ACTIVATING,
CommonStatesConstants.ACTIVE,
CommonStatesConstants.REQUESTED))
.and(
INSTANCE.STATE.notIn(
CommonStatesConstants.PURGING,
CommonStatesConstants.PURGED,
CommonStatesConstants.REMOVED,
CommonStatesConstants.REMOVING)))
.fetchInto(InstanceRecord.class);
}
