@Test
public void getDropTablesTest() {

  when( teraDataBulkLoaderMetaMock.getDropErrorTable() ).thenReturn( true );
  when( teraDataBulkLoaderMetaMock.getDropErrorTable2() ).thenReturn( true );
  when( teraDataBulkLoaderMetaMock.getDropLogTable() ).thenReturn( true );
  when( teraDataBulkLoaderMetaMock.getDropWorkTable() ).thenReturn( true );
  when( teraDataBulkLoaderMetaMock.getLogTable() ).thenReturn( "logTable" );
  when( teraDataBulkLoaderMetaMock.getWorkTable() ).thenReturn( "workTable" );
  when( teraDataBulkLoaderMetaMock.getErrorTable() ).thenReturn( "errorTable" );
  when( teraDataBulkLoaderMetaMock.getErrorTable2() ).thenReturn( "errorTable2" );
  String expectedDropTables = "STEP Setup_tables(\n"
    + "APPLY \n"
    + "     ('DROP TABLE logTable'),\n"
    + "     ('DROP TABLE workTable'),\n"
    + "     ('DROP TABLE errorTable'),\n"
    + "     ('DROP TABLE errorTable2')\n"
    + "\n"
    + "TO OPERATOR ( DDL_OPERATOR )\n"
    + ";\n"
    + "\n"
    + ");\n";
  String dropTables = teraDataBulkLoaderRoutines.getDropTables( true );
  assertEquals( expectedDropTables, dropTables );
}