Mercurial > roundup-cc > roundup-cc
comparison roundup_content_data/__init__.py @ 7:99e2e0e17103
Adding possibility and example to filter the entries.
| author | Bernhard Reiter <bernhard@intevation.de> |
|---|---|
| date | Tue, 01 Dec 2015 09:02:35 +0100 |
| parents | 2df45f6ecd81 |
| children | adca5b3780d2 |
comparison
equal
deleted
inserted
replaced
| 6:a1e71b5e4d68 | 7:99e2e0e17103 |
|---|---|
| 48 wish | 48 wish |
| 49 FROM issues | 49 FROM issues |
| 50 ORDER BY timestamp | 50 ORDER BY timestamp |
| 51 """ | 51 """ |
| 52 | 52 |
| 53 SELECT_WHERE = """ | |
| 54 SELECT strftime("%Y-%m-%dT%H:%M:%S", timestamp), | |
| 55 critical, | |
| 56 urgent, | |
| 57 bug, | |
| 58 feature, | |
| 59 wish | |
| 60 FROM issues | |
| 61 WHERE {} | |
| 62 ORDER BY timestamp | |
| 63 """ | |
| 64 | |
| 53 | 65 |
| 54 CREATE_DB = """ | 66 CREATE_DB = """ |
| 55 CREATE TABLE issues ( | 67 CREATE TABLE issues ( |
| 56 timestamp TIMESTAMP NOT NULL UNIQUE DEFAULT current_timestamp, | 68 timestamp TIMESTAMP NOT NULL UNIQUE DEFAULT current_timestamp, |
| 57 critical INTEGER NOT NULL DEFAULT 0, | 69 critical INTEGER NOT NULL DEFAULT 0, |