java.lang.Object
- com.feedzai.commons.sql.abstraction.dml.Expression

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

AlterColumn, Between, Case, Cast, Coalesce, Concat, Delete, DropPrimaryKey, Function, Join, K, Literal, Modulo, Name, Query, Rename, RepeatDelimiter, StringAgg, Truncate, Union, Update, Values, Values.Row, View, When, With
```
public abstract class Expression
extends Object
implements Serializable
```
A generic SQL Expression capable of being translated.

Since:

2.0.0

Author:

Rui Vilao (rui.vilao@feedzai.com)

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type	Field	Description
`protected String`	`alias`	The expression alias if applicable.
`protected boolean`	`enclosed`	True if the expression is to be enclosed in parenthesis.
`protected List<Join>`	`joins`	The list of joins, if applicable.
`protected String`	`ordering`	The string that specified the ordering if applicable.
`protected PdbProperties`	`properties`	The PDB properties.
`protected boolean`	`quotes`	True if the expression is to be put around quotes.
`protected AbstractTranslator`	`translator`	The abstract translator.
`protected boolean`	`withNoLock`	The SQL Server's no lock keyword.

Constructor Summary

Constructors
Constructor Description

Expression()

Method Summary

All Methods Instance Methods Abstract Methods Concrete Methods
Modifier and Type	Method	Description
`Expression`	`alias(String alias)`	Aliases this expression.
`Expression`	`asc()`	Sets ordering to ascendant.
`Expression`	`desc()`	Sets ordering to descendant.
`Expression`	`enclose()`	Encloses this expression with parenthesis.
`Expression`	`fullOuterJoin(Expression table, Expression expr)`	Sets a full outer join with the current table.
`String`	`getAlias()`	Gets the alias.
`List<Join>`	`getJoins()`	Gets the join list.
`String`	`getOrdering()`	Gets the ordering.
`Expression`	`innerJoin(Expression table, Expression expr)`	Sets an inner join with the current table.
`boolean`	`isAliased()`	Checks if this expression is to be aliased.
`boolean`	`isEnclosed()`	Checks if this expression is to be enclosed in parenthesis.
`boolean`	`isQuote()`	Checks if this expression is to be quoted.
`boolean`	`isQuotes()`	Checks if this expression is to be translated with quotes.
`boolean`	`isWithNoLock()`	Checks if this expression (TABLES) is with no lock.
`Expression`	`leftOuterJoin(Expression table, Expression expr)`	Sets a left outer join with the current table.
`Expression`	`rightOuterJoin(Expression table, Expression expr)`	Sets a right outer join with the current table.
`abstract String`	`translate()`	Translates the expression.
`Expression`	`unquote()`	Removes the quotes for this expression.
`Expression`	`withNoLock()`	Sets no lock keyword on SQL Server tables.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - translator
```
@Inject
protected AbstractTranslator translator
```
    The abstract translator.
  - properties
```
@Inject
protected PdbProperties properties
```
    The PDB properties.
  - alias
```
protected String alias
```
    The expression alias if applicable.
  - enclosed
```
protected boolean enclosed
```
    True if the expression is to be enclosed in parenthesis.
  - quotes
```
protected boolean quotes
```
    True if the expression is to be put around quotes.
  - ordering
```
protected String ordering
```
    The string that specified the ordering if applicable.
  - joins
```
protected final List<Join> joins
```
    The list of joins, if applicable.
  - withNoLock
```
protected boolean withNoLock
```
    The SQL Server's no lock keyword.
- Constructor Detail
  - Expression
```
public Expression()
```
- Method Detail
  - translate
```
public abstract String translate()
```
    Translates the expression.
    
    Returns:
    
    A translation of the implementing expression.
  - alias
```
public Expression alias(String alias)
```
    Aliases this expression.
    
    Parameters:
    
    alias - The alias.
    
    Returns:
    
    This expression.
  - unquote
```
public Expression unquote()
```
    Removes the quotes for this expression.
    
    Returns:
    
    This expression.
  - enclose
```
public Expression enclose()
```
    Encloses this expression with parenthesis.
    
    Returns:
    
    This expression.
  - asc
```
public Expression asc()
```
    Sets ordering to ascendant.
    
    Returns:
    
    This expression.
  - desc
```
public Expression desc()
```
    Sets ordering to descendant.
    
    Returns:
    
    This expression.
  - isEnclosed
```
public boolean isEnclosed()
```
    Checks if this expression is to be enclosed in parenthesis.
    
    Returns:
    
    true if this expression is enclosed, false otherwise.
  - isQuote
```
public boolean isQuote()
```
    Checks if this expression is to be quoted.
    
    Returns:
    
    true if this expression is quoted, false otherwise.
  - isAliased
```
public boolean isAliased()
```
    Checks if this expression is to be aliased.
    
    Returns:
    
    true if this expression is aliased, false otherwise.
  - innerJoin
```
public Expression innerJoin(Expression table,
                            Expression expr)
```
    Sets an inner join with the current table.
    
    Parameters:
    
    table - The table to join.
    
    expr - The expressions to join.
    
    Returns:
    
    This expression.
  - leftOuterJoin
```
public Expression leftOuterJoin(Expression table,
                                Expression expr)
```
    Sets a left outer join with the current table.
    
    Parameters:
    
    table - The table to join.
    
    expr - The expressions to join.
    
    Returns:
    
    This expression.
  - rightOuterJoin
```
public Expression rightOuterJoin(Expression table,
                                 Expression expr)
```
    Sets a right outer join with the current table.
    
    Parameters:
    
    table - The table to join.
    
    expr - The expressions to join.
    
    Returns:
    
    This expression.
  - fullOuterJoin
```
public Expression fullOuterJoin(Expression table,
                                Expression expr)
```
    Sets a full outer join with the current table.
    
    Parameters:
    
    table - The table to join.
    
    expr - The expressions to join.
    
    Returns:
    
    This expression.
  - withNoLock
```
public Expression withNoLock()
```
    Sets no lock keyword on SQL Server tables.
    
    Returns:
    
    This expression.
  - isWithNoLock
```
public boolean isWithNoLock()
```
    Checks if this expression (TABLES) is with no lock.
    
    Returns:
    
    true if this expression (TABLE) is with no lock, false otherwise.
  - getJoins
```
public List<Join> getJoins()
```
    Gets the join list.
    
    Returns:
    
    The join list.
  - getOrdering
```
public String getOrdering()
```
    Gets the ordering.
    
    Returns:
    
    The ordering.
  - isQuotes
```
public boolean isQuotes()
```
    Checks if this expression is to be translated with quotes.
    
    Returns:
    
    true if this expression is to be translated with quotes, false otherwise.
  - getAlias
```
public String getAlias()
```
    Gets the alias.
    
    Returns:
    
    The alias, null if not applicable.

Class Expression

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

translator

properties

alias

enclosed

quotes

ordering

joins

withNoLock

Constructor Detail

Expression

Method Detail

translate

alias

unquote

enclose

asc

desc

isEnclosed

isQuote

isAliased

innerJoin

leftOuterJoin

rightOuterJoin

fullOuterJoin

withNoLock

isWithNoLock

getJoins

getOrdering

isQuotes

getAlias