From mboxrd@z Thu Jan 1 00:00:00 1970 From: tsd@tsdye.com (Thomas S. Dye) Subject: Re: [Babel][R] Inclusion of multi-line named code blocks in R code Date: Mon, 07 Oct 2013 05:42:27 -1000 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51995) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VTCx8-0007DP-Vs for emacs-orgmode@gnu.org; Mon, 07 Oct 2013 11:42:41 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VTCx2-0003KE-Px for emacs-orgmode@gnu.org; Mon, 07 Oct 2013 11:42:34 -0400 Received: from outbound-ss-1229.hostmonster.com ([66.147.241.79]:48738) by eggs.gnu.org with smtp (Exim 4.71) (envelope-from ) id 1VTCx2-0003Js-CW for emacs-orgmode@gnu.org; Mon, 07 Oct 2013 11:42:28 -0400 In-Reply-To: (Alexander Vorobiev's message of "Wed, 18 Sep 2013 19:43:09 -0500") 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: Alexander Vorobiev Cc: emacs-orgmode Hi Alex, I made a first draft of the Babel SQL documentation for Worg. See http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sql.html Please edit or augment as you see fit. I believe you need FSF papers to contribute to ob-sql.el. If you have those, then by all means, please add Netezza support and get the ball rolling on sessions. All the best, Tom Alexander Vorobiev writes: > Hi Tom, > > Unfortunately I can't have pure SQL output in my org files for two reasons: > > 1. The result set I am dealing with for this particular problem is about > 20000 records > 2. My SQL server (Netezza, "big data appliance") is not supported by > Babel-SQL. I configured sql-mode to work with Netezza but session-based SQL > is not supported by Babel either. I started adding support for SQL sessions > to ob-sql.el and it kind of works but the results I am getting are > inconsistent and only a small subset of header parameters is supported. Of > course I haven't tested is with any other database. I can share what I've > done if anybody is interested. > > Regards, > Alex > > > On Wed, Sep 18, 2013 at 5:27 PM, Thomas S. Dye wrote: > >> Aloha Alex, >> >> My work flow in this situation evaluates the SQL to create an Org-mode >> table, which serves as input to the R source code block. >> >> For me, seeing the SQL output in a table is a sanity check. >> >> hth, >> Tom >> >> Alexander Vorobiev writes: >> >> > I have R code which submits SQL statements to a database server. Since >> the >> > SQL is rather complex, I want to put it into a separate code block in >> order >> > to have proper formatting, syntax highlighting, etc: >> > >> > #+name: long-sql >> > #+begin_src sql >> > select * >> > from many, tables >> > where >> > complex_condition1 = 1, >> > complex_condition2 = 2 >> > #+end_src >> > >> > * Load the data to R session >> > #+begin_src R :session *R* :noweb yes >> > result <- submit_query('<>') >> > #+end_src >> > >> > Unfortunately, the R block doesn't work. When I open the file generated >> by >> > Babel, I see this: >> > >> > result <- submit_query('select * >> > result <- submit_query('from many, tables >> > etc >> > >> > instead of the one R submit_query call with my SQL statement as an >> > argument. Is there anything I can do to achieve that? >> > >> > Thanks >> > Alex >> > I have R code which submits SQL statements to a database server. Since >> > the SQL is rather complex, I want to put it into a separate code block >> > in order to have proper formatting, syntax highlighting, etc: >> > >> > #+name: long-sql >> > #+begin_src sql >> > select * >> > from many, tables >> > where >> > complex_condition1 = 1, >> > complex_condition2 = 2 >> > #+end_src >> > >> > * Load the data to R session >> > #+begin_src R :session *R* :noweb yes >> > result <- submit_query('<>') >> > #+end_src >> > >> > Unfortunately, the R block doesn't work. When I open the file >> > generated by Babel, I see this: >> > >> > result <- submit_query('select * >> > result <- submit_query('from many, tables >> > etc >> > >> > instead of the one R submit_query call with my SQL statement as an >> > argument. Is there anything I can do to achieve that? >> > >> > Thanks >> > Alex >> > >> > >> >> -- >> Thomas S. Dye >> http://www.tsdye.com >> > Hi Tom, > > Unfortunately I can't have pure SQL output in my org files for two > reasons: > > 1. The result set I am dealing with for this particular problem is > about 20000 records > 2. My SQL server (Netezza, "big data appliance") is not supported by > Babel-SQL. I configured sql-mode to work with Netezza but > session-based SQL is not supported by Babel either. I started adding > support for SQL sessions to ob-sql.el and it kind of works but the > results I am getting are inconsistent and only a small subset of > header parameters is supported. Of course I haven't tested is with any > other database. I can share what I've done if anybody is interested. > > Regards, > Alex > > On Wed, Sep 18, 2013 at 5:27 PM, Thomas S. Dye wrote: > > Aloha Alex, > > My work flow in this situation evaluates the SQL to create an > Org-mode > table, which serves as input to the R source code block. > > For me, seeing the SQL output in a table is a sanity check. > > hth, > Tom > > > > Alexander Vorobiev writes: > > > I have R code which submits SQL statements to a database server. > Since the > > SQL is rather complex, I want to put it into a separate code > block in order > > to have proper formatting, syntax highlighting, etc: > > > > #+name: long-sql > > #+begin_src sql > > select * > > from many, tables > > where > > complex_condition1 = 1, > > complex_condition2 = 2 > > #+end_src > > > > * Load the data to R session > > #+begin_src R :session *R* :noweb yes > > result <- submit_query('<>') > > #+end_src > > > > Unfortunately, the R block doesn't work. When I open the file > generated by > > Babel, I see this: > > > > result <- submit_query('select * > > result <- submit_query('from many, tables > > etc > > > > instead of the one R submit_query call with my SQL statement as > an > > argument. Is there anything I can do to achieve that? > > > > Thanks > > Alex > > I have R code which submits SQL statements to a database server. > Since > > the SQL is rather complex, I want to put it into a separate code > block > > in order to have proper formatting, syntax highlighting, etc: > > > > #+name: long-sql > > #+begin_src sql > > select * > > from many, tables > > where > > complex_condition1 = 1, > > complex_condition2 = 2 > > #+end_src > > > > * Load the data to R session > > #+begin_src R :session *R* :noweb yes > > result <- submit_query('<>') > > #+end_src > > > > Unfortunately, the R block doesn't work. When I open the file > > generated by Babel, I see this: > > > > result <- submit_query('select * > > result <- submit_query('from many, tables > > etc > > > > instead of the one R submit_query call with my SQL statement as > an > > argument. Is there anything I can do to achieve that? > > > > Thanks > > Alex > > > > > > > -- > Thomas S. Dye > http://www.tsdye.com > > -- Thomas S. Dye http://www.tsdye.com