Re: Org-mode as a metalanguage: calling SQL "functions"

[Eric Abrahamsen <eric@ericabrahamsen.net>]

Gary Oberbrunner <garyo@oberbrunner.com> 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?

You're supposed to "load" named blocks before you can call them with
#+CALL, etc. I'm a little surprised that it doesn't automatically find
blocks defined in the same buffer, but calling C-c C-v i (ie
org-babel-lob-ingest) and loading the present file should make
"recorddate" available for calling.

E