From 8917c0d7a122c154a83b13cd9b7f1cfba2a41bda Mon Sep 17 00:00:00 2001
From: Stephane Gamard <stephane.gamard@searchbox.com>
Date: Fri, 23 May 2014 16:26:37 +0200
Subject: SONAR-5012 - Removed empty facets.

---
 .../sonar/core/qualityprofile/db/ActiveRuleMapper.xml    | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'sonar-core')

diff --git a/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/ActiveRuleMapper.xml b/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/ActiveRuleMapper.xml
index 45f24380931..bb120c7b4b0 100644
--- a/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/ActiveRuleMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/ActiveRuleMapper.xml
@@ -36,6 +36,22 @@
     LEFT JOIN active_rules active_rule_parent ON active_rule_parent.profile_id=profile_parent.id AND a.rule_id=active_rule_parent.rule_id
   </sql>
 
+    <select id="selectAllKeysAfterTimestamp" parameterType="Date" resultType="map">
+        SELECT
+        rule.plugin_rule_key as rule,
+        rule.plugin_name as repository,
+        profile.name as profile,
+        profile.language as language
+        FROM active_rules a
+        <include refid="activeRuleKeyJoin"/>
+        <where>
+            AND profile.name = #{profile}
+            AND profile.language = #{language}
+            AND rule.plugin_rule_key = #{rule}
+            AND rule.plugin_name = #{repository}
+        </where>
+    </select>
+
   <insert id="insert" parameterType="ActiveRule" keyColumn="id" useGeneratedKeys="true" keyProperty="id">
     INSERT INTO active_rules (profile_id, rule_id, failure_level, inheritance)
     VALUES (#{profileId}, #{ruleId}, #{severity}, #{inheritance})
-- 
cgit v1.2.3