TableCreator.java

/*
Copyright (c) 2011 James Ahlborn

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/

package com.healthmarketscience.jackcess.impl;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.EnumSet;
import java.util.HashSet;
import java.util.IdentityHashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

import com.healthmarketscience.jackcess.ColumnBuilder;
import com.healthmarketscience.jackcess.DataType;
import com.healthmarketscience.jackcess.IndexBuilder;
import com.healthmarketscience.jackcess.PropertyMap;
import com.healthmarketscience.jackcess.TableBuilder;

/**
 * Helper class used to maintain state during table creation.
 *
 * @author James Ahlborn
 * @usage _advanced_class_
 */
public class TableCreator extends TableMutator
{
  private String _name;
  private List<ColumnBuilder> _columns;
  private List<IndexBuilder> _indexes;
  private final List<IndexDataState> _indexDataStates = 
    new ArrayList<IndexDataState>();
  private final Map<ColumnBuilder,ColumnState> _columnStates = 
    new IdentityHashMap<ColumnBuilder,ColumnState>();
  private final List<ColumnBuilder> _lvalCols = new ArrayList<ColumnBuilder>();
  private int _tdefPageNumber = PageChannel.INVALID_PAGE_NUMBER;
  private int _umapPageNumber = PageChannel.INVALID_PAGE_NUMBER;
  private int _indexCount;
  private int _logicalIndexCount;

  public TableCreator(DatabaseImpl database) {
    super(database);
  }

  public String getName() {
    return _name;
  }

  @Override
  String getTableName() {
    return getName();
  }
  
  @Override
  public int getTdefPageNumber() {
    return _tdefPageNumber;
  }

  public int getUmapPageNumber() {
    return _umapPageNumber;
  }

  public List<ColumnBuilder> getColumns() {
    return _columns;
  }

  public List<IndexBuilder> getIndexes() {
    return _indexes;
  }

  public boolean hasIndexes() {
    return !_indexes.isEmpty();
  }

  public int getIndexCount() {
    return _indexCount;
  }

  public int getLogicalIndexCount() {
    return _logicalIndexCount;
  }

  @Override
  public IndexDataState getIndexDataState(IndexBuilder idx) {
    for(IndexDataState idxDataState : _indexDataStates) {
      for(IndexBuilder curIdx : idxDataState.getIndexes()) {
        if(idx == curIdx) {
          return idxDataState;
        }
      }
    }
    throw new IllegalStateException(withErrorContext(
        "could not find state for index"));
  }

  public List<IndexDataState> getIndexDataStates() {
    return _indexDataStates;
  }

  @Override
  public ColumnState getColumnState(ColumnBuilder col) {
    return _columnStates.get(col);
  }

  public List<ColumnBuilder> getLongValueColumns() {
    return _lvalCols;
  }

  @Override
  short getColumnNumber(String colName) {
    for(ColumnBuilder col : _columns) {
      if(col.getName().equalsIgnoreCase(colName)) {
        return col.getColumnNumber();
      }
    }
    return IndexData.COLUMN_UNUSED;
  }  

  /**
   * @return The number of variable length columns which are not long values
   *         found in the list
   * @usage _advanced_method_
   */
  public short countNonLongVariableLength() {
    short rtn = 0;
    for (ColumnBuilder col : _columns) {
      if (col.isVariableLength() && !col.getType().isLongValue()) {
        rtn++;
      }
    }
    return rtn;
  }
  

  /**
   * Creates the table in the database.
   * @usage _advanced_method_
   */
  public TableImpl createTable(TableBuilder table) throws IOException {

    _name = table.getName();
    _columns = table.getColumns();
    _indexes = table.getIndexes();
    if(_indexes == null) {
      _indexes = Collections.<IndexBuilder>emptyList();
    }

    validate();

    // assign column numbers and do some assorted column bookkeeping
    short columnNumber = (short) 0;
    for(ColumnBuilder col : _columns) {
      col.setColumnNumber(columnNumber++);
      if(col.getType().isLongValue()) {
        _lvalCols.add(col);
        // only lval columns need extra state
        _columnStates.put(col, new ColumnState());
      }
    }

    if(hasIndexes()) {
      // sort out index numbers (and backing index data).  
      for(IndexBuilder idx : _indexes) {
        idx.setIndexNumber(_logicalIndexCount++);
        findIndexDataState(idx);
      }
    }

    getPageChannel().startExclusiveWrite();
    try {
      
      // reserve some pages
      _tdefPageNumber = reservePageNumber();
      _umapPageNumber = reservePageNumber();
    
      //Write the tdef page to disk.
      TableImpl.writeTableDefinition(this);

      // update the database with the new table info
      getDatabase().addNewTable(_name, _tdefPageNumber, DatabaseImpl.TYPE_TABLE, 
                                null, null);

      TableImpl newTable = getDatabase().getTable(_name);

      // add any table properties
      boolean addedProps = false;
      Map<String,PropertyMap.Property> props = table.getProperties();
      if(props != null) {
        newTable.getProperties().putAll(props.values());
        addedProps = true;
      }
      for(ColumnBuilder cb : _columns) {
        Map<String,PropertyMap.Property> colProps = cb.getProperties();
        if(colProps != null) {
          newTable.getColumn(cb.getName()).getProperties()
            .putAll(colProps.values());
          addedProps = true;
        }
      }

      // all table and column props are saved together
      if(addedProps) {
        newTable.getProperties().save();
      }

      return newTable;

    } finally {
      getPageChannel().finishWrite();
    }
  }

