/** * Get latest iteration, null if no iteration exists * * @param connection * @return */ public static Iteration getLatestIteration(Connection connection) { String query = "select iteration_number, begin_time, end_time from periodic_test_iterations" + " where iteration_number = (select max(iteration_number) from periodic_test_iterations)"; return connection.createQuery(query) .addColumnMapping("iteration_number", "iterationNumber") .addColumnMapping("begin_time", "begin") .addColumnMapping("end_time", "end") .executeAndFetchFirst(Iteration.class); }
public static List<Server> getPublicServers(Connection connection) { String query = "select domain,software_name,software_version,listed from servers where listed=1"; return connection.createQuery(query) .addColumnMapping("software_name", "softwareName") .addColumnMapping("software_version", "softwareVersion") .executeAndFetch(Server.class); }
public static List<Server> getAllServers(Connection connection) { String query = "select domain,software_name,software_version,listed from servers"; return connection.createQuery(query) .addColumnMapping("software_name", "softwareName") .addColumnMapping("software_version", "softwareVersion") .executeAndFetch(Server.class); }
/** * Get the iteration which has the given iteration number * * @param connection * @param iterationNumber The iteration numbers for which the corresponding iteration is to be found * @return A list of iterations */ public static Iteration getIteration(Connection connection, int iterationNumber) { String query = "select iteration_number, begin_time, end_time from periodic_test_iterations" + " where iteration_number = (:iteration) limit 1"; return connection.createQuery(query) .addParameter("iteration", iterationNumber) .addColumnMapping("iteration_number", "iterationNumber") .addColumnMapping("begin_time", "begin") .addColumnMapping("end_time", "end") .executeAndFetchFirst(Iteration.class); }
public static Server getServer(Connection connection, String domain) { String query = "select domain,software_name,software_version,listed from servers where domain = :domain"; return connection.createQuery(query) .addColumnMapping("software_name", "softwareName") .addColumnMapping("software_version", "softwareVersion") .addParameter("domain", domain) .executeAndFetchFirst(Server.class); }