Package onl.ycode.stormify

Interface SqlDialect.QueryFormatter

Enclosing class:

SqlDialect

public static interface SqlDialect.QueryFormatter

A query builder for various SQL dialects. The main purpose of this interface is to be able to generate SQL queries with different pagination methods.

Method Summary

Modifier and Type	Method	Description
String	apply(String distinct, String tableName, String constraints, String sorting, int lowBound, int upperBound)	Generate a SQL pagination query with the given parameters.

Method Details

apply

String apply(String distinct,
 String tableName,
 String constraints,
 String sorting,
 int lowBound,
 int upperBound)

Generate a SQL pagination query with the given parameters.

Parameters:

distinct - The distinct clause of the query.

tableName - The name of the table.

constraints - The constraints of the query.

sorting - The order by part of the query.

lowBound - The lower bound of the query.

upperBound - The upper bound of the query.

Returns:

The generated SQL query.