org.silverpeas.jdbc
Class JdbcSqlQueryTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.dbunit.DatabaseTestCase
              org.dbunit.DBTestCase
                  org.dbunit.JndiBasedDBTestCase
                      com.silverpeas.components.model.AbstractTestDao
                          org.silverpeas.jdbc.JdbcSqlQueryTest

All Implemented Interfaces:

junit.framework.Test

public class JdbcSqlQueryTest
extends AbstractTestDao

Field Summary

Fields inherited from class com.silverpeas.components.model.AbstractTestDao

datasource

Constructor Summary

JdbcSqlQueryTest()

Method Summary

protected String	getDatasetFileName()
protected String	getTableCreationFileName()
void	setUp()
void	tearDown()
void	testCreateRowUsingAppendSaveParameter()
void	testCreateTableB()
void	testDeleteRows()
void	testDropTableA()
void	testSelectAll()
void	testSelectAllButUsingUnique()
void	testSelectCountVerifications()
void	testSelectOneParameter()
void	testSelectUsingAppendListOfParameters()
void	testSelectUsingOneAppendParameter()
void	testSelectUsingTwoAppendParametersAndAppendListOfParameters()
void	testUpdateTwoRowsFromThreeUpdatesUsingAppendSaveParameter()

Methods inherited from class com.silverpeas.components.model.AbstractTestDao

cleanData, configureJNDIDatasource, getDataSet, getLookupName, getTableCreationScript, getTearDownOperation, prepareData, setUpClass, tearDownClass

Methods inherited from class org.dbunit.JndiBasedDBTestCase

getJNDIProperties, newDatabaseTester

Methods inherited from class org.dbunit.DBTestCase

getConnection

Methods inherited from class org.dbunit.DatabaseTestCase

closeConnection, getDatabaseTester, getOperationListener, getSetUpOperation, setUpDatabaseConfig

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, run, runBare, runTest, setName, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcSqlQueryTest

public JdbcSqlQueryTest()

Method Detail

setUp

public void setUp()
           throws Exception

Overrides:

setUp in class AbstractTestDao

Throws:

Exception

tearDown

public void tearDown()
              throws Exception

Overrides:

tearDown in class AbstractTestDao

Throws:

Exception

getDatasetFileName

protected String getDatasetFileName()

Specified by:

getDatasetFileName in class AbstractTestDao

getTableCreationFileName

protected String getTableCreationFileName()

Specified by:

getTableCreationFileName in class AbstractTestDao

testSelectCountVerifications

public void testSelectCountVerifications()
                                  throws SQLException

Throws:

SQLException

testSelectAll

public void testSelectAll()
                   throws SQLException

Throws:

SQLException

testSelectAllButUsingUnique

public void testSelectAllButUsingUnique()
                                 throws SQLException

Throws:

SQLException

testSelectOneParameter

public void testSelectOneParameter()
                            throws SQLException

Throws:

SQLException

testSelectUsingOneAppendParameter

public void testSelectUsingOneAppendParameter()
                                       throws SQLException

Throws:

SQLException

testSelectUsingTwoAppendParametersAndAppendListOfParameters

public void testSelectUsingTwoAppendParametersAndAppendListOfParameters()
                                                                 throws SQLException

Throws:

SQLException

testSelectUsingAppendListOfParameters

public void testSelectUsingAppendListOfParameters()
                                           throws SQLException

Throws:

SQLException

testCreateRowUsingAppendSaveParameter

public void testCreateRowUsingAppendSaveParameter()
                                           throws SQLException

Throws:

SQLException

testUpdateTwoRowsFromThreeUpdatesUsingAppendSaveParameter

public void testUpdateTwoRowsFromThreeUpdatesUsingAppendSaveParameter()
                                                               throws SQLException

Throws:

SQLException

testDeleteRows

public void testDeleteRows()
                    throws SQLException

Throws:

SQLException

testDropTableA

public void testDropTableA()
                    throws SQLException

Throws:

SQLException

testCreateTableB

public void testCreateTableB()
                      throws SQLException

Throws:

SQLException