com.gemstone.gemfire.cache.query.functional.FunctionTest Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of gemfire-junit Show documentation
Show all versions of gemfire-junit Show documentation
SnappyData store based off Pivotal GemFireXD
/*
* Copyright (c) 2010-2015 Pivotal Software, Inc. All rights reserved.
*
* Licensed 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. See accompanying
* LICENSE file.
*/
/*
* FunctionTest.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 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;
/**
*
* @author vaibhav
* @author kdeshpan
*/
public class FunctionTest extends TestCase {
public FunctionTest(String testName) {
super(testName);
}
protected 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));
}
protected void tearDown() throws java.lang.Exception {
CacheUtils.closeCache();
}
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");
}
}
}
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