in sessions/next24/books-genai-vertex-springai/src/main/java/services/domain/BooksService.java [82:103]
public Integer insertBook(String fileName) {
String author = FileUtility.getAuthor(fileName);
author = SqlUtility.replaceUnderscoresWithSpaces(author);
String title = FileUtility.getTitle(fileName);
title = SqlUtility.replaceUnderscoresWithSpaces(title);
String year = FileUtility.getYear(fileName);
String publicPrivate = FileUtility.getPublicPrivate(fileName);
Map<String, Object> book = dao.findBook(title);
Map<String, Object> authorMap = dao.findAuthor(author);
Object authorId = authorMap.get("author_id");
Integer bookId = 0;
if(!book.isEmpty()){
bookId = (Integer) book.get("book_id");
} else {
if(authorId==null)
authorId = dao.insertAuthor("famous author", author);
logger.info("publicPrivate:"+publicPrivate);
bookId = dao.insertBook( (Integer) authorId, title, year, ScopeType.fromValue(publicPrivate));
}
return bookId;
}