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 ImportedAndExportedKeysFilteredByPKsCyclicTest extends AbstractImportedAndExportedKeysFilteredByPKsTestCase {

  public ImportedAndExportedKeysFilteredByPKsCyclicTest(String testName) {
    super(testName, "hypersonic_cyclic_dataset.sql");
  }
  protected int[] setupTablesSizeFixture() {
    int[] sizes = new int[] { 2, 1, 1 };
    return sizes;
  }
  
  public void testAWithOne() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1 } );
    addOutput( C, new String[] { C1 } );
    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( C, new String[] { C1 } );
    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( C, new String[] { C1 } );
    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( C, new String[] { C1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
  
  public void testAWithRepeated() throws DataSetException, SQLException, SearchException {
    addInput( A, new String[] { A1, A2, A2, A1, A1, A1, A2, A2 } );
    addOutput( C, new String[] { C1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
  
  public void testBWithOne() throws DataSetException, SQLException, SearchException {
    addInput( B, new String[] { B1 } );       
    addOutput( C, new String[] { C1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
  
  public void testCWithOne() throws DataSetException, SQLException, SearchException {
    addInput( C, new String[] { C1 } );
    addOutput( C, new String[] { C1 } );
    addOutput( B, new String[] { B1 } );
    addOutput( A, new String[] { A2, A1 } );
    doIt();      
  }
  
}