From 0fc8acc27a6c5e591efd38a9f6878b6edad7e506 Mon Sep 17 00:00:00 2001 From: Jiri Vlasak Date: Wed, 20 Mar 2019 13:01:13 +0100 Subject: [PATCH] Use db UT for creating test db --- README.md | 31 ++++++------------------------- 1 file changed, 6 insertions(+), 25 deletions(-) diff --git a/README.md b/README.md index 12e4c57..cefdf92 100644 --- a/README.md +++ b/README.md @@ -22,31 +22,13 @@ python3 -m unittest discover ut/ See [unittest][5] for start. ## Database -By default, sqlite3 `coffee.db` file is needed. Please, see [coffee_db.sql][6] -for the database format. You may create testing copy of database by: +By default, sqlite3 `coffee.db` file is needed. You may create testing copy of +database by: ``` -wget http://rtime.felk.cvut.cz/gitweb/coffee/coffee-flask.git/blob_plain/refs/heads/master:/coffee_db.sql -sqlite3 coffee.db < coffee_db.sql -``` - -Then add some testing data by: -``` -sqlite3 coffee.db "INSERT INTO "users" VALUES('1111','tester')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'espresso lungo')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,5 l')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,33 l')" -sleep 1 -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'espresso lungo')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,5 l')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,33 l')" -sleep 1 -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'espresso lungo')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,5 l')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,33 l')" -sleep 1 -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'espresso lungo')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,5 l')" -sqlite3 coffee.db "insert into coffees (id, flavor) values ('1111', 'Club-Mate 0,33 l')" +python3 -c ' +from ut.test_db import create_test_db +create_test_db("coffee.db") +' ``` Database is needed to pass the tests. @@ -59,4 +41,3 @@ This project is developed under [GNU GPLv3 license][4]. [3]: http://endoflineblog.com/oneflow-a-git-branching-model-and-workflow [4]: ./LICENSE [5]: https://docs.python.org/3.5/library/unittest.html -[6]: http://rtime.felk.cvut.cz/gitweb/coffee/coffee-flask.git/blob/refs/heads/master:/coffee_db.sql -- 2.39.2