@Test public void selectByKeys() { qualityProfileDb.insertQualityProfiles( newQualityProfileDto().setKey("qp-key-1"), newQualityProfileDto().setKee("qp-key-2"), newQualityProfileDto().setKee("qp-key-3")); assertThat(underTest.selectOrFailByKey(dbSession, "qp-key-1")).isNotNull(); assertThat(underTest.selectByKey(dbSession, "qp-key-1")).isNotNull(); assertThat(underTest.selectByKey(dbSession, "qp-key-42")).isNull(); assertThat(underTest.selectByKeys(dbSession, newArrayList("qp-key-1", "qp-key-3", "qp-key-42"))) .hasSize(2) .extracting(QualityProfileDto::getKey) .containsOnlyOnce("qp-key-1", "qp-key-3"); assertThat(underTest.selectByKeys(dbSession, emptyList())).isEmpty(); }