Mercurial > getan
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 497:ccd225b130a6 | 499:199b3e3657aa |
|---|---|
| 28 active BOOLEAN DEFAULT 1) | 28 active BOOLEAN DEFAULT 1) |
| 29 ''') | 29 ''') |
| 30 | 30 |
| 31 db.execute('''CREATE TABLE entries ( | 31 db.execute('''CREATE TABLE entries ( |
| 32 id INTEGER PRIMARY KEY AUTOINCREMENT, | 32 id INTEGER PRIMARY KEY AUTOINCREMENT, |
| 33 project_id INTEGER REFERENCES projects(id), | |
| 34 start_time TIMESTAMP NOT NULL, | |
| 35 stop_time TIMESTAMP NOT NULL, | |
| 36 description VARCHAR(256), | |
| 37 | |
| 38 CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))) | |
| 39 ''') | |
| 40 | |
| 41 db.execute('''CREATE TABLE recover ( | |
| 42 id INTEGER PRIMARY KEY, | |
| 33 project_id INTEGER REFERENCES projects(id), | 43 project_id INTEGER REFERENCES projects(id), |
| 34 start_time TIMESTAMP NOT NULL, | 44 start_time TIMESTAMP NOT NULL, |
| 35 stop_time TIMESTAMP NOT NULL, | 45 stop_time TIMESTAMP NOT NULL, |
| 36 description VARCHAR(256), | 46 description VARCHAR(256), |
| 37 | 47 |