gemfire-core/src/test/java/com/gemstone/gemfire/cache/query/functional/FunctionJUnitTest.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.
 *=========================================================================
 */
/*
 * FunctionJUnitTest.java
 * JUnit based test
 *
 * Created on March 10, 2005, 4:13 PM
 */
package com.gemstone.gemfire.cache.query.functional;

import java.text.SimpleDateFormat;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;

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

import static org.junit.Assert.*;

import junit.framework.TestCase;

import com.gemstone.gemfire.cache.Region;
import com.gemstone.gemfire.cache.query.CacheUtils;
import com.gemstone.gemfire.cache.query.FunctionDomainException;
import com.gemstone.gemfire.cache.query.Query;
import com.gemstone.gemfire.cache.query.QueryService;
import com.gemstone.gemfire.cache.query.data.Portfolio;
import com.gemstone.gemfire.cache.query.internal.CompiledFunction;
import com.gemstone.gemfire.cache.query.internal.CompiledLiteral;
import com.gemstone.gemfire.cache.query.internal.CompiledValue;
import com.gemstone.gemfire.cache.query.internal.ExecutionContext;
import com.gemstone.gemfire.cache.query.internal.parse.OQLLexerTokenTypes;
import com.gemstone.gemfire.test.junit.categories.IntegrationTest;

/**
 *
 * @author vaibhav
 * @author kdeshpan
 */
@Category(IntegrationTest.class)
public class FunctionJUnitTest {


  @Before
  public void setUp() throws java.lang.Exception {
    CacheUtils.startCache();
    Region region = CacheUtils.createRegion("Portfolios", Portfolio.class);
    region.put("0",new Portfolio(0));
    region.put("1",new Portfolio(1));
    region.put("2",new Portfolio(2));
    region.put("3",new Portfolio(3));
  }

  @After
  public void tearDown() throws java.lang.Exception {
    CacheUtils.closeCache();
  }

  @Test
  public void testCanonicalization() throws Exception {
    CompiledValue cv1 = new CompiledLiteral("str1");
    CompiledValue cv2 = new CompiledLiteral("str2");
    CompiledValue cv3 = new CompiledLiteral(null);
    CompiledValue cv4 = new CompiledLiteral(null);
    CompiledValue cv5 = new CompiledLiteral(new Integer(10));
    CompiledValue cv6 = new CompiledLiteral(new Integer(5));
    CompiledValue cvArr [] [] = new CompiledValue[][] {
                                  {cv1,cv2,cv3,cv4,cv5,cv6},
                                  {cv6,cv5,cv3,cv4,cv2,cv1},
                                  {cv1,cv3,cv5,cv2,cv4,cv6},
                                  {cv1},
                                  {cv3},
                                  {cv5}
    };

    String [] canonicalizedArgs = {
      "('str1','str2',null,null,10,5)",
      "(5,10,null,null,'str2','str1')",
      "('str1',null,10,'str2',null,5)",
      "('str1')",
      "(null)",
      "(10)"
    };

    ExecutionContext context = null;
    for (int i = 0; i < 6; i++) {
      CompiledValue cf = new CompiledFunction(cvArr[i], OQLLexerTokenTypes.LITERAL_nvl);
      StringBuffer clauseBuffer = new StringBuffer();
      cf.generateCanonicalizedExpression(clauseBuffer, context);
      if(!clauseBuffer.toString().equals("NVL" + canonicalizedArgs[i])) {
        fail("Canonicalization not done properly");
      }

      cf = new CompiledFunction(cvArr[i], OQLLexerTokenTypes.LITERAL_element);
      clauseBuffer = new StringBuffer();
      cf.generateCanonicalizedExpression(clauseBuffer, context);
      if(!clauseBuffer.toString().equals("ELEMENT" + canonicalizedArgs[i])) {
        fail("Canonicalization not done properly");
      }
    }
  }

