diff roundup_cc.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 9aca070c86bd
line wrap: on
line diff
--- a/roundup_cc.py	Tue Nov 13 21:04:22 2018 +0100
+++ b/roundup_cc.py	Thu Nov 22 12:57:20 2018 +0100
@@ -11,7 +11,7 @@
 import roundup_content_data as rcd
 
 PRIO = "critical, urgent, bug, feature, wish"
-STATES = "unread, deferred, chatting, need_eg, in_progress, testing, done_cbb, resolved"
+STATES = "unread, deferred, chatting, need-eg, in-progress, testing, done-cbb, resolved"
 
 def main():
 
@@ -48,16 +48,22 @@
     elif search == "status":
         list_of_columns = config.get("SEARCH", "Status", fallback=STATES).split(", ")
         status = [""]
+        include_no_prio = False
 
     else:
         print("Incorrect [SEARCH]Search parameter. (prio, status)")
         return
 
+    # roundup uses a "-" in its search parameters. Sql can't handle it.
+    sql_list_of_columns = []
+    for column in list_of_columns:
+         sql_list_of_columns.append(column.replace("-", "_"))
+
     select_all, select_where, create_db, insert_new = \
-        rcd.build_sql_commands(list_of_columns)
+        rcd.build_sql_commands(sql_list_of_columns)
 
     save_stats_in_db(search, login_parameters, base_url, database_file,
-                    list_of_columns, create_db, insert_new, keywords, status)
+                    list_of_columns, create_db, insert_new, keywords, status, include_no_prio)
 
 if __name__ == '__main__':
     main()
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)