Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id EEA33200B4B for ; Thu, 21 Jul 2016 10:52:48 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id EB7F9160A6D; Thu, 21 Jul 2016 08:52:48 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 40972160A68 for ; Thu, 21 Jul 2016 10:52:48 +0200 (CEST) Received: (qmail 41242 invoked by uid 500); 21 Jul 2016 08:52:47 -0000 Mailing-List: contact commits-help@empire-db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: empire-db-dev@empire-db.apache.org Delivered-To: mailing list commits@empire-db.apache.org Received: (qmail 41230 invoked by uid 99); 21 Jul 2016 08:52:47 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 Jul 2016 08:52:47 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id DC7B1E1101; Thu, 21 Jul 2016 08:52:46 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: derjan@apache.org To: commits@empire-db.apache.org Message-Id: <12c8cf79bbaa4cb9bc663d09f1dcf49c@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: empire-db git commit: Added Support for DELETE with JOIN via Multiple-Table Syntax Date: Thu, 21 Jul 2016 08:52:46 +0000 (UTC) archived-at: Thu, 21 Jul 2016 08:52:49 -0000 Repository: empire-db Updated Branches: refs/heads/master a0c6a6f45 -> 335bfcc1f Added Support for DELETE with JOIN via Multiple-Table Syntax Project: http://git-wip-us.apache.org/repos/asf/empire-db/repo Commit: http://git-wip-us.apache.org/repos/asf/empire-db/commit/335bfcc1 Tree: http://git-wip-us.apache.org/repos/asf/empire-db/tree/335bfcc1 Diff: http://git-wip-us.apache.org/repos/asf/empire-db/diff/335bfcc1 Branch: refs/heads/master Commit: 335bfcc1fa4770c1427667011fc0f72a43f9e39d Parents: a0c6a6f Author: Jan Glaubitz Authored: Thu Jul 21 10:47:10 2016 +0200 Committer: Jan Glaubitz Committed: Thu Jul 21 10:47:10 2016 +0200 ---------------------------------------------------------------------- .../empire/db/mysql/DBDatabaseDriverMySQL.java | 22 ++++++++++++++++++++ 1 file changed, 22 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/empire-db/blob/335bfcc1/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java ---------------------------------------------------------------------- diff --git a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java index 5da5611..e2517ab 100644 --- a/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java +++ b/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java @@ -99,6 +99,28 @@ public class DBDatabaseDriverMySQL extends DBDatabaseDriver } } } + + /** + * Creates an MySQL specific delete statement. + * @return the delete SQL-Command + */ + @Override + public synchronized String getDelete(DBTable table) + { + if (joins == null) { + // Default + return super.getDelete(table); + } + + // DELETE with Multiple-Table Syntax + // http://dev.mysql.com/doc/refman/5.7/en/delete.html + resetParamUsage(); + StringBuilder buf = new StringBuilder("DELETE "); + buf.append(table.getAlias()); + addFrom(buf); + addWhere(buf); + return buf.toString(); + } } // Properties