contrib/babel/lisp/org-babel-table.el

   1 ;;; org-babel-table.el --- integration for calling org-babel functions from tables
   2
   3 ;; Copyright (C) 2009 Eric Schulte
   4
   5 ;; Author: Eric Schulte
   6 ;; Keywords: literate programming, reproducible research
   7 ;; Homepage: http://orgmode.org
   8 ;; Version: 0.01
   9
  10 ;;; License:
  11
  12 ;; This program is free software; you can redistribute it and/or modify
  13 ;; it under the terms of the GNU General Public License as published by
  14 ;; the Free Software Foundation; either version 3, or (at your option)
  15 ;; any later version.
  16 ;;
  17 ;; This program is distributed in the hope that it will be useful,
  18 ;; but WITHOUT ANY WARRANTY; without even the implied warranty of
  19 ;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  20 ;; GNU General Public License for more details.
  21 ;;
  22 ;; You should have received a copy of the GNU General Public License
  23 ;; along with GNU Emacs; see the file COPYING.  If not, write to the
  24 ;; Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
  25 ;; Boston, MA 02110-1301, USA.
  26
  27 ;;; Commentary:
  28
  29 ;; Should allow calling functions from org-mode tables using the
  30 ;; function `sbe' as so...
  31 ;;
  32 ;; #+begin_src emacs-lisp :results silent
  33 ;; (defun fibbd (n) (if (< n 2) 1 (+ (fibbd (- n 1)) (fibbd (- n 2)))))
  34 ;; #+end_src
  35 ;;
  36 ;; #+srcname: fibbd
  37 ;; #+begin_src emacs-lisp :var n=2 :results silent
  38 ;; (fibbd n)
  39 ;; #+end_src
  40 ;;
  41 ;; | original | fibbd  |
  42 ;; |----------+--------|
  43 ;; |        0 |        |
  44 ;; |        1 |        |
  45 ;; |        2 |        |
  46 ;; |        3 |        |
  47 ;; |        4 |        |
  48 ;; |        5 |        |
  49 ;; |        6 |        |
  50 ;; |        7 |        |
  51 ;; |        8 |        |
  52 ;; |        9 |        |
  53 ;; #+TBLFM: $2='(sbe 'fibbd (n $1))
  54
  55 ;;; Code:
  56 (require 'org-babel)
  57
  58 (defun org-babel-table-truncate-at-newline (string)
  59   (if (and (stringp string) (string-match "[\n\r]" string))
  60       (concat (substring string 0 (match-beginning 0)) "...")
  61     string))
  62
  63 (defmacro sbe (source-block &rest variables)
  64   "Return the results of calling SOURCE-BLOCK assigning every
  65 variable in VARIABLES.  Each element of VARIABLES should be a two
  66 element list, whose first element is the name of the variable and
  67 second element is a string of its value.  The following call to
  68 `sbe' would be equivalent to the following source code block.
  69
  70  (sbe 'source-block (n $2) (m 3))
  71
  72 #+begin_src emacs-lisp :var results=source-block(n=val_at_col_2, m=3) :results silent
  73 results
  74 #+end_src
  75
  76 NOTE: by default string variable names are interpreted as
  77 references to source-code blocks, to force interpretation of a
  78 cell's value as a string, prefix the identifier with two \"$\"s
  79 rather than a single \"$\" (i.e. \"$$2\" instead of \"$2\" in the
  80 example above."
  81   (let ((variables (mapcar
  82                     (lambda (var)
  83                       (if (and (= 3 (length var)) (eq (second var) '$))
  84                           (list (car var) (format "\"%s\"" (last var)))
  85                         var))
  86                     variables)))
  87     (unless (stringp source-block) (setq source-block (symbol-name source-block)))
  88     (org-babel-table-truncate-at-newline ;; org-table cells can't be multi-line
  89      (if (and source-block (> (length source-block) 0))
  90          (let ((params
  91                 (eval `(org-babel-parse-header-arguments
  92                         (concat ":var results="
  93                                 ,source-block
  94                                 "("
  95                                 (mapconcat (lambda (var-spec)
  96                                              (format "%S=%s" (first var-spec) (second var-spec)))
  97                                            ',variables ", ")
  98                                 ")")))))
  99            (org-babel-execute-src-block
 100             nil (list "emacs-lisp" "results"
 101                       (org-babel-merge-params '((:results . "silent")) params))))
 102        ""))))
 103
 104 (provide 'org-babel-table)
 105 ;;; org-babel-table.el ends here