org.melati.poem.dbms.test
Class DbmsSpec

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.melati.poem.test.PoemTestCase
              org.melati.poem.dbms.test.DbmsSpec

All Implemented Interfaces:

junit.framework.Test

Direct Known Subclasses:

AnsiStandardTest, FirstSQLTest, HsqldbTest, InterbaseTest, MckoiTest, MimerTest, MSAccessTest, MySQLTest, OracleTest, PostgresqlTest, SQLServerTest

public abstract class DbmsSpec
extends PoemTestCase

Abstract test for a class implementing the Dbms interface.

Since:

23 Jan 2007

Author:

timp

Field Summary

protected org.melati.poem.dbms.Dbms

it

Fields inherited from class org.melati.poem.test.PoemTestCase

maxTrans, result

Constructor Summary

DbmsSpec(String name)
Constructor.

Method Summary

protected abstract void	setObjectUnderTest()
protected void	setUp()
protected void	tearDown()
void	testAlterColumnNotNullableSQL() Test method for alterColumnNotNullableSQL(java.lang.String, org.melati.poem.Column).
void	testBooleanTrueExtression() Test method for booleanTrueExpression(org.melati.poem.Column).
void	testCanBeIndexed() Test method for canBeIndexed(org.melati.poem.Column).
void	testCanDropColumns() Test method for canDropColumns(java.sql.Connection).
void	testCanRepresent() Test method for canRepresent(org.melati.poem.PoemType, org.melati.poem.PoemType).
void	testCaseInsensitiveRegExpSQL() Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).
void	testCaseInsensitiveRegExpSQLBlank() Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).
void	testCaseInsensitiveRegExpSQLQuoted() Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).
void	testCreateTableOptionsSql() Test method for Dbms.createTableOptionsSql().
void	testCreateTableSql() Test method for org.melati.poem.dbms.Dbms#createTableSql().
void	testDefaultPoemTypeOfColumnMetaData() Test method for defaultPoemTypeOfColumnMetaData(java.sql.ResultSet).
void	testExceptionForUpdateTablePreparedStatementBooleanSQLException() Test method for exceptionForUpdate(org.melati.poem.Table, java.sql.PreparedStatement, boolean, java.sql.SQLException).
void	testExceptionForUpdateTableStringBooleanSQLException() Test method for exceptionForUpdate(org.melati.poem.Table, java.lang.String, boolean, java.sql.SQLException).
void	testGetBinarySqlDefinition() Test method for getBinarySqlDefinition(int).
void	testGetConnection() FIXME Skipped for Postgres Test method for getConnection(java.lang.String, java.lang.String, java.lang.String).
void	testGetFixedPtSqlDefinition() Test method for getFixedPtSqlDefinition(int, int).
void	testGetForeignKeyDefinition() Test method for getForeignKeyDefinition(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String).
void	testGetIndexLength() Test method for getIndexLength(org.melati.poem.Column).
void	testGetJdbcMetadataName() Test method for getJdbcMetadataName(java.lang.String).
void	testGetLongSqlDefinition() Test method for getLongSqlDefinition().
void	testGetPrimaryKeyDefinition() Test method for getPrimaryKeyDefinition(java.lang.String).
void	testGetQuotedName() Test method for getQuotedName(java.lang.String).
void	testGetQuotedValue() Test method for getQuotedValue(org.melati.poem.SQLType, String) .
void	testGetSchema() Test method for Dbms.getSchema().
void	testGetSqlDefinition() Test method for getSqlDefinition(java.lang.String).
void	testGetStringSqlDefinition() Test method for Dbms.getStringSqlDefinition(int).
void	testGivesCapabilitySQL() Test method for givesCapabilitySQL(java.lang.Integer, java.lang.String).
void	testMelatiName() Test method for Dbms.melatiName(java.lang.String).
void	testPreparedStatementPlaceholder() Test method for preparedStatementPlaceholder(org.melati.poem.PoemType).
void	testSelectLimit() Test method for selectLimit(java.lang.String, int).
void	testShutdown() Test method for shutdown(java.sql.Connection).
void	testSqlBooleanValueOfRaw() Test method for sqlBooleanValueOfRaw(java.lang.Object).
void	testToString() Test method for Dbms.toString().
void	testUnreservedName() Test method for unreservedName(java.lang.String).

Methods inherited from class org.melati.poem.test.PoemTestCase

assertEquals, assertEquals, assertEquals, checkColumns, checkDbUnchanged, checkTables, checkTablesAndColumns, databaseUnchanged, dropTable, dumpTable, getDatabase, getDatabaseName, getDb, getDb, getName, getOrDie, getProperties, getPropertiesFileName, getUserToRunAs, run, runTest, setDatabaseName, setName, setPropertiesFileName, setUserToRunAs, testNothing

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, run, runBare, 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, 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

Field Detail

it

protected org.melati.poem.dbms.Dbms it

Constructor Detail

DbmsSpec

public DbmsSpec(String name)

Constructor.

Parameters:

name -

Method Detail

setUp

protected void setUp()
              throws Exception

Overrides:

setUp in class PoemTestCase

Throws:

Exception

See Also:

TestCase.setUp()

tearDown

