Update readme with database information

diff --git a/README.md b/README.md
index ee901cc04a34fbbfa1169f2639c1ae124272eed7..34d2efa230a55bda7d001f1be52a25b56aa90c36 100644 (file)
--- a/README.md
+++ b/README.md
@@ -21,6 +21,37 @@ 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:
+```
+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')"
+```
+
+Database is needed to pass the tests.
+
 ## License
 This project is developed under [GNU GPLv3 license][4].
 
@@ -29,3 +60,4 @@ 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