From mboxrd@z Thu Jan  1 00:00:00 1970
From: Gary Oberbrunner <garyo@oberbrunner.com>
Subject: MySQL params as global properties?
Date: Thu, 6 Oct 2016 18:07:13 -0400
Message-ID: <CAFChFyiZVeDSUxbQf2OFcHpdqn44pTgKw+f5oHpJrmE1nYtcpw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=94eb2c18f0bc180bc9053e3984d9
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:44475)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1bsGoz-0002Jk-AQ
	for emacs-orgmode@gnu.org; Thu, 06 Oct 2016 18:07:22 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1bsGou-0002o9-9R
	for emacs-orgmode@gnu.org; Thu, 06 Oct 2016 18:07:21 -0400
Received: from mail-yb0-x229.google.com ([2607:f8b0:4002:c09::229]:35934)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <garyo@oberbrunner.com>) id 1bsGot-0002mt-OV
	for emacs-orgmode@gnu.org; Thu, 06 Oct 2016 18:07:16 -0400
Received: by mail-yb0-x229.google.com with SMTP id 191so10364219ybv.3
	for <emacs-orgmode@gnu.org>; Thu, 06 Oct 2016 15:07:15 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: Orgmode Mailing List <emacs-orgmode@gnu.org>

--94eb2c18f0bc180bc9053e3984d9
Content-Type: text/plain; charset=UTF-8

I guess I've been out of the loop for a while. I used to have this at the
end of my org-mode SQL files:

#+PROPERTY: engine mysql
#+PROPERTY: dbhost xx.xx.xx.xx
#+PROPERTY: dbuser xxxxxx
#+PROPERTY: dbpassword xxxxxxxxx
#+PROPERTY: database xxxxxxxxxxxxx

But since I recently updated org-mode, these don't have any effect anymore.
In ob-sql I can see they're not getting passed to org-babel-execute:sql.

I tried a different form that I saw in the doc:

#+PROPERTY: header-args:sql :engine mysql
#+PROPERTY: header-args:sql :dbhost xxxxxxx
#+PROPERTY: header-args:sql :dbuser xxxxxxx
#+PROPERTY: header-args:sql :dbpassword xxxxxx
#+PROPERTY: header-args:sql :database xxxxxxxxxxxx

but that doesn't work either. Can anyone tell me the proper new-style form
for passing header args to all sql code blocks?

thanks!

-- 
Gary

--94eb2c18f0bc180bc9053e3984d9
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I guess I&#39;ve been out of the loop for a while. I used =
to have this at the end of my org-mode SQL files:<div><br clear=3D"all"><di=
v><div>#+PROPERTY: engine mysql</div><div>#+PROPERTY: dbhost xx.xx.xx.xx</d=
iv><div>#+PROPERTY: dbuser xxxxxx</div><div>#+PROPERTY: dbpassword xxxxxxxx=
x</div><div>#+PROPERTY: database xxxxxxxxxxxxx</div></div><div><br></div><d=
iv>But since I recently updated org-mode, these don&#39;t have any effect a=
nymore. In ob-sql I can see they&#39;re not getting passed to org-babel-exe=
cute:sql.</div><div><br></div><div>I tried a different form that I saw in t=
he doc:</div><div><br></div><div><div>#+PROPERTY: header-args:sql :engine m=
ysql</div><div>#+PROPERTY: header-args:sql :dbhost xxxxxxx</div><div>#+PROP=
ERTY: header-args:sql :dbuser xxxxxxx</div><div>#+PROPERTY: header-args:sql=
 :dbpassword xxxxxx</div><div>#+PROPERTY: header-args:sql :database xxxxxxx=
xxxxx</div><div><br></div></div><div>but that doesn&#39;t work either. Can =
anyone tell me the proper new-style form for passing header args to all sql=
 code blocks?</div><div><br></div><div>thanks!</div><div><br></div>-- <br><=
div class=3D"gmail_signature">Gary</div>
</div></div>

--94eb2c18f0bc180bc9053e3984d9--