emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

blob 0965b8edf7f76ca130e841925643ded5772875cd 555 bytes (raw)
name: testing/examples/ob-sqlite-test.org 	 # note: path name is non-authoritative(*)

#+Title: a collection of examples for ob-sqlite tests
#+OPTIONS: ^:nil
* Simple tests
  :PROPERTIES:
  :ID:       baa7fb30-28ec-4ac4-abef-0ad47b093332
  :END:

#+name: test_table1
| "Mr Test A. Sql" | Minister for Science, Eternal Happiness, and Finance |

#+begin_src sqlite :db /tmp/test.db :var tb=test_table1
  drop table if exists TestTable;
  create table TestTable(person, job);
  .mode csv TestTable
  .import $tb TestTable
  select * from TestTable;
#+end_src

#+RESULTS:
| Mr Test A. Sql | Minister for Science, Eternal Happiness, and Finance |

debug log:

solving 0965b8e ...
found 0965b8e in https://list.orgmode.org/orgmode/87wp5imjug.fsf@brickabode.com/

applying [1/1] https://list.orgmode.org/orgmode/87wp5imjug.fsf@brickabode.com/
diff --git a/testing/examples/ob-sqlite-test.org b/testing/examples/ob-sqlite-test.org
new file mode 100644
index 0000000..0965b8e

Checking patch testing/examples/ob-sqlite-test.org...
Applied patch testing/examples/ob-sqlite-test.org cleanly.

index at:
100644 0965b8edf7f76ca130e841925643ded5772875cd	testing/examples/ob-sqlite-test.org

(*) Git path names are given by the tree(s) the blob belongs to.
    Blobs themselves have no identifier aside from the hash of its contents.^

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).