/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.jackrabbit.test.api.query;
import javax.jcr.query.QueryResult;
import javax.jcr.query.RowIterator;
import javax.jcr.query.Row;
import javax.jcr.Value;
/**
* Tests SQL queries on content written to the workspace by the test itself.
*
* @test
* @sources SQLQueryLevel2Test.java
* @executeClass org.apache.jackrabbit.test.api.query.SQLQueryLevel2Test
* @keywords level2 sql
*/
public class SQLQueryLevel2Test extends AbstractQueryLevel2Test {
/**
* Test if the optional jcr:score property for full-text search is
* supported.
* <p>
* For configuration description see {@link #setUpFullTextTest()}.
*/
public void testScoreColumn() throws Exception {
setUpFullTextTest();
QueryResult result = execute(getFullTextStatement());
RowIterator rows = result.getRows();
// test mere existence
rows.nextRow().getValue(jcrScore);
}
/**
* Test full-text search of the repository.
* <p>
* For configuration description see {@link #setUpFullTextTest()}.
*/
public void testFullTextSearch() throws Exception {
setUpFullTextTest();
QueryResult result = execute(getFullTextStatement());
// must be 1
checkResult(result, 1);
// evaluate result
RowIterator itr = result.getRows();
while (itr.hasNext()) {
Row row = itr.nextRow();
Value value = row.getValue(propertyName1);
if (value != null) {
String fullText = value.getString();
if (fullText.indexOf("cat") > 0) {
fail("Search Text: full text search not correct, returned prohibited text");
}
}
}
}
/**
* Test range evaluation of a Query.
* <p>
* For configuration description see {@link #setUpRangeTest()}.
*/
public void testRange() throws Exception {
setUpRangeTest();
QueryResult result = execute(getRangeStatement());
// should be 1
checkResult(result, 1);
// evaluate result
checkValue(result.getRows(), propertyName1, "b");
}
/**
* Test multi-value support of search.
* <p>
* For configuration description see {@link #setUpMultiValueTest()}.
*/
public void testMultiValueSearch() throws Exception {
setUpMultiValueTest();
QueryResult result = execute(getMultiValueStatement());
//should be 1
checkResult(result, 1);
//evaluate result
checkValue(result.getRows(), propertyName1, "existence");
}
/**
* Test if the optional jcr:path pseudo property is contained in the query
* result.
* <p>
* For configuration description see {@link #setUpFullTextTest()}.
*/
public void testPathColumn() throws Exception {
setUpFullTextTest();
QueryResult result = execute(getFullTextStatement());
RowIterator rows = result.getRows();
if (getSize(rows) < 1) {
fail("Query result did not return any nodes");
}
// re-aquire rows
rows = result.getRows();
// test mere existence
rows.nextRow().getValue(jcrPath);
}
//------------------------< internal >--------------------------------------
/**
* @return Statement selecting a node by a phrase, and proper escaped value
* and excluding with a word
*/
private Statement getFullTextStatement() {
StringBuffer tmp = new StringBuffer("SELECT ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" FROM ").append(escapeIdentifierForSQL(testNodeType));
tmp.append(" WHERE CONTAINS(., '\"quick brown\" -cat')");
tmp.append(" AND ").append(jcrPath).append(" LIKE '");
tmp.append(testRoot).append("/%'");
return new Statement(tmp.toString(), qsSQL);
}
/**
* @return Statement selecting nodes by its value contained in a multi-value
* property
*/
private Statement getMultiValueStatement() {
StringBuffer tmp = new StringBuffer("SELECT ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" FROM ").append(escapeIdentifierForSQL(testNodeType));
tmp.append(" WHERE 'two' IN ");
tmp.append(escapeIdentifierForSQL(propertyName2));
tmp.append(" AND 'existence' IN ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" AND ").append(jcrPath).append(" LIKE '");
tmp.append(testRoot).append("/%'");
return new Statement(tmp.toString(), qsSQL);
}
/**
* @return Statement selecting nodes by its range in {@link #propertyName1}
*/
private Statement getRangeStatement() {
StringBuffer tmp = new StringBuffer("SELECT ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" FROM ").append(escapeIdentifierForSQL(testNodeType));
tmp.append(" WHERE ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" <= 'b' AND ");
tmp.append(escapeIdentifierForSQL(propertyName1));
tmp.append(" > 'a'");
tmp.append(" AND ").append(jcrPath).append(" LIKE '");
tmp.append(testRoot).append("/%'");
return new Statement(tmp.toString(), qsSQL);
}
}