@Override
public Credential getCredential(final String credentialName) throws RealmUnavailableException {
for (QueryConfiguration configuration : JdbcSecurityRealm.this.queryConfiguration) {
for (KeyMapper keyMapper : configuration.getColumnMappers(KeyMapper.class)) {
if (keyMapper.getCredentialName().equals(credentialName)) {
return executePrincipalQuery(configuration, resultSet -> keyMapper.map(resultSet));
}
}
}
return null;
}
@Override
public SupportLevel getCredentialAcquireSupport(final String credentialName)
throws RealmUnavailableException {
for (QueryConfiguration configuration : JdbcSecurityRealm.this.queryConfiguration) {
for (KeyMapper keyMapper : configuration.getColumnMappers(KeyMapper.class)) {
if (keyMapper.getCredentialName().equals(credentialName)) {
return executePrincipalQuery(configuration, keyMapper::getCredentialSupport);
}
}
}
return SupportLevel.UNSUPPORTED;
}
@Override
public SupportLevel getCredentialAcquireSupport(String credentialName)
throws RealmUnavailableException {
for (QueryConfiguration configuration : this.queryConfiguration) {
for (KeyMapper keyMapper : configuration.getColumnMappers(KeyMapper.class)) {
if (keyMapper.getCredentialName().equals(credentialName)) {
// by default, all credential types are supported if they have a corresponding mapper.
// however, we don't know if an account or realm identity has a specific credential or
// not.
return SupportLevel.POSSIBLY_SUPPORTED;
}
}
}
return SupportLevel.UNSUPPORTED;
}
@Override
public boolean verifyEvidence(final String credentialName, final Evidence evidence)
throws RealmUnavailableException {
if (evidence != null) {
for (QueryConfiguration configuration : JdbcSecurityRealm.this.queryConfiguration) {
for (PasswordKeyMapper passwordMapper :
configuration.getColumnMappers(PasswordKeyMapper.class)) {
if (passwordMapper.getCredentialName().equals(credentialName)) {
return verifyPassword(configuration, passwordMapper, evidence);
}
}
}
}
return false;
}
private Connection getConnection(QueryConfiguration configuration) {
try {
DataSource dataSource = configuration.getDataSource();
return dataSource.getConnection();
} catch (Exception e) {
throw log.couldNotOpenConnection(e);
}
}
private <E> E executePrincipalQuery(
QueryConfiguration configuration, ResultSetCallback<E> resultSetCallback) {
String sql = configuration.getSql();
try (Connection connection = getConnection(configuration);
PreparedStatement preparedStatement = connection.prepareStatement(sql)) {
preparedStatement.setString(1, name);
try (ResultSet resultSet = preparedStatement.executeQuery()) {
return resultSetCallback.handle(resultSet);
}
} catch (SQLException e) {
throw log.couldNotExecuteQuery(sql, e);
} catch (Exception e) {
throw log.unexpectedErrorWhenProcessingAuthenticationQuery(sql, e);
}
}
public void testTimeFilter() throws IOException, DocumentException, ParseException {
LgteIndexWriter writer = new LgteIndexWriter(path + "Contents", true);
LgteDocumentWrapper doc1 = new LgteDocumentWrapper();
doc1.indexText(Globals.DOCUMENT_ID_FIELD, "1");
doc1.indexText("contents", "word1 word2 word3");
doc1.indexStringNoStore(Config.S_HAS_TIMEXES, "true");
LgteDocumentWrapper doc2 = new LgteDocumentWrapper();
doc2.indexText(Globals.DOCUMENT_ID_FIELD, "2");
doc2.indexText("contents", "word2 word3 word4 word55 word96 word2 word54 word33 wordss");
writer.addDocument(doc1);
writer.addDocument(doc2);
writer.close();
LgteIndexWriter writer2 = new LgteIndexWriter(path + "Sentences", true);
LgteDocumentWrapper sentence0 = new LgteDocumentWrapper();
sentence0.indexText(Globals.DOCUMENT_ID_FIELD, "1_0");
sentence0.indexText("doc_id", "1");
sentence0.indexText("sentences", "word1 word3");
LgteDocumentWrapper sentence1 = new LgteDocumentWrapper();
sentence1.indexText(Globals.DOCUMENT_ID_FIELD, "1_1");
sentence1.indexText("doc_id", "1");
sentence1.indexText("sentences", "word1 word2 word3");
LgteDocumentWrapper sentence2 = new LgteDocumentWrapper();
sentence2.indexStringNoStore(Config.S_HAS_TIMEXES + "_sentences", "true");
sentence2.indexText(Globals.DOCUMENT_ID_FIELD, "2_1");
sentence2.indexText("doc_id", "2");
sentence2.indexText("sentences", "word2 word3 word4 word55 word96 word2 word54 word33 wordss");
writer2.addDocument(sentence0);
writer2.addDocument(sentence1);
writer2.addDocument(sentence2);
writer2.close();
IndexReader readerContents =
LgteIndexManager.openReader(path + "Contents", Model.OkapiBM25Model);
IndexReader readerSentences =
LgteIndexManager.openReader(path + "Sentences", Model.OkapiBM25Model);
Map<String, IndexReader> readers = new HashMap<String, IndexReader>();
readers.put("contents", readerContents);
readers.put("sentences", readerSentences);
readers.put(Config.S_HAS_TIMEXES, readerContents);
readers.put(Config.S_HAS_TIMEXES + "_sentences", readerSentences);
readers.put("doc_id", readerSentences);
readers.put("id", readerSentences);
LgteIsolatedIndexReader lgteIsolatedIndexReader = new LgteIsolatedIndexReader(readers);
lgteIsolatedIndexReader.addTreeMapping(readerContents, readerSentences, "doc_id");
LgteIndexSearcherWrapper searcher =
new LgteIndexSearcherWrapper(Model.OkapiBM25Model, lgteIsolatedIndexReader);
QueryConfiguration queryConfiguration = new QueryConfiguration();
queryConfiguration.setProperty("bm25.idf.policy", "floor_epslon");
queryConfiguration.setProperty("bm25.idf.epslon", "0.01");
queryConfiguration.setProperty("bm25.k1", "2.0");
queryConfiguration.setProperty("bm25.b", "0.75");
queryConfiguration.setProperty("index.tree", "true");
QueryFilter queryFilter =
new QueryFilter(
org.apache.lucene.queryParser.QueryParser.parse(
"true", Config.S_HAS_TIMEXES, new LgteNothingAnalyzer()));
LgteQuery lgteQuery =
LgteQueryParser.parseQuery(
"sentences:word2", new LgteNothingAnalyzer(), searcher, queryConfiguration);
LgteHits lgteHits = searcher.search(lgteQuery, queryFilter);
assertEquals(lgteHits.length(), 1);
assertEquals(lgteHits.id(0), 1);
TermsFilter termsFilter = new TermsFilter();
termsFilter.addTerm(new Term(Config.S_HAS_TIMEXES, "true"));
lgteHits = searcher.search(lgteQuery, termsFilter);
assertEquals(lgteHits.length(), 1);
assertEquals(lgteHits.id(0), 1);
termsFilter = new TermsFilter();
termsFilter.addTerm(new Term(Config.S_HAS_TIMEXES + "_sentences", "true"));
lgteHits = searcher.search(lgteQuery, termsFilter);
assertEquals(lgteHits.length(), 1);
assertEquals(lgteHits.id(0), 2);
searcher.close();
Files.delDirsE(path + "Contents");
Files.delDirsE(path + "Sentences");
}
public void testRange() throws IOException, InvalidGeoException {
double k1 = 2.0d;
double b = 0.75d;
double epslon = 0.05d;
QueryConfiguration queryConfiguration = new QueryConfiguration();
queryConfiguration.setProperty("bm25.idf.policy", "floor_epslon");
queryConfiguration.setProperty("bm25.idf.epslon", "" + epslon);
queryConfiguration.setProperty("bm25.k1", "" + k1);
queryConfiguration.setProperty("bm25.b", "" + b);
LgteIndexSearcherWrapper searcher =
new LgteIndexSearcherWrapper(Model.OkapiBM25Model, pathUnique);
IndexReader readerMulti1 = LgteIndexManager.openReader(pathMulti1, Model.OkapiBM25Model);
IndexReader readerMulti2 = LgteIndexManager.openReader(pathMulti2, Model.OkapiBM25Model);
Map<String, IndexReader> readers = new HashMap<String, IndexReader>();
readers.put("contents1", readerMulti1);
readers.put("contents2", readerMulti2);
LgteIndexSearcherWrapper searcherMulti =
new LgteIndexSearcherWrapper(Model.OkapiBM25Model, new LgteIsolatedIndexReader(readers));
try {
LgteQuery lgteQuery =
LgteQueryParser.parseQuery(
"contents1:(word2 word67 word1*) contents2:(word1* word2 word67)",
searcher,
queryConfiguration);
LgteHits lgteHits = searcher.search(lgteQuery);
LgteQuery lgteQueryMulti =
LgteQueryParser.parseQuery(
"contents1:(word1* word2 word67) contents2:(word1* word2 word67)",
searcherMulti,
queryConfiguration);
LgteHits lgteHitsMulti = searcherMulti.search(lgteQueryMulti);
System.out.println("EXPECTED");
System.out.println(
"doc:" + lgteHits.doc(0).get(Globals.DOCUMENT_ID_FIELD) + ":" + lgteHits.score(0));
System.out.println(
"doc:" + lgteHits.doc(1).get(Globals.DOCUMENT_ID_FIELD) + ":" + lgteHits.score(1));
System.out.println(
"doc:" + lgteHits.doc(2).get(Globals.DOCUMENT_ID_FIELD) + ":" + lgteHits.score(2));
System.out.println("RETURN:");
System.out.println(
"doc:"
+ lgteHitsMulti.doc(0).get(Globals.DOCUMENT_ID_FIELD)
+ ":"
+ lgteHitsMulti.score(0));
System.out.println(
"doc:"
+ lgteHitsMulti.doc(1).get(Globals.DOCUMENT_ID_FIELD)
+ ":"
+ lgteHitsMulti.score(1));
System.out.println(
"doc:"
+ lgteHitsMulti.doc(2).get(Globals.DOCUMENT_ID_FIELD)
+ ":"
+ lgteHitsMulti.score(2));
assertEquals(
lgteHits.doc(0).get(Globals.DOCUMENT_ID_FIELD),
lgteHitsMulti.doc(0).get(Globals.DOCUMENT_ID_FIELD));
assertEquals(
lgteHits.doc(1).get(Globals.DOCUMENT_ID_FIELD),
lgteHitsMulti.doc(1).get(Globals.DOCUMENT_ID_FIELD));
assertEquals(
lgteHits.doc(2).get(Globals.DOCUMENT_ID_FIELD),
lgteHitsMulti.doc(2).get(Globals.DOCUMENT_ID_FIELD));
assertEquals(lgteHits.score(0), lgteHitsMulti.score(0));
assertEquals(lgteHits.score(1), lgteHitsMulti.score(1));
assertEquals(lgteHits.score(2), lgteHitsMulti.score(2));
} catch (ParseException e) {
fail(e.toString());
}
searcher.close();
}
