Mercurial > roundup-cc
comparison display_issues_demo.py @ 28:e2864dabdb8c
fixes a logical error in the filtering of columns.
* The columns are stored in the pure order as they appear in the config.
* display_issues.py has been renamed to roundup_cc_display.py.
| author | Magnus Schieder <mschieder@intevation.de> |
|---|---|
| date | Thu, 22 Nov 2018 12:57:20 +0100 |
| parents | 761ee2351f58 |
| children |
comparison
equal
deleted
inserted
replaced
| 27:cdab667c6abb | 28:e2864dabdb8c |
|---|---|
| 45 | 45 |
| 46 else: | 46 else: |
| 47 print("Incorrect [SEARCH]Search parameter. (prio, status)") | 47 print("Incorrect [SEARCH]Search parameter. (prio, status)") |
| 48 return | 48 return |
| 49 | 49 |
| 50 # roundup uses a "-" in its search parameters. Sql can't handle it. | |
| 51 columns = columns.replace("-", "_") | |
| 50 | 52 |
| 51 cgitb.enable() # (optional) HTML traceback to browser | 53 cgitb.enable() # (optional) HTML traceback to browser |
| 52 #render_db_stats_as_html("./demo1.db", rcd.SELECT_ALL) | 54 #render_db_stats_as_html("./demo1.db", rcd.SELECT_ALL) |
| 53 render_db_stats_as_html(db, | 55 render_db_stats_as_html(db, |
| 54 rcd.build_sql_select(columns).format("timestamp > date('now', '-2 month')"), | 56 rcd.build_sql_select(columns).format("timestamp > date('now', '-2 month')"), |