public List<T> fetch(DSLContext ctx, Function<Table, Condition> func) { return ctx.fetch(table, func.apply(table)).map(mapper); }
@Override public final <E> List<E> fetch(RecordMapper<? super R, E> mapper) { return fetch().map(mapper); }
@Override public final <E> List<E> fetch(RecordMapper<? super R, E> mapper) { return fetch().map(mapper); }
@Override public final <E> List<E> fetch(RecordMapper<? super R, E> mapper) { return fetch().map(mapper); }
@Override public final <E> List<E> fetch(RecordMapper<? super R, E> mapper) { return fetch().map(mapper); }
public List<T> fetchAll(DSLContext ctx) { return ctx.fetch(table).map(mapper); }
@Override public /* non-final */ List<P> findAll() { return using(configuration) .selectFrom(table) .fetch() .map(mapper()); }
@Override public final List<P> findAll() { return using(configuration) .selectFrom(table) .fetch() .map(mapper()); }
@SuppressWarnings("unchecked") @Override public /* non-final */ <Z> List<P> fetch(Field<Z> field, Z... values) { return using(configuration) .selectFrom(table) .where(field.in(values)) .fetch() .map(mapper()); }
@Override public final <Z> List<P> fetch(Field<Z> field, Z... values) { return using(configuration) .selectFrom(table) .where(field.in(values)) .fetch() .map(mapper()); }
@Override public HealthcheckInstanceHostMap getHealthCheckInstanceUUID(String hostUUID, String instanceUUID) { MultiRecordMapper<HealthcheckInstanceHostMap> mapper = new MultiRecordMapper<HealthcheckInstanceHostMap>() { @Override protected HealthcheckInstanceHostMap map(List<Object> input) { if (input.get(0) != null) { return (HealthcheckInstanceHostMap) input.get(0); } return null; } }; HealthcheckInstanceHostMapTable hostMap = mapper.add(HEALTHCHECK_INSTANCE_HOST_MAP); InstanceTable instance = mapper.add(INSTANCE, INSTANCE.UUID, INSTANCE.ID); HostTable host = mapper.add(HOST, HOST.UUID, HOST.ID); List<HealthcheckInstanceHostMap> maps = create() .select(mapper.fields()) .from(hostMap) .join(instance) .on(instance.ID.eq(hostMap.INSTANCE_ID)) .join(host) .on(host.ID.eq(hostMap.HOST_ID)) .where(host.UUID.eq(hostUUID)) .and(instance.UUID.eq(instanceUUID)) .and(hostMap.REMOVED.isNull()) .fetch().map(mapper); if (maps.size() == 0) { return null; } return maps.get(0); }
@Override public Map<Long, IpAddress> getNicIdToPrimaryIpAddress(long accountId) { final Map<Long, IpAddress> result = new HashMap<>(); MultiRecordMapper<List<Object>> mapper = new MultiRecordMapper<List<Object>>() { @Override protected List<Object> map(List<Object> input) { result.put(((Nic) input.get(0)).getId(), (IpAddress) input.get(1)); return input; } }; NicTable nic = mapper.add(NIC); IpAddressTable ipAddress = mapper.add(IP_ADDRESS); create() .select(mapper.fields()) .from(nic) .join(IP_ADDRESS_NIC_MAP) .on(IP_ADDRESS_NIC_MAP.NIC_ID.eq(nic.ID)) .join(ipAddress) .on(ipAddress.ID.eq(IP_ADDRESS_NIC_MAP.IP_ADDRESS_ID)) .where(ipAddress.NETWORK_ID.eq(nic.NETWORK_ID) .and(IP_ADDRESS_NIC_MAP.REMOVED.isNull()) .and(ipAddress.REMOVED.isNull()) .and(nic.REMOVED.isNull())) .and(nic.ACCOUNT_ID.eq(accountId)) .fetch().map(mapper); return result; }
protected List<HostMetaData> getAllInstanceHostMetaDataForAccount(final Account account) { MultiRecordMapper<HostMetaData> mapper = new MultiRecordMapper<HostMetaData>() { @Override protected HostMetaData map(List<Object> input) { Host host = (Host) input.get(0); IpAddress hostIp = (IpAddress) input.get(1); HostMetaData data = new HostMetaData(hostIp.getAddress(), host, account); return data; } }; HostTable host = mapper.add(HOST); IpAddressTable hostIpAddress = mapper.add(IP_ADDRESS); return create() .select(mapper.fields()) .from(hostIpAddress) .join(HOST_IP_ADDRESS_MAP) .on(HOST_IP_ADDRESS_MAP.IP_ADDRESS_ID.eq(hostIpAddress.ID)) .join(host) .on(host.ID.eq(HOST_IP_ADDRESS_MAP.HOST_ID)) .where(host.REMOVED.isNull()) .and(host.STATE.notIn(CommonStatesConstants.REMOVING, CommonStatesConstants.REMOVED)) .and(hostIpAddress.REMOVED.isNull()) .and(host.ACCOUNT_ID.eq(account.getId())) .fetch().map(mapper); }
.and(hostIpAddress.REMOVED.isNull()) .and(exposeMap.SERVICE_ID.in(linkedServicesIds)) .fetch().map(mapper);
.and(INSTANCE.REMOVED.isNull()) .and(ipAddress.ROLE.eq(IpAddressConstants.ROLE_PRIMARY)) .fetch().map(mapper);
.where(nic.INSTANCE_ID.eq(agentInstance.getId()).and(nic.REMOVED.isNull())); return q.fetch().map(mapper);
CommonStatesConstants.UPDATING_ACTIVE)) .and(condition) .fetch().map(mapper);