/*
* Copyright (C) 2009 eXo Platform SAS.
*
* This is free software; you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as
* published by the Free Software Foundation; either version 2.1 of
* the License, or (at your option) any later version.
*
* This software is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this software; if not, write to the Free
* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA, or see the FSF site: http://www.fsf.org.
*/
package org.exoplatform.services.jcr.api.search;
import org.exoplatform.services.jcr.JcrAPIBaseTest;
import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.util.Calendar;
import javax.jcr.Node;
import javax.jcr.NodeIterator;
import javax.jcr.query.Query;
import javax.jcr.query.QueryManager;
import javax.jcr.query.QueryResult;
/**
* Created by The eXo Platform SAS Author : Peter Nedonosko peter.nedonosko@exoplatform.com.ua
* 25.12.2007
*
* @author <a href="mailto:peter.nedonosko@exoplatform.com.ua">Peter Nedonosko</a>
* @version $Id: TestSearch.java 11907 2008-03-13 15:36:21Z ksm $
*/
public class TestSearch extends JcrAPIBaseTest
{
private Node testNode;
@Override
public void setUp() throws Exception
{
super.setUp();
testNode = session.getRootNode().addNode("searchTestNode");
session.save();
}
@Override
protected void tearDown() throws Exception
{
testNode.remove();
session.save();
super.tearDown();
}
private Node addNtFile(Node parent, InputStream content) throws Exception
{
Node node1 = parent.addNode("File", "nt:file");
Node ntFile = node1.addNode("jcr:content", "nt:resource");
ntFile.setProperty("jcr:lastModified", Calendar.getInstance());
ntFile.setProperty("jcr:mimeType", "text/plain");
ntFile.setProperty("jcr:data", content);
return ntFile;
}
public void testAllofNodeType() throws Exception
{
for (int i = 1; i <= 100; i++)
{
Node queryNode = testNode.addNode("node-" + 1, "exojcrtest:type1");
Node file = addNtFile(queryNode, new ByteArrayInputStream("ACDC EEEE".getBytes()));
}
session.save();
String sqlQuery = "SELECT * FROM exojcrtest:type1 WHERE jcr:path LIKE '" + testNode.getPath() + "/%'";
QueryManager manager = session.getWorkspace().getQueryManager();
Query query = manager.createQuery(sqlQuery, Query.SQL);
QueryResult queryResult = query.execute();
NodeIterator iter = queryResult.getNodes();
assertTrue(iter.getSize() == 100); // check target nodes for existanse
while (iter.hasNext())
{
assertNotNull(iter.nextNode());
}
}
public void testAllofNodeTypeWithOrder() throws Exception
{
for (int i = 1; i <= 100; i++)
{
Node queryNode = testNode.addNode("node-" + 1, "exojcrtest:type1");
Node file = addNtFile(queryNode, new ByteArrayInputStream("ACDC EEEE".getBytes()));
}
session.save();
String sqlQuery =
"SELECT * FROM exojcrtest:type1 WHERE jcr:path LIKE '" + testNode.getPath() + "/%' order by jcr:primaryType";
QueryManager manager = session.getWorkspace().getQueryManager();
Query query = manager.createQuery(sqlQuery, Query.SQL);
QueryResult queryResult = query.execute();
NodeIterator iter = queryResult.getNodes();
assertTrue(iter.getSize() == 100); // check target nodes for existense
while (iter.hasNext())
{
assertNotNull(iter.nextNode());
}
}
}