Re: [O] sqlite3 in org-babel

2012-02-18 Thread Eric Schulte 
Daniel Clemente n142...@gmail.com writes:

 Have you tried using a sqlite code block?  See ob-sqlite.el

   I didn't notice there were both ob-sql and ob-sqlite. It would be
   useful to mention sqlite inside ob-sql.

Done.

   
   Perhaps they should be united?


I believe there were reasons for keeping them separate.  I'd rather not
combine them without a full overview of both code files.



   I still prefer ob-sql for sqlite because it lets me pass the
 parameter :init /dev/null. That makes it NOT load my ~/.sqliterc
 (where I have a very verbose .tables). ob-sqlite does not have
 :init and therefore always stuffs that output into the results.


From looking at the man page of sqlite, it seems you can do the same
with ob-sqlite.  Simply pass --init /dev/null to the sqlite command.
This could be done e.g. with something like

  (org-babel-sqlite3-command sqlite3 --init /dev/null)

Best,




 
 Daniel Clemente n142...@gmail.com writes:
 
  Hi,
 org-babel works well with sqlite3 if you add this (which I propose for 
  inclusion):
 


-- 
Eric Schulte
http://cs.unm.edu/~eschulte/

Re: [O] sqlite3 in org-babel

2012-02-16 Thread Daniel Clemente 

 Have you tried using a sqlite code block?  See ob-sqlite.el

  I didn't notice there were both ob-sql and ob-sqlite. It would be useful to 
mention sqlite inside ob-sql.
  Perhaps they should be united?


  I still prefer ob-sql for sqlite because it lets me pass the parameter :init 
/dev/null. That makes it NOT load my ~/.sqliterc (where I have a very verbose 
.tables). ob-sqlite does not have :init and therefore always stuffs that 
output into the results.



 
 Daniel Clemente n142...@gmail.com writes:
 
  Hi,
 org-babel works well with sqlite3 if you add this (which I propose for 
  inclusion):

Re: [O] sqlite3 in org-babel

2012-02-15 Thread Eric Schulte 
Hi Daniel,

Have you tried using a sqlite code block?  See ob-sqlite.el

Best,

Daniel Clemente n142...@gmail.com writes:

 Hi,
org-babel works well with sqlite3 if you add this (which I propose for 
 inclusion):

 -
 diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
 index 3f7882c..a59db7a 100644
 --- a/lisp/ob-sql.el
 +++ b/lisp/ob-sql.el
 @@ -82,6 +82,10 @@ This function is called by `org-babel-execute-src-block'.
   (org-babel-process-file-name in-file)
   (org-babel-process-file-name out-file)
   (or cmdline )))
 +('sqlite3 (format sqlite3 %s  %s  %s
 +(or cmdline )
 + (org-babel-process-file-name in-file)
 + (org-babel-process-file-name out-file)))
  (t (error no support for the %s sql engine engine)
  (with-temp-file in-file
(insert (org-babel-expand-body:sql body params)))

 -



Then you can use it in this way:
 #+BEGIN_SRC sql :cmdline -header -list ~/pruebas.sqlite3 :engine sqlite3
 select * from web_categorias;
 #+END_SRC

It's very useful! Org's results table is more interactive than the one you 
 can see in sql-mode (M-x sql-sqlite).



By the way, the code in ob-sql.el attempts to remove final newlines. I use 
 (setq require-final-newline 'ask) and I am being asked about the temporary 
 buffer, which is wrong. So I also propose this patch:

 
 diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
 index 3f7882c..8df0d98 100644
 --- a/lisp/ob-sql.el
 +++ b/lisp/ob-sql.el
 @@ -107,7 +107,8 @@ This function is called by `org-babel-execute-src-block'.
   (delete-char 1)
   (goto-char (point-max))
   (forward-char -1))
 -   (write-file out-file))
 +   (let ((require-final-newline nil))
 + (write-file out-file)))
   (org-table-import out-file '(16))
   (org-babel-reassemble-table
(mapcar (lambda (x)

 



   Greetings,

 Daniel


-- 
Eric Schulte
http://cs.unm.edu/~eschulte/

[O] sqlite3 in org-babel

2012-02-10 Thread Daniel Clemente 

Hi,
   org-babel works well with sqlite3 if you add this (which I propose for 
inclusion):

-
diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
index 3f7882c..a59db7a 100644
--- a/lisp/ob-sql.el
+++ b/lisp/ob-sql.el
@@ -82,6 +82,10 @@ This function is called by `org-babel-execute-src-block'.
(org-babel-process-file-name in-file)
(org-babel-process-file-name out-file)
(or cmdline )))
+('sqlite3 (format sqlite3 %s  %s  %s
+(or cmdline )
+   (org-babel-process-file-name in-file)
+   (org-babel-process-file-name out-file)))
 (t (error no support for the %s sql engine engine)
 (with-temp-file in-file
   (insert (org-babel-expand-body:sql body params)))

-



   Then you can use it in this way:
#+BEGIN_SRC sql :cmdline -header -list ~/pruebas.sqlite3 :engine sqlite3
select * from web_categorias;
#+END_SRC

   It's very useful! Org's results table is more interactive than the one you 
can see in sql-mode (M-x sql-sqlite).



   By the way, the code in ob-sql.el attempts to remove final newlines. I use 
(setq require-final-newline 'ask) and I am being asked about the temporary 
buffer, which is wrong. So I also propose this patch:


diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
index 3f7882c..8df0d98 100644
--- a/lisp/ob-sql.el
+++ b/lisp/ob-sql.el
@@ -107,7 +107,8 @@ This function is called by `org-babel-execute-src-block'.
(delete-char 1)
(goto-char (point-max))
(forward-char -1))
- (write-file out-file))
+ (let ((require-final-newline nil))
+   (write-file out-file)))
(org-table-import out-file '(16))
(org-babel-reassemble-table
 (mapcar (lambda (x)





  Greetings,

Daniel