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}