KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > objectstyle > cayenne > dba > postgres > PostgresQualifierTranslator


1 /* ====================================================================
2  *
3  * The ObjectStyle Group Software License, version 1.1
4  * ObjectStyle Group - http://objectstyle.org/
5  *
6  * Copyright (c) 2002-2005, Andrei (Andrus) Adamchik and individual authors
7  * of the software. All rights reserved.
8  *
9  * Redistribution and use in source and binary forms, with or without
10  * modification, are permitted provided that the following conditions
11  * are met:
12  *
13  * 1. Redistributions of source code must retain the above copyright
14  * notice, this list of conditions and the following disclaimer.
15  *
16  * 2. Redistributions in binary form must reproduce the above copyright
17  * notice, this list of conditions and the following disclaimer in
18  * the documentation and/or other materials provided with the
19  * distribution.
20  *
21  * 3. The end-user documentation included with the redistribution, if any,
22  * must include the following acknowlegement:
23  * "This product includes software developed by independent contributors
24  * and hosted on ObjectStyle Group web site (http://objectstyle.org/)."
25  * Alternately, this acknowlegement may appear in the software itself,
26  * if and wherever such third-party acknowlegements normally appear.
27  *
28  * 4. The names "ObjectStyle Group" and "Cayenne" must not be used to endorse
29  * or promote products derived from this software without prior written
30  * permission. For written permission, email
31  * "andrus at objectstyle dot org".
32  *
33  * 5. Products derived from this software may not be called "ObjectStyle"
34  * or "Cayenne", nor may "ObjectStyle" or "Cayenne" appear in their
35  * names without prior written permission.
36  *
37  * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
38  * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
39  * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
40  * DISCLAIMED. IN NO EVENT SHALL THE OBJECTSTYLE GROUP OR
41  * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
42  * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
43  * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
44  * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
45  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
46  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
47  * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
48  * SUCH DAMAGE.
49  * ====================================================================
50  *
51  * This software consists of voluntary contributions made by many
52  * individuals and hosted on ObjectStyle Group web site. For more
53  * information on the ObjectStyle Group, please see
54  * <http://objectstyle.org/>.
55  */

56 package org.objectstyle.cayenne.dba.postgres;
57
58 import org.objectstyle.cayenne.access.trans.QueryAssembler;
59 import org.objectstyle.cayenne.access.trans.TrimmingQualifierTranslator;
60 import org.objectstyle.cayenne.exp.Expression;
61
62 /**
63  * Uses Postgres extensions to optimize various translations.
64  *
65  * @author Andrei Adamchik
66  * @since 1.1
67  */

68 public class PostgresQualifierTranslator extends TrimmingQualifierTranslator {
69
70     public PostgresQualifierTranslator(QueryAssembler queryAssembler) {
71         super(queryAssembler, "RTRIM");
72     }
73
74     public void startNode(Expression node, Expression parentNode) {
75
76         if (node.getOperandCount() == 2) {
77             // binary nodes are the only ones that currently require this
78
detectObjectMatch(node);
79
80             if (parenthesisNeeded(node, parentNode)) {
81                 qualBuf.append('(');
82             }
83
84             // super implementation has special handling
85
// of LIKE_IGNORE_CASE and NOT_LIKE_IGNORE_CASE
86
// Postgres uses ILIKE
87
// ...
88
}
89         else {
90             super.startNode(node, parentNode);
91         }
92     }
93
94     public void endNode(Expression node, Expression parentNode) {
95         if (node.getOperandCount() == 2) {
96             // check if we need to use objectMatchTranslator to finish building the expression
97
if (matchingObject) {
98                 appendObjectMatch();
99             }
100
101             if (parenthesisNeeded(node, parentNode))
102                 qualBuf.append(')');
103
104             // super implementation has special handling
105
// of LIKE_IGNORE_CASE and NOT_LIKE_IGNORE_CASE
106
// Postgres uses ILIKE
107
// ...
108
}
109         else {
110             super.endNode(node, parentNode);
111         }
112     }
113
114     public void finishedChild(Expression node, int childIndex, boolean hasMoreChildren) {
115         if (!hasMoreChildren) {
116             return;
117         }
118
119         // use ILIKE
120

121         switch (node.getType()) {
122
123             case Expression.LIKE_IGNORE_CASE :
124                 finishedChildNodeAppendExpression(node, " ILIKE ");
125                 break;
126             case Expression.NOT_LIKE_IGNORE_CASE :
127                 finishedChildNodeAppendExpression(node, " NOT ILIKE ");
128                 break;
129             default :
130                 super.finishedChild(node, childIndex, hasMoreChildren);
131         }
132     }
133
134     private void finishedChildNodeAppendExpression(Expression node, String JavaDoc operation) {
135         StringBuffer JavaDoc buf = (matchingObject) ? new StringBuffer JavaDoc() : qualBuf;
136         buf.append(operation);
137         if (matchingObject) {
138             objectMatchTranslator.setOperation(buf.toString());
139             objectMatchTranslator.setExpression(node);
140         }
141     }
142 }
Popular Tags