@Test
public void testException() throws Exception {
getStatementResultSetHandler().prepareThrowsSQLException("select.*isbn,.*quantity.*");
Bookstore.order(getJDBCMockObjectFactory().getMockConnection(), new ArrayList());
verifyRolledBack();
verifyAllResultSetsClosed();
verifyAllStatementsClosed();
}
@Test
public void testCorrectSQL() throws Exception {
MockResultSet result = getStatementResultSetHandler().createResultSet();
getStatementResultSetHandler().prepareResultSet("select.*isbn,.*quantity.*", result);
List orderList = new ArrayList();
orderList.add("1234567890");
orderList.add("1111111111");
Bookstore.order(getJDBCMockObjectFactory().getMockConnection(), orderList);
verifySQLStatementExecuted(
"select.*isbn,.*quantity.*\\(isbn='1234567890'.*or.*isbn='1111111111'\\)");
}
public static void main(String[] args) {
Author a1 = new Author("Ivo Andric", "*****@*****.**", "M");
Author a2 = new Author("Mesa Selimovic", "*****@*****.**", "M");
Author a3 = new Author("Miroslav Krleza", "*****@*****.**", "M");
Book b1 = new Book(a1, "Gospodjica", 19.99, Book.TWO_BOOKS);
Book b2 = new Book(a1, "Prokleta avlija", 22.95, Book.NO_BOOK);
Book b3 = new Book(a2, "Tvrdjava", 19.95, Book.THREE_BOOKS);
Book b4 = new Book(a2, "Ostrvo", 12.99, Book.NO_BOOK);
Book b5 = new Book(a2, "Dervis i smrt", 22.95, Book.THREE_BOOKS);
Book[] b = new Book[] {b1, b2, b3};
Book[] bb = new Book[] {b4, b5};
Bookstore bs = new Bookstore("Bookstore", b);
bs.sellBookFromBookstore(b3);
bs.sellBookFromBookstore(b3);
System.out.println(bs);
}
@Test
public void testSuccessfulOrder() throws Exception {
FileResultSetFactory factory =
new FileResultSetFactory("target/test-classes/com/mockrunner/example/jdbc/bookstore.txt");
factory.setFirstLineContainsColumnNames(true);
MockResultSet result = getStatementResultSetHandler().createResultSet("bookresult", factory);
// System.out.println(result.toString());
getStatementResultSetHandler().prepareResultSet("select.*isbn,.*quantity.*", result);
List resultList =
Bookstore.order(getJDBCMockObjectFactory().getMockConnection(), new ArrayList());
assertEquals(4, resultList.size());
assertTrue(resultList.contains("1234567890"));
assertTrue(resultList.contains("1111111111"));
assertTrue(resultList.contains("1212121212"));
assertTrue(resultList.contains("3333333333"));
verifyResultSetRow("bookresult", 1, new String[] {"1234567890", "0"});
verifyResultSetRow("bookresult", 2, new String[] {"1111111111", "4"});
verifyResultSetRow("bookresult", 3, new String[] {"0987654321", "0"});
verifyResultSetRow("bookresult", 4, new String[] {"1212121212", "2"});
verifyResultSetRow("bookresult", 5, new String[] {"3333333333", "0"});
verifyCommitted();
verifyAllResultSetsClosed();
verifyAllStatementsClosed();
}
