Examples of rewriteQuery()

Examples of org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter.rewriteQuery()

43
44
45
46
47
48
49
50
51
52
53
        AbstractQueryRewriter rewriter = new DefaultQueryRewriter(null) {

        };

        assertEquals("SELECT COUNT(*) FROM foobar WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));

        rewriter = new DefaultQueryRewriter(null) {
            @Override
            protected String rewriteFromItem(Query query, FromItem item) {
                return "mytable";
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter.rewriteQuery()

53
54
55
56
57
58
59
60
61
62
63
                return "mytable";
            }
        };

        assertEquals("SELECT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));

        q.getSelectClause().setDistinct(true);

        assertEquals(
                "SELECT DISTINCT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter.rewriteQuery()

59
60
61
62
63
64
65
66
        q.getSelectClause().setDistinct(true);

        assertEquals(
                "SELECT DISTINCT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));
    }
}
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.DefaultQueryRewriter.rewriteQuery()

43
44
45
46
47
48
49
50
51
52
53
        AbstractQueryRewriter rewriter = new DefaultQueryRewriter(null) {

        };

        assertEquals("SELECT COUNT(*) FROM foobar WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));

        rewriter = new DefaultQueryRewriter(null) {
            @Override
            protected String rewriteFromItem(Query query, FromItem item) {
                return "mytable";
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.DefaultQueryRewriter.rewriteQuery()

53
54
55
56
57
58
59
60
61
62
63
                return "mytable";
            }
        };

        assertEquals("SELECT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));

        q.getSelectClause().setDistinct(true);

        assertEquals(
                "SELECT DISTINCT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.DefaultQueryRewriter.rewriteQuery()

59
60
61
62
63
64
65
66
        q.getSelectClause().setDistinct(true);

        assertEquals(
                "SELECT DISTINCT COUNT(*) FROM mytable WHERE foob IS NULL GROUP BY col1 HAVING col2 > 40 ORDER BY bla ASC",
                rewriter.rewriteQuery(q));
    }
}
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.IQueryRewriter.rewriteQuery()

121
122
123
124
125
126
127
128
129
130
131
                new SelectItem(customersTable.getColumnByName("AccountNumber")).setAlias("c|o|d|e"));
        q.setMaxRows(5);

        assertEquals("SELECT cus-tomers.\"AccountNumber\" AS c|o|d|e FROM Sales.\"Customer\" cus-tomers", q.toString());

        String queryString = queryRewriter.rewriteQuery(q);
        assertEquals(
                "SELECT TOP 5 \"cus-tomers\".\"AccountNumber\" AS \"c|o|d|e\" FROM Sales.\"Customer\" \"cus-tomers\"",
                queryString);

        // We have to test that no additional quoting characters are added every
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.IQueryRewriter.rewriteQuery()

128
129
130
131
132
133
134
135
136
137
138
                "SELECT TOP 5 \"cus-tomers\".\"AccountNumber\" AS \"c|o|d|e\" FROM Sales.\"Customer\" \"cus-tomers\"",
                queryString);

        // We have to test that no additional quoting characters are added every
        // time we run the rewriting
        queryString = queryRewriter.rewriteQuery(q);
        queryString = queryRewriter.rewriteQuery(q);
        assertEquals(
                "SELECT TOP 5 \"cus-tomers\".\"AccountNumber\" AS \"c|o|d|e\" FROM Sales.\"Customer\" \"cus-tomers\"",
                queryString);
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.IQueryRewriter.rewriteQuery()

129
130
131
132
133
134
135
136
137
138
139
                queryString);

        // We have to test that no additional quoting characters are added every
        // time we run the rewriting
        queryString = queryRewriter.rewriteQuery(q);
        queryString = queryRewriter.rewriteQuery(q);
        assertEquals(
                "SELECT TOP 5 \"cus-tomers\".\"AccountNumber\" AS \"c|o|d|e\" FROM Sales.\"Customer\" \"cus-tomers\"",
                queryString);

        // Test that the original query is still the same (ie. it has been
View Full Code Here

Examples of org.apache.metamodel.jdbc.dialects.IQueryRewriter.rewriteQuery()

156
157
158
159
160
161
162
163
        Query q = dc.query().from("Production", "Product").select("Name").where("Color").eq("R'ed").toQuery();

        assertEquals(
                "SELECT \"Product\".\"Name\" FROM Production.\"Product\" Product WHERE Product.\"Color\" = 'R''ed'",
                queryRewriter.rewriteQuery(q));
    }
}
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.