ValueSetElement[] readLevelFromDatabaseHelper(
final int c_hlevel, final String fullName, final int offset)
throws KnowledgeSourceReadException {
try (ConnectionSpecQueryExecutor queryExecutor =
this.querySupport.getQueryExecutorInstance(
new QueryConstructor() {
@Override
public void appendStatement(StringBuilder sql, String table) {
sql.append("SELECT ")
.append(querySupport.getEurekaIdColumn())
.append(", C_NAME FROM ");
sql.append(table);
sql.append(
" WHERE C_HLEVEL=? AND M_APPLIED_PATH='@' AND C_FULLNAME LIKE ? ESCAPE '\\'");
}
})) {
return queryExecutor.execute(
new ParameterSetter() {
private static final String ONT_PATH_SEP = "\\";
private String newFullName = newFullName(fullName, offset);
@Override
public int set(PreparedStatement stmt, int j) throws SQLException {
stmt.setInt(j++, c_hlevel + offset);
stmt.setString(j++, newFullName + "%");
return j;
}
private String newFullName(String fullName, int offset) {
String fullName2 = fullName;
if (fullName2.length() == 0) {
return fullName2;
}
if (fullName2.endsWith(ONT_PATH_SEP)) {
fullName2 = fullName2.substring(0, fullName2.length() - 1);
}
if (offset == -1) {
int lastIndexOf = fullName2.lastIndexOf(ONT_PATH_SEP);
if (lastIndexOf == -1) {
fullName2 = "";
} else {
fullName2 = fullName2.substring(0, lastIndexOf);
}
}
fullName2 = I2B2Util.escapeLike(fullName2);
return fullName2;
}
},
new ResultSetReader<ValueSetElement[]>() {
@Override
public ValueSetElement[] read(ResultSet rs) throws KnowledgeSourceReadException {
List<ValueSetElement> result = new ArrayList<>();
if (rs != null)
try {
while (rs.next()) {
result.add(
new ValueSetElement(
NominalValue.getInstance(rs.getString(1)), rs.getString(2), null));
}
} catch (SQLException ex) {
throw new KnowledgeSourceReadException(ex);
}
return result.toArray(new ValueSetElement[result.size()]);
}
});
}
}
ValueSet readFromDatabase(String id) throws KnowledgeSourceReadException {
try (ConnectionSpecQueryExecutor queryExecutor =
this.querySupport.getQueryExecutorInstance(READ_FROM_DB_QUERY_CONSTRUCTOR)) {
return new ValueSet(id, null, queryExecutor.execute(id, reader), null);
}
}
