org.javalite.activejdbc.dialects

Class DefaultDialect

java.lang.Object

org.javalite.activejdbc.dialects.DefaultDialect

All Implemented Interfaces:

Serializable, Dialect

Direct Known Subclasses:

DB2Dialect, MSSQLDialect, OracleDialect, PostgreSQLDialect

public class DefaultDialect
extends Object
implements Dialect

Author:

Igor Polevoy, Eric Nielsen

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected static Pattern	GROUP_BY_PATTERN
protected static Pattern	ORDER_BY_PATTERN

Constructor Summary

Constructors

Constructor and Description
DefaultDialect()

Method Summary

Modifier and Type	Method and Description
protected void	appendDate(StringBuilder query, Date value)
protected void	appendEmptyRow(MetaModel metaModel, StringBuilder query)
protected void	appendOrderBy(StringBuilder query, List<String> orderBys)
protected void	appendQuestions(StringBuilder query, int count)
protected void	appendSelect(StringBuilder queryBuilder, String tableName, String[] columns, String tableAlias, String subQuery, List<String> orderBys)
protected void	appendSubQuery(StringBuilder queryBuilder, String subQuery)
protected void	appendTime(StringBuilder query, Time value)
protected void	appendTimestamp(StringBuilder query, Timestamp value)
protected void	appendValue(StringBuilder query, Object value, String... replacements)
String	deleteManyToManyAssociation(Many2ManyAssociation association)
String	formSelect(String tableName, String[] columns, String subQuery, List<String> orderBys, long limit, long offset)
String	insert(MetaModel metaModel, Map<String,Object> attributes, String... replacements)
String	insertManyToManyAssociation(Many2ManyAssociation association)
String	insertParametrized(MetaModel metaModel, List<String> columns, boolean containsId)
Object	overrideDriverTypeConversion(MetaModel mm, String attributeName, Object value)
protected String	replace(Object valueObject, String... replacements)
String	selectCount(String from)
String	selectCount(String table, String where)
String	selectExists(MetaModel metaModel)
String	selectManyToManyAssociation(Many2ManyAssociation association, String sourceFkColumnName, int questionsCount)
String	selectStar(String table)
String	selectStar(String table, String where)
String	selectStarParametrized(String table, String... parameters) Produces a parametrized AND query.
String	update(MetaModel metaModel, Map<String,Object> attributes, String... replacements)

Methods inherited from class java.lang.Object

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

Field Detail

ORDER_BY_PATTERN

protected static final Pattern ORDER_BY_PATTERN

GROUP_BY_PATTERN

protected static final Pattern GROUP_BY_PATTERN

Constructor Detail

DefaultDialect

public DefaultDialect()

Method Detail

selectStar

public String selectStar(String table)

Specified by:

selectStar in interface Dialect

selectStar

public String selectStar(String table,
                         String where)

Specified by:

selectStar in interface Dialect

selectStarParametrized

public String selectStarParametrized(String table,
                                     String... parameters)

Produces a parametrized AND query. Example:

 String sql = dialect.selectStarParametrized("people", "name", "ssn", "dob");
 //generates:
 //SELECT * FROM people WHERE name = ? AND ssn = ? AND dob = ?
 

Specified by:

selectStarParametrized in interface Dialect

Parameters:

table - name of table

parameters - list of parameter names

Returns:

something like: "select * from table_name where name = ? and last_name = ? ..."

appendEmptyRow

protected void appendEmptyRow(MetaModel metaModel,
                              StringBuilder query)

appendQuestions

protected void appendQuestions(StringBuilder query,
                               int count)

appendOrderBy

protected void appendOrderBy(StringBuilder query,
                             List<String> orderBys)

appendSubQuery

protected void appendSubQuery(StringBuilder queryBuilder,
                              String subQuery)

appendSelect

protected void appendSelect(StringBuilder queryBuilder,
                            String tableName,
                            String[] columns,
                            String tableAlias,
                            String subQuery,
                            List<String> orderBys)

formSelect

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

Specified by:

formSelect in interface Dialect

overrideDriverTypeConversion

public Object overrideDriverTypeConversion(MetaModel mm,
                                           String attributeName,
                                           Object value)

Specified by:

overrideDriverTypeConversion in interface Dialect

selectCount

public String selectCount(String from)

Specified by:

selectCount in interface Dialect

selectCount

public String selectCount(String table,
                          String where)

Specified by:

selectCount in interface Dialect

selectExists

public String selectExists(MetaModel metaModel)

Specified by:

selectExists in interface Dialect

selectManyToManyAssociation

public String selectManyToManyAssociation(Many2ManyAssociation association,
                                          String sourceFkColumnName,
                                          int questionsCount)

Specified by:

selectManyToManyAssociation in interface Dialect

insertManyToManyAssociation

public String insertManyToManyAssociation(Many2ManyAssociation association)

Specified by:

insertManyToManyAssociation in interface Dialect

insertParametrized

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

Specified by:

insertParametrized in interface Dialect

deleteManyToManyAssociation

public String deleteManyToManyAssociation(Many2ManyAssociation association)

Specified by:

deleteManyToManyAssociation in interface Dialect

appendValue

protected void appendValue(StringBuilder query,
                           Object value,
                           String... replacements)

replace

protected String replace(Object valueObject,
                         String... replacements)

appendDate

protected void appendDate(StringBuilder query,
                          Date value)

appendTime

protected void appendTime(StringBuilder query,
                          Time value)

appendTimestamp

protected void appendTimestamp(StringBuilder query,
                               Timestamp value)

insert

public String insert(MetaModel metaModel,
                     Map<String,Object> attributes,
                     String... replacements)

Specified by:

insert in interface Dialect

update

public String update(MetaModel metaModel,
                     Map<String,Object> attributes,
                     String... replacements)

Specified by:

update in interface Dialect