From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id KI8bN9ll4GBvcQAAgWs5BA (envelope-from ) for ; Sat, 03 Jul 2021 15:27:53 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id oAq0Mtll4GAFYAAAbx9fmQ (envelope-from ) for ; Sat, 03 Jul 2021 13:27:53 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id E41921B692 for ; Sat, 3 Jul 2021 15:27:52 +0200 (CEST) Received: from localhost ([::1]:51706 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lzfgU-0003xF-UT for larch@yhetil.org; Sat, 03 Jul 2021 09:27:50 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:33230) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lzffj-0003x5-BX for emacs-orgmode@gnu.org; Sat, 03 Jul 2021 09:27:03 -0400 Received: from mail-pl1-x62b.google.com ([2607:f8b0:4864:20::62b]:44576) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1lzfff-0008Va-2g for emacs-orgmode@gnu.org; Sat, 03 Jul 2021 09:27:02 -0400 Received: by mail-pl1-x62b.google.com with SMTP id h6so6220889plf.11 for ; Sat, 03 Jul 2021 06:26:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=utec-edu-pe.20150623.gappssmtp.com; s=20150623; h=from:to:subject:references:date:in-reply-to:message-id:user-agent :mime-version; bh=18Rrd8wSVrGYUMRCiuFzKrdIJEc2YPf5AJWA3uha61Q=; b=nhxpmKDQt1T/IH+bRYhXkhV6X3+RXn67HVFnm6U59BKhEYUIraW0+SWP5XBAfOan4D bC4Ai8UwVQn6DXj/ZbEcM7L67U7rZyQ9h1Vi0MNXODYhpet61B2Sr69TP7I8S/CXxcL5 WMqUOkK14kOre9Mc8TFsffwI6eGbVOCg+Y4x45za4CYduhFqrfOVHBSgwEV7E32b8CF2 8vejTQ/AGunrAB/HUI0KkiltdREtOtOyGnXYuwaw3CcTORRA4DpsVcWgtWt6IZhpElEo y2BGEjcvZpCXCaymNzQHVJ+2vZ5xYlQZQBAJXl1TCTOx0I/czU7kCXVT1MfHCl8Jko1H tqZw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:references:date:in-reply-to :message-id:user-agent:mime-version; bh=18Rrd8wSVrGYUMRCiuFzKrdIJEc2YPf5AJWA3uha61Q=; b=kZ9F30LMo3nXjo0AfTrdgyiFRbFkY7/TtfdjDo1lKg7wL8POZChv9Fz+0YMrqMiZfn HX2vvfwW4K+0XPOTVn6L9PaOiQEApALsnDgtbaziG45obNs80bS3INpEFXxd0XemhK0W Dsw2pLUg5KerCgf8KCFRwNVDYfrllCucskhQTwUpylIGsuGHjO2kP1Wd/gLewGDWg08R MZ53zwQ17bZuE6fDwhr3efIIlr3hi/j5lAo0fNNSVK5q+5Jn7VolFoh3z77vhcGK1PkV YGqdwscYbBqCSEpK++FDo4Oh23Xp34ulMpmQr0b+CtjcR9WWfxbb1xy6/Ja9xRIrH9ZW cpAg== X-Gm-Message-State: AOAM5326igw3QO2klsGkjYDIXLcLLfGnVKZnNNsBLq20wUDgoIPUI7MJ 04m1JcwTJBpbHvGWPxBAHTIiBEwBNs+qS2lo+C979okZtGuAeL/bIr2dTwOK517rieEOgKppiRO Wy2icXvbDVSfG16d6iEc= X-Google-Smtp-Source: ABdhPJz/02JV41GJB7CV9hLBTlk2qf/eREFYgTspBaHrv3272K751GbLwarDwGJw6qejD5tJqcbRfA== X-Received: by 2002:a17:90a:390d:: with SMTP id y13mr4646686pjb.133.1625318816609; Sat, 03 Jul 2021 06:26:56 -0700 (PDT) Received: from r1 ([190.239.232.58]) by smtp.gmail.com with ESMTPSA id u7sm7217217pgl.30.2021.07.03.06.26.55 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 03 Jul 2021 06:26:56 -0700 (PDT) From: Rodrigo Morales To: emacs-orgmode@gnu.org Subject: Re: [PATCH] Add support for prologue and epilogue in SQL code blocks References: <87h7hb51c8.fsf@utec.edu.pe> Date: Sat, 03 Jul 2021 08:26:47 -0500 In-Reply-To: <87h7hb51c8.fsf@utec.edu.pe> (Rodrigo Morales's message of "Sat, 03 Jul 2021 02:00:07 -0500") Message-ID: <87mtr334vc.fsf@utec.edu.pe> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Received-SPF: pass client-ip=2607:f8b0:4864:20::62b; envelope-from=rodrigo.morales@utec.edu.pe; helo=mail-pl1-x62b.google.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1625318873; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=18Rrd8wSVrGYUMRCiuFzKrdIJEc2YPf5AJWA3uha61Q=; b=VCquTKcJDMiXiAvdGo/3hnjesI4lAw0ToiLOCLG0+uPFMkrV7FkmyQgEdD418jTF2phFIw iwmJZrCyliUJYkYbuDn1zRTwbLZpzs0Q5tNkN1cCkjYRGhr6mRuem0ee3f2fHAj/o1x/Ek ONDerrbWbLWtyDFBJYVr0WyiaUkLHOqrcheR1kNpTzs5Hj+BgR8f+3QKv51zVFCXCrABSs 7dDgHGQDpjLjCR3O1JnYU6kvpQLSNiOWlP7MBLKSVHmOrEYiByJyeuhIm7rbpOBMT3vzoQ RiZpsXYL4/Z4th4ukYiDQ1SWhD8I2F3cVXWyYNmutywY8qnD4HCKEufIw6AZqQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1625318873; a=rsa-sha256; cv=none; b=eIii//c78JgRz9pM0pLB9bE1+YylXLQWzAxwMCLaTY/aQH8JQGO3AVggp9ciDkU3VnX2K/ 7wuKiwPIxWsshNdKux7r+qq7QswuxsaTZpzbqf8Jms4zPegWeLA5auNvWAVkqHkYQNTHY4 DnyuDCMySrR+YeLhAp8paA3PO65R0xLoTB+GVnf/DvaOMB2JRX3s+RmS8xurjR6NiMPUwI /IzkmW5WU0aN8PNBvf4EoDu/Yq2zQUSHh6Y95nCU3nRNptulQT++uS7fcMdpW8Z6LO5d+T AF0UEH5b0M3G7DWS6XzddF1KIQ2sc78rgomTiG5tyRuDLnG+HccWA8wAKMHFpg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=utec-edu-pe.20150623.gappssmtp.com header.s=20150623 header.b=nhxpmKDQ; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -2.61 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=utec-edu-pe.20150623.gappssmtp.com header.s=20150623 header.b=nhxpmKDQ; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: E41921B692 X-Spam-Score: -2.61 X-Migadu-Scanner: scn0.migadu.com X-TUID: TKe1Q+fUBBeZ --=-=-= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Apparently, A ">" character was accidentally inserted in the first line of the patch. I'm attaching the patch again. --=20 La informaci=F3n contenida en este e-mail y sus anexos es confidencial,=20 privilegiada y est=E1 dirigida exclusivamente a su destinatario, en=20 consecuencia, solo puede ser utilizada por aquel. Si usted no es el=20 destinatario original, no deber=E1 examinar, usar, copiar o distribuir este= =20 mensaje o la informaci=F3n que contiene. Si lo recibe por error, por favor= =20 reenv=EDelo a la persona que se lo envi=F3 y elim=EDnelo. Cualquier retenci= =F3n o=20 uso total o parcial no autorizada de este mensaje est=E1 estrictamente=20 prohibida y sancionada por ley. --=-=-= Content-Type: text/x-patch Content-Disposition: attachment; filename=0001-lisp-ob-sql.el-Add-support-for-prologue-and-epilogue.patch >From ed083bed92dcac258c9253cd34485c6cfe91eb6c Mon Sep 17 00:00:00 2001 From: Rodrigo Morales Date: Sat, 3 Jul 2021 01:53:44 -0500 Subject: [PATCH] lisp/ob-sql.el: Add support for :prologue and :epilogue --- lisp/ob-sql.el | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el index 6eae5bb67..667bada31 100644 --- a/lisp/ob-sql.el +++ b/lisp/ob-sql.el @@ -93,8 +93,15 @@ (defun org-babel-expand-body:sql (body params) "Expand BODY according to the values of PARAMS." - (org-babel-sql-expand-vars - body (org-babel--get-vars params))) + (let ((prologue (cdr (assq :prologue params))) + (epilogue (cdr (assq :epilogue params)))) + (mapconcat 'identity + (list + prologue + (org-babel-sql-expand-vars + body (org-babel--get-vars params)) + epilogue) + "\n"))) (defun org-babel-edit-prep:sql (info) "Set `sql-product' in Org edit buffer. -- 2.32.0 --=-=-=--