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

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

203
204
205
206
207
208
209
                sqlToUse = sqlToUse + currentChar;
                tokenStart++;
            }
        }

        return new QueryTemplate(sqlToUse, queryType, parameterList);
    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
    }

    @Override
    public QueryTemplate getObject() throws Exception
    {
        QueryTemplate queryTemplate = queryParser.parse(sqlText);

        List<QueryParam> resolvedParams = new LinkedList<QueryParam>();

        for (QueryParam templateParam : queryTemplate.getParams())
        {
            QueryParam param = findOverriddenParam(templateParam.getName(), queryParams);

            if (param == null)
            {
                resolvedParams.add(templateParam);
            }
            else
            {
                resolvedParams.add(overrideParam(templateParam, param));
            }
        }

        return new QueryTemplate(queryTemplate.getSqlText(), queryTemplate.getType(), resolvedParams);
    }
View Full Code Here
61
62
63
64
65
66
67
        if (usesNameParamOverride)
        {
            processNameParamOverride(paramDefinitions);
        }

        return new QueryTemplate(queryTemplate.getSqlText(), queryTemplate.getType(), paramDefinitions);
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
    @Override
    public Query resolve(DbConnection connection, MuleEvent muleEvent)
    {
        try
        {
            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)
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
    @Override
    public Query resolve(DbConnection connection, MuleEvent muleEvent)
    {
        List<QueryParamValue> resolvedParams = paramValueResolver.resolveParams(muleEvent, query.getParamValues());

        QueryTemplate queryTemplate = query.getQueryTemplate();

        if (needsParamTypeResolution(queryTemplate.getParams()))
        {
            Map<Integer, DbType> paramTypes = getParameterTypes(connection, queryTemplate);

            queryTemplate = resolveQueryTemplate(queryTemplate, paramTypes);
        }
View Full Code Here
114
115
116
117
118
119
120
            }

            newParams.add(newParam);
        }

        return new QueryTemplate(queryTemplate.getSqlText(), queryTemplate.getType(), newParams);
    }
View Full Code Here
29
30
31
32
33
34
35
    }

    @Override
    public QueryTemplate getObject() throws Exception
    {
        return new QueryTemplate(sqlText, QueryType.DDL, Collections.<QueryParam>emptyList(), true);
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
            if ("".equals(sql.trim()))
            {
                continue;
            }

            QueryTemplate queryTemplate = parser.parse(sql);
            bulkQuery.add(queryTemplate);
        }

        return bulkQuery;
    }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
    @Test
    public void detectsDdl() throws Exception
    {
        String sql = "drop table PLANET";

        QueryTemplate queryTemplate = parser.parse(sql);

        assertThat(queryTemplate.getType(), equalTo(QueryType.DDL));
        assertThat(queryTemplate.getSqlText(), equalTo(sql));
        assertThat(queryTemplate.getParams().size(), equalTo(0));
    }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    @Test
    public void definesSelect() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("testSelect");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = ?", queryTemplate.getSqlText());
        assertEquals(1, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertEquals("position", param1.getName());
        assertEquals("0", param1.getValue());
        assertEquals(1, param1.getIndex());
    }
View Full Code Here
TOP

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

  • org.mule.module.db.integration.config.CustomParamTypeTestCase
  • org.mule.module.db.integration.select.SelectTemplateSqlTestCase
  • org.mule.module.db.integration.storedprocedure.StoredProcedureTemplateSqlTestCase
  • org.mule.module.db.integration.template.CdataParameterizedQueryTemplateTestCase
  • org.mule.module.db.integration.template.TemplateQueryConfigTestCase
  • org.mule.module.db.integration.update.UpdateTemplateSqlTestCase
  • org.mule.module.db.internal.config.domain.query.DynamicQueryTemplateFactoryBean
  • org.mule.module.db.internal.config.domain.query.DynamicQueryTemplateFactoryBeanTestCase
  • org.mule.module.db.internal.config.domain.query.ParameterizedQueryTemplateFactoryBean
  • org.mule.module.db.internal.config.domain.query.ParameterizedQueryTemplateFactoryBeanTestCase
    • 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.