LinterTableWithNullColumnsInIndex.java

package schemacrawler.tools.analysis;


import java.util.ArrayList;
import java.util.List;

import schemacrawler.schema.Index;
import schemacrawler.schema.IndexColumn;
import schemacrawler.schema.Table;
import sf.util.ObjectToString;

public class LinterTableWithNullColumnsInIndex
  extends BaseLinter<Table>
{

  public void lint(final Table table)
  {
    if (table != null)
    {
      final Index[] nullableColumnsInUniqueIndex = findNullableColumnsInUniqueIndex(table
        .getIndices());
      if (nullableColumnsInUniqueIndex.length > 0)
      {
        addLint(table, new Lint("unique indices have nullable columns",
          nullableColumnsInUniqueIndex)
        {

          private static final long serialVersionUID = -1954217739621236510L;

          @Override
          public String getLintValueAsString()
          {
            final List<String> indexNames = new ArrayList<String>();
            for (final Index index: nullableColumnsInUniqueIndex)
            {
              indexNames.add(index.getName());
            }
            return ObjectToString.toString(indexNames);
          }
        });
      }
    }
  }

  private Index[] findNullableColumnsInUniqueIndex(final Index[] indices)
  {
    final List<Index> nullableColumnsInUniqueIndex = new ArrayList<Index>();
    for (final Index index: indices)
    {
      if (index.isUnique())
      {
        final IndexColumn[] columns = index.getColumns();
        for (final IndexColumn indexColumn: columns)
        {
          if (indexColumn.isNullable())
          {
            nullableColumnsInUniqueIndex.add(index);
            break;
          }
        }
      }
    }
    return nullableColumnsInUniqueIndex
      .toArray(new Index[nullableColumnsInUniqueIndex.size()]);
  }

}