SQLOrderByTest (Apache Jackrabbit 2.23.1-beta API)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - org.apache.jackrabbit.test.JUnitTest
    - - org.apache.jackrabbit.test.AbstractJCRTest
      - org.apache.jackrabbit.test.api.query.AbstractQueryTest
        
        org.apache.jackrabbit.test.api.query.SQLOrderByTest

All Implemented Interfaces:

junit.framework.Test
```
public class SQLOrderByTest
extends AbstractQueryTest
```
This test searches for all nodes of a specific node type and orders them by the property with name configured as AbstractJCRTest.propertyName1.
The default workspace must at least contain two nodes of type AbstractJCRTest.testNodeType with String properties named AbstractJCRTest.propertyName1 containing distinct values.

Field Summary
- Fields inherited from class org.apache.jackrabbit.test.api.query.AbstractQueryTest
  jcrContains, jcrDeref, jcrPath, jcrRoot, jcrScore, qf, qm, qsSQL, qsXPATH, vf, xpathRoot
- Fields inherited from class org.apache.jackrabbit.test.AbstractJCRTest
  isReadOnly, jcrBaseVersion, jcrCopiedFrom, jcrCreated, jcrFrozenNode, jcrFrozenUuid, jcrIsCheckedOut, jcrlockIsDeep, jcrLockOwner, jcrMergeFailed, jcrMixinTypes, jcrPredecessors, jcrPrimaryType, jcrRootVersion, jcrSuccessors, jcrSystem, jcrUUID, jcrVersionHistory, mixLockable, mixReferenceable, mixShareable, mixSimpleVersionable, mixTitle, mixVersionable, nodeName1, nodeName2, nodeName3, nodeName4, NS_JCR_URI, NS_MIX_URI, NS_NT_URI, NS_SV_URI, ntActivity, ntBase, ntFrozenNode, ntQuery, ntUnstructured, ntVersion, ntVersionHistory, ntVersionLabels, propertyName1, propertyName2, superuser, testNodeType, testNodeTypeNoChildren, testNodeTypeTestRoot, testPath, testRoot, testRootNode, workspaceName
- Fields inherited from class org.apache.jackrabbit.test.JUnitTest
  log, logger

Constructor Summary

Constructors
Constructor Description

SQLOrderByTest()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`protected void`	`setUp()`	Prepare a statement without the order by modifier to be used for the tests
`void`	`testOrderByAscending()`	Test if sort order ascending is respected.
`void`	`testOrderByDefault()`	Test if default sort order is respected and is ascending if the order by modifier is missing.
`void`	`testOrderByDescending()`	Test if sort order descending is respected.

Methods inherited from class org.apache.jackrabbit.test.api.query.AbstractQueryTest
checkResult, checkResult, checkResult, checkResult, createQuery, createQuery, createQuery, escapeIdentifierForSQL, evaluateResultOrder, execute, execute, executeSqlQuery, executeSqlQuery, executeXPathQuery, isSupportedLanguage, tearDown, toArray

Methods inherited from class org.apache.jackrabbit.test.AbstractJCRTest
checkSupportedOption, cleanUp, cleanUpTestRoot, createRandomString, ensureCanSetProperty, ensureCanSetProperty, ensureCanSetProperty, ensureKnowsNodeType, ensureLockingSupported, ensureMixinType, ensureMultipleWorkspacesSupported, getHelper, getJcrValue, getLocalName, getNonExistingWorkspaceName, getPrefix, getProperty, getProperty, getQualifiedName, getSize, isSupported, needsMixin, run

Methods inherited from class junit.framework.TestCase
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, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, runBare, runTest, setName, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - SQLOrderByTest
```
public SQLOrderByTest()
```
- Method Detail
  - setUp
```
protected void setUp()
              throws Exception
```
    Prepare a statement without the order by modifier to be used for the tests
    
    Overrides:
    
    setUp in class AbstractQueryTest
    
    Throws:
    
    Exception
  - testOrderByAscending
```
public void testOrderByAscending()
                          throws Exception
```
    Test if sort order ascending is respected.
    For configuration description see SQLOrderByTest.
    
    Throws:
    
    Exception
  - testOrderByDescending
```
public void testOrderByDescending()
                           throws Exception
```
    Test if sort order descending is respected.
    For configuration description see SQLOrderByTest.
    
    Throws:
    
    Exception
  - testOrderByDefault
```
public void testOrderByDefault()
                        throws Exception
```
    Test if default sort order is respected and is ascending if the order by modifier is missing.
    For configuration description see SQLOrderByTest.
    
    Throws:
    
    Exception