|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectjunit.framework.Assert
junit.framework.TestCase
org.apache.ojb.broker.QueryTest
Testing the query API
Field Summary | |
(package private) PersistenceBroker |
broker
|
Constructor Summary | |
QueryTest(java.lang.String name)
BrokerTests constructor comment. |
Method Summary | |
void |
_testReportQueryWithStartAndEnd()
Simple ReportQuery returning rows with 2 columns of Person needs SQL paging |
static void |
main(java.lang.String[] args)
Insert the method's description here. |
void |
setUp()
Insert the method's description here. |
void |
tearDown()
Insert the method's description here. |
void |
testBetweenCriteria()
test Between Criteria |
void |
testCriteria()
Criteria containing other Criteria only |
void |
testDistinct()
Distinct Query |
void |
testDistinctMultiPk()
Distinct Query |
void |
testEqualCriteria()
test EqualTo Criteria |
void |
testInCriteria()
test In Criteria |
void |
testInversePathExpression()
Read a CD and then read the ProductGroup for the CD |
void |
testLikeCriteria()
test Like Criteria |
void |
testLikeEscapedCriteria1()
test escaped Like Criteria |
void |
testLikeEscapedCriteria2()
test escaped Like Criteria with escape character |
void |
testMultipleJoins()
Test multiple non nested joins using pathExpressions |
void |
testNestedJoins()
Test nested joins using pathExpressions |
void |
testNullCriteria()
test Null Criteria |
void |
testPathExpressionForAbstractExtent()
test PathExpression pointing to abstract class (InterfaceArticle) |
void |
testPathExpressionForExtents1()
Test pathExpression and Extents |
void |
testPathExpressionForExtents2()
Test pathExpression and Extents |
void |
testPathExpressionForExtents3()
Test pathExpression and Extents musicians is only defined in CD |
void |
testPathExpressionForExtents4()
Test pathExpression and Extents Abstract Base |
void |
testPathExpressionForExtentsAlias()
Test pathExpression and Extents using Alias |
void |
testPathExpressions()
Single Path Expression |
void |
testPathExpressionsMtoN()
Multi Path Expression over nondecomposed m:n |
void |
testPathExpressionsMtoN2()
Multi Path Expression over nondecomposed m:n new test case for the 'not unique alias' problem with m:n relationship |
void |
testPathExpressionsMtoNDecomposed()
Multi Path Expression over decomposed m:n |
void |
testPrefetchedArraySingleKey()
prefetch Articles for ProductGroupsWithArray, Does not yet work with Arrays |
void |
testPrefetchedCollectionSingleKey()
prefetch Articles for ProductGroups |
void |
testPrefetchedReferencesSingleKey()
prefetch ProductGroups for Articles |
void |
testQueryMN_Alias1()
|
void |
testQueryMN_Alias2()
|
void |
testQueryMN()
|
void |
testQueryOrderByNonSelectColumn()
ReportQuery returning rows with some "Liquor" data ordered by productGroup.groupId |
void |
testQueryRangeAllRecords()
Run a query range test that includes all of the records that exist. |
void |
testQueryRangeOneLessThanTotal()
Run a query range test that includes one record less than the total number of records that exist. |
void |
testQueryRangeOneMoreThanTotal()
Run a query range test that includes one record more than the total number of records that exist. |
void |
testReportPathExpressionForExtents1()
Test pathExpression and Extents |
void |
testReportPathExpressionForExtents2()
Test pathExpression and Extents |
void |
testReportQuery()
Simple ReportQuery returning rows with 3 columns of Person |
void |
testReportQueryExtent()
Simple ReportQuery returning rows with 2 columns of Person |
void |
testReportQueryGroupBy()
ReportQuery returning rows with summed stock and price per article group |
void |
testReportQueryOrderBy()
ReportQuery returning rows with some "Liquor" data ordered by price |
void |
testReportQueryOrderByNonSelectColumn()
ReportQuery returning rows with some "Liquor" data ordered by productGroup.groupId |
void |
testReportQueryPathExpression()
ReportQuery with pathExpression in columns |
void |
testReportQueryWithJdbcTypes()
Simple ReportQuery returning rows with 3 columns of Person Type of column data defined by sqltypes |
void |
testSubQuery1()
test Subquery get all articles with price > avg(price) PROBLEM: avg(price) is NOT extent aware !! test may fail if db does not support sub queries |
void |
testSubQuery2()
test Subquery get all product groups without articles test may fail if db does not support sub queries |
void |
testSubQuery3()
test Subquery get all product groups with more than 10 articles, uses attribute as value ! see testSubQuery4 for a better way test may fail if db does not support sub queries |
void |
testSubQuery4()
test Subquery get all product groups with more than 10 articles test may fail if db does not support sub queries |
void |
tesXNestedJoins2()
Test nested joins using pathExpressions *** Fails under hsqldb because of join using multiple keys *** |
void |
tesXReportPathExpressionAbstractExtent()
test PathExpression pointing to abstract class (InterfaceArticle) |
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 |
Field Detail |
PersistenceBroker broker
Constructor Detail |
public QueryTest(java.lang.String name)
name
- java.lang.StringMethod Detail |
public static void main(java.lang.String[] args)
args
- java.lang.String[]public void setUp()
public void tearDown()
public void testCriteria()
public void testEqualCriteria()
public void testSubQuery2()
public void testSubQuery1()
public void testSubQuery3()
public void testSubQuery4()
public void testLikeCriteria()
public void testLikeEscapedCriteria1()
public void testLikeEscapedCriteria2()
public void testNullCriteria()
public void testBetweenCriteria()
public void testInCriteria()
public void testPathExpressions()
public void testPathExpressionsMtoNDecomposed()
public void testPathExpressionsMtoN()
public void testPathExpressionsMtoN2()
public void testDistinct()
public void testDistinctMultiPk()
public void testReportQuery()
public void testReportQueryWithJdbcTypes()
Types
public void _testReportQueryWithStartAndEnd()
public void testReportQueryExtent()
public void testReportQueryPathExpression()
public void testReportQueryOrderBy()
public void testReportQueryOrderByNonSelectColumn()
public void testReportQueryGroupBy()
public void testInversePathExpression()
public void testPrefetchedArraySingleKey()
public void testPrefetchedCollectionSingleKey()
public void testNestedJoins()
public void testMultipleJoins()
public void tesXNestedJoins2()
public void testPrefetchedReferencesSingleKey()
public void tesXReportPathExpressionAbstractExtent()
public void testQueryOrderByNonSelectColumn()
public void testPathExpressionForAbstractExtent()
public void testReportPathExpressionForExtents1()
public void testReportPathExpressionForExtents2()
public void testPathExpressionForExtents1()
public void testPathExpressionForExtents2()
public void testPathExpressionForExtents3()
public void testPathExpressionForExtents4()
public void testPathExpressionForExtentsAlias()
public void testQueryRangeOneLessThanTotal()
public void testQueryRangeAllRecords()
public void testQueryRangeOneMoreThanTotal()
public void testQueryMN_Alias1() throws java.lang.Exception
java.lang.Exception
public void testQueryMN_Alias2() throws java.lang.Exception
java.lang.Exception
public void testQueryMN() throws java.lang.Exception
java.lang.Exception
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |