Mercurial > roundup-cc
diff roundup_content_data/__init__.py @ 20:3bb3d9a9f1b7
Filter by keywords and states.
Configuration via configuration file.
"No prio" grapf is displayed.
(./display_issues_demo.py is not yet dynamic, it needs all states)
author | Magnus Schieder <mschieder@intevation.de> |
---|---|
date | Mon, 22 Oct 2018 16:49:58 +0200 |
parents | adca5b3780d2 |
children |
line wrap: on
line diff
--- a/roundup_content_data/__init__.py Mon Jul 09 14:49:44 2018 +0200 +++ b/roundup_content_data/__init__.py Mon Oct 22 16:49:58 2018 +0200 @@ -27,7 +27,8 @@ "urgent": [], "bug": [], "feature": [], - "wish": [] + "wish": [], + "noPrio": [] } #SQL @@ -50,7 +51,8 @@ urgent, bug, feature, - wish + wish, + None FROM issues WHERE {} ORDER BY timestamp @@ -72,6 +74,15 @@ INSERT INTO issues (critical, urgent, bug, feature, wish) VALUES (?, ?, ?, ?, ?) """ +def build_sql_select(columns): + return """ + SELECT strftime("%Y-%m-%dT%H:%M:%S", timestamp), + """+ columns + """ + FROM issues + WHERE {} + ORDER BY timestamp + """ + def build_sql_commands(list_of_columns: list):