in sessions/fall24/books-genai-vertex-langchain4j/src/main/java/services/domain/dao/DataAccess.java [158:173]
private String createWhereClause(String book, String author) {
StringBuilder whereClause = new StringBuilder();
whereClause.append("WHERE ");
if (book != null) {
whereClause.append("b.title = ?");
}
if (author != null) {
if (whereClause.length() > 0) {
whereClause.append(" AND ");
}
whereClause.append("a.name = ?");
}
return whereClause.toString();
}