mondrian.rolap
Class GroupingSetQueryTest

java.lang.Object
  extended by junit.framework.Assert
      extended by junit.framework.TestCase
          extended by mondrian.test.FoodMartTestCase
              extended by mondrian.rolap.BatchTestCase
                  extended by mondrian.rolap.GroupingSetQueryTest
All Implemented Interfaces:
junit.framework.Test

public class GroupingSetQueryTest
extends BatchTestCase

Test support for generating SQL queries with the GROUPING SETS construct, if the DBMS supports it.

Since:
08-Jun-2007
Author:
Thiyagu

Nested Class Summary
 
Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase
BatchTestCase.Bomb, BatchTestCase.CellRequestConstraint, BatchTestCase.TestCase, BatchTestCase.TestListener
 
Field Summary
 
Fields inherited from class mondrian.rolap.BatchTestCase
cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime
 
Fields inherited from class mondrian.test.FoodMartTestCase
propSaver
 
Constructor Summary
GroupingSetQueryTest()
           
 
Method Summary
protected  void setUp()
           
protected  void tearDown()
           
 void testBug2004202()
          Testcase for bug 2004202, "Except not working with grouping sets".
 void testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()
           
 void testGroupingSetForMultipleColumnConstraint()
           
 void testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()
           
 void testGroupingSetForMultipleMeasureAndSingleConstraint()
           
 void testGroupingSetForSingleColumnConstraint()
           
 void testGroupingSetsWithAggregateOverDefaultMember()
           
 void testNotUsingGroupingSet()
           
 void testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()
           
 
Methods inherited from class mondrian.rolap.BatchTestCase
assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, getRegistry, makeConstraintCountryState, makeConstraintProductFamilyDepartment, makeConstraintYearQuarterMonth
 
Methods inherited from class mondrian.test.FoodMartTestCase
allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertQueryThrows, assertSize, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, genderMembersIncludingAll, getConnection, getDimensionWithName, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, warehouseMembersCanadaMexicoUsa
 
Methods inherited from class junit.framework.TestCase
countTestCases, createResult, getName, run, run, runBare, runTest, setName, toString
 
Methods inherited from class junit.framework.Assert
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

GroupingSetQueryTest

public GroupingSetQueryTest()
Method Detail

setUp

protected void setUp()
              throws Exception
Overrides:
setUp in class junit.framework.TestCase
Throws:
Exception

tearDown

protected void tearDown()
                 throws Exception
Overrides:
tearDown in class FoodMartTestCase
Throws:
Exception

testGroupingSetsWithAggregateOverDefaultMember

public void testGroupingSetsWithAggregateOverDefaultMember()

testGroupingSetForSingleColumnConstraint

public void testGroupingSetForSingleColumnConstraint()

testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable

public void testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()

testNotUsingGroupingSet

public void testNotUsingGroupingSet()

testGroupingSetForMultipleMeasureAndSingleConstraint

public void testGroupingSetForMultipleMeasureAndSingleConstraint()

testGroupingSetForASummaryCanBeGroupedWith2DetailBatch

public void testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()

testGroupingSetForMultipleColumnConstraint

public void testGroupingSetForMultipleColumnConstraint()

testGroupingSetForMultipleColumnConstraintAndCompoundConstraint

public void testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()

testBug2004202

public void testBug2004202()
Testcase for bug 2004202, "Except not working with grouping sets".


Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads