ru.curs.celesta.dbutils.QueryBuildingHelper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of celesta-core Show documentation

The newest version!

package ru.curs.celesta.dbutils;

import ru.curs.celesta.score.DataGrainElement;
import ru.curs.celesta.score.SQLGenerator;

import java.sql.Connection;
import java.time.ZonedDateTime;
import java.util.List;

/**
 * Subset of DBAdaptor functions for literals translation.
 */
public interface QueryBuildingHelper {

    /**
     * Translates date from ISO YYYYMMDD format into RDBMS-specific format.
     *
     * @param date
     *            date in ISO format.
     */
    String translateDate(String date);

    /**
     * Does RDBMS sort nulls first?
     */
    boolean nullsFirst();

    /**
     * Returns SQL generator for Celesta views/complex filters.
     */
    SQLGenerator getViewSQLGenerator();

    //TODO: Javadoc
    String getInFilterClause(DataGrainElement dge, DataGrainElement otherDge, List fields,
                             List otherFields, String whereForOtherTable);

    /**
     * Whether cortege comparing is supported by RDBMS.
     *
     * @return
     */
    boolean supportsCortegeComparing();

    ZonedDateTime prepareZonedDateTimeForParameterSetter(Connection conn, ZonedDateTime z);

}