Package com.hades.builder.sqlCommand.clauseBuilder.filter

Interface SQLFilterClause<E extends EntityType>

All Known Implementing Classes:
FilterClause
public interface SQLFilterClause<E extends EntityType>

operation in where clause will be handled in this interface

Author:
alireza_bayat created on 10/27/21

  • Method Details

    • createInstance

      SQLFilterClause<E> createInstance(E e)

      create instance Class of given entity to be used in filter clauses

      probably not needed in second approach

      Parameters:
      e - passed entity object
      Returns:
      SQLFilterClause object

    • equal

      SQLFilterClause<E> equal(String field, Object filterPhrase)

      equal operand in standard query language main purpose is to set equality operand between given field and filterPhrase

      Parameters:
      field - field name which must be present as Column.name() in entity class
      filterPhrase - filtered value in field
      Returns:
      SQLFilterClause object

    • equal

      SQLFilterClause<E> equal(Selection selection, Object filterPhrase)

      equal operand in standard query language main purpose is to set equality operand between given field and filterPhrase

      Parameters:
      selection - field name which must be present as Column.name() in entity class stored in Selection.fieldName
      filterPhrase - filtered value in field
      Returns:
      SQLFilterClause object

    • notEqual

      SQLFilterClause<E> notEqual(String field, Object filterPhrase)

      not equal operand in standard query language main purpose is to set not equality operand between given field and filterPhrase

      Parameters:
      field - field name which must be present as Column.name() in entity class
      filterPhrase - filtered value in field
      Returns:
      SQLFilterClause object

    • notEqual

      SQLFilterClause<E> notEqual(Selection selection, Object filterPhrase)

      equal operand in standard query language main purpose is to set equality operand between given field and filterPhrase

      Parameters:
      selection - field name which must be present as Column.name() in entity class stored in Selection.fieldName
      filterPhrase - filtered value in field
      Returns:
      SQLFilterClause object

    • and

      SQLFilterClause<E> and()
      to append `and` key word in where clause

    • and

      SQLFilterClause<E> and(String customQuery)
      to append `and` key word and let some filter to be run in parentheses

    • or

      SQLFilterClause<E> or()
      to append `or` key word in where clause

    • or

      SQLFilterClause<E> or(String customQuery)
      to append `or` key word and let some filter to be run in parentheses

    • not

      SQLFilterClause<E> not()
      to append `not` key word in where clause

    • not

      SQLFilterClause<E> not(String customQuery)
      to append `not` key word and let some filter to be run in parentheses

    • like

      SQLFilterClause<E> like(String field, String matchString)

      like operand in standard query language to generate like phrase in between given fields

      Parameters:
      field - field name which must be present as Column.name()
      matchString - filtered value in field
      Returns:
      SQLFilterClause object

    • between

      SQLFilterClause<E> between(String field, Object firstValue, Object secondValue)

    • in

      SQLFilterClause<E> in(String field, Object... items)

      In operand in standard language

      Parameters:
      field - field name which must be present as Column.name() in entity class
      items - varargs of all the objects that will appear in final clause
      Returns:
      SQLFilterClause object

    • in

      SQLFilterClause<E> in(String field, String customQuery)

      In operand in standard language

      Parameters:
      field - field name which must be present as Column.name() in entity class
      customQuery - custom objects that will appear in final clause
      Returns:
      SQLFilterClause object

    • notIn

      SQLFilterClause<E> notIn(String field, Object... items)

      notIn operand in standard language

      Parameters:
      field - field name which must be present as Column.name() in entity class
      items - varargs of all the objects that will appear in final clause
      Returns:
      SQLFilterClause object

    • notIn

      SQLFilterClause<E> notIn(String field, String customQuery)

      notIn operand in standard language

      Parameters:
      field - field name which must be present as Column.name() in entity class
      customQuery - custom objects that will appear in final clause
      Returns:
      SQLFilterClause object

    • exists

      SQLFilterClause<E> exists(String customQuery)

      exists operand in standard language

      Parameters:
      customQuery - exact query will appear in final query
      Returns:
      SQLFilterClause object

    • notExists

      SQLFilterClause<E> notExists(String customQuery)

      not exists operand in standard language

      Parameters:
      customQuery - exact query will be appeared in final query
      Returns:
      SQLFilterClause object

    • innerSelect

      SQLFilterClause<E> innerSelect()

    • customClause

      SQLFilterClause<E> customClause(String customClause)

      any customized filter that is not supported by main SQLFilterClause can be specifies by this function

      Parameters:
      customClause - any customized filter clause
      Returns:
      SQLFilterClause object