private static List<Project> selectProjects(DbSession session, long afterDate, @Nullable String projectUuid) {
List<Project> projects = new ArrayList<>();
try (PreparedStatement stmt = createProjectsStatement(session, afterDate, projectUuid);
ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
String orgUuid = rs.getString(1);
String uuid = rs.getString(2);
String key = rs.getString(3);
String name = rs.getString(4);
String analysisUuid = DatabaseUtils.getString(rs, 5);
Long analysisDate = DatabaseUtils.getLong(rs, 6);
Project project = new Project(orgUuid, uuid, key, name, analysisUuid, analysisDate);
projects.add(project);
}
return projects;
} catch (SQLException e) {
throw new IllegalStateException("Fail to execute request to select all projects", e);
}
}