* Feature request: results type json @ 2018-03-28 20:42 Ag Ibragimov 2018-03-28 21:05 ` John Kitchin 0 siblings, 1 reply; 5+ messages in thread From: Ag Ibragimov @ 2018-03-28 20:42 UTC (permalink / raw) To: emacs-orgmode Sorry, I don't know the best medium to convey ideas and I'm afraid not qualified (familiar with org-mode codebase) to submit a PR for this. I wonder how difficult would be to add the possibility to have babel src block results to be rendered as json? Basically a new result type https://orgmode.org/manual/results.html#results Thank you. ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Feature request: results type json 2018-03-28 20:42 Feature request: results type json Ag Ibragimov @ 2018-03-28 21:05 ` John Kitchin 2018-03-28 21:19 ` agzam.ibragimov 0 siblings, 1 reply; 5+ messages in thread From: John Kitchin @ 2018-03-28 21:05 UTC (permalink / raw) To: Ag Ibragimov; +Cc: org-mode-email [-- Attachment #1: Type: text/plain, Size: 833 bytes --] Does this do what you want: #+BEGIN_SRC emacs-lisp :wrap json (json-encode '((type . "text"))) #+END_SRC #+RESULTS: #+BEGIN_json {"type":"text"} #+END_json John ----------------------------------- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu On Wed, Mar 28, 2018 at 1:42 PM, Ag Ibragimov <agzam.ibragimov@gmail.com> wrote: > > Sorry, I don't know the best medium to convey ideas and I'm afraid not > qualified (familiar with org-mode codebase) to submit a PR for this. > I wonder how difficult would be to > add the possibility to have babel src block results to be rendered as > json? > Basically a new result type https://orgmode.org/manual/ > results.html#results > > Thank you. > > [-- Attachment #2: Type: text/html, Size: 1680 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Feature request: results type json 2018-03-28 21:05 ` John Kitchin @ 2018-03-28 21:19 ` agzam.ibragimov 2018-03-28 22:30 ` John Kitchin 0 siblings, 1 reply; 5+ messages in thread From: agzam.ibragimov @ 2018-03-28 21:19 UTC (permalink / raw) To: John Kitchin; +Cc: org-mode-email [-- Attachment #1: Type: text/plain, Size: 1097 bytes --] Hmm, it works for emacs-lisp, however I specifically wanted to use it with ob-sql, and can't find a way. On Wed, Mar 28, 2018 at 2:05 PM John Kitchin <jkitchin@andrew.cmu.edu> wrote: > Does this do what you want: > > #+BEGIN_SRC emacs-lisp :wrap json > (json-encode '((type . "text"))) > #+END_SRC > > #+RESULTS: > #+BEGIN_json > {"type":"text"} > #+END_json > > John > > ----------------------------------- > Professor John Kitchin > Doherty Hall A207F > Department of Chemical Engineering > Carnegie Mellon University > Pittsburgh, PA 15213 > 412-268-7803 <(412)%20268-7803> > @johnkitchin > http://kitchingroup.cheme.cmu.edu > > > On Wed, Mar 28, 2018 at 1:42 PM, Ag Ibragimov <agzam.ibragimov@gmail.com> > wrote: > >> >> Sorry, I don't know the best medium to convey ideas and I'm afraid not >> qualified (familiar with org-mode codebase) to submit a PR for this. >> I wonder how difficult would be to >> add the possibility to have babel src block results to be rendered as >> json? >> Basically a new result type >> https://orgmode.org/manual/results.html#results >> >> Thank you. >> >> > [-- Attachment #2: Type: text/html, Size: 2236 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Feature request: results type json 2018-03-28 21:19 ` agzam.ibragimov @ 2018-03-28 22:30 ` John Kitchin 2018-03-29 3:44 ` stardiviner 0 siblings, 1 reply; 5+ messages in thread From: John Kitchin @ 2018-03-28 22:30 UTC (permalink / raw) To: Ag Ibragimov; +Cc: org-mode-email [-- Attachment #1: Type: text/plain, Size: 2288 bytes --] If you can get ob-sql to output data in tabular form (if it is not nested) you can do something like this: #+name: tabular #+BEGIN_SRC python :results value d = [['type', 'test'], ['format', 'json']] return d #+END_SRC #+RESULTS: tabular | type | test | | format | json | #+BEGIN_SRC emacs-lisp :var data=tabular :wrap json (json-encode data) #+END_SRC #+RESULTS: #+BEGIN_json {"type":["test"],"format":["json"]} #+END_json If the data is nested, then you can see if there is a way to output a lisp readable string: #+name: my-data #+BEGIN_SRC python :results output print('((type . test) (format . json))') #+END_SRC #+RESULTS: my-data : ((type . test) (format . json)) #+BEGIN_SRC emacs-lisp :var data=my-data :wrap json (json-encode (read data)) #+END_SRC #+RESULTS: #+BEGIN_json {"type":"test","format":"json"} #+END_json John ----------------------------------- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu On Wed, Mar 28, 2018 at 2:19 PM, <agzam.ibragimov@gmail.com> wrote: > Hmm, it works for emacs-lisp, however I specifically wanted to use it with > ob-sql, and can't find a way. > > On Wed, Mar 28, 2018 at 2:05 PM John Kitchin <jkitchin@andrew.cmu.edu> > wrote: > >> Does this do what you want: >> >> #+BEGIN_SRC emacs-lisp :wrap json >> (json-encode '((type . "text"))) >> #+END_SRC >> >> #+RESULTS: >> #+BEGIN_json >> {"type":"text"} >> #+END_json >> >> John >> >> ----------------------------------- >> Professor John Kitchin >> Doherty Hall A207F >> Department of Chemical Engineering >> Carnegie Mellon University >> Pittsburgh, PA 15213 >> 412-268-7803 <(412)%20268-7803> >> @johnkitchin >> http://kitchingroup.cheme.cmu.edu >> >> >> On Wed, Mar 28, 2018 at 1:42 PM, Ag Ibragimov <agzam.ibragimov@gmail.com> >> wrote: >> >>> >>> Sorry, I don't know the best medium to convey ideas and I'm afraid not >>> qualified (familiar with org-mode codebase) to submit a PR for this. >>> I wonder how difficult would be to >>> add the possibility to have babel src block results to be rendered as >>> json? >>> Basically a new result type https://orgmode.org/manual/ >>> results.html#results >>> >>> Thank you. >>> >>> >> [-- Attachment #2: Type: text/html, Size: 4661 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Feature request: results type json 2018-03-28 22:30 ` John Kitchin @ 2018-03-29 3:44 ` stardiviner 0 siblings, 0 replies; 5+ messages in thread From: stardiviner @ 2018-03-29 3:44 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 3452 bytes --] You can wrap result value into another language src block like this: #+begin_src ruby :results code :wrap src shell puts "echo 'hello'" #+end_src #+RESULTS: #+begin_src shell echo 'hello' #+end_src Same for JSON by changed `:wrap src shell` into `wrap json`. But you need the value is JSON. Isaw you mentioned want ob-sql support JSON return type. I guess it need to be implemented in ob-sql.Or you can use `:post` to convert result to JSON. Or use `advice-add` to add a function to convert result to JSON. On 03/29/2018 06:30 AM, John Kitchin wrote: > If you can get ob-sql to output data in tabular form (if it is not > nested) you can do something like this: > > #+name: tabular > #+BEGIN_SRC python :results value > d = [['type', 'test'], ['format', 'json']] > return d > #+END_SRC > > #+RESULTS: tabular > | type | test | > | format | json | > > #+BEGIN_SRC emacs-lisp :var data=tabular :wrap json > (json-encode data) > #+END_SRC > > #+RESULTS: > #+BEGIN_json > {"type":["test"],"format":["json"]} > #+END_json > > If the data is nested, then you can see if there is a way to output a > lisp readable string: > > #+name: my-data > #+BEGIN_SRC python :results output > print('((type . test) (format . json))') > #+END_SRC > > #+RESULTS: my-data > : ((type . test) (format . json)) > > > > #+BEGIN_SRC emacs-lisp :var data=my-data :wrap json > (json-encode (read data)) > #+END_SRC > > #+RESULTS: > #+BEGIN_json > {"type":"test","format":"json"} > #+END_json > > > > John > > ----------------------------------- > Professor John Kitchin > Doherty Hall A207F > Department of Chemical Engineering > Carnegie Mellon University > Pittsburgh, PA 15213 > 412-268-7803 > @johnkitchin > http://kitchingroup.cheme.cmu.edu > > > On Wed, Mar 28, 2018 at 2:19 PM, <agzam.ibragimov@gmail.com > <mailto:agzam.ibragimov@gmail.com>> wrote: > > Hmm, it works for emacs-lisp, however I specifically wanted to use > it with ob-sql, and can't find a way. > > On Wed, Mar 28, 2018 at 2:05 PM John Kitchin > <jkitchin@andrew.cmu.edu <mailto:jkitchin@andrew.cmu.edu>> wrote: > > Does this do what you want: > > #+BEGIN_SRC emacs-lisp :wrap json > (json-encode '((type . "text"))) > #+END_SRC > > #+RESULTS: > #+BEGIN_json > {"type":"text"} > #+END_json > > John > > ----------------------------------- > Professor John Kitchin > Doherty Hall A207F > Department of Chemical Engineering > Carnegie Mellon University > Pittsburgh, PA 15213 > 412-268-7803 <tel:%28412%29%20268-7803> > @johnkitchin > http://kitchingroup.cheme.cmu.edu > <http://kitchingroup.cheme.cmu.edu> > > > On Wed, Mar 28, 2018 at 1:42 PM, Ag Ibragimov > <agzam.ibragimov@gmail.com <mailto:agzam.ibragimov@gmail.com>> > wrote: > > > Sorry, I don't know the best medium to convey ideas and > I'm afraid not > qualified (familiar with org-mode codebase) to submit a PR > for this. > I wonder how difficult would be to > add the possibility to have babel src block results to be > rendered as > json? > Basically a new result type > https://orgmode.org/manual/results.html#results > <https://orgmode.org/manual/results.html#results> > > Thank you. > > > [-- Attachment #2: Type: text/html, Size: 10526 bytes --] ^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2018-03-29 3:44 UTC | newest] Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed) -- links below jump to the message on this page -- 2018-03-28 20:42 Feature request: results type json Ag Ibragimov 2018-03-28 21:05 ` John Kitchin 2018-03-28 21:19 ` agzam.ibragimov 2018-03-28 22:30 ` John Kitchin 2018-03-29 3:44 ` stardiviner
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).