com.gemstone.gemfire.cache.query.functional.IUM6Bug32345ReTest 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.
*/
/*
* IUM6Bug32345ReTest.java
*
* Created on May 5, 2005, 10:32 AM
*/
// @Task IUM6:
package com.gemstone.gemfire.cache.query.functional;
import com.gemstone.gemfire.cache.Region;
import junit.framework.TestCase;
import com.gemstone.gemfire.cache.query.*;
import com.gemstone.gemfire.cache.query.data.Portfolio;
import com.gemstone.gemfire.cache.query.data.Position;
import com.gemstone.gemfire.cache.query.internal.QueryObserverAdapter;
import com.gemstone.gemfire.cache.query.internal.QueryObserverHolder;
import com.gemstone.gemfire.cache.query.types.StructType;
import java.util.*;
import junit.framework.Test;
import junit.framework.TestSuite;
public class IUM6Bug32345ReTest extends TestCase{
StructType resType1=null;
StructType resType2= null;
String[] strg1 = null;
String[] strg2= null;
int resSize1=0;
int resSize2=0;
Object valPf1=null;
Object valPos1=null;
Object valPf2=null;
Object valPos2=null;
Iterator itert1=null;
Iterator itert2=null;
Set set1=null;
Set set2=null;
boolean isActive1=false;
boolean isActive2=false;
public IUM6Bug32345ReTest(String testName){
super(testName);
}
protected void setUp() throws java.lang.Exception {
CacheUtils.startCache();
}
protected void tearDown() throws java.lang.Exception {
CacheUtils.closeCache();
}
public static Test suite(){
TestSuite suite = new TestSuite(IUM6Bug32345ReTest.class);
return suite;
}
public void testComparisonBetnWithAndWithoutIndexCreation() throws Exception {
Region region = CacheUtils.createRegion("pos", Portfolio.class);
for(int i=0;i<4;i++){
region.put(""+i, new Portfolio(i));
}
QueryService qs;
qs = CacheUtils.getQueryService();
String queries[] = {
"SELECT DISTINCT * FROM /pos pf, positions.values pos where pf.status='active' and pos.secId= 'IBM' and ID = 0"
};
SelectResults sr[][] = new SelectResults[queries.length][2];
for (int i = 0; i < queries.length; i++) {
Query q = null;
try {
q = CacheUtils.getQueryService().newQuery(queries[i]);
QueryObserverImpl observer = new QueryObserverImpl();
QueryObserverHolder.setInstance(observer);
sr[i][0] =(SelectResults) q.execute();
if(!observer.isIndexesUsed){
System.out.println("NO INDEX USED");
}
System.out.println(Utils.printResult(sr[i][0]));
resType1 =(StructType)(sr[i][0]).getCollectionType().getElementType();
resSize1 =((sr[i][0]).size());
strg1=resType1.getFieldNames();
set1=((sr[i][0]).asSet());
Iterator iter=set1.iterator();
while (iter.hasNext()){
Struct stc1=(Struct)iter.next();
valPf1=stc1.get(strg1[0]);
valPos1=stc1.get(strg1[1]);
isActive1=((Portfolio)stc1.get(strg1[0])).isActive();
}
}
catch (Exception e) {
e.printStackTrace();
fail(q.getQueryString());
}
}
// Create an Index on status and execute the same query again.
qs = CacheUtils.getQueryService();
qs.createIndex("statusIndex", IndexType.FUNCTIONAL,"pf.status","/pos pf, pf.positions.values pos");
//Retesting BUG # 32345
//Index index2 = (Index)qs.createIndex("secIdIndex", IndexType.FUNCTIONAL,"pos.secId","/pos pf, pf.positions.values pos");
qs.createIndex("IDIndex", IndexType.FUNCTIONAL,"pf.ID","/pos pf, pf.positions.values pos");
String queries2[] = {
"SELECT DISTINCT * FROM /pos pf, positions.values pos where pf.status='active' and pos.secId= 'IBM' and ID = 0"
};
for (int i = 0; i < queries.length; i++) {
Query q = null;
try {
q = CacheUtils.getQueryService().newQuery(queries[i]);
QueryObserverImpl observer2 = new QueryObserverImpl();
QueryObserverHolder.setInstance(observer2);
sr[i][1] = (SelectResults)q.execute();
if(observer2.isIndexesUsed){
System.out.println("YES INDEX IS USED!");
}
else {
fail("Index NOT Used");
}
System.out.println(Utils.printResult(sr[i][1]));
resType2 =(StructType)(sr[i][1]).getCollectionType().getElementType();
resSize2 =((sr[i][1]).size());
// System.out.println(resType2);
strg2=resType2.getFieldNames();
// System.out.println(strg2[0]);
// System.out.println(strg2[1]);
set2=((sr[i][1]).asSet());
Iterator iter=set2.iterator();
while (iter.hasNext()){
Struct stc2=(Struct)iter.next();
valPf2=stc2.get(strg2[0]);
valPos2=stc2.get(strg2[1]);
isActive2=((Portfolio)stc2.get(strg2[0])).isActive();
// System.out.println(valPf2);
// System.out.println(valPos2);
}
}
catch (Exception e) {
e.printStackTrace();
fail(q.getQueryString());
}
}
if ((resType1).equals(resType2)){
System.out.println("Both Search Results are of the same Type i.e.--> "+resType1);
}else {
fail("FAILED:Search result Type is different in both the cases");
}
if (resSize1==resSize2 || resSize1 != 0){
System.out.println("Both Search Results are Non-zero and are of Same Size i.e. Size= "+resSize1);
}else {
fail("FAILED:Search result Type is different in both the cases");
}
itert2 = set2.iterator();
itert1 = set1.iterator();
while (itert1.hasNext()){
Struct stc2=(Struct)itert2.next();
Struct stc1 = (Struct)itert1.next();
if( stc2.get(strg2[0]) != stc1.get(strg1[0]) )
fail("FAILED: In both the Cases the first member of StructSet i.e. Portfolio are different. ");
if(stc2.get(strg2[1]) != stc1.get(strg1[1]))
fail("FAILED: In both the cases Positions are different");
if(((Position)stc2.get(strg2[1])).secId != ((Position)stc1.get(strg1[1])).secId)
fail("FAILED: In both the cases Positions secIds are different");
if (((Portfolio)stc2.get(strg2[0])).isActive() != ((Portfolio)stc1.get(strg1[0])).isActive() )
fail("FAILED: Status of the Portfolios found are different");
if (((Portfolio)stc2.get(strg2[0])).getID() != ((Portfolio)stc1.get(strg1[0])).getID() )
fail("FAILED: IDs of the Portfolios found are different");
}
CacheUtils.compareResultsOfWithAndWithoutIndex(sr, this);
}
class QueryObserverImpl extends QueryObserverAdapter{
boolean isIndexesUsed = false;
ArrayList indexesUsed = new ArrayList();
public void beforeIndexLookup(Index index, int oper, Object key) {
indexesUsed.add(index.getName());
}
public void afterIndexLookup(Collection results) {
if(results != null){
isIndexesUsed = true;
}
}
}
}