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.properties;
021
022import org.apache.commons.lang.StringUtils;
023import org.apache.ibatis.session.SqlSession;
024import org.sonar.api.BatchComponent;
025import org.sonar.api.ServerComponent;
026import org.sonar.core.persistence.MyBatis;
027
028import java.util.List;
029
030public class PropertiesDao implements BatchComponent, ServerComponent {
031
032  private MyBatis mybatis;
033
034  public PropertiesDao(MyBatis mybatis) {
035    this.mybatis = mybatis;
036  }
037
038  /**
039   * Returns the logins of users who have flagged as favourite the resource identified by the given id.
040   *
041   * @param resourceId the resource id
042   * @return the list of logins (maybe be empty - obviously)
043   */
044  public List<String> findUserIdsForFavouriteResource(Long resourceId) {
045    SqlSession session = mybatis.openSession();
046    PropertiesMapper mapper = session.getMapper(PropertiesMapper.class);
047    try {
048      return mapper.findUserIdsForFavouriteResource(resourceId);
049    } finally {
050      MyBatis.closeQuietly(session);
051    }
052  }
053
054  public List<PropertyDto> selectGlobalProperties() {
055    SqlSession session = mybatis.openSession();
056    PropertiesMapper mapper = session.getMapper(PropertiesMapper.class);
057    try {
058      return mapper.selectGlobalProperties();
059    } finally {
060      MyBatis.closeQuietly(session);
061    }
062  }
063
064  public List<PropertyDto> selectProjectProperties(String resourceKey) {
065    SqlSession session = mybatis.openSession();
066    PropertiesMapper mapper = session.getMapper(PropertiesMapper.class);
067    try {
068      return mapper.selectProjectProperties(resourceKey);
069    } finally {
070      MyBatis.closeQuietly(session);
071    }
072  }
073
074  public void setProperty(PropertyDto property) {
075    SqlSession session = mybatis.openSession();
076    PropertiesMapper mapper = session.getMapper(PropertiesMapper.class);
077    try {
078      PropertyDto persistedProperty = mapper.selectByKey(property);
079      if (persistedProperty != null && !StringUtils.equals(persistedProperty.getValue(), property.getValue())) {
080        persistedProperty.setValue(property.getValue());
081        mapper.update(persistedProperty);
082        session.commit();
083
084      } else if (persistedProperty == null) {
085        mapper.insert(property);
086        session.commit();
087      }
088    } finally {
089      MyBatis.closeQuietly(session);
090    }
091  }
092}