/*
* 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.oak.query;
import static junit.framework.Assert.assertTrue;
import static org.apache.jackrabbit.JcrConstants.JCR_SYSTEM;
import static org.apache.jackrabbit.oak.plugins.nodetype.NodeTypeConstants.JCR_NODE_TYPES;
import static org.apache.jackrabbit.oak.plugins.nodetype.write.InitialContent.INITIAL_CONTENT;
import java.text.ParseException;
import org.apache.jackrabbit.oak.query.xpath.XPathToSQL2Converter;
import org.apache.jackrabbit.oak.spi.state.NodeState;
import org.junit.Test;
/**
* Tests the SQL-2 parser.
*/
public class SQL2ParserTest {
private final NodeState types =
INITIAL_CONTENT.getChildNode(JCR_SYSTEM).getChildNode(JCR_NODE_TYPES);
private final SQL2Parser p = new SQL2Parser(null, types, new QueryEngineSettings());
@Test
public void testIgnoreSqlComment() throws ParseException {
p.parse("select * from [nt:unstructured] /* sql comment */");
p.parse("select [jcr:path], [jcr:score], * from [nt:base] as a /* xpath: //* */");
}
@Test(expected = ParseException.class)
public void testUnfinishedSqlComment() throws ParseException {
p.parse("select [jcr:path], [jcr:score], * from [nt:base] as a /* xpath: //* ");
}
@Test
public void testTransformAndParse() throws ParseException {
p.parse(new XPathToSQL2Converter()
.convert("/jcr:root/test/*/nt:resource[@jcr:encoding]"));
}
// see OAK-OAK-830: XPathToSQL2Converter fails to wrap or clauses
@Test
public void testUnwrappedOr() throws ParseException {
String q = new XPathToSQL2Converter()
.convert("/jcr:root/home//test/* [@type='t1' or @type='t2' or @type='t3']");
String token = "and (b.[type] = 't1' or b.[type] = 't2' or b.[type] = 't3')";
assertTrue(q.contains(token));
}
}