Class FluentSqlBuilderTest


  • public class FluentSqlBuilderTest
    extends java.lang.Object
    • 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 java.lang.Exception
        Throws:
        java.lang.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 java.lang.Exception
        Throws:
        java.lang.Exception
      • shouldUnionTwoBuildersWithStatements

        public void shouldUnionTwoBuildersWithStatements()
      • shouldUnionAllTwoBuildersWithStatements

        public void shouldUnionAllTwoBuildersWithStatements()
      • shouldCreateModifiedSelectStatementUsingINForOracleWhenINParamsAreGreaterThan1000

        public void shouldCreateModifiedSelectStatementUsingINForOracleWhenINParamsAreGreaterThan1000()
                                                                                               throws java.lang.Exception
        Throws:
        java.lang.Exception
      • shouldCreateSelectStatementUsingINForOracleWhenINParamsAreLessOrEqualThan1000

        public void shouldCreateSelectStatementUsingINForOracleWhenINParamsAreLessOrEqualThan1000()
                                                                                           throws java.lang.Exception
        Throws:
        java.lang.Exception
      • shouldCreateSelectStatementUsingINForOracleInCombinedWhereClause

        public void shouldCreateSelectStatementUsingINForOracleInCombinedWhereClause()
                                                                              throws java.lang.Exception
        Throws:
        java.lang.Exception
      • shouldCreateStatementWithOrderBy

        public void shouldCreateStatementWithOrderBy()
                                              throws java.lang.Exception
        Throws:
        java.lang.Exception
      • shouldCreateStatementWithSubQuery

        public void shouldCreateStatementWithSubQuery()
                                               throws java.lang.Exception
        Throws:
        java.lang.Exception