001: /*
002: * Copyright (c) 1998-2008 Caucho Technology -- all rights reserved
003: *
004: * This file is part of Resin(R) Open Source
005: *
006: * Each copy or derived work must preserve the copyright notice and this
007: * notice unmodified.
008: *
009: * Resin Open Source is free software; you can redistribute it and/or modify
010: * it under the terms of the GNU General Public License as published by
011: * the Free Software Foundation; either version 2 of the License, or
012: * (at your option) any later version.
013: *
014: * Resin Open Source is distributed in the hope that it will be useful,
015: * but WITHOUT ANY WARRANTY; without even the implied warranty of
016: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty
017: * of NON-INFRINGEMENT. See the GNU General Public License for more
018: * details.
019: *
020: * You should have received a copy of the GNU General Public License
021: * along with Resin Open Source; if not, write to the
022: * Free Software Foundation, Inc.
023: * 59 Temple Place, Suite 330
024: * Boston, MA 02111-1307 USA
025: *
026: * @author Scott Ferguson
027: */
028:
029: package com.caucho.amber.query;
030:
031: import com.caucho.amber.entity.AmberEntityHome;
032: import com.caucho.amber.entity.TableInvalidateCompletion;
033: import com.caucho.amber.expr.AmberExpr;
034: import com.caucho.amber.manager.AmberConnection;
035: import com.caucho.jdbc.JdbcMetaData;
036: import com.caucho.util.CharBuffer;
037:
038: import java.sql.SQLException;
039:
040: /**
041: * Represents an Amber delete query
042: */
043: public class DeleteQuery extends AbstractQuery {
044: private String _sql;
045:
046: DeleteQuery(String query, JdbcMetaData metaData) {
047: super (query, metaData);
048: }
049:
050: /**
051: * Sets the where expression
052: */
053: void setWhere(AmberExpr expr) {
054: _where = expr;
055: }
056:
057: /**
058: * Returns the id load sql
059: */
060: public String getSQL() {
061: return _sql;
062: }
063:
064: /**
065: * Initialize
066: */
067: void init() throws QueryParseException {
068: super .init();
069:
070: CharBuffer cb = CharBuffer.allocate();
071:
072: cb.append("DELETE FROM ");
073:
074: FromItem item = _fromList.get(0);
075:
076: // jpa/1332
077: cb.append(item.getTable().getName());
078:
079: // jpa/1300, jpa/1331
080: if ((getMetaData().supportsUpdateTableAlias() && (_fromList
081: .size() > 1))
082: || hasSubQuery()) {
083: cb.append(" ");
084: cb.append(item.getName());
085: }
086:
087: if (_where != null) {
088: cb.append(" WHERE ");
089: _where.generateUpdateWhere(cb);
090: }
091:
092: _sql = cb.close();
093: }
094:
095: /**
096: * Adds any completion info.
097: */
098: public void prepare(UserQuery userQuery, AmberConnection aConn)
099: throws SQLException {
100: aConn.flushNoChecks();
101: }
102:
103: /**
104: * Adds any completion info.
105: */
106: public void complete(UserQuery userQuery, AmberConnection aConn)
107: throws SQLException {
108: aConn.expire();
109:
110: FromItem item = _fromList.get(0);
111:
112: aConn.addCompletion(new TableInvalidateCompletion(item
113: .getEntityType().getTable().getName()));
114: }
115:
116: /**
117: * Debug view.
118: */
119: public String toString() {
120: return "DeleteQuery[" + getQueryString() + "]";
121: }
122: }
|