@Override
public boolean isInstanceImageKind(long instanceId, String kind) {
return create()
.select(STORAGE_POOL.fields())
.from(STORAGE_POOL)
.join(IMAGE_STORAGE_POOL_MAP)
.on(STORAGE_POOL.ID.eq(IMAGE_STORAGE_POOL_MAP.STORAGE_POOL_ID))
.join(IMAGE)
.on(IMAGE.ID.eq(IMAGE_STORAGE_POOL_MAP.IMAGE_ID))
.join(INSTANCE)
.on(INSTANCE.IMAGE_ID.eq(IMAGE.ID))
.where(
INSTANCE
.ID
.eq(instanceId)
.and(IMAGE_STORAGE_POOL_MAP.REMOVED.isNull())
.and(STORAGE_POOL.KIND.eq(kind)))
.fetch()
.size()
> 0;
}
