@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);
}
}
