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.filter;
021
022import org.apache.ibatis.session.SqlSession;
023import org.sonar.api.BatchComponent;
024import org.sonar.api.ServerComponent;
025import org.sonar.core.persistence.MyBatis;
026
027/**
028 * @since 3.1
029 */
030public class FilterDao implements BatchComponent, ServerComponent {
031  private MyBatis mybatis;
032
033  public FilterDao(MyBatis mybatis) {
034    this.mybatis = mybatis;
035  }
036
037  public FilterDto findFilter(String name) {
038    SqlSession session = mybatis.openSession();
039    try {
040      FilterMapper mapper = session.getMapper(FilterMapper.class);
041      return mapper.findFilter(name);
042    } finally {
043      MyBatis.closeQuietly(session);
044    }
045  }
046
047  public void insert(FilterDto filterDto) {
048    SqlSession session = mybatis.openSession();
049    FilterMapper filterMapper = session.getMapper(FilterMapper.class);
050    CriterionMapper criteriaMapper = session.getMapper(CriterionMapper.class);
051    FilterColumnMapper columnMapper = session.getMapper(FilterColumnMapper.class);
052    try {
053      filterMapper.insert(filterDto);
054      for (CriterionDto criteriaDto : filterDto.getCriteria()) {
055        criteriaDto.setFilterId(filterDto.getId());
056        criteriaMapper.insert(criteriaDto);
057      }
058      for (FilterColumnDto filterColumnDto : filterDto.getColumns()) {
059        filterColumnDto.setFilterId(filterDto.getId());
060        columnMapper.insert(filterColumnDto);
061      }
062      session.commit();
063    } finally {
064      MyBatis.closeQuietly(session);
065    }
066  }
067}