From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Schulte Subject: Re: Org-mode as a metalanguage: calling SQL "functions" Date: Mon, 01 Apr 2013 19:45:29 -0600 Message-ID: <87y5d1itxx.fsf@gmail.com> References: <87vc85raoh.fsf@ericabrahamsen.net> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Return-path: Received: from eggs.gnu.org ([208.118.235.92]:59856) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UMqLH-0007k9-4O for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 21:49:02 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UMqLF-0000fK-9K for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 21:48:55 -0400 Received: from mail-pa0-f48.google.com ([209.85.220.48]:40297) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UMqLE-0000fE-Vk for emacs-orgmode@gnu.org; Mon, 01 Apr 2013 21:48:53 -0400 Received: by mail-pa0-f48.google.com with SMTP id lj1so1549pab.21 for ; Mon, 01 Apr 2013 18:48:52 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Eric Abrahamsen Cc: emacs-orgmode@gnu.org --=-=-= Content-Type: text/plain Eric Abrahamsen writes: > Gary Oberbrunner writes: > >> It seems like you can define "procedures" in org-mode and call them >> from elsewhere, with args. >> But I'm not sure how well-defined that process is; the documentation >> is not completely perfect yet I think. Here's one thing I'm trying >> that seems not to work. >> >> I define a "procedure" as a named ref called recorddate with two args, >> ver and order. The idea is I could later call that with different >> values of those args. >> >> #+NAME: recorddate(order="desc") >> #+BEGIN_SRC sql :exports none :colnames no :results scalar >> select Event.CreatedAt from Event join MachineInfo as MI on >> Event.MachineInfoId=MI.Id >> where Event.CreatedAt is not NULL order by CreatedAt $order limit 1; >> #+END_SRC sql >> >> (BTW, I really like how $ vars are substituted into SQL. Nice.) But >> when I try to call it like this: >> >> * earliest record is call_recorddate(ver="'.'", order="asc") >> or like this: >> #+CALL: recorddate(ver="'.'", order="asc") >> >> and I try to export as LaTeX (or anything), I get >> org-babel-ref-resolve: Reference 'recorddate' not found in this buffer >> >> Is this supposed to work? > Yes, your example should work. From the "Evaluating code blocks" section of the Org-mode manual. ,---- | It is also possible to evaluate named code blocks from anywhere in an | Org mode buffer or an Org mode table. Live code blocks located in the | current Org mode buffer or in the "Library of Babel" (see *note Library | of Babel::) can be executed. Named code blocks can be executed with a | separate '#+CALL:' line or inline within a block of text. `---- There is no need to load code blocks in the same buffer into the library of babel. This example works for me evaluating code blocks in the same buffer using call lines. --=-=-= Content-Type: text/x-org Content-Disposition: inline; filename=in-buffer-execution-example.org #+Title: Call Example #+name: example-block #+begin_src sh :var input="" echo "input is $input" #+end_src Here's a simple call using a named argument. #+call: example-block(input="foo") #+RESULTS: example-block(input="foo") : input is foo It also works with a positional argument. #+call: example-block("bar") #+RESULTS: example-block("bar") : input is bar --=-=-= Content-Type: text/plain When I export this to e.g., html I get the following. --=-=-= Content-Type: text/html Content-Disposition: inline; filename=example.html Call Example

Call Example

echo "input is $input"

Here's a simple call using a named argument. 

input is foo

It also works with a positional argument. 

input is bar

Date: 2013-04-01T19:39-0600

Author:

Org version 7.9.3f with Emacs version 24

Validate XHTML 1.0
--=-=-= Content-Type: text/plain The call lines are replaced with their results as part of the export process. If the above doesn't work for you, then I imagine something is wrong with your install. -- Eric Schulte http://cs.unm.edu/~eschulte --=-=-=--