Mercurial > roundup-cc
view 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 source
#!/usr/bin/env python3 """Connect to roundup-tracker and save status to db. Run periodically as often as you want data points to be saved. """ import configparser import argparse from collect_issues import save_stats_in_db import roundup_content_data as rcd PRIO = "critical, urgent, bug, feature, wish" STATES = "unread, deferred, chatting, need-eg, in-progress, testing, done-cbb, resolved" def main(): parser = argparse.ArgumentParser() parser.add_argument("config_file", type=str, metavar="[config file]") args = parser.parse_args() config = configparser.ConfigParser() config.read(args.config_file) base_url = config.get("URL", "BaseURL") user = config.get("LOGIN","Username") password = config.get("LOGIN", "Password") login_parameters = ( ("__login_name", user), ("__login_password", password), ("@action", "Login"), ) database_file = config.get("DB", "DatabaseFile") keywords = config.get("SEARCH", "Keywords", fallback="").split(", ") search = config.get("SEARCH", "Search", fallback="prio") if search == "prio": list_of_columns = config.get("SEARCH", "Priority", fallback=PRIO).split(", ") status = config.get("SEARCH", "Status", fallback="").split(", ") include_no_prio = config.getboolean("SEARCH", "IncludeNoPrio", fallback= False) if include_no_prio: list_of_columns += ["None"] 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(sql_list_of_columns) save_stats_in_db(search, login_parameters, base_url, database_file, list_of_columns, create_db, insert_new, keywords, status, include_no_prio) if __name__ == '__main__': main()