Querier.java

/*
 * 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 jackrabbit.query;

import javax.jcr.NodeIterator;
import javax.jcr.query.RowIterator;
import javax.jcr.RepositoryException;
import javax.jcr.Session;
import javax.jcr.Value;
import javax.jcr.query.Query;
import javax.jcr.query.QueryManager;
import javax.jcr.query.QueryResult;
import javax.jcr.query.Row;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class Querier {
	
	protected static Log log=LogFactory.getLog(Querier.class);
	
	public static NodeIterator queryBySQLNode(Session session, String query) throws RepositoryException {
		QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery(query, Query.JCR_SQL2);
        QueryResult result = q.execute();
        NodeIterator it = result.getNodes();
        return it;
	}
	
	public static RowIterator queryBySQLRow(Session session, String query) throws RepositoryException {
		QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery(query, Query.JCR_SQL2);
        QueryResult result = q.execute();
        RowIterator it = result.getRows();
        return it;
	}
	
	public static RowIterator queryBySQLRow(Session session, String query, String queryType) throws RepositoryException {
		if (queryType==null || queryType.isEmpty()) queryType=Query.JCR_SQL2;
		QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery(query, queryType);
        QueryResult result = q.execute();
        RowIterator it = result.getRows();
        return it;
	}
	
	public static String formatQueryResults(RowIterator it) throws RepositoryException {
		String results="\n";
		while (it.hasNext()) {
        	Row row = it.nextRow();
        	Value[] values=row.getValues();
        	String s="";
        	for (Value value:values) {
        		if (value!=null)
        			s+="| " + value.getString() + " ";
        		else
        			s+="| null ";
        	}
        	results+=s+"\n";
		}
		return results;
	}
 
}