/*
 * Copyright (C) 2009 eXo Platform SAS.
 *
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 2.1 of
 * the License, or (at your option) any later version.
 *
 * This software is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this software; if not, write to the Free
 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
 * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
 */

package org.exoplatform.services.jcr.impl.backup.rdbms;

import org.exoplatform.commons.utils.PrivilegedFileHelper;
import org.exoplatform.services.jcr.dataflow.serialization.ObjectReader;
import org.exoplatform.services.jcr.impl.dataflow.serialization.ObjectReaderImpl;
import org.exoplatform.services.jcr.impl.storage.jdbc.JDBCDataContainerConfig;
import org.exoplatform.services.jcr.impl.storage.jdbc.JDBCDataContainerConfig.DatabaseStructureType;
import org.exoplatform.services.log.ExoLogger;
import org.exoplatform.services.log.Log;

import java.io.File;
import java.io.IOException;
import java.sql.Types;
import java.util.HashSet;
import java.util.Set;

/**
 * Keeps information required by table transformation process during
 * backup/respore. Provides methods to aquire
 * transformation rules for ITEM, REFERENCE and VALUE tables.
 * 
 * @author <a href="mailto:dmitry.kuleshov@exoplatform.com">Dmitry Kuleshov</a>
 * @version $Id: tableTransformationRule.java 34360 2009-07-22 23:58:59Z dkuleshov $
 */
public class TableTransformationRuleGenerator
{
   protected static final Log LOG = ExoLogger.getLogger("exo.jcr.component.core.TableTransformationRuleGenerator");

   private final DatabaseStructureType srcDbType;

   private final DatabaseStructureType dstDbType;

   private final String srcContainerName;

   private final String dstContainerName;

   private final String srcItemTableName;

   private final String srcValueTableName;

   private final String srcRefTableName;

   public TableTransformationRuleGenerator(JDBCDataContainerConfig containerConfig, File storageDir) throws IOException

   {
      ObjectReader backupInfoReader = null;
      try
      {
         this.dstDbType = containerConfig.dbStructureType;
         this.dstContainerName = containerConfig.containerName;

         backupInfoReader =
            new ObjectReaderImpl(PrivilegedFileHelper.fileInputStream(new File(storageDir,
               "JDBCWorkspaceDataContainer.info")));;

         this.srcContainerName = backupInfoReader.readString();
         this.srcDbType = DatabaseStructureType.valueOf(backupInfoReader.readString());
         this.srcItemTableName = backupInfoReader.readString();
         this.srcValueTableName = backupInfoReader.readString();
         this.srcRefTableName = backupInfoReader.readString();
      }
      finally
      {
         if (backupInfoReader != null)
         {
            try
            {
               backupInfoReader.close();
            }
            catch (IOException e)
            {
               LOG.error("Can't close object reader", e);
            }
         }
      }
   }

   private TableTransformationRule getBasicTransformationRule()
   {
      TableTransformationRule basicTableTransformationRule = new TableTransformationRule();
      basicTableTransformationRule.setSrcContainerName(srcContainerName);
      basicTableTransformationRule.setSrcMultiDb(srcDbType.isMultiDatabase());
      basicTableTransformationRule.setDstContainerName(dstContainerName);
      basicTableTransformationRule.setDstMultiDb(dstDbType.isMultiDatabase());

      return basicTableTransformationRule;
   }

   public TableTransformationRule getValueTableTransformationRule()
   {
      TableTransformationRule valueTableTransformationRule = getBasicTransformationRule();
      valueTableTransformationRule.setSrcTableName(srcValueTableName);

      // auto increment ID column
      valueTableTransformationRule.setSkipColumnIndex(0);

      if (srcDbType == DatabaseStructureType.SINGLE || dstDbType == DatabaseStructureType.SINGLE)
      {
         // PROPERTY_ID column index
         Set<Integer> convertColumnIndex = new HashSet<Integer>();
         convertColumnIndex.add(3);
         valueTableTransformationRule.setConvertColumnIndex(convertColumnIndex);
      }

      return valueTableTransformationRule;
   }

   public TableTransformationRule getRefTableTransformationRule()
   {
      TableTransformationRule refTableTransformationRule = getBasicTransformationRule();
      refTableTransformationRule.setSrcTableName(srcRefTableName);

      if (srcDbType == DatabaseStructureType.SINGLE || dstDbType == DatabaseStructureType.SINGLE)
      {
         // NODE_ID and PROPERTY_ID column indexes
         Set<Integer> convertColumnIndex = new HashSet<Integer>();
         convertColumnIndex.add(0);
         convertColumnIndex.add(1);
         refTableTransformationRule.setConvertColumnIndex(convertColumnIndex);
      }

      return refTableTransformationRule;
   }

   public TableTransformationRule getItemTableTransformationRule()
   {
      TableTransformationRule itemTableTransformationRule = getBasicTransformationRule();
      itemTableTransformationRule.setSrcTableName(srcItemTableName);

      if (dstDbType == DatabaseStructureType.MULTI || dstDbType == DatabaseStructureType.ISOLATED)
      {
         if (srcDbType == DatabaseStructureType.SINGLE)
         {
            // CONTAINER_NAME column index
            itemTableTransformationRule.setSkipColumnIndex(4);

            // ID and PARENT_ID column indexes
            Set<Integer> convertColumnIndex = new HashSet<Integer>();
            convertColumnIndex.add(0);
            convertColumnIndex.add(1);
            itemTableTransformationRule.setConvertColumnIndex(convertColumnIndex);
         }
      }
      // single-db
      else
      {
         if (srcDbType == DatabaseStructureType.MULTI || srcDbType == DatabaseStructureType.ISOLATED)
         {
            // CONTAINER_NAME column index
            itemTableTransformationRule.setNewColumnIndex(4);
            itemTableTransformationRule.setNewColumnName("CONTAINER_NAME");
            itemTableTransformationRule.setNewColumnType(Types.VARCHAR);

            // ID and PARENT_ID column indexes
            Set<Integer> convertColumnIndex = new HashSet<Integer>();
            convertColumnIndex.add(0);
            convertColumnIndex.add(1);
            itemTableTransformationRule.setConvertColumnIndex(convertColumnIndex);
         }
         else
         {
            // ID and PARENT_ID and CONTAINER_NAME column indexes
            Set<Integer> convertColumnIndex = new HashSet<Integer>();
            convertColumnIndex.add(0);
            convertColumnIndex.add(1);
            convertColumnIndex.add(4);
            itemTableTransformationRule.setConvertColumnIndex(convertColumnIndex);
         }
      }

      return itemTableTransformationRule;
   }
}