Move custom measures in sonar-db

2 files changed, 202 insertions, 0 deletions

diff --git a/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureDaoTest.java b/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureDaoTest.java
new file mode 100644
index 00000000000..559b4779032
--- /dev/null
+++ b/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureDaoTest.java
@@ -0,0 +1,159 @@
+/*
+ * SonarQube, open source software quality management tool.
+ * Copyright (C) 2008-2014 SonarSource
+ * mailto:contact AT sonarsource DOT com
+ *
+ * SonarQube is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 3 of the License, or (at your option) any later version.
+ *
+ * SonarQube is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with this program; if not, write to the Free Software Foundation,
+ * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+
+package org.sonar.db.measure.custom;
+
+import java.util.Arrays;
+import java.util.List;
+import org.junit.Before;
+import org.junit.Rule;
+import org.junit.Test;
+import org.junit.experimental.categories.Category;
+import org.junit.rules.ExpectedException;
+import org.sonar.api.utils.System2;
+import org.sonar.db.DbSession;
+import org.sonar.db.DbTester;
+import org.sonar.test.DbTests;
+
+import static org.assertj.core.api.Assertions.assertThat;
+import static org.assertj.core.api.Assertions.offset;
+import static org.sonar.db.measure.custom.CustomMeasureTesting.newCustomMeasureDto;
+
+@Category(DbTests.class)
+public class CustomMeasureDaoTest {
+  @Rule
+  public DbTester db = DbTester.create(System2.INSTANCE);
+  @Rule
+  public ExpectedException expectedException = ExpectedException.none();
+
+  CustomMeasureDao sut;
+  DbSession session;
+
+  @Before
+  public void setUp() {
+    session = db.getSession();
+    sut = new CustomMeasureDao();
+    db.truncateTables();
+  }
+
+  @Test
+  public void insert() {
+    CustomMeasureDto measure = newCustomMeasureDto();
+
+    sut.insert(session, measure);
+
+    CustomMeasureDto result = sut.selectById(session, measure.getId());
+    assertThat(result.getId()).isEqualTo(measure.getId());
+    assertThat(result.getMetricId()).isEqualTo(measure.getMetricId());
+    assertThat(result.getComponentUuid()).isEqualTo(measure.getComponentUuid());
+    assertThat(result.getDescription()).isEqualTo(measure.getDescription());
+    assertThat(result.getUserLogin()).isEqualTo(measure.getUserLogin());
+    assertThat(result.getTextValue()).isEqualTo(measure.getTextValue());
+    assertThat(result.getValue()).isCloseTo(measure.getValue(), offset(0.001d));
+    assertThat(result.getCreatedAt()).isEqualTo(measure.getCreatedAt());
+    assertThat(result.getUpdatedAt()).isEqualTo(measure.getUpdatedAt());
+  }
+
+  @Test
+  public void delete_by_metric_id() {
+    CustomMeasureDto measure = newCustomMeasureDto();
+    sut.insert(session, measure);
+    assertThat(sut.selectNullableById(session, measure.getId())).isNotNull();
+
+    sut.deleteByMetricIds(session, Arrays.asList(measure.getMetricId()));
+
+    assertThat(sut.selectNullableById(session, measure.getId())).isNull();
+  }
+
+  @Test
+  public void update() {
+    CustomMeasureDto measure = newCustomMeasureDto().setDescription("old-description");
+    sut.insert(session, measure);
+    measure.setDescription("new-description");
+
+    sut.update(session, measure);
+
+    assertThat(sut.selectNullableById(session, measure.getId()).getDescription()).isEqualTo("new-description");
+  }
+
+  @Test
+  public void delete() {
+    CustomMeasureDto measure = newCustomMeasureDto();
+    sut.insert(session, measure);
+
+    sut.delete(session, measure.getId());
+    assertThat(sut.selectNullableById(session, measure.getId())).isNull();
+  }
+
+  @Test
+  public void select_by_component_uuid() {
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u1"));
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u1"));
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u2"));
+    session.commit();
+
+    List<CustomMeasureDto> result = sut.selectByComponentUuid(session, "u1");
+
+    assertThat(result).hasSize(2);
+    assertThat(result).extracting("componentUuid").containsOnly("u1");
+    assertThat(sut.countByComponentUuid(session, "u1")).isEqualTo(2);
+  }
+
+  @Test
+  public void select_by_component_uuid_with_options() {
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u1"));
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u1"));
+    sut.insert(session, newCustomMeasureDto().setComponentUuid("u2"));
+    session.commit();
+
+    List<CustomMeasureDto> result = sut.selectByComponentUuid(session, "u1", 0, 100);
+
+    assertThat(result).hasSize(2);
+    assertThat(result).extracting("componentUuid").containsOnly("u1");
+  }
+
+  @Test
+  public void select_by_metric_id() {
+    sut.insert(session, newCustomMeasureDto().setMetricId(123));
+    sut.insert(session, newCustomMeasureDto().setMetricId(123));
+
+    List<CustomMeasureDto> result = sut.selectByMetricId(session, 123);
+
+    assertThat(result).hasSize(2);
+  }
+
+  @Test
+  public void count_by_component_uuid_and_metric_id() {
+    sut.insert(session, newCustomMeasureDto().setMetricId(123).setComponentUuid("123"));
+    sut.insert(session, newCustomMeasureDto().setMetricId(123).setComponentUuid("123"));
+
+    int count = sut.countByComponentIdAndMetricId(session, "123", 123);
+
+    assertThat(count).isEqualTo(2);
+  }
+
+  @Test
+  public void select_by_id_fail_if_no_measure_found() {
+    expectedException.expect(IllegalArgumentException.class);
+
+    sut.selectById(session, 42L);
+  }
+
+}
diff --git a/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureTesting.java b/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureTesting.java
new file mode 100644
index 00000000000..6f6dcf5e0d5
--- /dev/null
+++ b/sonar-db/src/test/java/org/sonar/db/measure/custom/CustomMeasureTesting.java
@@ -0,0 +1,43 @@
+/*
+ * SonarQube, open source software quality management tool.
+ * Copyright (C) 2008-2014 SonarSource
+ * mailto:contact AT sonarsource DOT com
+ *
+ * SonarQube is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 3 of the License, or (at your option) any later version.
+ *
+ * SonarQube is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with this program; if not, write to the Free Software Foundation,
+ * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+
+package org.sonar.db.measure.custom;
+
+import org.apache.commons.lang.RandomStringUtils;
+import org.apache.commons.lang.math.RandomUtils;
+import org.sonar.api.utils.System2;
+
+public class CustomMeasureTesting {
+  private CustomMeasureTesting() {
+    // static stuff only
+  }
+
+  public static CustomMeasureDto newCustomMeasureDto() {
+    return new CustomMeasureDto()
+      .setDescription(RandomStringUtils.randomAlphanumeric(255))
+      .setTextValue(RandomStringUtils.randomAlphanumeric(255))
+      .setUserLogin(RandomStringUtils.randomAlphanumeric(255))
+      .setValue(RandomUtils.nextDouble())
+      .setMetricId(RandomUtils.nextInt())
+      .setComponentUuid(RandomStringUtils.randomAlphanumeric(50))
+      .setCreatedAt(System2.INSTANCE.now())
+      .setUpdatedAt(System2.INSTANCE.now());
+  }
+}