diff options
| author | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2017-01-19 11:31:16 +0100 |
|---|---|---|
| committer | Sébastien Lesaint <sebastien.lesaint@sonarsource.com> | 2017-01-23 16:56:35 +0100 |
| commit | ade9f5dd257775ca22e8be0d10a574fce92c80cb (patch) | |
| tree | afab88351ca5911d369196d268db5fd173913601 /sonar-db/src | |
| parent | 0832a517c9b7cb70d51ba6557094a605a8a9efdc (diff) | |
| download | sonarqube-ade9f5dd257775ca22e8be0d10a574fce92c80cb.tar.gz sonarqube-ade9f5dd257775ca22e8be0d10a574fce92c80cb.zip | |
SONAR-8681 delete perm,groups&components in api/organizations/delete
Diffstat (limited to 'sonar-db/src')
3 files changed, 19 insertions, 0 deletions
diff --git a/sonar-db/src/main/java/org/sonar/db/component/ComponentDao.java b/sonar-db/src/main/java/org/sonar/db/component/ComponentDao.java index 0bc027afb7a..ad049fc90df 100644 --- a/sonar-db/src/main/java/org/sonar/db/component/ComponentDao.java +++ b/sonar-db/src/main/java/org/sonar/db/component/ComponentDao.java @@ -198,6 +198,13 @@ public class ComponentDao implements Dao { return mapper(session).selectProjects(); } + /** + * Select all root components (projects and views), including disabled ones, for a given organization. + */ + public List<ComponentDto> selectAllRootsByOrganization(DbSession dbSession, String organizationUuid) { + return mapper(dbSession).selectAllRootsByOrganization(organizationUuid); + } + public List<ComponentDto> selectProvisionedProjects(DbSession session, int offset, int limit, @Nullable String query) { Map<String, Object> parameters = newHashMapWithExpectedSize(2); addProjectQualifier(parameters); diff --git a/sonar-db/src/main/java/org/sonar/db/component/ComponentMapper.java b/sonar-db/src/main/java/org/sonar/db/component/ComponentMapper.java index a32a4177b58..9ad0394deb4 100644 --- a/sonar-db/src/main/java/org/sonar/db/component/ComponentMapper.java +++ b/sonar-db/src/main/java/org/sonar/db/component/ComponentMapper.java @@ -69,6 +69,8 @@ public interface ComponentMapper { */ List<ComponentDto> selectProjects(); + List<ComponentDto> selectAllRootsByOrganization(@Param("organizationUuid") String organizationUuid); + /** * Return all descendant modules (including itself) from a given component uuid and scope */ diff --git a/sonar-db/src/main/resources/org/sonar/db/component/ComponentMapper.xml b/sonar-db/src/main/resources/org/sonar/db/component/ComponentMapper.xml index 92c23601b28..6fba079f9d5 100644 --- a/sonar-db/src/main/resources/org/sonar/db/component/ComponentMapper.xml +++ b/sonar-db/src/main/resources/org/sonar/db/component/ComponentMapper.xml @@ -214,6 +214,16 @@ </where> </select> + <select id="selectAllRootsByOrganization" resultType="Component"> + select + <include refid="componentColumns"/> + from projects p + where + p.scope='PRJ' + and (p.qualifier='TRK' or p.qualifier='VW') + and p.organization_uuid = #{organizationUuid,jdbcType=VARCHAR} + </select> + <select id="selectComponentsByQualifiers" resultType="Component"> SELECT <include refid="componentColumns"/> |