gemfire-core/src/test/java/com/gemstone/gemfire/cache/query/partitioned/PRInvalidQueryJUnitTest.java

/*=========================================================================
 * Copyright (c) 2010-2014 Pivotal Software, Inc. All Rights Reserved.
 * This product is protected by U.S. and international copyright
 * and intellectual property laws. Pivotal products are covered by
 * one or more patents listed at http://www.pivotal.io/patents.
 *=========================================================================
 */
package com.gemstone.gemfire.cache.query.partitioned;

import static org.junit.Assert.fail;

import org.junit.Before;
import org.junit.Test;
import org.junit.experimental.categories.Category;

import com.gemstone.gemfire.LogWriter;
import com.gemstone.gemfire.cache.Region;
import com.gemstone.gemfire.cache.query.QueryInvalidException;
import com.gemstone.gemfire.cache.query.data.PortfolioData;
import com.gemstone.gemfire.internal.cache.PartitionedRegionTestHelper;
import com.gemstone.gemfire.test.junit.categories.IntegrationTest;

/**
 * Class verifies Region#query(Select Query) API for PartitionedRegion on a
 * single VM.,As region#query doesn't support Select Query for Local Querying it
 * should throw QueryInvalidException
 * 
 * @author pbatra
 * 
 */
@Category(IntegrationTest.class)
public class PRInvalidQueryJUnitTest
{
  String regionName = "Portfolios";

  LogWriter logger = null;

  @Before
  public void setUp() throws Exception
  {
    if (logger == null) {
      logger = PartitionedRegionTestHelper.getLogger();
    }
  }

  /**
   * Tests the execution of an Invalid query <br>
   * (of the nature Select Distinct * from /Portfolios ) <br>
   * on a PartitionedRegion created on a single data store. <br>
   * 1. Creates a PR with redundancy=0 on a single VM.<br>
   * 2. Puts some test Objects in cache.<br>
   * 3. Fires querie on the data and verifies the result.<br>
   * 4. Since region#query() doesn't support this type of query syntax it should
   * throw QueryInvalidException <br>
   * 
   * @throws Exception
   */
  @Test
  public void testInvalidQueryOnSingleDS() throws Exception
  {
    logger
        .info("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: Test Started  ");
    Region region = PartitionedRegionTestHelper.createPartitionedRegion(
        regionName, "100", 0);

    logger
        .info("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: creating portfolioData objects");
    PortfolioData[] portfolios = new PortfolioData[100];
    for (int j = 0; j < 100; j++) {
      portfolios[j] = new PortfolioData(j);
    }
    populateData(region, portfolios);

    logger
        .info("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: creating Select Query");

    String queryString = "SELECT DISTINCT * FROM /Portfolios WHERE pkid < '5'";

    final String expectedQueryInvalidException = QueryInvalidException.class
        .getName();
    logger.info("<ExpectedException action=add>"
        + expectedQueryInvalidException + "</ExpectedException>");
    try {
      region.query(queryString);
      fail("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: Expected an Invalid Query Exception for the query :"
          + queryString + " this is not supported for region#query()");
    }
    catch (QueryInvalidException qe) {

      logger
          .info("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: Caught an Invalid Query Exception for the query :"
              + queryString + " this is not supported for region#query()");

    }

    logger
        .info("PRInvalidQueryJUnitTest#testInvalidQueryOnSingleDS: Test Ended");

    logger.info("<ExpectedException action=remove>"
        + expectedQueryInvalidException + "</ExpectedException>");
  }

  /**
   * Populates the region with the Objects stores in the data Object array.
   * 
   * @param region
   * @param data
   */
  private void populateData(Region region, Object[] data)
  {
    logger
        .info("PRInvalidQueryJUnitTest#populateData: Populating Data to the region");

    for (int j = 0; j < data.length; j++) {
      region.put(new Integer(j), data[j]);
    }
  }
}