private List<JobExecutionInfo> processListQuery(Connection connection, JobExecutionQuery query) throws SQLException { Preconditions.checkArgument(query.getId().isQueryListType()); QueryListType queryType = query.getId().getQueryListType(); String listJobExecutionsQuery = ""; if (queryType == QueryListType.DISTINCT) {
List<JobExecutionInfo> jobExecutionInfos = Lists.newArrayList(); JobExecutionInfo jobExecutionInfo = processQueryById(connection, query.getId().getString(), query, Filter.MISSING); if (jobExecutionInfo != null) { jobExecutionInfos.add(jobExecutionInfo); return processQueryByJobName(connection, query.getId().getString(), query, Filter.MISSING); case TABLE: return processQueryByTable(connection, query);
private List<JobExecutionInfo> processQueryByTable(Connection connection, JobExecutionQuery query) throws SQLException { Preconditions.checkArgument(query.getId().isTable()); Filter tableFilter = constructTableFilter(query.getId().getTable()); // Construct the query for job names by table definition String jobNameByTableQuery = String.format(JOB_NAME_QUERY_BY_TABLE_STATEMENT_TEMPLATE, tableFilter.getFilter()); List<JobExecutionInfo> jobExecutionInfos = Lists.newArrayList(); // Query job names by table definition try (PreparedStatement queryStatement = connection.prepareStatement(jobNameByTableQuery)) { if (tableFilter.isPresent()) { tableFilter.addParameters(queryStatement, 1); } try (ResultSet rs = queryStatement.executeQuery()) { while (rs.next()) { jobExecutionInfos.addAll(processQueryByJobName(connection, rs.getString(1), query, tableFilter)); } } return jobExecutionInfos; } }
private List<JobExecutionInfo> processListQuery(Connection connection, JobExecutionQuery query) throws SQLException { Preconditions.checkArgument(query.getId().isQueryListType()); QueryListType queryType = query.getId().getQueryListType(); String listJobExecutionsQuery; if (queryType == QueryListType.DISTINCT) {
private List<JobExecutionInfo> processQueryByTable(Connection connection, JobExecutionQuery query) throws SQLException { Preconditions.checkArgument(query.getId().isTable()); Filter tableFilter = constructTableFilter(query.getId().getTable()); // Construct the query for job names by table definition String jobNameByTableQuery = String.format(JOB_NAME_QUERY_BY_TABLE_STATEMENT_TEMPLATE, tableFilter); List<JobExecutionInfo> jobExecutionInfos = Lists.newArrayList(); // Query job names by table definition try (PreparedStatement queryStatement = connection.prepareStatement(jobNameByTableQuery)) { if (tableFilter.isPresent()) { tableFilter.addParameters(queryStatement, 1); } try (ResultSet rs = queryStatement.executeQuery()) { while (rs.next()) { jobExecutionInfos.addAll(processQueryByJobName(connection, rs.getString(1), query, tableFilter)); } } } return jobExecutionInfos; }
public boolean isQueryListType() { return memberIs("gobblin.rest.QueryListType"); }
public void setString(java.lang.String value) { selectDirect(MEMBER_String, java.lang.String.class, java.lang.String.class, "string", value); }
public void setQueryListType(gobblin.rest.QueryListType value) { selectDirect(MEMBER_QueryListType, gobblin.rest.QueryListType.class, java.lang.String.class, "gobblin.rest.QueryListType", value); }
public gobblin.rest.QueryListType getQueryListType() { return obtainDirect(MEMBER_QueryListType, gobblin.rest.QueryListType.class, "gobblin.rest.QueryListType"); }
public gobblin.rest.Table getTable() { return obtainWrapped(MEMBER_Table, gobblin.rest.Table.class, "gobblin.rest.Table"); }
public boolean isString() { return memberIs("string"); }
public boolean isTable() { return memberIs("gobblin.rest.Table"); }
public java.lang.String getString() { return obtainDirect(MEMBER_String, java.lang.String.class, "string"); }
public static JobExecutionQuery.Id create(java.lang.String value) { JobExecutionQuery.Id newUnion = new JobExecutionQuery.Id(); newUnion.setString(value); return newUnion; }
public static JobExecutionQuery.Id create(gobblin.rest.QueryListType value) { JobExecutionQuery.Id newUnion = new JobExecutionQuery.Id(); newUnion.setQueryListType(value); return newUnion; }
public static JobExecutionQuery.Id create(gobblin.rest.Table value) { JobExecutionQuery.Id newUnion = new JobExecutionQuery.Id(); newUnion.setTable(value); return newUnion; }