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.sonar.api.BatchExtension;
23 import org.sonar.api.database.DatabaseSession;
24 import org.sonar.api.database.model.Snapshot;
26 import java.text.SimpleDateFormat;
27 import java.util.Date;
28 import java.util.List;
30 public class PastSnapshotFinderByDate implements BatchExtension{
32 public static final String MODE = "date";
35 private Snapshot projectSnapshot; // TODO replace by PersistenceManager
36 private DatabaseSession session;
38 public PastSnapshotFinderByDate(Snapshot projectSnapshot, DatabaseSession session) {
39 this.projectSnapshot = projectSnapshot;
40 this.session = session;
43 PastSnapshot findByDate(Date date) {
44 String hql = "from " + Snapshot.class.getSimpleName() + " where createdAt>=:date AND resourceId=:resourceId AND status=:status order by createdAt asc";
45 List<Snapshot> snapshots = session.createQuery(hql)
46 .setParameter("date", date)
47 .setParameter("resourceId", projectSnapshot.getResourceId())
48 .setParameter("status", Snapshot.STATUS_PROCESSED)
51 if (snapshots.isEmpty()) {
55 SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
56 return new PastSnapshot(MODE, date, snapshots.get(0)).setModeParameter(format.format(date));