  @Test
  public void testIS_DEFINED() throws Exception {
    Query query = CacheUtils.getQueryService().newQuery("SELECT DISTINCT * FROM /Portfolios where IS_DEFINED(P2.secId)");
    Object result = query.execute();
    if(result instanceof Collection){
      Iterator iter = ((Collection)result).iterator();
      while(iter.hasNext()){
        Portfolio p = (Portfolio)iter.next();
        if(p.getP2() == null)
          fail(query.getQueryString());
      }
    }
    Object testData[][] ={
      {"string", Boolean.TRUE},
      {new Integer(0), Boolean.TRUE},
      {QueryService.UNDEFINED, Boolean.FALSE},
      {null, Boolean.TRUE}
    };

    for(int i=0;i<testData.length;i++){
      query = CacheUtils.getQueryService().newQuery("IS_DEFINED($1)");
      result = query.execute(testData[i]);
      if(!result.equals(testData[i][1]))
        fail(query.getQueryString()+" for "+testData[i][0]);
    }
  }

  @Test
  public void testIS_UNDEFINED() throws Exception {
    Query query = CacheUtils.getQueryService().newQuery("SELECT DISTINCT * FROM /Portfolios where IS_UNDEFINED(P2.secId)");
    Object result = query.execute();
    if(result instanceof Collection){
      Iterator iter = ((Collection)result).iterator();
      while(iter.hasNext()){
        Portfolio p = (Portfolio)iter.next();
        if(p.getP2() != null)
          fail(query.getQueryString());
      }
    }
    Object testData[][] ={
      {"string", Boolean.FALSE},
      {new Integer(0), Boolean.FALSE},
      {QueryService.UNDEFINED, Boolean.TRUE},
      {null, Boolean.FALSE}
    };

    for(int i=0;i<testData.length;i++){
      query = CacheUtils.getQueryService().newQuery("IS_UNDEFINED($1)");
      result = query.execute(testData[i]);
      if(!result.equals(testData[i][1]))
        fail(query.getQueryString()+" for "+testData[i][0]);
    }
  }

  @Test
  public void testELEMENT() throws Exception {
    Query query = CacheUtils.getQueryService().newQuery("ELEMENT(SELECT DISTINCT * FROM /Portfolios where ID =1).status");
    Object result = query.execute();
    if(!result.equals("inactive"))
      fail(query.getQueryString());
    try{
      query = CacheUtils.getQueryService().newQuery("ELEMENT(SELECT DISTINCT * FROM /Portfolios where ID <= 1).status");
      result = query.execute();
      fail(query.getQueryString());
    }catch(FunctionDomainException e){

    }
  }

  @Test
  public void testNVL() throws Exception {
    Query query = CacheUtils.getQueryService().newQuery(
        "nvl(NULL, 'foundNull')");
    Object result = query.execute();
    if (!result.equals("foundNull"))
      fail(query.getQueryString());

    query = CacheUtils.getQueryService().newQuery(
    "nvl('notNull', 'foundNull')");
    result = query.execute();
    if (result.equals("foundNull"))
      fail(query.getQueryString());

    query = CacheUtils.getQueryService().newQuery("select distinct * from /Portfolios pf where nvl(pf.position2,'foundNull') = 'foundNull'");
    result = query.execute();

    if (((Collection)result).size() != 2) {
      fail(query.getQueryString());
    }

    query = CacheUtils.getQueryService().newQuery("select distinct nvl(pf.position2, 'inProjection') from /Portfolios pf where nvl(pf.position2,'foundNull') = 'foundNull'");
    result = query.execute();
 //   CacheUtils.log("Size of result :" + ((Collection)result).size());
    if (((Collection)result).size() != 1) {
      fail(query.getQueryString());
    }
  }

