from __future__ import with_statement
import os, sys
import csv
import watch_folder_sizes

if __name__ == '__main__':
  CSV_FILENAME = "size_changes.csv"
  db = watch_folder_sizes.database ()
  q = db.cursor ()
  q.execute ("SELECT root_name, folder_name, logged_at, size_change FROM dbo.v_folder_size_changes ORDER BY root_name, folder_name, logged_at")
  with open (CSV_FILENAME, "wb") as f:
    writer = csv.writer (f)
    writer.writerow (['root', 'folder', 'logged at', 'size change'])
    writer.writerows (q.fetchall ())
  q.close ()
  db.close ()
  
  os.startfile (CSV_FILENAME)