Package org.apache.torque.sql
Klasse SqlBuilderTest
java.lang.Object
org.apache.torque.BaseTestCase
org.apache.torque.sql.SqlBuilderTest
Tests for SqlExpression
- Version:
- $Id: SqlBuilderTest.java 1917245 2024-04-21 14:06:23Z tv $
- Autor:
- Martin Poeschl, Scott Eade
-
Verschachtelte Klassen - Übersicht
Verschachtelte KlassenModifizierer und TypKlasseBeschreibungstatic enumstatic enum -
Feldübersicht
Von Klasse geerbte Felder org.apache.torque.BaseTestCase
CONFIG_FILE, database, databaseMap, databaseMysql, databaseOracle, databasePostgresql, integerColumnMap, stringColumnMap, stringColumnMap2, stringColumnMap3, tableMap -
Konstruktorübersicht
Konstruktoren -
Methodenübersicht
Modifizierer und TypMethodeBeschreibungvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTest where condition with several ANDs compairing against Strings.voidTest where condition with several ANDs compairing against Strings.voidTest the andVerbatimSql method with null replacements.voidTest the andVerbatimSql method with from Columns.voidTest the andVerbatimSql method with replacements.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTests that an enum which does not have a getValue() method cannot be added as select value.voidvoidvoidvoidvoidvoidvoidvoidvoidTest that unknown columns are treated case-insensitive if ignoreCase is set.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTests that a subselect can be added to the from clause.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidtestLike()voidvoidvoidvoidTest whether LIKE clauses with Escapes are built correctly.voidTest whether LIKE clauses with Escapes are built correctly in Oracle.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTest where condition with several ORs compairing against Strings.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTest where condition with several ORs compairing against Strings.voidTest the orVerbatimSql method with null replacements.voidTest the orVerbatimSql method with from Columns.voidTest the orVerbatimSql method with replacements.voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidTest the whereVerbatimSql method with null replacements.voidTest the whereVerbatimSql method with from Columns.voidTest the whereVerbatimSql method with replacements.Von Klasse geerbte Methoden org.apache.torque.BaseTestCase
setUp
-
Konstruktordetails
-
SqlBuilderTest
public SqlBuilderTest()
-
-
Methodendetails
-
testAndString
Test where condition with several ANDs compairing against Strings.- Löst aus:
Exception
-
testOrString
Test where condition with several ORs compairing against Strings.- Löst aus:
Exception
-
testAndCriterions
Test where condition with several ANDs compairing against Strings.- Löst aus:
Exception
-
testOrCriterions
Test where condition with several ORs compairing against Strings.- Löst aus:
Exception
-
testAndVerbatimSqlReplacementNull
Test the andVerbatimSql method with null replacements.- Löst aus:
Exception
-
testAndVerbatimSqlWithReplacements
Test the andVerbatimSql method with replacements.- Löst aus:
Exception
-
testAndVerbatimSqlWithFromColumns
Test the andVerbatimSql method with from Columns.- Löst aus:
Exception
-
testOrVerbatimSqlReplacementNull
Test the orVerbatimSql method with null replacements.- Löst aus:
Exception
-
testOrVerbatimSqlWithReplacements
Test the orVerbatimSql method with replacements.- Löst aus:
Exception
-
testOrVerbatimSqlWithFromColumns
Test the orVerbatimSql method with from Columns.- Löst aus:
Exception
-
testWhereVerbatimSqlReplacementNull
Test the whereVerbatimSql method with null replacements.- Löst aus:
Exception
-
testWhereVerbatimSqlWithReplacements
Test the whereVerbatimSql method with replacements.- Löst aus:
Exception
-
testWhereVerbatimSqlWithFromColumns
Test the whereVerbatimSql method with from Columns.- Löst aus:
Exception
-
testignoreCaseUnknownColumnType
Test that unknown columns are treated case-insensitive if ignoreCase is set.- Löst aus:
Exception
-
testIgnoreCaseStringColumnType
- Löst aus:
Exception
-
testIgnoreCaseIntegerColumnType
- Löst aus:
Exception
-
testOrderByDesc
public void testOrderByDesc() throws org.apache.torque.TorqueException- Löst aus:
org.apache.torque.TorqueException
-
testOrderByAsc
- Löst aus:
Exception
-
testOrderByNullColumn
- Löst aus:
Exception
-
testOrderByMultiple
- Löst aus:
Exception
-
testOrderByWithDefaultSchema
- Löst aus:
Exception
-
testOrderByWithFunction
- Löst aus:
Exception
-
testOrderByWithAsColumn
- Löst aus:
Exception
-
testOrderByWithAsColumnIgnoreCase
- Löst aus:
Exception
-
testOrderByWithAsColumnAndAliasIgnoreCase
- Löst aus:
Exception
-
testOrderByAscendingIgnoreCaseString
- Löst aus:
Exception
-
testOrderByAscendingIgnoreCaseInteger
- Löst aus:
Exception
-
testOrderByAscendingIgnoreCaseStringInCriteria
- Löst aus:
Exception
-
testOrderByAscendingIgnoreCaseIntegerInCriteria
- Löst aus:
Exception
-
testOrderByDescendingIgnoreCaseString
- Löst aus:
Exception
-
testOrderByDescendingIgnoreCaseInteger
- Löst aus:
Exception
-
testOrderByDescendingIgnoreCaseStringInCriteria
- Löst aus:
Exception
-
testOrderByDescendingIgnoreCaseIntegerInCriteria
- Löst aus:
Exception
-
testAlias
- Löst aus:
Exception
-
testAliasWithDefaultSchema
- Löst aus:
Exception
-
testAliasWithIgnoreCaseUnknownColumnType
- Löst aus:
Exception
-
testAliasWithSubquery
- Löst aus:
Exception
-
testAliasWithSubqueryAndReplacements
- Löst aus:
Exception
-
testAliasWithIgnoreCaseStringColumnType
- Löst aus:
Exception
-
testAliasWithIgnoreCaseIntegerColumnType
- Löst aus:
Exception
-
testAliasWithIgnoreCaseStringColumnTypeAndDefaultSchema
- Löst aus:
Exception
-
testAliasWithIgnoreCaseIntegerColumnTypeAndDefaultSchema
- Löst aus:
Exception
-
testAsColumn
- Löst aus:
Exception
-
testAsColumnWithIgnoreCaseUnknownColumn
- Löst aus:
Exception
-
testAsColumnWithIgnoreCaseStringColumn
- Löst aus:
Exception
-
testAsColumnWithIgnoreCaseIntegerColumn
- Löst aus:
Exception
-
testAsColumnWithIgnoreCaseStringColumnAndDefaultSchema
- Löst aus:
Exception
-
testAsColumnWithIgnoreCaseIntegerColumnAndDefaultSchema
- Löst aus:
Exception
-
testInnerJoinImplicit
- Löst aus:
Exception
-
testInnerJoinImplicitWithComparison
- Löst aus:
Exception
-
testInnerJoinExplicit
- Löst aus:
Exception
-
testInnerJoinWithExcplicitExistingRightTable
- Löst aus:
Exception
-
testInnerJoinWithExcplicitExistingRightTableAndOperator
- Löst aus:
Exception
-
testInnerJoinExcplicitWithExistingRightAndLeftTable
- Löst aus:
Exception
-
testInnerJoinExplicitWithComplicatedCondition
- Löst aus:
Exception
-
testInnerJoinExplicitWithSubselect
Tests that a subselect can be added to the from clause.- Löst aus:
Exception- if an error occurs
-
testInnerJoinWithJoinCriteriaAndDefaultSchema
- Löst aus:
Exception
-
testLeftJoin
- Löst aus:
Exception
-
testLeftJoinWithExistingRightTable
- Löst aus:
Exception
-
testRightJoin
- Löst aus:
Exception
-
testRightJoinWithExistingRightTable
- Löst aus:
Exception
-
testInnerJoinImplicitWithAlias
- Löst aus:
Exception
-
testInnerJoinImplicitWithAliasAndAsColumn
- Löst aus:
Exception
-
testInnerJoinImplicitWithDefaultSchema
- Löst aus:
Exception
-
testInnerJoinImplicitWithAliasAndDefaultSchema
- Löst aus:
Exception
-
testInnerJoinImplicitWithAliasAndSchema
- Löst aus:
Exception
-
testInnerJoinImplicitWithSubqueryAndReplacements
- Löst aus:
Exception
-
testInnerJoinImplicitWithComplicatedCondition
- Löst aus:
Exception
-
testDistinct
- Löst aus:
Exception
-
testGroupBy
- Löst aus:
Exception
-
testLimitPostgresql
- Löst aus:
Exception
-
testOffsetPostgresql
- Löst aus:
Exception
-
testLimitOffsetPostgresql
- Löst aus:
Exception
-
testLimitMysql
- Löst aus:
Exception
-
testOffsetMysql
- Löst aus:
Exception
-
testLimitOffsetMysql
- Löst aus:
Exception
-
testLimitOracle
- Löst aus:
Exception
-
testOffsetOracle
- Löst aus:
Exception
-
testLimitOffsetOracle
- Löst aus:
Exception
-
testSelectForUpdate
- Löst aus:
Exception
-
testHaving
- Löst aus:
Exception
-
testSelectColumnWithoutTable
- Löst aus:
Exception
-
testCriterionCustomSql
- Löst aus:
Exception
-
testLvalueIsObject
- Löst aus:
Exception
-
testCurrentDate
- Löst aus:
Exception
-
testCurrentTime
- Löst aus:
Exception
-
testCurrentTimestamp
- Löst aus:
Exception
-
testObjectKey
- Löst aus:
Exception
-
testNullValue
- Löst aus:
Exception
-
testNullValueNotEqual
- Löst aus:
Exception
-
testNullValueAltNotEqual
- Löst aus:
Exception
-
testIsNull
- Löst aus:
Exception
-
testIsNotNull
- Löst aus:
Exception
-
testSubselect
- Löst aus:
Exception
-
testSubselectReferenceOuterTable
- Löst aus:
Exception
-
testLike
- Löst aus:
Exception
-
testLikeWithEscape
public void testLikeWithEscape() throws org.apache.torque.TorqueExceptionTest whether LIKE clauses with Escapes are built correctly.- Löst aus:
org.apache.torque.TorqueException
-
testLikeWithEscapeOracle
public void testLikeWithEscapeOracle() throws org.apache.torque.TorqueExceptionTest whether LIKE clauses with Escapes are built correctly in Oracle. Oracle needs to have an ESCAPE clause- Löst aus:
org.apache.torque.TorqueException
-
testLikeIgnoreCase
- Löst aus:
Exception
-
testLikeIgnoreCaseNoWildcard
- Löst aus:
Exception
-
testLikeInteger
public void testLikeInteger() throws org.apache.torque.TorqueException- Löst aus:
org.apache.torque.TorqueException
-
testNotLike
- Löst aus:
Exception
-
testNotLikeIgnoreCase
- Löst aus:
Exception
-
testNotLikeIgnoreCaseNoWildcard
- Löst aus:
Exception
-
testIlike
- Löst aus:
Exception
-
testIlikeNoWildcard
- Löst aus:
Exception
-
testNotIlike
- Löst aus:
Exception
-
testNotIlikeNoWildcard
- Löst aus:
Exception
-
testLvalueString
- Löst aus:
Exception
-
testLvalueNull
- Löst aus:
Exception
-
testLvalueCriteria
- Löst aus:
Exception
-
testInArray
- Löst aus:
Exception
-
testInArrayIgnoreCase
- Löst aus:
Exception
-
testInList
- Löst aus:
Exception
-
testInListIgnoreCase
- Löst aus:
Exception
-
testNotInList
- Löst aus:
Exception
-
testInLargeArray
public void testInLargeArray() throws org.apache.torque.TorqueException- Löst aus:
org.apache.torque.TorqueException
-
testInString
- Löst aus:
Exception
-
testFromElementsSetExplicitly
- Löst aus:
Exception
-
testFromElementsSetExplicitlyAsString
- Löst aus:
Exception
-
testUnion
- Löst aus:
Exception
-
testUnionAll
- Löst aus:
Exception
-
testExcept
- Löst aus:
Exception
-
testExceptAll
- Löst aus:
Exception
-
testIntersect
- Löst aus:
Exception
-
testIntersectAll
- Löst aus:
Exception
-
testUnionOrderByLimitOffset
- Löst aus:
Exception
-
testSetOperationBraces
- Löst aus:
Exception
-
testEnumValues
- Löst aus:
Exception
-
testEnumValuesNoGetValueMethod
Tests that an enum which does not have a getValue() method cannot be added as select value.- Löst aus:
Exception
-