  @Test
  public void testTo_Date() throws Exception {
    String [] queries = {
        "to_date('10/09/05', 'MM/dd/yy')",
        "to_date('09/10/05', 'dd/MM/yy')",
        "to_date('05/10/09', 'yy/MM/dd')",
        "to_date('05/09/10', 'yy/dd/MM')",
        "to_date('10/05/09', 'MM/yy/dd')",
        "to_date('09/05/10', 'dd/yy/MM')",

        "to_date('10/09/2005', 'MM/dd/yy')",
        "to_date('09/10/2005', 'dd/MM/yy')",
        "to_date('2005/10/09', 'yy/MM/dd')",
        "to_date('2005/09/10', 'yy/dd/MM')",
        "to_date('10/2005/09', 'MM/yy/dd')",
        "to_date('09/2005/10', 'dd/yy/MM')",

        "to_date('10/09/2005', 'MM/dd/yyyy')",
        "to_date('09/10/2005', 'dd/MM/yyyy')",
        "to_date('2005/10/09', 'yyyy/MM/dd')",
        "to_date('2005/09/10', 'yyyy/dd/MM')",
        "to_date('10/2005/09', 'MM/yyyy/dd')",
        "to_date('09/2005/10', 'dd/yyyy/MM')",
        ////////////////////////////////////////////////////////////////////

        "to_date('100905', 'MMddyy')",
        "to_date('091005', 'ddMMyy')",
        "to_date('051009', 'yyMMdd')",
        "to_date('050910', 'yyddMM')",
        "to_date('100509', 'MMyydd')",
        "to_date('090510', 'ddyyMM')",

        "to_date('10092005', 'MMddyy')",
        "to_date('09102005', 'ddMMyy')",

        "to_date('10092005', 'MMddyyyy')",
        "to_date('09102005', 'ddMMyyyy')",
        "to_date('20051009', 'yyyyMMdd')",
        "to_date('20050910', 'yyyyddMM')",
        "to_date('10200509', 'MMyyyydd')",
        "to_date('09200510', 'ddyyyyMM')",
//

    };

    String noCheckQueries [] =  {
      "to_date('100936', 'MMddyyyy')",
      "to_date('09/10/05', 'dd/MM/yyyy')",
      "to_date('05/10/09', 'yyyy/MM/dd')",
      "to_date('05/09/10', 'yyyy/dd/MM')",
      "to_date('10/05/09', 'MM/yyyy/dd')",
      "to_date('09/05/10', 'dd/yyyy/MM')",

      "to_date('20051009', 'yyMMdd')",
      "to_date('20050910', 'yyddMM')",
      "to_date('10200509', 'MMyydd')",
      "to_date('09200510', 'ddyyMM')",

    };

    String[][] fineGrainedQueries = {
      new String[] {"10092005121314", "MMddyyyyHHmmss"},
      new String[] {"10092005121314567", "MMddyyyyHHmmssSSS"}
    };

    Query query = null;
    Object result = null;
    Date date = new Date(105, 9, 9);
    QueryService qs = CacheUtils.getQueryService();
    for (int i = 0; i < queries.length; i++) {
      query = qs.newQuery(queries[i]);
      result = query.execute();
    //  CacheUtils.log(((Date)result));
      if (!result.equals(date))
        fail(query.getQueryString());
    }

    for (int i = 0; i < noCheckQueries.length; i++) {
      query = qs.newQuery(queries[i]);
      result = query.execute();
  //    CacheUtils.log(((Date)result));

    }

    for (int i = 0; i < fineGrainedQueries.length; i++) {
      String[] dateStringAndFormat = fineGrainedQueries[i];
      String dateString = dateStringAndFormat[0];
      String format = dateStringAndFormat[1];
      SimpleDateFormat sdf = new SimpleDateFormat(format);
      Date sdfDate = sdf.parse(dateString);
      query = qs.newQuery("to_date('" + dateString + "', '" + format + "')");
      Date qsDate = (Date) query.execute();
      assertEquals(sdfDate, qsDate);
    }

  }

}