org.opensubsystems.core.persist.db.driver
Class QueryTest.QueryTestInternal

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.opensubsystems.core.persist.db.DatabaseTest
              org.opensubsystems.core.persist.db.driver.QueryTest.QueryTestInternal

All Implemented Interfaces:

junit.framework.Test

Enclosing class:

QueryTest

public static class QueryTest.QueryTestInternal
extends DatabaseTest

Internal class which can be included in other test suites directly without including the above suite. This allows us to group multiple tests together and the execute the DatabaseTestSetup only once

Field Summary

Fields inherited from class org.opensubsystems.core.persist.db.DatabaseTest

DEFAULT_DB_PASSWORD, DEFAULT_DB_USER, DEFAULT_PROPERTY_FILE, m_connection, m_iRequestedConnectionCount, m_transaction

Constructor Summary

QueryTest.QueryTestInternal(java.lang.String strTestName)
Create new test.

Method Summary

void	testExceptExcept() Test if select except except without parenthesis work
void	testExceptUnion() Test if select except union without parenthesis work
void	testExistsQuery() Test if the exists is working
void	testGroupQuery() Test if the group will be correct if no specified data in DB In that case there should be no row in result
void	testInsertSelectQuery() Test if the insert-select with parameter is working
void	testIntersectQuery() Test if the intersect is working
void	testJoinQuery() Test if the join with also other conditions in ON part will go through In case that no join data there also should be result row
void	testUnionQuery() Test if the union is working

Methods inherited from class org.opensubsystems.core.persist.db.DatabaseTest

addDataSource, addDataSource, getDataSourceName, setDataSourceName, setUp, tearDown

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, failNotEquals, failNotSame, failSame

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

QueryTest.QueryTestInternal

public QueryTest.QueryTestInternal(java.lang.String strTestName)

Create new test.

Parameters:

strTestName - - name of the test

Method Detail

testJoinQuery

public void testJoinQuery()
                   throws java.lang.Throwable

Test if the join with also other conditions in ON part will go through In case that no join data there also should be result row

Throws:

java.lang.Throwable - - an error has occured during test

testGroupQuery

public void testGroupQuery()
                    throws java.lang.Throwable

Test if the group will be correct if no specified data in DB In that case there should be no row in result

Throws:

java.lang.Throwable - - an error has occured during test

testUnionQuery

public void testUnionQuery()
                    throws java.lang.Throwable

Test if the union is working

Throws:

java.lang.Throwable - - an error has occured during test

testIntersectQuery

public void testIntersectQuery()
                        throws java.lang.Throwable

Test if the intersect is working

Throws:

java.lang.Throwable - - an error has occured during test

testInsertSelectQuery

public void testInsertSelectQuery()
                           throws java.lang.Throwable

Test if the insert-select with parameter is working

Throws:

java.lang.Throwable - - an error has occured during test

testExceptExcept

public void testExceptExcept()
                      throws java.lang.Throwable

Test if select except except without parenthesis work

Throws:

java.lang.Throwable - - an error has occured during test

testExceptUnion

public void testExceptUnion()
                     throws java.lang.Throwable

Test if select except union without parenthesis work

Throws:

java.lang.Throwable - - an error has occured during test

testExistsQuery

public void testExistsQuery()
                     throws java.lang.Throwable

Test if the exists is working

Throws:

java.lang.Throwable - - an error has occured during test