@Override public Reader get( EntityReference entityReference ) { String state = dsl.select( stateColumn ) .from( table ) .where( identityColumn.equal( entityReference.identity().toString() ) ) .fetchOptional( stateColumn ) .orElseThrow( () -> new EntityNotFoundException( entityReference ) ); return new StringReader( state ); }
public Optional<String> get(String alias) { try (DSLContext tx = DSL.using(cfg)) { return tx.select(TEMPLATE_ALIASES.TEMPLATE_URL) .from(TEMPLATE_ALIASES) .where(TEMPLATE_ALIASES.TEMPLATE_ALIAS.eq(alias)) .fetchOptional(TEMPLATE_ALIASES.TEMPLATE_URL); } }
public Optional<Boolean> isAcceptsRawPayload(UUID projectId) { try (DSLContext tx = DSL.using(cfg)) { return tx.select(PROJECTS.ACCEPTS_RAW_PAYLOAD) .from(PROJECTS) .where(PROJECTS.PROJECT_ID.eq(projectId)) .fetchOptional(PROJECTS.ACCEPTS_RAW_PAYLOAD); } }
public ProcessLog get(ProcessKey processKey, Integer start, Integer end) { UUID instanceId = processKey.getInstanceId(); Timestamp createdAt = processKey.getCreatedAt(); try (DSLContext tx = DSL.using(cfg)) { List<ProcessLogChunk> chunks = getChunks(tx, processKey, start, end); int size = tx.select(V_PROCESS_LOGS_SIZE.SIZE) .from(V_PROCESS_LOGS_SIZE) .where(V_PROCESS_LOGS_SIZE.INSTANCE_ID.eq(instanceId) .and(V_PROCESS_LOGS_SIZE.INSTANCE_CREATED_AT.eq(createdAt))) .fetchOptional(V_PROCESS_LOGS_SIZE.SIZE) .orElse(0); return new ProcessLog(size, chunks); } }