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.core.dashboard;
021
022import org.apache.ibatis.session.SqlSession;
023import org.sonar.api.BatchComponent;
024import org.sonar.api.ServerComponent;
025import org.sonar.core.persistence.MyBatis;
026
027public class DashboardDao implements BatchComponent, ServerComponent {
028
029  private MyBatis mybatis;
030
031  public DashboardDao(MyBatis mybatis) {
032    this.mybatis = mybatis;
033  }
034
035  public DashboardDto selectGlobalDashboard(String name) {
036    SqlSession session = mybatis.openSession();
037    try {
038      DashboardMapper mapper = session.getMapper(DashboardMapper.class);
039      return mapper.selectGlobalDashboard(name);
040    } finally {
041      MyBatis.closeQuietly(session);
042    }
043  }
044
045  public void insert(DashboardDto dashboardDto) {
046    SqlSession session = mybatis.openSession();
047    DashboardMapper dashboardMapper = session.getMapper(DashboardMapper.class);
048    WidgetMapper widgetMapper = session.getMapper(WidgetMapper.class);
049    WidgetPropertyMapper widgetPropertyMapper = session.getMapper(WidgetPropertyMapper.class);
050    try {
051      dashboardMapper.insert(dashboardDto);
052      for (WidgetDto widgetDto : dashboardDto.getWidgets()) {
053        widgetDto.setDashboardId(dashboardDto.getId());
054        widgetMapper.insert(widgetDto);
055        for (WidgetPropertyDto widgetPropertyDto : widgetDto.getWidgetProperties()) {
056          widgetPropertyDto.setWidgetId(widgetDto.getId());
057          widgetPropertyMapper.insert(widgetPropertyDto);
058        }
059      }
060      session.commit();
061    } finally {
062      MyBatis.closeQuietly(session);
063    }
064  }
065
066}