@Override public List<String> getTestNames() { try { return db.withConnection( new ConnectionAction<List<String>>() { public List<String> execute(Connection connection) throws Exception { List<String> testNames = new ArrayList<String>(); ResultSet testExecutions = connection .createStatement() .executeQuery("select distinct testId from testExecution order by testId"); while (testExecutions.next()) { testNames.add(testExecutions.getString(1)); } return testNames; } }); } catch (Exception e) { throw new RuntimeException( String.format("Could not load test history from datastore '%s'.", dbFile), e); } }
public void report(final CrossVersionPerformanceResults results) { try { db.withConnection( new ConnectionAction<Void>() { public Void execute(Connection connection) throws Exception { long testId; PreparedStatement statement = connection.prepareStatement( "insert into testExecution(testId, executionTime, targetVersion, testProject, tasks, args, gradleOpts, daemon, operatingSystem, jvm, vcsBranch, vcsCommit) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); try { statement.setString(1, results.getTestId()); statement.setTimestamp(2, new Timestamp(results.getTestTime())); statement.setString(3, results.getVersionUnderTest()); statement.setString(4, results.getTestProject()); statement.setObject(5, toArray(results.getTasks())); statement.setObject(6, toArray(results.getArgs())); statement.setObject(7, toArray(results.getGradleOpts())); statement.setObject(8, results.getDaemon()); statement.setString(9, results.getOperatingSystem()); statement.setString(10, results.getJvm()); statement.setString(11, results.getVcsBranch()); String vcs = results.getVcsCommits() == null ? null : Joiner.on(",").join(results.getVcsCommits()); statement.setString(12, vcs); statement.execute(); ResultSet keys = statement.getGeneratedKeys(); keys.next(); testId = keys.getLong(1); } finally { statement.close(); } statement = connection.prepareStatement( "insert into testOperation(testExecution, version, totalTime, configurationTime, executionTime, heapUsageBytes, totalHeapUsageBytes, maxHeapUsageBytes, maxUncollectedHeapBytes, maxCommittedHeapBytes) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); try { addOperations(statement, testId, null, results.getCurrent()); for (BaselineVersion baselineVersion : results.getBaselineVersions()) { addOperations( statement, testId, baselineVersion.getVersion(), baselineVersion.getResults()); } } finally { statement.close(); } for (String previousId : results.getPreviousTestIds()) { statement = connection.prepareStatement( "update testExecution set testId = ? where testId = ?"); try { statement.setString(1, results.getTestId()); statement.setString(2, previousId); statement.execute(); } finally { statement.close(); } } return null; } }); } catch (Exception e) { throw new RuntimeException( String.format("Could not open results datastore '%s'.", dbFile), e); } }
public void close() { db.close(); }
@Override public CrossVersionPerformanceTestHistory getTestResults( final String testName, final int mostRecentN) { try { return db.withConnection( new ConnectionAction<CrossVersionPerformanceTestHistory>() { public CrossVersionPerformanceTestHistory execute(Connection connection) throws Exception { List<CrossVersionPerformanceResults> results = new ArrayList<CrossVersionPerformanceResults>(); Set<String> allVersions = new TreeSet<String>( new Comparator<String>() { public int compare(String o1, String o2) { return GradleVersion.version(o1).compareTo(GradleVersion.version(o2)); } }); Set<String> allBranches = new TreeSet<String>(); PreparedStatement executionsForName = connection.prepareStatement( "select top ? id, executionTime, targetVersion, testProject, tasks, args, gradleOpts, daemon, operatingSystem, jvm, vcsBranch, vcsCommit from testExecution where testId = ? order by executionTime desc"); PreparedStatement operationsForExecution = connection.prepareStatement( "select version, totalTime, configurationTime, executionTime, heapUsageBytes, totalHeapUsageBytes, maxHeapUsageBytes, maxUncollectedHeapBytes, maxCommittedHeapBytes from testOperation where testExecution = ?"); executionsForName.setInt(1, mostRecentN); executionsForName.setString(2, testName); ResultSet testExecutions = executionsForName.executeQuery(); while (testExecutions.next()) { long id = testExecutions.getLong(1); CrossVersionPerformanceResults performanceResults = new CrossVersionPerformanceResults(); performanceResults.setTestId(testName); performanceResults.setTestTime(testExecutions.getTimestamp(2).getTime()); performanceResults.setVersionUnderTest(testExecutions.getString(3)); performanceResults.setTestProject(testExecutions.getString(4)); performanceResults.setTasks(toList(testExecutions.getObject(5))); performanceResults.setArgs(toList(testExecutions.getObject(6))); performanceResults.setGradleOpts(toList(testExecutions.getObject(7))); performanceResults.setDaemon((Boolean) testExecutions.getObject(8)); performanceResults.setOperatingSystem(testExecutions.getString(9)); performanceResults.setJvm(testExecutions.getString(10)); performanceResults.setVcsBranch(testExecutions.getString(11).trim()); performanceResults.setVcsCommits(splitVcsCommits(testExecutions.getString(12))); results.add(performanceResults); allBranches.add(performanceResults.getVcsBranch()); operationsForExecution.setLong(1, id); ResultSet builds = operationsForExecution.executeQuery(); while (builds.next()) { String version = builds.getString(1); if ("1.7".equals(version) && performanceResults.getTestTime() <= ignoreV17Before) { // Ignore some broken samples continue; } MeasuredOperation operation = new MeasuredOperation(); operation.setTotalTime(Duration.millis(builds.getBigDecimal(2))); operation.setConfigurationTime(Duration.millis(builds.getBigDecimal(3))); operation.setExecutionTime(Duration.millis(builds.getBigDecimal(4))); operation.setTotalMemoryUsed(DataAmount.bytes(builds.getBigDecimal(5))); operation.setTotalHeapUsage(DataAmount.bytes(builds.getBigDecimal(6))); operation.setMaxHeapUsage(DataAmount.bytes(builds.getBigDecimal(7))); operation.setMaxUncollectedHeap(DataAmount.bytes(builds.getBigDecimal(8))); operation.setMaxCommittedHeap(DataAmount.bytes(builds.getBigDecimal(9))); if (version == null) { performanceResults.getCurrent().add(operation); } else { BaselineVersion baselineVersion = performanceResults.baseline(version); baselineVersion.getResults().add(operation); allVersions.add(version); } } } testExecutions.close(); operationsForExecution.close(); executionsForName.close(); return new CrossVersionPerformanceTestHistory( testName, new ArrayList<String>(allVersions), new ArrayList<String>(allBranches), results); } }); } catch (Exception e) { throw new RuntimeException( String.format("Could not load results from datastore '%s'.", dbFile), e); } }