private String addConstantVarialbePlaceHolderIn(
String sqlQuery, List<CMSEntityEntry> constAndVarialbeMetaDataList) {
for (CMSEntityEntry entry : constAndVarialbeMetaDataList) {
String replacement = entry.getSqlElement();
if (replacement.matches(".+'\\w+'.*")) {
Matcher theMatcher = Pattern.compile("'\\w+'").matcher(replacement);
while (theMatcher.find()) {
String group = theMatcher.group();
String variable = entry.getEntityAttribute() + "_" + group.replaceAll("\\W", "");
// UPDATE
entry.addToVariableAttrMap(variable, entry.getEntityAttribute());
replacement = replacement.replace(group, ":" + entry.getVariable(variable));
}
// REPLACE
sqlQuery =
sqlQuery.replaceFirst(
entry.getSqlElement().replace("(", "\\(").replace(")", "\\)"), replacement);
} else {
String variable = replacement.replaceFirst(".+:", "");
// UPDATE
entry.addToVariableAttrMap(variable, entry.getEntityAttribute());
// REPLACE
sqlQuery =
sqlQuery.replaceFirst(
replacement, replacement.replaceFirst(":.+", ":" + entry.getVariable(variable)));
}
}
return sqlQuery;
}
private String addIntoPlaceHolderIn(
String sqlQuery, List<CMSEntityEntry> intoStatementMetaDataList) {
for (CMSEntityEntry entry : intoStatementMetaDataList) {
if (entry.getSqlElement().endsWith(STAR)) {
Set<String> entityAttrs = entry.getEntityAttrSet();
StringWriter out = new StringWriter();
PrintWriter pw =
new PrintWriter(out); // pw can do println, so I don't have to hardcode this "\n".
for (String entityAttr : entityAttrs) {
String[] split = entityAttr.split("\\."); // e.g. claimcycle.claimcycleid
// UPDATE
entry.addToVariableAttrMap(
split[1], entityAttr); // so we will have attr_a mapping to attr
String tableAlias = entry.getTableAlias(split[0].toUpperCase());
pw.println(
tableAlias
+ "."
+ split[1]
+ "{"
+ entry.getVariable(split[1])
+ "}"
+ ","); // e.g.: cc.claimcycleid{claimcycleid_a}
}
// REPLACE
if (entry.getSqlElement().equals("*") == false) {
sqlQuery = sqlQuery.replace(entry.getSqlElement(), "@");
}
sqlQuery = sqlQuery.replaceFirst("[*@]", out.toString() + "@");
pw.close();
} else {
String variable =
entry.getColumnAlias().isEmpty() ? entry.getEntityAttribute() : entry.getColumnAlias();
// UPDATE
entry.addToVariableAttrMap(variable, entry.getEntityAttribute());
// REPALCE
sqlQuery =
sqlQuery.replaceFirst(
entry.getSqlElement(),
entry.getSqlElement() + "{" + entry.getVariable(variable) + "}");
}
}
StringWriter out = new StringWriter();
PrintWriter pw =
new PrintWriter(out); // pw can do println, so I don't have to hardcode this "\n".
int indexToInsertIntoClause = sqlQuery.lastIndexOf("}") + 1;
pw.println(sqlQuery.substring(0, indexToInsertIntoClause)); // SELECT CLAUSE
pw.println("INTO");
Pattern pattern = Pattern.compile("\\{\\w+}");
Matcher matcher = pattern.matcher(sqlQuery);
while (matcher.find()) {
pw.println(":" + matcher.group().replaceAll("[\\{}]", "") + ",");
}
pw.println("<FROM>");
String finalQuery = out.toString().replaceAll("\\{\\w+}", "");
pw.close();
finalQuery =
finalQuery.substring(0, finalQuery.lastIndexOf(",")) // trim the last ",";
+ finalQuery.substring(
finalQuery.lastIndexOf(",") + 1); // keep the FROM and the "\r\n" around it
String fromClause =
sqlQuery.substring(indexToInsertIntoClause).replaceFirst("(F|f)(R|r)(O|o)(M|m)", "FROM");
fromClause = fromClause.substring(fromClause.indexOf("FROM")); // From clause
finalQuery = finalQuery.replace("<FROM>", fromClause).trim();
return finalQuery;
}