Re: [O] [Orgmode] Babel sql code block issue and patch proposal

[Alain Clément]

Hi Eric,

Thanks for your prompt answer! Actually, it doesn't work since mysql interprets backslashes as options, even between quotes. The value of my `org-babel-temporary-directory' is "/var/folders/9E/9EMu+g0oHBSrq-h9sX6i1U+++TM/-Tmp-/babel-86766893", but "+"'s are escaped with a backslash at some stage.

Thanks,

- Alain

2011/3/3 Eric Schulte <address@hidden>

Hi Alain,

Does the following alternative fix work for you?

#+begin_src diff
 Changes in HEAD
         Modified lisp/ob-sql.el
 diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
 index 364070e..604d444 100644
 --- a/lisp/ob-sql.el
 +++ b/lisp/ob-sql.el
 @@ -71,7 +71,7 @@ This function is called by `org-babel-execute-src-block'."
                                       (or cmdline "")
                                       (org-babel-process-file-name in-file)
                                       (org-babel-process-file-name out-file)))
 -                    ('mysql (format "mysql %s -e \"source %s\" > %s"
 +                    ('mysql (format "mysql %s -e 'source %s' > %s"
                                      (or cmdline "")
                                     (org-babel-process-file-name in-file)
                                     (org-babel-process-file-name out-file)))
#+end_src

Also, just out of curiosity would you mind sharing an example result of
`org-babel-temporary-directory' which contains backslashes?

Thanks -- Eric

Alain Clément <address@hidden> writes:

> Hi everyone,
>
> The =org-babel-temp-file= string seems to be escaped with backslashes on
> some platforms (like MacOSX), which is not very appreciated by the =mysql
> -e= command. I suggest the following patch for ="" (Org-mode Version
> 7.4 (release_7.4.590.g85d4d)):
>
> 74c74
> <                     ('mysql (format "mysql %s < %s > %s"
> ---
>>                     ('mysql (format "mysql %s -e \"source %s\" > %s"
>
> Best regards,
> -- Alain
>
> --
>
>
>
> Alain Clément
> Dr ès sc. mathématiques
>
> Université de Lausanne
> Quartier UNIL-Centre
> Bâtiment Unicentre
> Bureau 339
> CH-1015 Lausanne
>
> T. +41 21 692 20 36 (direct)
> T. +41 21 692 20 60 (secrétariat)
>
> address@hidden

--

Alain Clément
Dr ès sc. mathématiques

Université de Lausanne
Quartier UNIL-Centre
Bâtiment Unicentre
Bureau 339
CH-1015 Lausanne

T. +41 21 692 20 36 (direct)
T. +41 21 692 20 60 (secrétariat)

address@hidden