florent-babylon

[15:29:33]~/ λ sqlite3 test.sqlite
SQLite version 3.14.0 2016-07-26 15:17:14
Enter ".help" for usage hints.
sqlite> create table test(id integer, data text);
sqlite> insert into test values (1, '{"test": 1}'), (2, '{"test": 2}'), (1, '{"test": 3}'), (1, '{"test": 4}'), (2, '{"test": 2}');
sqlite> select id, data from test order by id;
1|{"test": 1}
1|{"test": 3}
1|{"test": 4}
2|{"test": 2}

florent-babylon

# Dependencies:
# brew install terminal-notifier
# Run the tests and notifies of success or failure.
# NB - the icons are optional, remove the whole "-appIcon $path" if you don't need them.

NOTIF=/Applications/terminal-notifier.app/Contents/MacOS/terminal-notifier

python -m unittest test/test_*_model.py

if [ $? = 0 ]