de.hybris.platform.directpersistence.statement.sql

Class FluentSqlBuilderTest

java.lang.Object

de.hybris.platform.directpersistence.statement.sql.FluentSqlBuilderTest

public class FluentSqlBuilderTest
extends Object

Constructor Summary

Constructors

Constructor and Description
FluentSqlBuilderTest()

Method Summary

Modifier and Type	Method and Description
void	shouldCreateDeleteStatementForMoreThanOneColumn()
void	shouldCreateDeleteStatementForOneColumn()
void	shouldCreateDeleteStatementUsingWhereIN()
void	shouldCreateInsertStatementForThreeColumnsWithPlaceholders()
void	shouldCreateModifiedSelectStatementUsingINForOracleWhenINParamsAreGreaterThan1000()
void	shouldCreateSelectDistinctStatement()
void	shouldCreateSelectStatementForAllColumns()
void	shouldCreateSelectStatementForMoreThanOneColumn()
void	shouldCreateSelectStatementForMoreThanOneColumnUsingEqualAndNotEqualOperands()
void	shouldCreateSelectStatementForOneColumn()
void	shouldCreateSelectStatementUsingINForOracleInCombinedWhereClause()
void	shouldCreateSelectStatementUsingINForOracleWhenINParamsAreLessOrEqualThan1000()
void	shouldCreateSelectStatementUsingWhereIN()
void	shouldCreateSelectStatementWithIsNullWhereClause()
void	shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumns()
void	shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumnsUsinWhereIN()
void	shouldCreateStatementWithOrderBy()
void	shouldCreateStatementWithSubQuery()
void	shouldCreateUpdateStatement()
void	shouldUnionAllTwoBuildersWithStatements()
void	shouldUnionTwoBuildersWithStatements()

Methods inherited from class java.lang.Object

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

Constructor Detail

FluentSqlBuilderTest

public FluentSqlBuilderTest()

Method Detail

shouldCreateInsertStatementForThreeColumnsWithPlaceholders

public void shouldCreateInsertStatementForThreeColumnsWithPlaceholders()

shouldCreateDeleteStatementForOneColumn

public void shouldCreateDeleteStatementForOneColumn()

shouldCreateDeleteStatementUsingWhereIN

public void shouldCreateDeleteStatementUsingWhereIN()

shouldCreateDeleteStatementForMoreThanOneColumn

public void shouldCreateDeleteStatementForMoreThanOneColumn()

shouldCreateSelectStatementForAllColumns

public void shouldCreateSelectStatementForAllColumns()
                                              throws Exception

Throws:

Exception

shouldCreateSelectStatementForOneColumn

public void shouldCreateSelectStatementForOneColumn()

shouldCreateSelectStatementForMoreThanOneColumn

public void shouldCreateSelectStatementForMoreThanOneColumn()

shouldCreateSelectDistinctStatement

public void shouldCreateSelectDistinctStatement()

shouldCreateSelectStatementUsingWhereIN

public void shouldCreateSelectStatementUsingWhereIN()

shouldCreateSelectStatementForMoreThanOneColumnUsingEqualAndNotEqualOperands

public void shouldCreateSelectStatementForMoreThanOneColumnUsingEqualAndNotEqualOperands()

shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumns

public void shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumns()

shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumnsUsinWhereIN

public void shouldCreateSelectStatementWithMaxFunctionOnOneOfTheColumnsUsinWhereIN()

shouldCreateUpdateStatement

public void shouldCreateUpdateStatement()

shouldCreateSelectStatementWithIsNullWhereClause

public void shouldCreateSelectStatementWithIsNullWhereClause()
                                                      throws Exception

Throws:

Exception

shouldUnionTwoBuildersWithStatements

public void shouldUnionTwoBuildersWithStatements()

shouldUnionAllTwoBuildersWithStatements

public void shouldUnionAllTwoBuildersWithStatements()

shouldCreateModifiedSelectStatementUsingINForOracleWhenINParamsAreGreaterThan1000

public void shouldCreateModifiedSelectStatementUsingINForOracleWhenINParamsAreGreaterThan1000()
                                                                                       throws Exception

Throws:

Exception

shouldCreateSelectStatementUsingINForOracleWhenINParamsAreLessOrEqualThan1000

public void shouldCreateSelectStatementUsingINForOracleWhenINParamsAreLessOrEqualThan1000()
                                                                                   throws Exception

Throws:

Exception

shouldCreateSelectStatementUsingINForOracleInCombinedWhereClause

public void shouldCreateSelectStatementUsingINForOracleInCombinedWhereClause()
                                                                      throws Exception

Throws:

Exception

shouldCreateStatementWithOrderBy

public void shouldCreateStatementWithOrderBy()
                                      throws Exception

Throws:

Exception

shouldCreateStatementWithSubQuery

public void shouldCreateStatementWithSubQuery()
                                       throws Exception

Throws:

Exception