protected void tearDown()
                 throws Exception

Overrides:

tearDown in class PoemTestCase

Throws:

Exception

See Also:

TestCase.tearDown()

setObjectUnderTest

protected abstract void setObjectUnderTest()

testGetConnection

public void testGetConnection()
                       throws Exception

FIXME Skipped for Postgres Test method for getConnection(java.lang.String, java.lang.String, java.lang.String).

Throws:

Exception

testGetSchema

public void testGetSchema()

Test method for Dbms.getSchema().

testShutdown

public void testShutdown()

Test method for shutdown(java.sql.Connection).

testGetQuotedName

public void testGetQuotedName()

Test method for getQuotedName(java.lang.String).

testGetQuotedValue

public void testGetQuotedValue()

Test method for getQuotedValue(org.melati.poem.SQLType, String) .

testGetJdbcMetadataName

public void testGetJdbcMetadataName()

Test method for getJdbcMetadataName(java.lang.String).

testPreparedStatementPlaceholder

public void testPreparedStatementPlaceholder()

Test method for preparedStatementPlaceholder(org.melati.poem.PoemType).

testCreateTableSql

public void testCreateTableSql()

Test method for org.melati.poem.dbms.Dbms#createTableSql().

testCreateTableOptionsSql

public void testCreateTableOptionsSql()

Test method for Dbms.createTableOptionsSql().

testGetSqlDefinition

public void testGetSqlDefinition()
                          throws Exception

Test method for getSqlDefinition(java.lang.String).

Throws:

Exception

testGetStringSqlDefinition

public void testGetStringSqlDefinition()
                                throws Exception

Test method for Dbms.getStringSqlDefinition(int).

Throws:

Exception

testGetLongSqlDefinition

public void testGetLongSqlDefinition()

Test method for getLongSqlDefinition().

testSqlBooleanValueOfRaw

public void testSqlBooleanValueOfRaw()

Test method for sqlBooleanValueOfRaw(java.lang.Object).

testGetBinarySqlDefinition

public void testGetBinarySqlDefinition()
                                throws Exception

Test method for getBinarySqlDefinition(int).

Throws:

Exception

testGetFixedPtSqlDefinition

public void testGetFixedPtSqlDefinition()
                                 throws Exception

Test method for getFixedPtSqlDefinition(int, int).

Throws:

Exception

testCanRepresent

public void testCanRepresent()

Test method for canRepresent(org.melati.poem.PoemType, org.melati.poem.PoemType).

testDefaultPoemTypeOfColumnMetaData

public void testDefaultPoemTypeOfColumnMetaData()

Test method for defaultPoemTypeOfColumnMetaData(java.sql.ResultSet).

testCanDropColumns

public void testCanDropColumns()
                        throws Exception

Test method for canDropColumns(java.sql.Connection).

Throws:

Exception

testExceptionForUpdateTableStringBooleanSQLException

public void testExceptionForUpdateTableStringBooleanSQLException()

Test method for exceptionForUpdate(org.melati.poem.Table, java.lang.String, boolean, java.sql.SQLException).

testExceptionForUpdateTablePreparedStatementBooleanSQLException

public void testExceptionForUpdateTablePreparedStatementBooleanSQLException()

Test method for exceptionForUpdate(org.melati.poem.Table, java.sql.PreparedStatement, boolean, java.sql.SQLException).

testUnreservedName

public void testUnreservedName()

Test method for unreservedName(java.lang.String).

testMelatiName

public void testMelatiName()

Test method for Dbms.melatiName(java.lang.String).

testGetIndexLength

public void testGetIndexLength()
                        throws Exception

Test method for getIndexLength(org.melati.poem.Column).

Throws:

Exception

testCanBeIndexed

public void testCanBeIndexed()
                      throws Exception

Test method for canBeIndexed(org.melati.poem.Column).

Throws:

Exception

testGivesCapabilitySQL

public void testGivesCapabilitySQL()

Test method for givesCapabilitySQL(java.lang.Integer, java.lang.String).

testCaseInsensitiveRegExpSQL

public void testCaseInsensitiveRegExpSQL()

Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).

testCaseInsensitiveRegExpSQLQuoted

public void testCaseInsensitiveRegExpSQLQuoted()

Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).

testCaseInsensitiveRegExpSQLBlank

public void testCaseInsensitiveRegExpSQLBlank()

Test method for caseInsensitiveRegExpSQL(java.lang.String, java.lang.String).

testToString

public void testToString()

Test method for Dbms.toString().

testGetForeignKeyDefinition

public void testGetForeignKeyDefinition()

Test method for getForeignKeyDefinition(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String).

testGetPrimaryKeyDefinition

public void testGetPrimaryKeyDefinition()

Test method for getPrimaryKeyDefinition(java.lang.String).

testAlterColumnNotNullableSQL

public void testAlterColumnNotNullableSQL()

Test method for alterColumnNotNullableSQL(java.lang.String, org.melati.poem.Column).

testSelectLimit

public void testSelectLimit()

Test method for selectLimit(java.lang.String, int).

testBooleanTrueExtression

public void testBooleanTrueExtression()

Test method for booleanTrueExpression(org.melati.poem.Column).