From 72a1c9dc8f15e011bc1b309730f4562b877c1906 Mon Sep 17 00:00:00 2001 From: Shane Jaroch Date: Mon, 10 Aug 2020 11:39:58 -0400 Subject: [PATCH] add travis-ci --- .travis.yml | 10 ++++++++++ README.rst | 6 ++++++ sql/init.sql | 2 ++ 3 files changed, 18 insertions(+) create mode 100644 .travis.yml create mode 100644 sql/init.sql diff --git a/.travis.yml b/.travis.yml new file mode 100644 index 0000000..3fd96a1 --- /dev/null +++ b/.travis.yml @@ -0,0 +1,10 @@ +dist: xenial +sudo: true +language: python +python: +- '3.6' +script: +- git submodule update --init +- bash data/setup.sh +- python data/process.py +- cd sql && sqlite3 nutra.db ".read init.sql" diff --git a/README.rst b/README.rst index 6287385..fd96e8a 100644 --- a/README.rst +++ b/README.rst @@ -56,6 +56,12 @@ NOTE: FOLLOW STEPS 5 and 6 FROM INSIDE THE SQL SHELL .read import.sql .exit +Or alternatively from the bash shell (outside SQL) + +.. code-block:: bash + + sqlite3 nutra.db -init init.sql + 6. Verify the tables (again inside the SQL shell :code:`sqlite nutra.db`), .. code-block:: sql diff --git a/sql/init.sql b/sql/init.sql new file mode 100644 index 0000000..9039d81 --- /dev/null +++ b/sql/init.sql @@ -0,0 +1,2 @@ +.read tables.sql +.read import.sql -- 2.52.0