2 * Sonar, open source software quality management tool.
3 * Copyright (C) 2009 SonarSource SA
4 * mailto:contact AT sonarsource DOT com
6 * Sonar is free software; you can redistribute it and/or
7 * modify it under the terms of the GNU Lesser General Public
8 * License as published by the Free Software Foundation; either
9 * version 3 of the License, or (at your option) any later version.
11 * Sonar is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
14 * Lesser General Public License for more details.
16 * You should have received a copy of the GNU Lesser General Public
17 * License along with Sonar; if not, write to the Free Software
18 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02
20 package org.sonar.plugins.core.timemachine;
22 import org.apache.commons.lang.time.DateUtils;
23 import org.sonar.api.BatchExtension;
24 import org.sonar.api.database.DatabaseSession;
25 import org.sonar.api.database.model.Snapshot;
27 import java.util.Date;
28 import java.util.List;
30 public class PastSnapshotFinderByDays implements BatchExtension {
32 public static final String MODE = "days";
35 private Snapshot projectSnapshot; // TODO replace by PersistenceManager
36 private DatabaseSession session;
38 public PastSnapshotFinderByDays(Snapshot projectSnapshot, DatabaseSession session) {
39 this.projectSnapshot = projectSnapshot;
40 this.session = session;
43 PastSnapshot findFromDays(int days) {
44 Date targetDate = DateUtils.addDays(projectSnapshot.getCreatedAt(), -days);
45 String hql = "from " + Snapshot.class.getSimpleName() + " where resourceId=:resourceId AND status=:status AND createdAt>=:from AND createdAt<:to order by createdAt asc";
46 List<Snapshot> snapshots = session.createQuery(hql)
47 .setParameter("from", targetDate)
48 .setParameter("to", projectSnapshot.getCreatedAt())
49 .setParameter("resourceId", projectSnapshot.getResourceId())
50 .setParameter("status", Snapshot.STATUS_PROCESSED)
54 if (snapshots.isEmpty()) {
57 return new PastSnapshot(MODE, targetDate, snapshots.get(0)).setModeParameter(String.valueOf(days));