aboutsummaryrefslogtreecommitdiff
path: root/misc/export_to_2.0
blob: ef30ffe4e83adc47ebc58037969d2c55e7683ba5 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
#!/usr/bin/python
import os
import sys
sys.path.insert(0, "/usr/share/Watcher/")
import csv
from watch_log import get_date
import datetime
import time_operations as to

def extract_data(date):
    user = os.getlogin()
    path = "/home/" + user +"/.cache/Watcher/raw_data/"
    filename = path + date + ".csv"

    l = list() # l = list of  (app_name, time spent on app on that session)
    d = dict()

    if os.path.isfile(filename):
        with open(filename, 'r') as file:
            reader = csv.reader(file)
            for row in reader:
                for column in row:
                    l.append([column[18::],column[9:17]])
                    d.update({column[18::]: "O"})
    else:
        None

    d = list(d) # list of app opened on that day
    return d, l

# creating dictionary to store time spend on each applicaitons on that particular day
def final_report(window_opened, time_spent):
    report = dict()

    for i in window_opened: # i is applications name
        time = '00:00:00'
        for j in time_spent: # j is list of applicaions_name and  time_spent in particular session
            if i == j[0]:
                time = to.time_addition(j[1], time)
                report.update({i:time})

    #print(report)
    if "User-logged-in" in report.keys():
        report.pop("User-logged-in")
    if "AFK" in report.keys():
        report.pop("AFK")
    if "Unknown" in report.keys():
        report.pop("Unknown")
    # sort report dictonary in decreasing order of Usages
    sorted_values = []
    for x,y in report.items():
        sorted_values.append(to.convert_into_sec(y))

    sorted_values.sort(reverse=True)
    sorted_report = dict()

    for i in sorted_values:
        for x, y in report.items():
            if to.convert_into_sec(y) == i:
                sorted_report.update({x:y})

    return sorted_report

def export_to_new(date):
    window_opened, time_spent = extract_data(date)
    sorted_report = final_report(window_opened, time_spent)
    filename = "/home/"+os.getlogin()+"/.cache/Watcher/daily_data/"+date+".csv"
    overwrite_Data = []
    with open(filename, 'w') as csvfile:
        for x,y in sorted_report.items():
            overwrite_Data.append([y,x])

        csvwriter = csv.writer(csvfile, delimiter='\t')
        csvwriter.writerows(overwrite_Data)

    del sorted_report
    del overwrite_Data

path = "/home/" + os.getlogin() +"/.cache/Watcher/raw_data/"
for file in os.listdir(path):
    export_to_new(file[:-4])