org.jooq.Context Maven / Gradle / Ivy
/**
* Copyright (c) 2009-2014, Data Geekery GmbH (http://www.datageekery.com)
* All rights reserved.
*
* This work is dual-licensed
* - under the Apache Software License 2.0 (the "ASL")
* - under the jOOQ License and Maintenance Agreement (the "jOOQ License")
* =============================================================================
* You may choose which license applies to you:
*
* - If you're using this work with Open Source databases, you may choose
* either ASL or jOOQ License.
* - If you're using this work with at least one commercial database, you must
* choose jOOQ License
*
* For more information, please visit http://www.jooq.org/licenses
*
* Apache Software License 2.0:
* -----------------------------------------------------------------------------
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* jOOQ License and Maintenance Agreement:
* -----------------------------------------------------------------------------
* Data Geekery grants the Customer the non-exclusive, timely limited and
* non-transferable license to install and use the Software under the terms of
* the jOOQ License and Maintenance Agreement.
*
* This library is distributed with a LIMITED WARRANTY. See the jOOQ License
* and Maintenance Agreement for more details: http://www.jooq.org/licensing
*/
package org.jooq;
import java.sql.PreparedStatement;
import org.jooq.RenderContext.CastMode;
import org.jooq.conf.ParamType;
import org.jooq.conf.RenderKeywordStyle;
import org.jooq.conf.Settings;
import org.jooq.exception.DataAccessException;
/**
* A context type that is used for rendering SQL or for binding.
*
* @author Lukas Eder
* @see BindContext
* @see RenderContext
*/
public interface Context> extends Scope {
// ------------------------------------------------------------------------
// General methods
// ------------------------------------------------------------------------
/**
* Visit a QueryPart in the current Context.
*
* This method is called by certain QueryPart implementations
* to recursively visit component QueryParts.
*
* @param part The component QueryPart
* @throws DataAccessException If something went wrong while visiting the
* component QueryPart, e.g. when binding a
* variable
*/
C visit(QueryPart part) throws DataAccessException;
/**
* TODO [#2667]
*
* Properties of these methods:
* - A clause is always started / ended, even if it isn't rendered or if it's empty!
*/
C start(Clause clause);
C end(Clause clause);
/**
* Whether the current context is rendering a SQL field declaration (e.g. a
* {@link Field} in the SELECT clause of the query).
*/
boolean declareFields();
/**
* Set the new context value for {@link #declareFields()}
*/
C declareFields(boolean declareFields);
/**
* Whether the current context is rendering a SQL table declaration (e.g. a
* {@link Table} in the FROM or JOIN clause of the
* query).
*/
boolean declareTables();
/**
* Set the new context value for {@link #declareTables()}
*/
C declareTables(boolean declareTables);
/**
* Whether the current context is rendering a SQL window declaration (e.g. a
* {@link WindowDefinition} in the WINDOW clause of the query).
*/
boolean declareWindows();
/**
* Set the new context value for {@link #declareWindows()}
*/
C declareWindows(boolean declareWindows);
/**
* Whether the current context is rendering a common table expression (e.g.
* a {@link CommonTableExpression} in the WITH clause of the
* query).
*/
boolean declareCTE();
/**
* Set the new context value for {@link #declareCTE()}
*/
C declareCTE(boolean declareCTE);
/**
* Whether the current context is rendering a sub-query (nested query)
*/
boolean subquery();
/**
* Set the new context value for {@link #subquery()}
*/
C subquery(boolean subquery);
/**
* Get the next bind index. This increments an internal counter. This is
* relevant for two use-cases:
*
* - When binding variables to a {@link PreparedStatement}. Client code
* must assure that calling {@link #nextIndex()} is followed by setting a
* bind value to {@link BindContext#statement()}
* - When rendering unnamed bind variables with
* {@link RenderContext#paramType()} being to
NAMED
*
*/
int nextIndex();
/**
* Peek the next bind index. This won't increment the internal counter,
* unlike {@link #nextIndex()}
*/
int peekIndex();
// ------------------------------------------------------------------------
// Methods used for variable binding
// ------------------------------------------------------------------------
/**
* Retrieve the context's underlying {@link PreparedStatement} if available,
* or null if this traversal does not operate on a
* PreparedStatement.
*/
PreparedStatement statement();
/**
* Bind a value using a specific type. This will also increment the internal
* counter.
*
* @throws DataAccessException If something went wrong while binding a
* variable
*/
BindContext bindValue(Object value, Field field) throws DataAccessException;
// ------------------------------------------------------------------------
// Methods used for SQL rendering
// ------------------------------------------------------------------------
/**
* Peek the next alias that will be generated by {@link #nextAlias()}.
*/
String peekAlias();
/**
* Return a new alias that is unique for the scope of one query. These
* aliases are sometimes needed when unaliased projections are defined in
* subqueries, which can lead to syntax errors.
*/
String nextAlias();
/**
* Render the context's underlying SQL statement.
*/
String render();
/**
* Render a query part in a new context derived from this one. The rendered
* SQL will not be appended to this context.
*/
String render(QueryPart part);
/**
* Append a SQL keyword to the context's contained {@link StringBuilder}.
*
* Use this to have your SQL keyword rendered in {@link RenderKeywordStyle}
* (upper or lower case)
*/
C keyword(String keyword);
/**
* Append some SQL to the context's contained {@link StringBuilder}.
*/
C sql(String sql);
/**
* Append some SQL to the context's contained {@link StringBuilder}.
*
* Set literal = true to indicate that the
* RenderContext shall not format the argument SQL.
*/
C sql(String sql, boolean literal);
/**
* Append some SQL to the context's contained {@link StringBuilder}.
*/
C sql(char sql);
/**
* Append some SQL to the context's contained {@link StringBuilder}.
*/
C sql(int sql);
/**
* Override the value of {@link Settings#isRenderFormatted()}.
*/
C format(boolean format);
/**
* The value of {@link Settings#isRenderFormatted()}.
*/
boolean format();
/**
* Render a new line character (only if {@link Settings#isRenderFormatted()}
* is set to true).
*/
C formatNewLine();
/**
* Render a new line character (only if {@link Settings#isRenderFormatted()}
* is set to true, and the {@link #formatPrintMargin(int)} has
* been exceeded).
*/
C formatNewLineAfterPrintMargin();
/**
* Render a new line character (only if {@link Settings#isRenderFormatted()}
* is set to true), or a whitespace separator character
* otherwise.
*/
C formatSeparator();
/**
* Start indenting subsequent SQL by one level (two characters), if
* {@link Settings#isRenderFormatted()} is set to true.
*
* This is the same as calling {@link #formatIndentStart(int)} with a
* parameter of 2
*/
C formatIndentStart();
/**
* Start indenting subsequent SQL by a number of characters, if
* {@link Settings#isRenderFormatted()} is set to true.
*/
C formatIndentStart(int indent);
/**
* Start indenting subsequent SQL at the same level as the current line, if
* {@link Settings#isRenderFormatted()} is set to true.
*/
C formatIndentLockStart();
/**
* Stop indenting subsequent SQL by one level (two characters), if
* {@link Settings#isRenderFormatted()} is set to true.
*
* This is the same as calling {@link #formatIndentEnd(int)} with a
* parameter of 2
*/
C formatIndentEnd();
/**
* Stop indenting subsequent SQL by a number of characters, if
* {@link Settings#isRenderFormatted()} is set to true.
*/
C formatIndentEnd(int indent);
/**
* Stop indenting subsequent SQL at the same level as the current line, if
* {@link Settings#isRenderFormatted()} is set to true.
*/
C formatIndentLockEnd();
/**
* Set a print margin that will be applied to formatted SQL, if
* {@link Settings#isRenderFormatted()} is set to true.
*
* The default print margin is 80. Setting this to zero or a
* negative value means that no print margin will be applied.
*
* The print margin is applied to any of these QueryParts:
*
* - {@link Field#in(Field...)} and related expressions
*/
C formatPrintMargin(int margin);
/**
* Append some (quoted) literal to the context's contained
* {@link StringBuilder}.
*/
C literal(String literal);
/**
* Whether query parts should render qualified names or not.
*/
boolean qualify();
/**
* Sett the new context value for {@link #qualify()}.
*/
C qualify(boolean qualify);
/**
* Specify, how bind values should be rendered.
*
*
* - As {@link ParamType#INDEXED} parameters:
* ?, ?, ?
* - As {@link ParamType#NAMED} parameters:
* :1, :2, :custom_name
* - As {@link ParamType#INLINED} parameters:
* 1, 'A', null
*
*/
ParamType paramType();
/**
* Set the new context value for {@link #paramType()}.
*/
C paramType(ParamType paramType);
/**
* The currently applied cast mode for bind values.
*/
CastMode castMode();
/**
* Set the new cast mode for {@link #castMode()}.
*/
C castMode(CastMode mode);
/**
* Whether casting must be applied. The result follows this logic:
*
*
* CastMode
* result
*
*
* ALWAYStrue
*
* NEVERfalse
*
* SOMEtrue or false depending on the dialect
*
* DEFAULTnull
*
*
* @deprecated - [#3703] - 3.5.0 - Do not use this any longer
*/
@Deprecated
Boolean cast();
/**
* Set the new cast mode to {@link CastMode#SOME} for a list of dialects.
*
* @deprecated - [#3703] - 3.5.0 - Do not use this any longer
*/
@Deprecated
C castModeSome(SQLDialect... dialects);
}