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.component; import com.google.common.base.Function; import com.google.common.base.Strings; import com.google.common.collect.Lists; import java.util.Collection; import java.util.List; import javax.annotation.CheckForNull; import javax.annotation.Nonnull; import javax.annotation.Nullable; import org.apache.ibatis.session.RowBounds; import org.sonar.api.resources.Scopes; import org.sonar.db.Dao; import org.sonar.db.DbSession; import org.sonar.db.RowNotFoundException; import static com.google.common.base.Preconditions.checkState; import static com.google.common.collect.FluentIterable.from; import static org.sonar.db.DatabaseUtils.executeLargeInputs; public class SnapshotDao implements Dao { public static boolean isLast(SnapshotDto snapshotTested, @Nullable SnapshotDto previousLastSnapshot) { return previousLastSnapshot == null || previousLastSnapshot.getCreatedAt() < snapshotTested.getCreatedAt(); } @CheckForNull public SnapshotDto selectById(DbSession session, long id) { return mapper(session).selectByKey(id); } public SnapshotDto selectOrFailById(DbSession session, long id) { SnapshotDto value = selectById(session, id); if (value == null) { throw new RowNotFoundException(String.format("Snapshot id does not exist: %d", id)); } return value; } public List<SnapshotDto> selectByIds(final DbSession dbSession, List<Long> snapshotIds) { return executeLargeInputs(snapshotIds, new Function<List<Long>, List<SnapshotDto>>() { @Nonnull @Override public List<SnapshotDto> apply(@Nonnull List<Long> input) { return mapper(dbSession).selectByIds(input); } }); } @CheckForNull public SnapshotDto selectLastSnapshotByComponentId(DbSession session, long componentId) { return mapper(session).selectLastSnapshot(componentId); } public boolean hasLastSnapshotByComponentUuid(DbSession session, String componentUUid) { return mapper(session).countLastSnapshotByComponentUuid(componentUUid) > 0; } public List<SnapshotDto> selectSnapshotsByComponentId(DbSession session, long componentId) { return mapper(session).selectSnapshotsByQuery(new SnapshotQuery().setComponentId(componentId)); } public List<SnapshotDto> selectSnapshotsByQuery(DbSession session, SnapshotQuery query) { return mapper(session).selectSnapshotsByQuery(query); } @CheckForNull public SnapshotDto selectSnapshotByQuery(DbSession session, SnapshotQuery query) { List<SnapshotDto> snapshotDtos = mapper(session).selectSnapshotsByQuery(query); if (snapshotDtos.isEmpty()) { return null; } checkState(snapshotDtos.size() == 1, "Expected one snapshot to be returned, got %s", snapshotDtos.size()); return snapshotDtos.get(0); } public List<SnapshotDto> selectPreviousVersionSnapshots(DbSession session, long componentId, String lastVersion) { return mapper(session).selectPreviousVersionSnapshots(componentId, lastVersion); } @CheckForNull public SnapshotDto selectOldestSnapshot(DbSession session, long componentId) { List<SnapshotDto> snapshotDtos = mapper(session).selectOldestSnapshots(componentId, new RowBounds(0, 1)); return snapshotDtos.isEmpty() ? null : snapshotDtos.get(0); } public List<SnapshotDto> selectSnapshotAndChildrenOfProjectScope(DbSession session, long snapshotId) { return mapper(session).selectSnapshotAndChildrenOfScope(snapshotId, Scopes.PROJECT); } public int updateSnapshotAndChildrenLastFlagAndStatus(DbSession session, SnapshotDto snapshot, boolean isLast, String status) { Long rootId = snapshot.getId(); String path = Strings.nullToEmpty(snapshot.getPath()) + snapshot.getId() + ".%"; Long pathRootId = snapshot.getRootIdOrSelf(); return mapper(session).updateSnapshotAndChildrenLastFlagAndStatus(rootId, pathRootId, path, isLast, status); } public int updateSnapshotAndChildrenLastFlag(DbSession session, SnapshotDto snapshot, boolean isLast) { Long rootId = snapshot.getId(); String path = Strings.nullToEmpty(snapshot.getPath()) + snapshot.getId() + ".%"; Long pathRootId = snapshot.getRootIdOrSelf(); return mapper(session).updateSnapshotAndChildrenLastFlag(rootId, pathRootId, path, isLast); } public SnapshotDto insert(DbSession session, SnapshotDto item) { mapper(session).insert(item); return item; } public void insert(DbSession session, Collection<SnapshotDto> items) { for (SnapshotDto item : items) { insert(session, item); } } public void insert(DbSession session, SnapshotDto item, SnapshotDto... others) { insert(session, Lists.asList(item, others)); } @CheckForNull public ViewsSnapshotDto selectSnapshotBefore(long componentId, long date, DbSession dbSession) { return from(mapper(dbSession).selectSnapshotBefore(componentId, date)).first().orNull(); } @CheckForNull public ViewsSnapshotDto selectLatestSnapshot(long componentId, DbSession dbSession) { return mapper(dbSession).selectLatestSnapshot(componentId); } private SnapshotMapper mapper(DbSession session) { return session.getMapper(SnapshotMapper.class); } }