org.backsource.alert.agent
Class SQLTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.backsource.alert.agent.BaseCase
              org.backsource.alert.agent.SQLTest

All Implemented Interfaces:

Agent, junit.framework.Test

public class SQLTest

extends BaseCase

Execute a SQL query test. The test will succed if all the following conditions are true:

• The database driver can be loaded
• A connection can be established
• The query executes without an error
• Atleast one row is returned
• The first column of the first row can be interpreted as boolean TRUE

Version:

$Id: SQLTest.java,v 1.1.1.1 2004/05/19 12:33:41 pra Exp $

Author:

Jens Askengren

Field Summary

Fields inherited from class org.backsource.alert.agent.BaseCase

agentName, prop

Constructor Summary

SQLTest(java.lang.String name)

Method Summary

protected void	executeSQL(java.sql.Connection con)
protected void	setUp()
void	testQuery()

Methods inherited from class org.backsource.alert.agent.BaseCase

getAgentName, getProperties, initialize, toString

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, tearDown

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

Methods inherited from interface junit.framework.Test

countTestCases, run

Constructor Detail

SQLTest

public SQLTest(java.lang.String name)

Method Detail

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class BaseCase

Throws:

java.lang.Exception

testQuery

public void testQuery()

executeSQL

protected void executeSQL(java.sql.Connection con)
                   throws AlertError

Throws:

AlertError