Package org.javalite.activejdbc.dialects

Class PostgreSQLDialect

java.lang.Object

org.javalite.activejdbc.dialects.DefaultDialect

org.javalite.activejdbc.dialects.PostgreSQLDialect

All Implemented Interfaces:

Serializable, Dialect

public class PostgreSQLDialect
extends DefaultDialect

See Also:

Serialized Form

Field Summary

Fields inherited from class org.javalite.activejdbc.dialects.DefaultDialect

GROUP_BY_PATTERN, ORDER_BY_PATTERN

Constructor Summary

Constructors

Constructor	Description
PostgreSQLDialect()

Method Summary

Modifier and Type	Method	Description
void	appendQuestionsForUpdate(MetaModel metaModel, StringBuilder query, List<String> columns)	Appends PostgreSQL - specific code: "description = ?::varchar,status = ?::status_type"
void	appendTypedQuestionsInsert(MetaModel metaModel, StringBuilder query, List<String> columns)	Attention, this method has a side effect, it modifies the "query" parameter query - example passed in: "INSERT INTO statuses (status) VALUES (" query - after this method: "INSERT INTO statuses (status) VALUES (?::status_type" In other words, it appends a type for every value placeholder.
String	formSelect(String tableName, String[] columns, String subQuery, List<String> orderBys, long limit, long offset)	Generates adds limit, offset and order bys to a sub-query
String	insertParametrized(MetaModel metaModel, List<String> columns, boolean containsId)
Array	toArray(String typeName, Object value, Connection connection)	Converts the input

Methods inherited from class org.javalite.activejdbc.dialects.DefaultDialect

appendDate, appendEmptyRow, appendOrderBy, appendQuestions, appendSelect, appendSubQuery, appendTime, appendTimestamp, appendValue, deleteManyToManyAssociation, insert, insertManyToManyAssociation, overrideDriverTypeConversion, replace, selectCount, selectCount, selectExists, selectManyToManyAssociation, selectStar, selectStar, selectStarParametrized, update

Methods inherited from class java.lang.Object

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

Constructor Details

PostgreSQLDialect

public PostgreSQLDialect()

Method Details

formSelect

public String formSelect(String tableName,
 String[] columns,
 String subQuery,
 List<String> orderBys,
 long limit,
 long offset)

Generates adds limit, offset and order bys to a sub-query

Specified by:

formSelect in interface Dialect

Overrides:

formSelect in class DefaultDialect

Parameters:

tableName - name of table. If table name is null, then the subQuery parameter is considered to be a full query, and all that needs to be done is to add limit, offset and order bys

columns - not used in this implementation

subQuery - sub-query or a full query

orderBys -

limit -

offset -

Returns:

query with

insertParametrized

public String insertParametrized(MetaModel metaModel,
 List<String> columns,
 boolean containsId)

Specified by:

insertParametrized in interface Dialect

Overrides:

insertParametrized in class DefaultDialect

appendTypedQuestionsInsert

public void appendTypedQuestionsInsert(MetaModel metaModel,
 StringBuilder query,
 List<String> columns)

Attention, this method has a side effect, it modifies the "query" parameter query - example passed in: "INSERT INTO statuses (status) VALUES (" query - after this method: "INSERT INTO statuses (status) VALUES (?::status_type" In other words, it appends a type for every value placeholder.

appendQuestionsForUpdate

public void appendQuestionsForUpdate(MetaModel metaModel,
 StringBuilder query,
 List<String> columns)

Appends PostgreSQL - specific code: "description = ?::varchar,status = ?::status_type"

Specified by:

appendQuestionsForUpdate in interface Dialect

Overrides:

appendQuestionsForUpdate in class DefaultDialect

Parameters:

metaModel - metamodel instance

toArray

public Array toArray(String typeName,
 Object value,
 Connection connection)

Description copied from class: DefaultDialect

Converts the input

Specified by:

toArray in interface Dialect

Overrides:

toArray in class DefaultDialect