Examples of QueryTemplate

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

85
86
87
88
89
90
91
        return new DbConnectionBuilder().preparing(SQL_TEXT, preparedStatement).build();
    }

    private QueryTemplate createQueryTemplate()
    {
        return new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<QueryParam>singletonList(new DefaultInputQueryParam(1, UnknownDbType.getInstance(), "7", "param1")));
    }
View Full Code Here

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

41
42
43
44
45
46
47
48
49
50
    @Test
    public void detectsSelectWithLineBreak() throws Exception
    {
        String sql = "SELECT *\nFROM PLANET";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

51
52
53
54
55
56
57
58
59
60
    @Test
    public void detectsUpdate() throws Exception
    {
        String sql = "update PLANET set NAME='Mercury' where ID=1";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.UPDATE, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

61
62
63
64
65
66
67
68
69
70
    @Test
    public void detectsUpdatewithLineBreak() throws Exception
    {
        String sql = "update PLANET set NAME='Mercury' \nwhere ID=1";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.UPDATE, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

71
72
73
74
75
76
77
78
79
80
    @Test
    public void detectsInsert() throws Exception
    {
        String sql = "INSERT INTO PLANET(POSITION, NAME) VALUES (777, 'Mercury')";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.INSERT, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

81
82
83
84
85
86
87
88
89
90
    @Test
    public void detectsInsertWithLineBreak() throws Exception
    {
        String sql = "INSERT INTO PLANET(\nPOSITION, NAME) VALUES (777, 'Mercury')";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.INSERT, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

91
92
93
94
95
96
97
98
99
100
    @Test
    public void detectsDelete() throws Exception
    {
        String sql = "delete from PLANET";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.DELETE, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

49
50
51
52
53
54
55
56
57
58
59
        final String sqlText = "call testStoredProcedure(?)";

        DbConnection connection = new DbConnectionBuilder().onCalatog(catalog).with(databaseMetaData).build();

        QueryTemplate queryTemplate = new QueryTemplate(sqlText, QueryType.STORE_PROCEDURE_CALL, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, UnknownDbType.getInstance(), "7", TYPE_COLUMN)));

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

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

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

101
102
103
104
105
106
107
108
109
110
    @Test
    public void detectsDeleteWithLineBreak() throws Exception
    {
        String sql = "delete from PLANET";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.DELETE, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here

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

87
88
89
90
91
92
93
94
95
96
97
        DefaultOutputQueryParam param1 = new DefaultOutputQueryParam(0, UnknownDbType.getInstance(), "param1");
        List<QueryParam> params = new LinkedList<QueryParam>();
        params.add(param1);

        QueryTemplate queryTemplate = new QueryTemplate("dummy", QueryType.STORE_PROCEDURE_CALL, params);
        StatementResultIterator iterator = new StatementResultIterator(null, statement, queryTemplate, null, null);

        boolean hasNext = iterator.hasNext();

        assertThat(hasNext, equalTo(true));
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.