/*
* Copyright 2011, Unitils.org
*
* 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 org.unitils.database.sqlassert;
import junit.framework.AssertionFailedError;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.unitils.UnitilsJUnit4;
import org.unitils.core.UnitilsException;
import org.unitils.database.annotations.TestDataSource;
import javax.sql.DataSource;
import static org.unitils.database.SQLUnitils.executeUpdate;
import static org.unitils.database.SQLUnitils.executeUpdateQuietly;
import static org.unitils.database.sqlassert.SqlAssert.*;
/**
* @author Jeroen Horemans
*/
public class SqlAssertTest extends UnitilsJUnit4 {
private static final String SQL_SELECT_STATEMENT = "select col1, col2 from test";
private static final String SQL_SELECT_STATEMENT_ONE_ROW = "select col1, col2 from test where col1 = '1'";
private static final String SQL_COUNT_STATEMENT = "select count(*) from test";
@TestDataSource
private DataSource dataSource;
@Before
public void initialize() {
dropTestTables();
createTestTables();
executeUpdate("delete from test", dataSource);
executeUpdate("insert into test values ('1', 'one')", dataSource);
executeUpdate("insert into test values ('2', 'two')", dataSource);
}
@After
public void cleanup() {
dropTestTables();
}
@Test(expected = UnitilsException.class)
public void triggerSqlException() {
assertSingleRowSqlResult("select * from not_existing_random_table", dataSource, new String[]{"one", "1"});
}
@Test
public void assertSingleRowSqlResultMainSucces() {
assertSingleRowSqlResult(SQL_SELECT_STATEMENT_ONE_ROW, dataSource, new String[]{"one", "1"});
}
@Test
public void assertSingleRowSqlResultDifferentOrderInResults() {
assertSingleRowSqlResult(SQL_SELECT_STATEMENT_ONE_ROW, dataSource, new String[]{"1", "one"});
}
@Test(expected = AssertionFailedError.class)
public void assertSingleRowSqlResultMainFailure() {
assertSingleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, new String[]{"two", "1"});
}
@Test(expected = AssertionFailedError.class)
public void assertSingleRowSqlResultFailureOnNumber() {
assertSingleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, new String[]{"one", "2"});
}
@Test
public void assertMultipleRowSqlResultTestMainSucces() {
String[][] expected = new String[][]{{"two", "2"}, {"one", "1"}};
assertMultipleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, expected);
}
@Test
public void assertMultipleRowSqlResultTestMainSuccesOtherImpl() {
assertMultipleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, new String[]{"one", "1"}, new String[]{"two", "2"});
}
@Test(expected = AssertionFailedError.class)
public void assertMultipleRowSqlResultTestMainFailure() {
String[][] expected = new String[][]{{"two", "1"}, {"one", "1"}};
assertMultipleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, expected);
}
@Test(expected = AssertionFailedError.class)
public void assertMultipleRowSqlResultTestMainFailureDifferentNumber() {
String[][] expected = new String[][]{{"two", "1"}, {"one", "1"}, {"three", "3"}};
assertMultipleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, expected);
}
@Test(expected = AssertionFailedError.class)
public void assertMultipleRowSqlResultTestMainFailureNotEnough() {
String[][] expected = new String[][]{{"two", "1"},};
assertMultipleRowSqlResult(SQL_SELECT_STATEMENT, dataSource, expected);
}
@Test
public void assertCountSqlResultMainSucces() {
assertCountSqlResult(SQL_COUNT_STATEMENT, dataSource, 2L);
}
@Test(expected = AssertionFailedError.class)
public void assertCountSqlResultMainFailure() {
assertCountSqlResult(SQL_COUNT_STATEMENT, dataSource, 1L);
}
private void createTestTables() {
executeUpdate("create table TEST (col1 varchar(100), col2 varchar(100))", dataSource);
}
private void dropTestTables() {
executeUpdateQuietly("drop table TEST", dataSource);
}
}