commit bbd41efd441cd6d12f55bd22561e6f840258e91e Author: Tom Ritter <tom@ritter.vg> Date: Wed May 3 11:18:56 2017 -0500 Also output the entire history of bwauth stats for a historical analysis --- write_website.py | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/write_website.py b/write_website.py index 23ff8d7..fe2c219 100755 --- a/write_website.py +++ b/write_website.py @@ -282,6 +282,17 @@ def main(): f.write("\n") f.close() + bwauth_data = dbc.execute("SELECT * from bwauth_data ORDER BY date DESC") + f = open(os.path.join(os.path.dirname(__file__), 'out', 'bwauth-stats-all.csv'), 'w') + for c in bwauth_data_columns: + f.write(c + ",") + f.write("\n") + for r in bwauth_data.fetchall(): + for v in r: + f.write(("0" if v == None else str(v)) + ",") + f.write("\n") + f.close() + # produces the website w = WebsiteWriter() w.set_config(CONFIG)