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.server.configuration;
021
022import com.thoughtworks.xstream.XStream;
023import org.apache.commons.collections.CollectionUtils;
024import org.slf4j.LoggerFactory;
025import org.sonar.api.CoreProperties;
026import org.sonar.api.database.DatabaseSession;
027import org.sonar.api.database.configuration.Property;
028
029import java.util.ArrayList;
030import java.util.List;
031
032public class PropertiesBackup implements Backupable {
033
034  private DatabaseSession databaseSession;
035  private static final String FROM_GLOBAL_PROPERTIES = "from " + Property.class.getSimpleName() + " p WHERE p.resourceId IS NULL and user_id is null";
036
037  public PropertiesBackup(DatabaseSession databaseSession) {
038    this.databaseSession = databaseSession;
039  }
040
041  public void exportXml(SonarConfig sonarConfig) {
042    List<Property> xmlProperties = new ArrayList<Property>();
043
044    List<Property> dbProperties = databaseSession.createQuery(FROM_GLOBAL_PROPERTIES).getResultList();
045    if (dbProperties != null) {
046      for (Property dbProperty : dbProperties) {
047        String propKey = dbProperty.getKey();
048        if (!CoreProperties.SERVER_ID.equals(propKey)) {
049          // "sonar.core.id" must never be restored, it is unique for a server and it created once at the 1rst server startup
050          xmlProperties.add(new Property(dbProperty.getKey(), dbProperty.getValue()));
051        }
052      }
053      sonarConfig.setProperties(xmlProperties);
054    }
055  }
056
057  public void importXml(SonarConfig sonarConfig) {
058    LoggerFactory.getLogger(getClass()).info("Restore properties");
059    clearProperties();
060
061    if (CollectionUtils.isNotEmpty(sonarConfig.getProperties())) {
062      for (Property xmlProperty : sonarConfig.getProperties()) {
063        String propKey = xmlProperty.getKey();
064        if (!CoreProperties.SERVER_ID.equals(propKey)) {
065          // "sonar.core.id" must never be restored, it is unique for a server and it created once at the 1rst server startup
066          databaseSession.save(new Property(propKey, xmlProperty.getValue()));
067        }
068      }
069    }
070  }
071
072  private void clearProperties() {
073    // "sonar.core.id" property should not be cleared, because it is the unique key used to identify the server
074    // and it is used by the batch to verify that it connects to the same DB as the remote server (see SONAR-3126).
075    databaseSession.createQuery("delete " + FROM_GLOBAL_PROPERTIES + " and prop_key != '" + CoreProperties.SERVER_ID + "'").executeUpdate();
076  }
077
078  public void configure(XStream xStream) {
079    xStream.alias("property", Property.class);
080  }
081}