Mercurial > roundup-cc
diff 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 |
line wrap: on
line diff
--- a/roundup_content_data/__init__.py Tue Dec 01 09:01:52 2015 +0100 +++ b/roundup_content_data/__init__.py Tue Dec 01 09:02:35 2015 +0100 @@ -50,6 +50,18 @@ ORDER BY timestamp """ +SELECT_WHERE = """ +SELECT strftime("%Y-%m-%dT%H:%M:%S", timestamp), + critical, + urgent, + bug, + feature, + wish +FROM issues +WHERE {} +ORDER BY timestamp +""" + CREATE_DB = """ CREATE TABLE issues ( @@ -79,4 +91,4 @@ wishlist FROM issues ORDER BY sample_time -""" \ No newline at end of file +"""