Examples of QueryTemplate

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

69
70
71
72
73
74
75
76
77
78
79
        DefaultInputQueryParam param2 = new DefaultInputQueryParam(2, UnknownDbType.getInstance(), "A", "param2");
        List<QueryParam> params = new ArrayList<QueryParam>();
        params.add(param1);
        params.add(param2);

        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, params);

        Map<Integer, DbType> paramTypes = new HashMap<Integer, DbType>();
        paramTypes.put(1, JdbcTypes.INTEGER_DB_TYPE);
        paramTypes.put(2, JdbcTypes.INTEGER_DB_TYPE);
View Full Code Here

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

85
86
87
88
89
90
91
92
93
94
95
    }

    @Test
    public void usesUnknownTypesWhenNoMetadataAvailable() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, UnknownDbType.getInstance(), "7", "param1")));

        when(metadataParamTypeResolver.getParameterTypes(connection, queryTemplate)).thenThrow(new SQLException("Error"));

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here

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

98
99
100
101
102
103
104
105
106
107
108
    }

    @Test
    public void resolvesDynamicDbType() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, new DynamicDbType(CUSTOM_TYPE_NAME), "7", "param1")));

        DbType customType = mock(DbType.class);
        when(dbTypeManager.lookup(connection, CUSTOM_TYPE_NAME)).thenReturn(customType);

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here

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

114
115
116
117
118
119
120
121
122
123
124
    }

    @Test
    public void skipsResolvedTypes() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, JdbcTypes.INTEGER_DB_TYPE, "7", "param1")));

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);

        assertThat(1, equalTo(parameterTypes.size()));
        assertThat(JdbcTypes.INTEGER_DB_TYPE, equalTo(parameterTypes.get(1)));
View Full Code Here

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

126
127
128
129
130
131
132
133
134
135
136
    }

    @Test(expected = UnknownDbTypeException.class)
    public void failsResolvingInvalidType() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, new DynamicDbType(CUSTOM_TYPE_NAME), "7", "param1")));

        when(metadataParamTypeResolver.getParameterTypes(connection, queryTemplate)).thenThrow(new SQLException("Error"));
        when(dbTypeManager.lookup(connection, CUSTOM_TYPE_NAME)).thenThrow(new UnknownDbTypeException(CUSTOM_TYPE_NAME));

        paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here

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

29
30
31
32
33
34
35
36
37
    @Test
    public void configuresSimpleStoredProcedure() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("simple");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.STORE_PROCEDURE_CALL, queryTemplate.getType());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

39
40
41
42
43
44
45
46
47
48
49
50
51
    @Test
    public void configuresInputParam() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("inputParam");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.STORE_PROCEDURE_CALL, queryTemplate.getType());
        assertEquals(1, queryTemplate.getInputParams().size());

        InputQueryParam inputSqlParam = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), inputSqlParam.getType());
        assertEquals("foo", inputSqlParam.getValue());
    }
View Full Code Here

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

45
46
47
48
49
50
51
52
53
54
55
    {
        DbConnection connection = createDbConnection();

        DbTypeManager dbTypeManager = new DbTypeManagerBuilder().on(connection).managing(JdbcTypes.INTEGER_DB_TYPE).build();

        QueryTemplate queryTemplate = createQueryTemplate();

        QueryParamTypeResolver paramTypeResolver = new QueryParamTypeResolver(dbTypeManager);

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here

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

60
61
62
63
64
65
66
67
68
69
70
    @Test
    public void resolvesQueryParameterUnknownType() throws Exception
    {
        DbConnection connection = createDbConnection();

        QueryTemplate queryTemplate = createQueryTemplate();

        DbTypeManager dbTypeManager = new DbTypeManagerBuilder().on(connection).unknowing(JdbcTypes.INTEGER_DB_TYPE).build();

        QueryParamTypeResolver paramTypeResolver = new QueryParamTypeResolver(dbTypeManager);
View Full Code Here

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

31
32
33
34
35
36
37
38
39
40
    @Test
    public void detectsSelect() throws Exception
    {
        String sql = "SELECT * FROM PLANET";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.