From 526e4462a75591804fa560f65e536cf4f9a20b72 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Fri, 6 Jul 2012 19:12:26 +0200 Subject: [PATCH] Add tests to MyBatis RoleMapper --- .../org/sonar/core/user/RoleMapperTest.java | 79 +++++++++++++++++++ .../core/user/RoleMapperTest/countRoles.xml | 14 ++++ .../deleteRolesByResourceId-result.xml | 14 ++++ .../deleteRolesByResourceId.xml | 14 ++++ .../RoleMapperTest/insertRoles-result.xml | 11 +++ .../core/user/RoleMapperTest/insertRoles.xml | 5 ++ 6 files changed, 137 insertions(+) create mode 100644 sonar-core/src/test/java/org/sonar/core/user/RoleMapperTest.java create mode 100644 sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/countRoles.xml create mode 100644 sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId-result.xml create mode 100644 sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId.xml create mode 100644 sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles-result.xml create mode 100644 sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles.xml diff --git a/sonar-core/src/test/java/org/sonar/core/user/RoleMapperTest.java b/sonar-core/src/test/java/org/sonar/core/user/RoleMapperTest.java new file mode 100644 index 00000000000..2c269694746 --- /dev/null +++ b/sonar-core/src/test/java/org/sonar/core/user/RoleMapperTest.java @@ -0,0 +1,79 @@ +/* + * Sonar, open source software quality management tool. + * Copyright (C) 2008-2012 SonarSource + * mailto:contact AT sonarsource DOT com + * + * Sonar 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. + * + * Sonar 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 Sonar; if not, write to the Free Software + * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02 + */ +package org.sonar.core.user; + +import org.apache.ibatis.session.SqlSession; +import org.junit.After; +import org.junit.Before; +import org.junit.Test; +import org.sonar.core.persistence.AbstractDaoTestCase; +import org.sonar.core.persistence.MyBatis; + +import static org.fest.assertions.Assertions.assertThat; + +public class RoleMapperTest extends AbstractDaoTestCase { + + private SqlSession session; + + @Before + public void openSession() { + session = getMyBatis().openSession(); + } + + @After + public void closeSession() { + MyBatis.closeQuietly(session); + } + + @Test + public void countRoles() { + setupData("countRoles"); + + RoleMapper mapper = session.getMapper(RoleMapper.class); + assertThat(mapper.countGroupRoles(123L)).isEqualTo(2); + assertThat(mapper.countUserRoles(123L)).isEqualTo(1); + } + + @Test + public void deleteRolesByResourceId() { + setupData("deleteRolesByResourceId"); + + RoleMapper mapper = session.getMapper(RoleMapper.class); + mapper.deleteGroupRolesByResourceId(123L); + mapper.deleteUserRolesByResourceId(123L); + session.commit(); + + + checkTables("deleteRolesByResourceId", "group_roles", "user_roles"); + } + + @Test + public void insertRoles() { + setupData("insertRoles"); + + RoleMapper mapper = session.getMapper(RoleMapper.class); + mapper.insertGroupRole(new GroupRoleDto().setRole("admin").setGroupId(100L).setResourceId(123L)); + mapper.insertGroupRole(new GroupRoleDto().setRole("user").setResourceId(123L));// Anyone + mapper.insertUserRole(new UserRoleDto().setRole("codeviewer").setUserId(200L).setResourceId(123L));// Anyone + session.commit(); + + checkTables("insertRoles", "group_roles", "user_roles"); + } +} diff --git a/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/countRoles.xml b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/countRoles.xml new file mode 100644 index 00000000000..ec1ed3b076f --- /dev/null +++ b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/countRoles.xml @@ -0,0 +1,14 @@ + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId-result.xml b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId-result.xml new file mode 100644 index 00000000000..dae82ddd8f8 --- /dev/null +++ b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId-result.xml @@ -0,0 +1,14 @@ + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId.xml b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId.xml new file mode 100644 index 00000000000..ec1ed3b076f --- /dev/null +++ b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/deleteRolesByResourceId.xml @@ -0,0 +1,14 @@ + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles-result.xml b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles-result.xml new file mode 100644 index 00000000000..7a7e6f8e196 --- /dev/null +++ b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles-result.xml @@ -0,0 +1,11 @@ + + + + + + + + + + + \ No newline at end of file diff --git a/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles.xml b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles.xml new file mode 100644 index 00000000000..b99df83bc15 --- /dev/null +++ b/sonar-core/src/test/resources/org/sonar/core/user/RoleMapperTest/insertRoles.xml @@ -0,0 +1,5 @@ + + + + + \ No newline at end of file -- 2.39.5