Re: [Orgmode] [Babel] Patch for adding Microsoft's osql command-line utility

[Eric Schulte]

Hi Seb,

Thanks for the patch, this has just been applied.

-- Eric

Sébastien Vauban <address@hidden> writes:

> Hi Eric,
>
> Here a patch for osql from Microsoft.
>
> diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
> index 19c271d..9e6f06a 100644
> --- a/lisp/ob-sql.el
> +++ b/lisp/ob-sql.el
> @@ -66,6 +66,10 @@ This function is called by `org-babel-execute-src-block'."
>           (out-file (or (cdr (assoc :out-file params))
>                         (org-babel-temp-file "sql-out-")))
>           (command (case (intern engine)
> +                    ('msosql (format "osql %s -s \"\t\" -i %s -o %s"
> +                                     (or cmdline "")
> +                                     (org-babel-process-file-name in-file)
> +                                     (org-babel-process-file-name out-file)))
>                      ('mysql (format "mysql %s -e \"source %s\" > %s"
>                                      (or cmdline "")
>                                   (org-babel-process-file-name in-file)
>
> Best regards,
>   Seb