#+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 |