@Then("the user <user> has borrowed the book <isbn>") public void thenTheUseruserHasBorrowedTheBookisbn( @Named("user") String user, @Named("isbn") String isbn) throws SQLException { waitForServerResponse(); String id = database.getResult("SELECT id FROM borrowing WHERE borrower_email_address='" + user + "'"); database.shouldReturnExactlyOne( "SELECT * FROM book WHERE current_borrowing_id=" + id + " AND isbn='" + isbn + "'"); }
@Given("a user <user> has borrowed books <isbns>") public void createListOfBorrowedBooks(@Named("user") String user, @Named("isbns") String isbns) throws SQLException { List<String> isbnList = getListOfItems(isbns); for (String isbn : isbnList) { database.execute( "INSERT INTO book(title,author,edition,isbn,year_of_publication) VALUES " + "('Title', 'Author', '1', '" + isbn + "', 2011)"); String bookId = database.getResult("SELECT LAST_INSERT_ID()"); database.execute( "INSERT INTO borrowing(borrow_date, borrower_email_address) VALUES " + "(CURDATE(), '" + user + "')"); String borrowingId = database.getResult("SELECT LAST_INSERT_ID()"); database.execute( "UPDATE book SET current_borrowing_id = " + borrowingId + " WHERE id = " + bookId); } }