Package org.mule.module.db.internal.domain.query

Examples of org.mule.module.db.internal.domain.query.Query

58
59
60
61
62
63
64
65
66
67
68
69
70
    }

    @Override
    protected Object executeQuery(DbConnection connection, MuleEvent muleEvent) throws SQLException
    {
        Query query = queryResolver.resolve(connection, muleEvent);

        validateQueryType(query.getQueryTemplate());

        List<List<QueryParamValue>> paramValues = resolveParamSets(muleEvent, query);

        BulkExecutor bulkUpdateExecutor = bulkUpdateExecutorFactory.create();
        return bulkUpdateExecutor.execute(connection, query, paramValues);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        {
            QueryTemplate queryTemplate = query.getQueryTemplate();
            String resolvedSqlText = expressionManager.parse(queryTemplate.getSqlText(), muleEvent);
            queryTemplate = queryTemplateParser.parse(resolvedSqlText);

            return new Query(queryTemplate, Collections.<QueryParamValue>emptyList());
        }
        catch (RuntimeException e)
        {
            throw new QueryResolutionException("Error parsing query", e);
        }
View Full Code Here
56
57
58
59
60
61
62
            Map<Integer, DbType> paramTypes = getParameterTypes(connection, queryTemplate);

            queryTemplate = resolveQueryTemplate(queryTemplate, paramTypes);
        }

        return new Query(queryTemplate, resolvedParams);
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
    @Override
    protected Object executeQuery(DbConnection connection, MuleEvent muleEvent) throws SQLException
    {
        MuleEvent eventToUse = resolveSource(muleEvent);

        Query resolvedQuery = queryResolver.resolve(connection, eventToUse);

        validateQueryType(resolvedQuery.getQueryTemplate());

        return doExecuteQuery(connection, resolvedQuery);
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
        QueryResolver queryResolver = new ParametrizedQueryResolver(resolvedTemplateQuery, paramValueResolver);

        List<QueryParamValue> resolvedParams = Collections.singletonList(new QueryParamValue("param1", "foo"));
        when(paramValueResolver.resolveParams(muleEvent, resolvedTemplateQuery.getParamValues())).thenReturn(resolvedParams);

        Query resolvedQuery = queryResolver.resolve(null, muleEvent);

        assertThat(resolvedTemplateQuery, not(sameInstance(resolvedQuery)));
        assertThat(resolvedTemplateQuery.getQueryTemplate(), sameInstance(resolvedQuery.getQueryTemplate()));
        assertThat(resolvedParams, sameInstance(resolvedQuery.getParamValues()));
        assertThat((String) resolvedParams.get(0).getValue(), equalTo("foo"));
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
        QueryResolver queryResolver = new ParametrizedQueryResolver(unresolvedTemplateQuery, paramValueResolver);

        DbConnection connection = mock(DbConnection.class);
        when(connection.getParamTypes(unresolvedTemplateQuery.getQueryTemplate())).thenReturn(Collections.singletonMap(1, JdbcTypes.INTEGER_DB_TYPE));

        Query resolvedQuery = queryResolver.resolve(connection, muleEvent);

        assertThat(unresolvedTemplateQuery, not(sameInstance(resolvedQuery)));
        assertThat(unresolvedTemplateQuery.getQueryTemplate().getSqlText(), equalTo(resolvedQuery.getQueryTemplate().getSqlText()));
        assertThat(resolvedQuery.getQueryTemplate().getParams().get(0).getType(), equalTo(JdbcTypes.INTEGER_DB_TYPE));
        assertThat(resolvedParams, sameInstance(resolvedQuery.getParamValues()));
        assertThat((String) resolvedParams.get(0).getValue(), equalTo("foo"));
    }
View Full Code Here
42
43
44
45
46
47
48
                QueryParamValue paramValue = new QueryParamValue("param" + paramIndex++, param);
                queryParamValues.add(paramValue);
            }
        }

        return new Query(template, queryParamValues);
    }
View Full Code Here
47
48
49
50
51
52
53
        return new Query(template, queryParamValues);
    }

    protected Query createQuery(QueryTemplate template)
    {
        return new Query(template);
    }
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
30
31
{

    @Test
    public void resolvesStaticQuery() throws Exception
    {
        Query query = createQuery(createQueryTemplate(STATIC_SQL_TEXT));

        StaticQueryResolver queryResolver = new StaticQueryResolver(query);

        Query resolvedQuery = queryResolver.resolve(null, muleEvent);

        assertThat(query, equalTo(resolvedQuery));
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
        QueryTemplateParser queryTemplateParser = mock(QueryTemplateParser.class);
        when(queryTemplateParser.parse(staticSqlText)).thenReturn(expectedQueryTemplate);

        DynamicQueryResolver queryResolver = new DynamicQueryResolver(query, queryTemplateParser, expressionManager);

        Query resolvedQuery = queryResolver.resolve(null, muleEvent);

        assertThat(expectedQueryTemplate, sameInstance(resolvedQuery.getQueryTemplate()));
    }
View Full Code Here
TOP

Related Classes of org.mule.module.db.internal.domain.query.Query

  • org.mule.module.db.internal.processor.AbstractSingleQueryDbMessageProcessor
  • org.mule.module.db.internal.processor.PreparedBulkUpdateMessageProcessor
  • org.mule.module.db.internal.processor.SelectMessageProcessorTestCase
  • org.mule.module.db.internal.processor.UpdateMessageProcessorTestCase
  • org.mule.module.db.internal.resolver.query.AbstractQueryResolverTestCase
  • org.mule.module.db.internal.resolver.query.DynamicQueryResolver
  • org.mule.module.db.internal.resolver.query.DynamicQueryResolverTestCase
  • org.mule.module.db.internal.resolver.query.ParametrizedQueryResolver
  • org.mule.module.db.internal.resolver.query.ParametrizedQueryResolverTestCase
  • org.mule.module.db.internal.resolver.query.StaticQueryResolverTestCase
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.