Examples of org.jooq.QueryPart

org.jooq.QueryPart
The common base type for all objects that can be used for query composition.
All QueryPart implementations can be cast to {@link QueryPartInternal} in order to access the internal API. See also{@link #internalAPI(Class)}
A QueryPart essentially combines the {@link Attachable}interface with SQL code generation and variable binding functionality. @author Lukas Eder

        ctx.delete(TABLE1));
    }


    @Test
    public void test_DELETE_WHERE() {
        QueryPart part =
        ctx.delete(TABLE1)
           .where(FIELD_ID1.eq(1));


        assertEvents(asList(
            asList(DELETE),

View Full Code Here

public class CustomQueryPartTest extends AbstractTest {


    @SuppressWarnings("serial")
    @Test
    public void testCustomQueryPart() throws Exception {
        QueryPart p = new CustomQueryPart() {


            @Override
            public void accept(Context<?> ctx) {
                ctx.visit(val("abc"));
            }

View Full Code Here

        assertEquals("(a = \"?\" and b = \"{0}\" and c = :1)", DSL.using(POSTGRES).renderNamedParams(c2));
    }


    @Test
    public void testIndexedParameters() {
        QueryPart q = condition("a = ? and b = ? and ? = ?", 1, 2, "a", "b");


        assertEquals("(a = ? and b = ? and ? = ?)", create.render(q));
        assertEquals("(a = 1 and b = 2 and 'a' = 'b')", create.renderInlined(q));
    }

View Full Code Here


        ctx.sql(")");
    }


    private final void toSQLOverClause(Context<?> ctx) {
        QueryPart window = window(ctx);


        // Render this clause only if needed
        if (window == null)
            return;

View Full Code Here

                for (int i = 0; i < clauses.length; i++)
                    start(clauses[i]);


            // Perform the actual visiting, or recurse into the replacement
            // -----------------------------------------------------------------
            QueryPart original = part;
            QueryPart replacement = start(part);


            if (original == replacement)
                visit0(original);
            else
                visit0(replacement);

View Full Code Here

        private boolean anyAbbreviations = false;


        @Override
        public void visitStart(VisitContext context) {
            if (context.renderContext() != null) {
                QueryPart part = context.queryPart();


                if (part instanceof Param<?>) {
                    Param<?> param = (Param<?>) part;
                    Object value = param.getValue();

View Full Code Here

                }
            }


            // Inline bind variables only outside of string literals
            else if (sqlChars[i] == '?' && substituteIndex < substitutes.size()) {
                QueryPart substitute = substitutes.get(substituteIndex++);


                if (render.paramType() == INLINED || render.paramType() == NAMED || render.paramType() == NAMED_OR_INLINED) {
                    render.visit(substitute);
                }
                else {
                    render.sql(sqlChars[i]);
                }


                if (bind != null) {
                    bind.visit(substitute);
                }
            }


            // [#1432] Inline substitues for {numbered placeholders} outside of string literals
            else if (sqlChars[i] == '{') {


                // [#1461] Be careful not to match any JDBC escape syntax
                if (peekAny(sqlChars, i, JDBC_ESCAPE_PREFIXES, true)) {
                    render.sql(sqlChars[i]);
                }


                // Consume the whole token
                else {
                    int start = ++i;
                    for (; i < sqlChars.length && sqlChars[i] != '}'; i++);
                    int end = i;


                    String token = sql.substring(start, end);


                    // Try getting the {numbered placeholder}
                    try {
                        QueryPart substitute = substitutes.get(Integer.valueOf(token));
                        render.visit(substitute);


                        if (bind != null) {
                            bind.visit(substitute);
                        }

View Full Code Here

               PathAnalysis path = where.symbolicAnalysis.paths.get(n);


               TypedValue returnVal = PathAnalysisSimplifier.simplifyBoolean(path.getReturnValue(), Collections.emptyMap());
               ColumnExpressions<?> returnColumns = translator.transform(returnVal);
               if (!returnColumns.isSingleColumn()) throw new IllegalArgumentException("Where lambda should only return a single column of data");
               QueryPart returnExpr = returnColumns.getOnlyColumn();


               if (returnVal instanceof ConstantValue.BooleanConstant)
               {
                  if (((ConstantValue.BooleanConstant)returnVal).val)
                  {

View Full Code Here

TOP

Related Classes of org.jooq.QueryPart

org.jinq.jooq.transform.WhereTransform

org.jooq.impl.AbstractContext

org.jooq.impl.Function

org.jooq.impl.Utils

org.jooq.test.CustomQueryPartTest

org.jooq.test.PlainSQLTest

org.jooq.test.VisitContextTest

org.jooq.tools.LoggerListener$BindValueAbbreviator

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.