ru.curs.celesta.dbutils

Interface QueryBuildingHelper

All Known Implementing Classes:

DBAdaptor, FirebirdAdaptor, H2Adaptor, MSSQLAdaptor, OpenSourceDbAdaptor, OraAdaptor, PostgresAdaptor

public interface QueryBuildingHelper

Subset of DBAdaptor functions for literals translation.

Method Summary

Modifier and Type	Method and Description
String	getInFilterClause(DataGrainElement dge, DataGrainElement otherDge, List<String> fields, List<String> otherFields, String whereForOtherTable)
SQLGenerator	getViewSQLGenerator() Returns SQL generator for Celesta views/complex filters.
boolean	nullsFirst() Does RDBMS sort nulls first?
ZonedDateTime	prepareZonedDateTimeForParameterSetter(Connection conn, ZonedDateTime z)
boolean	supportsCortegeComparing() Whether cortege comparing is supported by RDBMS.
String	translateDate(String date) Translates date from ISO YYYYMMDD format into RDBMS-specific format.

Method Detail

translateDate

String translateDate(String date)

Translates date from ISO YYYYMMDD format into RDBMS-specific format.

Parameters:

date - date in ISO format.

nullsFirst

boolean nullsFirst()

Does RDBMS sort nulls first?

getViewSQLGenerator

SQLGenerator getViewSQLGenerator()

Returns SQL generator for Celesta views/complex filters.

getInFilterClause

String getInFilterClause(DataGrainElement dge,
                         DataGrainElement otherDge,
                         List<String> fields,
                         List<String> otherFields,
                         String whereForOtherTable)

supportsCortegeComparing

boolean supportsCortegeComparing()

Whether cortege comparing is supported by RDBMS.

Returns:

prepareZonedDateTimeForParameterSetter

ZonedDateTime prepareZonedDateTimeForParameterSetter(Connection conn,
                                                     ZonedDateTime z)