bernhard@3: #!/usr/bin/env python3
bernhard@3: 
bernhard@3: """ Fetch issues from a roundup-tracker and save them in a databse.
bernhard@3: 
bernhard@3: author: Sascha L. Teichmann <sascha.teichmann@intevation.de>
bernhard@3: author: Bernhard Reiter <bernhard@intevation.de>
bernhard@3: author: Sean Engelhardt <sean.engelhardt@intevation.de>
bernhard@3: 
bernhard@17: (c) 2010, 2015, 2018 by Intevation GmbH
bernhard@3: 
bernhard@3: This is Free Software unter the terms of the
bernhard@3: GNU GENERAL PUBLIC LICENSE Version 3 or later.
bernhard@3: See http://www.gnu.org/licenses/gpl-3.0.txt for details
bernhard@3: """
mschieder@20: import configparser
mschieder@20: from display_issues import *
bernhard@3: 
mschieder@20: config = configparser.ConfigParser()
mschieder@20: config.read('config3.ini')
mschieder@20: 
mschieder@20: keywords = config.get("SEARCH", "Keywords", fallback="")
mschieder@20: status = config.get("SEARCH", "Status", fallback="")
mschieder@20: columns = config.get("SEARCH", "Columns", fallback="critical, urgent, bug, feature, wish")
mschieder@20: noPrio = config.get("SEARCH", "IncludeNoPrio", fallback=False)
mschieder@20: if noPrio:
mschieder@20:     columns += ", None"
bernhard@3: 
bernhard@3: cgitb.enable() # (optional) HTML traceback to browser
bernhard@17: #render_db_stats_as_html("./demo1.db", rcd.SELECT_ALL)
mschieder@20: render_db_stats_as_html("./demo3.db",
mschieder@20:         rcd.build_sql_select(columns).format("timestamp > date('now', '-2 month')"),
mschieder@20:         status, keywords)