net.sf.farrago.test
Class FennelDmlTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.eigenbase.test.DiffTestCase
              net.sf.farrago.test.ResultSetTestCase
                  net.sf.farrago.test.FarragoTestCase
                      net.sf.farrago.test.FennelDmlTest

All Implemented Interfaces:

Test

public class FennelDmlTest
extends FarragoTestCase

FennelDmlTest tests execution of Farrago DML statements over data stored in Fennel (including both temporary and permanent tables).

Version:

$Id: //open/dev/farrago/src/net/sf/farrago/test/FennelDmlTest.java#16 $

Author:

John V. Sichi

Nested Class Summary

Nested classes/interfaces inherited from class net.sf.farrago.test.FarragoTestCase

FarragoTestCase.Cleanup, FarragoTestCase.CleanupFactory

Field Summary

Fields inherited from class net.sf.farrago.test.FarragoTestCase

allocOwner, connection, preparedStmt, repos, stmt, tracer

Fields inherited from class net.sf.farrago.test.ResultSetTestCase

resultSet

Fields inherited from class org.eigenbase.test.DiffTestCase

logFile, logOutputStream, refFile

Constructor Summary

FennelDmlTest(String testName)
Creates a new FennelDmlTest object.

Method Summary

protected void	setUp()
static Test	suite()
void	testCheckpoint() Tests explicit checkpoint (results are not verifiable so just test that the statement is accepted).
void	testDelete() Tests DELETE.
void	testDeleteNothing()
void	testDeleteWithFilter() Tests DELETE ...
void	testInsert() Tests INSERT ...
void	testInsertColumnList() Tests INSERT ...
void	testInsertImplicitDefault() Tests INSERT with an implied DEFAULT value.
void	testInsertMultiRow() Tests INSERT ...
void	testInsertPrepared() Tests INSERT ...
void	testInsertSingleRow() Tests INSERT ...
void	testInsertWithFilter() Tests INSERT ...
void	testPrimaryUpdate() Tests UPDATE which can be performed without updating any secondary indexes.
void	testSavepoints() Tests savepoint API.
void	testSecondaryUpdate() Tests UPDATE to a column covered by a secondary index.
void	testSelfInsert() Tests INSERT where source and target are the same table.

Methods inherited from class net.sf.farrago.test.FarragoTestCase

forceShutdown, getJdbcUri, getSession, getTestlogRoot, getTestlogRootStatic, newConnection, newJdbcEngineDriver, restoreParameters, restoreParameters, runCleanup, runSqlLineTest, runSqlLineTest, saveParameters, saveParameters, setRefFileDiffMasks, shouldDiff, staticSetUp, staticTearDown, tearDown, tearDownImpl, wrappedSuite, wrappedSuite

Methods inherited from class net.sf.farrago.test.ResultSetTestCase

compareResultList, compareResultLists, compareResultSet, compareResultSetWithDelta, compareResultSetWithPattern, getResultSetCount

Methods inherited from class org.eigenbase.test.DiffTestCase

addDiffMask, addIgnorePattern, diffFile, diffLines, diffTestLog, fileContents, openTestLog, openTestLogOutputStream, setGC, setVerbose

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, format

Methods inherited from class java.lang.Object

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

Constructor Detail

FennelDmlTest

public FennelDmlTest(String testName)
              throws Exception

Creates a new FennelDmlTest object.

Parameters:

testName - .

Throws:

Exception - .

Method Detail

suite

public static Test suite()

testInsert

public void testInsert()
                throws Exception

Tests INSERT ... SELECT

Throws:

Exception - .

testInsertSingleRow

public void testInsertSingleRow()
                         throws Exception

Tests INSERT ... VALUES ()

Throws:

Exception - .

testInsertColumnList

public void testInsertColumnList()
                          throws Exception

Tests INSERT ... (column-list) VALUES ()

Throws:

Exception - .

testInsertMultiRow

public void testInsertMultiRow()
                        throws Exception

Tests INSERT ... VALUES (), ()

Throws:

Exception - .

testInsertImplicitDefault

public void testInsertImplicitDefault()
                               throws Exception

Tests INSERT with an implied DEFAULT value.

Throws:

Exception - .

testInsertWithFilter

public void testInsertWithFilter()
                          throws Exception

Tests INSERT ... SELECT ... WHERE ...

Throws:

Exception - .

testSelfInsert

public void testSelfInsert()
                    throws Exception

Tests INSERT where source and target are the same table.

Throws:

Exception - .

testInsertPrepared

public void testInsertPrepared()
                        throws Exception

Tests INSERT ... VALUES (?,?,...)

Throws:

Exception - .

testDelete

public void testDelete()
                throws Exception

Tests DELETE.

Throws:

Exception - .

testDeleteNothing

public void testDeleteNothing()
                       throws Exception

Throws:

Exception

testDeleteWithFilter

public void testDeleteWithFilter()
                          throws Exception

Tests DELETE ... WHERE ...

Throws:

Exception - .

testPrimaryUpdate

public void testPrimaryUpdate()
                       throws Exception

Tests UPDATE which can be performed without updating any secondary indexes.

Throws:

Exception - .

testSecondaryUpdate

public void testSecondaryUpdate()
                         throws Exception

Tests UPDATE to a column covered by a secondary index.

Throws:

Exception - .

testCheckpoint

public void testCheckpoint()
                    throws Exception

Tests explicit checkpoint (results are not verifiable so just test that the statement is accepted).

Throws:

Exception - .

testSavepoints

public void testSavepoints()
                    throws Exception

Tests savepoint API.

Throws:

Exception - .

setUp

protected void setUp()
              throws Exception

Overrides:

setUp in class FarragoTestCase

Throws:

Exception