public List<Category> getCategoriesWithAgeGroup(AgeGroup ageGroup) { return this.dslContext.select().from(CATEGORY).where(CATEGORY.AGE_GROUP.equal(ageGroup.name())) .fetchInto(Category.class); } }
@Override public boolean isUnique(final Credential credential) { if (StringUtils.isNotBlank(credential.getPublicValue()) && CredentialConstants.CREDENTIAL_TYPES_TO_FILTER.contains(credential.getKind())) { List<Credential> credentials = create().selectFrom(CREDENTIAL) .where(CREDENTIAL.REMOVED.isNull() .and(CREDENTIAL.PUBLIC_VALUE.equalIgnoreCase(credential.getPublicValue()) .and(CREDENTIAL.KIND.equalIgnoreCase(credential.getKind())))).fetchInto (Credential.class); return credentials.isEmpty(); } return true; }
@Override public List<? extends ServiceConsumeMap> findConsumingServices(long serviceId) { return create() .selectFrom(SERVICE_CONSUME_MAP) .where( SERVICE_CONSUME_MAP.CONSUMED_SERVICE_ID.eq(serviceId) .and(SERVICE_CONSUME_MAP.REMOVED.isNull())).fetchInto(ServiceConsumeMapRecord.class); }
@Override public List<? extends ScheduledUpgrade> getRunningUpgrades() { return create().select(SCHEDULED_UPGRADE.fields()) .from(SCHEDULED_UPGRADE) .where(SCHEDULED_UPGRADE.STATE.eq("running")) .fetchInto(ScheduledUpgradeRecord.class); }
@Override public List<Long> getInstanceIdsForAccount(long accountId) { return create() .select(INSTANCE.ID) .from(INSTANCE) .where(INSTANCE.REMOVED.isNull() .and(INSTANCE.ACCOUNT_ID.eq(accountId))) .fetchInto(Long.class); } }
@Override public List<? extends ServiceConsumeMap> findConsumedMapsToRemove(long serviceId) { return create() .selectFrom(SERVICE_CONSUME_MAP) .where( SERVICE_CONSUME_MAP.SERVICE_ID.eq(serviceId) .and((SERVICE_CONSUME_MAP.REMOVED.isNull(). or(SERVICE_CONSUME_MAP.STATE.eq(CommonStatesConstants.REMOVING))))). fetchInto(ServiceConsumeMapRecord.class); }
@Override public List<? extends Network> getActiveNetworks(Long accountId) { return create().select(NETWORK.fields()) .from(NETWORK) .where(NETWORK.ACCOUNT_ID.eq(accountId) .and(NETWORK.STATE.in(CommonStatesConstants.ACTIVATING, CommonStatesConstants.ACTIVE, CommonStatesConstants.UPDATING_ACTIVE))) .fetchInto(NetworkRecord.class); }
@Override public List<? extends ServiceConsumeMap> findConsumingMapsToRemove(long serviceId) { return create() .selectFrom(SERVICE_CONSUME_MAP) .where( SERVICE_CONSUME_MAP.CONSUMED_SERVICE_ID.eq(serviceId) .and((SERVICE_CONSUME_MAP.REMOVED.isNull(). or(SERVICE_CONSUME_MAP.STATE.eq(CommonStatesConstants.REMOVING))))). fetchInto(ServiceConsumeMapRecord.class); }
@Override public List<? extends StoragePoolHostMap> findMapsToRemove(Long storagePoolId) { return create() .selectFrom(STORAGE_POOL_HOST_MAP) .where(STORAGE_POOL_HOST_MAP.STORAGE_POOL_ID.eq(storagePoolId) .and((STORAGE_POOL_HOST_MAP.REMOVED.isNull() .or(STORAGE_POOL_HOST_MAP.STATE.eq(CommonStatesConstants.REMOVING))))) .fetchInto(StoragePoolHostMap.class); }
@Override public List<? extends Host> getNonPurgedHosts(long accountId) { return create() .select(HOST.fields()) .from(HOST) .where(HOST.ACCOUNT_ID.eq(accountId) .and(HOST.STATE.notEqual(CommonStatesConstants.PURGED))) .fetchInto(Host.class); }
@Override public Map<String, Host> getHosts(long agentId) { List<? extends Host> hostList = create() .select(HOST.fields()) .from(HOST) .where( HOST.AGENT_ID.eq(agentId) .and(HOST.REMOVED.isNull())) .fetchInto(HostRecord.class); return groupByReportedUUid(hostList); }
@Override public List<? extends Service> getSkipServices(long accountId) { return create() .select(SERVICE.fields()) .from(SERVICE) .where(SERVICE.ACCOUNT_ID.eq(accountId) .and(SERVICE.REMOVED.isNull()) .and(SERVICE.SKIP.isTrue())) .fetchInto(ServiceRecord.class); }
@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 Service> getActiveServices(long accountId) { return create() .select(SERVICE.fields()) .from(SERVICE) .where(SERVICE.ACCOUNT_ID.eq(accountId)) .and(SERVICE.REMOVED.isNull()) .and(SERVICE.STATE.in(sdService.getServiceActiveStates())) .fetchInto(ServiceRecord.class); }
@Override public List<? extends Service> findLinkedServices(long serviceId) { return create() .select(SERVICE.fields()) .from(SERVICE) .join(SERVICE_CONSUME_MAP) .on(SERVICE_CONSUME_MAP.CONSUMED_SERVICE_ID.eq(SERVICE.ID)) .where( SERVICE_CONSUME_MAP.SERVICE_ID.eq(serviceId) .and(SERVICE_CONSUME_MAP.REMOVED.isNull())).fetchInto(Service.class); }
@Override public List<? extends ServiceExposeMap> getNonRemovedServiceHostnameMaps(long serviceId) { return create() .select(SERVICE_EXPOSE_MAP.fields()) .from(SERVICE_EXPOSE_MAP) .where(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(serviceId)) .and(SERVICE_EXPOSE_MAP.REMOVED.isNull() .and(SERVICE_EXPOSE_MAP.STATE.notIn(CommonStatesConstants.REMOVED, CommonStatesConstants.REMOVING)) .and(SERVICE_EXPOSE_MAP.HOST_NAME.isNotNull())) .fetchInto(ServiceExposeMapRecord.class); }
@Override public List<? extends ServiceExposeMap> getInstancesSetForUpgrade(long serviceId) { return create() .select(SERVICE_EXPOSE_MAP.fields()) .from(SERVICE_EXPOSE_MAP) .where(SERVICE_EXPOSE_MAP.SERVICE_ID.eq(serviceId)) .and(SERVICE_EXPOSE_MAP.MANAGED.eq(false)) .and(SERVICE_EXPOSE_MAP.UPGRADE.eq(true)) .and(SERVICE_EXPOSE_MAP.STATE.in(CommonStatesConstants.ACTIVATING, CommonStatesConstants.ACTIVE, CommonStatesConstants.REQUESTED)) .fetchInto(ServiceExposeMapRecord.class); } }
@Override public List<? extends Service> findServicesForInstanceId(long instanceId){ 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(instanceId)) .and(SERVICE_EXPOSE_MAP.REMOVED.isNull()) .and(SERVICE.REMOVED.isNull()) .fetchInto(ServiceRecord.class); }
@Override public List<? extends Instance> getNonRemovedInstanceOn(Long hostId) { return create() .select(INSTANCE.fields()) .from(INSTANCE) .join(INSTANCE_HOST_MAP) .on(INSTANCE_HOST_MAP.HOST_ID.eq(hostId) .and(INSTANCE_HOST_MAP.INSTANCE_ID.eq(INSTANCE.ID))) .where(INSTANCE.REMOVED.isNull().and( INSTANCE.STATE.notIn(InstanceConstants.STATE_ERROR, InstanceConstants.STATE_ERRORING, CommonStatesConstants.REMOVING))) .fetchInto(InstanceRecord.class); }
@Override public List<? extends Host> findHosts(long accountId, long instanceId) { return create().select(HOST.fields()) .from(INSTANCE) .join(INSTANCE_HOST_MAP) .on(INSTANCE.ID.eq(INSTANCE_HOST_MAP.INSTANCE_ID)) .join(HOST) .on(HOST.ID.eq(INSTANCE_HOST_MAP.HOST_ID)) .where(HOST.REMOVED.isNull() .and(INSTANCE_HOST_MAP.REMOVED.isNull()) .and(INSTANCE.ID.eq(instanceId))) .fetchInto(HostRecord.class); }