  private IndexDataState findIndexDataState(IndexBuilder idx) {

    // search for an index which matches the given index (in terms of the
    // backing data)
    for(IndexDataState idxDataState : _indexDataStates) {
      if(sameIndexData(idxDataState.getFirstIndex(), idx)) {
        idxDataState.addIndex(idx);
        return idxDataState;
      }
    }

    // no matches found, need new index data state
    IndexDataState idxDataState = new IndexDataState();
    idxDataState.setIndexDataNumber(_indexCount++);
    idxDataState.addIndex(idx);
    _indexDataStates.add(idxDataState);
    return idxDataState;
  }

  /**
   * Validates the new table information before attempting creation.
   */
  private void validate() throws IOException {

    getDatabase().validateNewTableName(_name);
    
    if((_columns == null) || _columns.isEmpty()) {
      throw new IllegalArgumentException(withErrorContext(
          "Cannot create table with no columns"));
    }
    if(_columns.size() > getFormat().MAX_COLUMNS_PER_TABLE) {
      throw new IllegalArgumentException(withErrorContext(
          "Cannot create table with more than " +
          getFormat().MAX_COLUMNS_PER_TABLE + " columns"));
    }
    
    Set<String> colNames = new HashSet<String>();
    // next, validate the column definitions
    for(ColumnBuilder column : _columns) {
      validateColumn(colNames, column);
    }

    List<ColumnBuilder> autoCols = getAutoNumberColumns();
    if(autoCols.size() > 1) {
      // for most autonumber types, we can only have one of each type
      Set<DataType> autoTypes = EnumSet.noneOf(DataType.class);
      for(ColumnBuilder c : autoCols) {
        validateAutoNumberColumn(autoTypes, c);
      }
    }

    if(hasIndexes()) {

      if(_indexes.size() > getFormat().MAX_INDEXES_PER_TABLE) {
        throw new IllegalArgumentException(withErrorContext(
            "Cannot create table with more than " +
            getFormat().MAX_INDEXES_PER_TABLE + " indexes"));
      }

      // now, validate the indexes
      Set<String> idxNames = new HashSet<String>();
      boolean foundPk[] = new boolean[1];
      for(IndexBuilder index : _indexes) {
        validateIndex(colNames, idxNames, foundPk, index);
      }
    }
  }

  private List<ColumnBuilder> getAutoNumberColumns() 
  {
    List<ColumnBuilder> autoCols = new ArrayList<ColumnBuilder>(1);
    for(ColumnBuilder c : _columns) {
      if(c.isAutoNumber()) {
        autoCols.add(c);
      }
    }
    return autoCols;
  }

  private static boolean sameIndexData(IndexBuilder idx1, IndexBuilder idx2) {
    // index data can be combined if flags match and columns (and col flags)
    // match
    if(idx1.getFlags() != idx2.getFlags()) {
      return false;
    }

    if(idx1.getColumns().size() != idx2.getColumns().size()) {
      return false;
    }
    
    for(int i = 0; i < idx1.getColumns().size(); ++i) {
      IndexBuilder.Column col1 = idx1.getColumns().get(i);
      IndexBuilder.Column col2 = idx2.getColumns().get(i);

      if(!sameIndexData(col1, col2)) {
        return false;
      }
    }

    return true;
  }

  private static boolean sameIndexData(
      IndexBuilder.Column col1, IndexBuilder.Column col2) {
    return (col1.getName().equals(col2.getName()) && 
            (col1.getFlags() == col2.getFlags()));
  }

  @Override
  protected String withErrorContext(String msg) {
    return msg + "(Table=" + getName() + ")";
  }
}