Java tutorial
/* * SonarQube * Copyright (C) 2009-2016 SonarSource SA * mailto:contact AT sonarsource DOT com * * This program 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. * * This program 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.user; import com.google.common.base.Function; import java.util.Collection; import java.util.Date; import java.util.List; import java.util.Locale; import javax.annotation.CheckForNull; import javax.annotation.Nonnull; import javax.annotation.Nullable; import org.apache.commons.lang.StringUtils; import org.apache.ibatis.session.RowBounds; import org.sonar.api.utils.System2; import org.sonar.db.Dao; import org.sonar.db.DatabaseUtils; import org.sonar.db.DbSession; import org.sonar.db.RowNotFoundException; import org.sonar.db.WildcardPosition; import static org.sonar.db.DatabaseUtils.executeLargeInputs; public class GroupDao implements Dao { private System2 system; public GroupDao(System2 system) { this.system = system; } public GroupDto selectOrFailByName(DbSession session, String key) { GroupDto group = selectByName(session, key); if (group == null) { throw new RowNotFoundException(String.format("Could not find a group with name '%s'", key)); } return group; } @CheckForNull public GroupDto selectByName(DbSession session, String key) { return mapper(session).selectByKey(key); } public List<GroupDto> selectByNames(DbSession session, Collection<String> names) { return executeLargeInputs(names, new SelectByNames(mapper(session))); } public GroupDto selectOrFailById(DbSession dbSession, long groupId) { GroupDto group = selectById(dbSession, groupId); if (group == null) { throw new RowNotFoundException(String.format("Could not find a group with id '%d'", groupId)); } return group; } @CheckForNull public GroupDto selectById(DbSession dbSession, long groupId) { return mapper(dbSession).selectById(groupId); } public void deleteById(DbSession dbSession, long groupId) { mapper(dbSession).deleteById(groupId); } public int countByQuery(DbSession session, @Nullable String query) { return mapper(session).countByQuery(groupSearchToSql(query)); } public List<GroupDto> selectByQuery(DbSession session, @Nullable String query, int offset, int limit) { return mapper(session).selectByQuery(groupSearchToSql(query), new RowBounds(offset, limit)); } public GroupDto insert(DbSession session, GroupDto item) { Date createdAt = new Date(system.now()); item.setCreatedAt(createdAt).setUpdatedAt(createdAt); mapper(session).insert(item); return item; } public GroupDto update(DbSession session, GroupDto item) { item.setUpdatedAt(new Date(system.now())); mapper(session).update(item); return item; } public List<GroupDto> selectByUserLogin(DbSession session, String login) { return mapper(session).selectByUserLogin(login); } @CheckForNull private static String groupSearchToSql(@Nullable String query) { if (query == null) { return null; } String upperCasedNameQuery = StringUtils.upperCase(query, Locale.ENGLISH); return DatabaseUtils.buildLikeValue(upperCasedNameQuery, WildcardPosition.BEFORE_AND_AFTER); } private GroupMapper mapper(DbSession session) { return session.getMapper(GroupMapper.class); } private static class SelectByNames implements Function<List<String>, List<GroupDto>> { private final GroupMapper mapper; private SelectByNames(GroupMapper mapper) { this.mapper = mapper; } @Override public List<GroupDto> apply(@Nonnull List<String> partitionOfNames) { return mapper.selectByNames(partitionOfNames); } } }