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/main/resources | |
| 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/main/resources')
| -rw-r--r-- | sonar-db/src/main/resources/org/sonar/db/component/ComponentMapper.xml | 10 |
1 files changed, 10 insertions, 0 deletions
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"/> |