package org.dbunit.database.search;

import java.sql.SQLException;

import org.dbunit.database.AbstractImportedAndExportedKeysFilteredByPKsTestCase;
import org.dbunit.dataset.DataSetException;

import org.dbunit.util.search.SearchException;

public class ImportedAndExportedKeysFilteredByPKsSingleInputTest extends AbstractImportedAndExportedKeysFilteredByPKsTestCase {

  public ImportedAndExportedKeysFilteredByPKsSingleInputTest(String testName) {
   this(testName, "hypersonic_simple_input_dataset.sql");
  }
  public ImportedAndExportedKeysFilteredByPKsSingleInputTest(String testName, String sqlFile) {
    super( testName, sqlFile );
  }
  protected int[] setupTablesSizeFixture() {
    int[] sizes = new int[] { 2, 1 };
    return sizes;
  }
  
  public void testAWithOne() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A1 } );
    doIt();      
  }
  
  public void testAWithOneRepeated() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1, A1, A1, A1, A1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A1 } );
    doIt();      
  }
  
  public void testAWithTwo() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1, A2 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A1, A2 } );
    doIt();      
  }
  
  public void testAWithTwoRepeated() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1, A2 , A1, A2, A2, A1, A1, A1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A1, A2 } );
    doIt();      
  }
  
  public void testAWithTwoInvertedInput() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A2, A1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A1, A2 } );
    doIt();      
  }

  public void testAWithTwoInvertedOutput() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1, A2 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
   
  public void testB() throws DataSetException, SQLException, SearchException {
    addInput( B, new String[] { B1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
  
}