Package com.feedzai.commons.sql.abstraction.engine.impl

Class MySqlTranslator

java.lang.Object

com.feedzai.commons.sql.abstraction.engine.AbstractTranslator

com.feedzai.commons.sql.abstraction.engine.impl.MySqlTranslator

public class MySqlTranslator
extends AbstractTranslator

Provides SQL translation for MySQL.

Since:

2.0.0

Author:

Rui Vilao (rui.vilao@feedzai.com)

Field Summary

Fields inherited from class com.feedzai.commons.sql.abstraction.engine.AbstractTranslator

injector, properties

Constructor Summary

Constructors

Constructor	Description
MySqlTranslator()

Method Summary

Modifier and Type	Method	Description
protected Union	rowsToUnion(List<Expression> rows)	Transform values' rows into a union.
String	translate(AlterColumn ac)	Translates Name.
String	translate(DbColumn c)	Translates DbColumn.
String	translate(DropPrimaryKey dpk)	Translates DropPrimaryKey.
String	translate(Rename r)	Translates Rename.
String	translate(Cast cast)	Translates Cast.
String	translate(Function f)	Translates Function.
String	translate(Modulo m)	Translates Modulo.
String	translate(Query q)	Translates Query.
String	translate(RepeatDelimiter rd)	Translates RepeatDelimiter.
String	translate(StringAgg stringAgg)	Translates StringAgg.
String	translate(View v)	Translates View.
String	translate(With with)
String	translateEscape()	Translates the escape character.
String	translateFalse()	Translates the boolean false.
String	translateTrue()	Translates the boolean true.
protected String	translateUpdateFrom(Update update)	Translates Update considering the FROM clause.

Methods inherited from class com.feedzai.commons.sql.abstraction.engine.AbstractTranslator

inject, inject, join, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translate, translateUpdate, translateUpdateSetClause

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlTranslator

public MySqlTranslator()

Method Detail

translate

public String translate(AlterColumn ac)

Description copied from class: AbstractTranslator

Translates Name.

Specified by:

translate in class AbstractTranslator

Parameters:

ac - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(DropPrimaryKey dpk)

Description copied from class: AbstractTranslator

Translates DropPrimaryKey.

Specified by:

translate in class AbstractTranslator

Parameters:

dpk - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(Function f)

Description copied from class: AbstractTranslator

Translates Function.

Specified by:

translate in class AbstractTranslator

Parameters:

f - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(Modulo m)

Description copied from class: AbstractTranslator

Translates Modulo.

Specified by:

translate in class AbstractTranslator

Parameters:

m - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(Rename r)

Description copied from class: AbstractTranslator

Translates Rename.

Specified by:

translate in class AbstractTranslator

Parameters:

r - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(RepeatDelimiter rd)

Description copied from class: AbstractTranslator

Translates RepeatDelimiter.

Specified by:

translate in class AbstractTranslator

Parameters:

rd - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(Query q)

Description copied from class: AbstractTranslator

Translates Query.

Specified by:

translate in class AbstractTranslator

Parameters:

q - The object to translate.

Returns:

The string representation of the given object.

translateUpdateFrom

protected String translateUpdateFrom(Update update)

Description copied from class: AbstractTranslator

Translates Update considering the FROM clause.

Overrides:

translateUpdateFrom in class AbstractTranslator

Parameters:

update - The update to translate.

Returns:

The string representation of the given object.

translate

public String translate(View v)

Description copied from class: AbstractTranslator

Translates View.

Specified by:

translate in class AbstractTranslator

Parameters:

v - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(DbColumn c)

Description copied from class: AbstractTranslator

Translates DbColumn.

Specified by:

translate in class AbstractTranslator

Parameters:

c - The object to translate.

Returns:

The string representation of the given object.

translate

public String translate(Cast cast)

Description copied from class: AbstractTranslator

Translates Cast.

Specified by:

translate in class AbstractTranslator

Parameters:

cast - a cast expression.

Returns:

cast translation.

translate

public String translate(With with)

Overrides:

translate in class AbstractTranslator

rowsToUnion

protected Union rowsToUnion(List<Expression> rows)

Description copied from class: AbstractTranslator

Transform values' rows into a union.

Overrides:

rowsToUnion in class AbstractTranslator

Parameters:

rows - the values' rows

Returns:

the resulting union

translate

public String translate(StringAgg stringAgg)

Description copied from class: AbstractTranslator

Translates StringAgg.

Specified by:

translate in class AbstractTranslator

Parameters:

stringAgg - The object to translate.

Returns:

The string representation of the given object.

translateEscape

public String translateEscape()

Description copied from class: AbstractTranslator

Translates the escape character.

Specified by:

translateEscape in class AbstractTranslator

Returns:

The string representation of the escape character.

translateTrue

public String translateTrue()

Description copied from class: AbstractTranslator

Translates the boolean true.

Specified by:

translateTrue in class AbstractTranslator

Returns:

The string representation of the true keyword.

translateFalse

public String translateFalse()

Description copied from class: AbstractTranslator

Translates the boolean false.

Specified by:

translateFalse in class AbstractTranslator

Returns:

The string representation of the false keyword.