Package 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	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()	Tells whether RDBMS sorts 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 Details

translateDate

String translateDate(String date)

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

Parameters:

date - date in ISO format.

nullsFirst

boolean nullsFirst()

Tells whether RDBMS sorts 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)