From: jemarch@gnu.org (Jose E. Marchesi)
To: emacs-orgmode@gnu.org
Subject: [BABEL] ob-rec.el and some questions
Date: Mon, 14 Feb 2011 22:07:29 +0100 [thread overview]
Message-ID: <877hd2uxym.fsf@gnu.org> (raw)
[-- Attachment #1: Type: text/plain, Size: 1851 bytes --]
Hi.
I have been playing a bit with org babel, the goal being to be able to
query a recfile[1] and insert the result as a rec table. Thanks to the
superb design of org-babel and the existing examples, I quickly wrote
the attached little hack.
The hack allows to query a rec file 'foo.rec' as follows:
#+begin_src rec :data hackers.rec :fields Name,Email :type Hacker
Papers = 'requested' && CreatedAt << '01 January 2011'
#+end_src
Where :data points to the recfile (or list of files), :fields is a
comma-separated list of fields (allowing subscripts) and :type selects
the record set where to make the query. :cmdline can also be used to
specify any other command line option to recsel. All parameters but
:data are optional.
The selection expression can be any expression allowed by recsel in the
-e command line option.
Of course you have to install the recutils for it to work.
It roughly works and I want to add more functionality, but due to my
lack of experience with org-babel I would like to ask some questions
before continuing working on it.
- Is there a way to execute empty code blocks? It would be quite common
to require all the records stored in a record set, e.g.
#+begin_src rec :data inventory.rec
#+end_src
C-cC-c in that block echoes "Local setup has been refreshed" and
nothing happens. A workaround would be to use a selection expression
that always evaluates to "true", such as:
#+begin_src rec :data inventory.rec
1
#+end_src
but it would be nice to avoid it.
- Is there a way to dinamically change the value of the :results
parameter in the org-babel-execute:rec function? I would like to add
a :template parameter containing a template for recfmt, and in that
case the default value "raw" would not be appropriate.
Thanks in advance :)
[1] http://www.gnu.org/software/recutils
[-- Attachment #2: ob-rec.el --]
[-- Type: application/emacs-lisp, Size: 2025 bytes --]
[-- Attachment #3: Type: text/plain, Size: 80 bytes --]
--
Jose E. Marchesi jemarch@gnu.org
GNU Project http://www.gnu.org
[-- Attachment #4: Type: text/plain, Size: 201 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next reply other threads:[~2011-02-14 21:12 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-02-14 21:07 Jose E. Marchesi [this message]
2011-02-15 18:35 ` [BABEL] ob-rec.el and some questions Eric Schulte
2011-02-15 19:29 ` Jose E. Marchesi
2011-02-15 20:35 ` Eric Schulte
2011-02-15 21:05 ` Jose E. Marchesi
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=877hd2uxym.fsf@gnu.org \
--to=jemarch@gnu.org \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).