# HG changeset patch
# User Bernhard Reiter <bernhard@intevation.de>
# Date 1448901982 -3600
# Node ID 99c68ebfb3b9a81790f970d1b524576174646c95
# Parent  3e9f4a6803d1e0b068b7e3d06f3258184ccbcc2f
Streamlined to example use.
  * removed superfluous file
  * added example file for usage as python module

diff -r 3e9f4a6803d1 -r 99c68ebfb3b9 display_issues
--- a/display_issues	Wed Apr 15 11:40:28 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,91 +0,0 @@
-#!/usr/bin/env python3
-
-""" Display previously saved issues from a database on webpage via CGI.
-
-author: Sascha L. Teichmann <sascha.teichmann@intevation.de>
-author: Bernhard Reiter <bernhard@intevation.de>
-author: Sean Engelhardt <sean.engelhardt@intevation.de>
-
-(c) 2010,2015 by Intevation GmbH
-
-This is Free Software unter the terms of the
-GNU GENERAL PUBLIC LICENSE Version 3 or later.
-See http://www.gnu.org/licenses/gpl-3.0.txt for details
-"""
-
-import sqlite3 as db
-import cgitb
-import roundup_content_data as rcd
-
-
-def make_js_object_string(array):
-    formated = []
-
-    for item in array:
-        formated.append("{points: " + str(item) + "}")
-
-    return ",".join(formated)
-
-
-def make_js_object_date(array):
-    formated = []
-
-    for item in array:
-        formated.append("{date : new Date('" + str(item) + "')}")
-
-    return ", ".join(formated)
-
-
-def get_webpage():
-
-    with open ("graph.html", "r") as html_chart_file:
-        base_html_data = html_chart_file.read()
-
-    base_html_data = (base_html_data
-        .replace("var critical=[];", "var critical=[" + make_js_object_string(rcd.data_dict["critical"]) + "]")
-        .replace("var urgent=[];", "var urgent=[" + make_js_object_string(rcd.data_dict["urgent"]) + "]")
-        .replace("var bug=[];", "var bug=[" + make_js_object_string(rcd.data_dict["bug"]) + "]")
-        .replace("var feature=[];", "var feature=[" + make_js_object_string(rcd.data_dict["feature"]) + "]")
-        .replace("var wish=[];", "var wish=[" + make_js_object_string(rcd.data_dict["wish"]) + "]")
-        .replace("var timestamp=[];", "var timestamp=[" + make_js_object_date(rcd.data_dict["date"]) + "]"))
-
-    return base_html_data
-
-
-def render_webpage(content):
-    for line in content.split("\n"):
-        print(line)
-
-
-def render_db_stats_as_html():
-
-    con = None
-    cur = None
-
-    try:
-        con = db.connect(rcd.DATABASE_FILE)
-        cur = con.cursor()
-        cur.execute(rcd.SELECT_ALL)
-
-        for row in cur.fetchall():
-            rcd.data_dict["date"].append(row[0])
-            rcd.data_dict["critical"].append(row[1])
-            rcd.data_dict["urgent"].append(row[2])
-            rcd.data_dict["bug"].append(row[3])
-            rcd.data_dict["feature"].append(row[4])
-            rcd.data_dict["wish"].append(row[5])
-    finally:
-        if cur:
-            cur.close()
-        if con:
-            con.close()
-
-    render_webpage(get_webpage())
-
-
-cgitb.enable()
-print("Content-Type: text/html")
-print()
-
-
-render_db_stats_as_html()
diff -r 3e9f4a6803d1 -r 99c68ebfb3b9 display_issues.py
--- a/display_issues.py	Wed Apr 15 11:40:28 2015 +0200
+++ b/display_issues.py	Mon Nov 30 17:46:22 2015 +0100
@@ -15,6 +15,10 @@
 
 ##Usage Example: ##
 
+from display_issues import *
+cgitb.enable() # (optional) HTML traceback to browser
+print("Content-Type: text/html")
+print()
 render_db_stats_as_html(rcd.DATABASE_DEMO, rcd.SELECT_ALL)
 """
 
@@ -88,6 +92,9 @@
     render_webpage(get_webpage())
 
 
-cgitb.enable()
-print("Content-Type: text/html")
-print()
\ No newline at end of file
+if __name__ == '__main__':
+    cgitb.enable()
+    print("Content-Type: text/html")
+    print()
+
+    render_db_stats_as_html(rcd.DATABASE_DEMO, rcd.SELECT_ALL)
diff -r 3e9f4a6803d1 -r 99c68ebfb3b9 display_issues_demo.py
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/display_issues_demo.py	Mon Nov 30 17:46:22 2015 +0100
@@ -0,0 +1,21 @@
+#!/usr/bin/env python3
+
+""" Fetch issues from a roundup-tracker and save them in a databse.
+
+author: Sascha L. Teichmann <sascha.teichmann@intevation.de>
+author: Bernhard Reiter <bernhard@intevation.de>
+author: Sean Engelhardt <sean.engelhardt@intevation.de>
+
+(c) 2010,2015 by Intevation GmbH
+
+This is Free Software unter the terms of the
+GNU GENERAL PUBLIC LICENSE Version 3 or later.
+See http://www.gnu.org/licenses/gpl-3.0.txt for details
+"""
+
+from display_issues import *
+
+cgitb.enable() # (optional) HTML traceback to browser
+print("Content-Type: text/html")
+print()
+render_db_stats_as_html(rcd.DATABASE_DEMO, rcd.SELECT_ALL)