001/*
002 * Sonar, open source software quality management tool.
003 * Copyright (C) 2008-2012 SonarSource
004 * mailto:contact AT sonarsource DOT com
005 *
006 * Sonar is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 3 of the License, or (at your option) any later version.
010 *
011 * Sonar is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 *
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with Sonar; if not, write to the Free Software
018 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02
019 */
020package org.sonar.batch.components;
021
022import org.sonar.api.BatchExtension;
023import org.sonar.api.CoreProperties;
024import org.sonar.api.database.DatabaseSession;
025import org.sonar.api.database.model.Snapshot;
026import org.sonar.api.resources.Qualifiers;
027import org.sonar.api.utils.DateUtils;
028
029import java.text.SimpleDateFormat;
030import java.util.Date;
031import java.util.List;
032
033public class PastSnapshotFinderByDate implements BatchExtension {
034
035  private DatabaseSession session;
036
037  public PastSnapshotFinderByDate(DatabaseSession session) {
038    this.session = session;
039  }
040
041  PastSnapshot findByDate(Snapshot projectSnapshot, Date date) {
042    Snapshot snapshot = null;
043    if (projectSnapshot != null) {
044      snapshot = findSnapshot(projectSnapshot, date);
045    }
046    SimpleDateFormat format = new SimpleDateFormat(DateUtils.DATE_FORMAT);
047    return new PastSnapshot(CoreProperties.TIMEMACHINE_MODE_DATE, date, snapshot).setModeParameter(format.format(date));
048  }
049
050
051  private Snapshot findSnapshot(Snapshot projectSnapshot, Date date) {
052    String hql = "from " + Snapshot.class.getSimpleName() + " where createdAt>=:date AND resourceId=:resourceId AND status=:status AND qualifier<>:lib order by createdAt asc";
053    List<Snapshot> snapshots = session.createQuery(hql)
054        .setParameter("date", date)
055        .setParameter("resourceId", projectSnapshot.getResourceId())
056        .setParameter("status", Snapshot.STATUS_PROCESSED)
057        .setParameter("lib", Qualifiers.LIBRARY)
058        .setMaxResults(1)
059        .getResultList();
060
061    return (snapshots.isEmpty() ? null : snapshots.get(0));
062  }
063}