Mercurial > getan > getan
diff test_data/getan_test_data.py @ 499:199b3e3657aa
Every minute the time of the current entry is saved.
author | Magnus Schieder <mschieder@intevation.de> |
---|---|
date | Mon, 17 Sep 2018 20:35:36 +0200 |
parents | a4f04440f045 |
children |
line wrap: on
line diff
--- a/test_data/getan_test_data.py Tue Jul 10 09:32:42 2018 +0200 +++ b/test_data/getan_test_data.py Mon Sep 17 20:35:36 2018 +0200 @@ -38,6 +38,16 @@ CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))) ''') + db.execute('''CREATE TABLE recover ( + id INTEGER PRIMARY KEY, + project_id INTEGER REFERENCES projects(id), + start_time TIMESTAMP NOT NULL, + stop_time TIMESTAMP NOT NULL, + description VARCHAR(256), + + CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))) + ''') + # List of projects. # (key, 'description') pro = [