-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathview_stats.py
124 lines (99 loc) · 4.48 KB
/
view_stats.py
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
import psycopg2 as pp
import psycopg2.extras as ppx
import time, datetime
conn = pp.connect(dbname='public', host='virtualdb.engineering.redhat.com', port=5433)
cur = conn.cursor(cursor_factory=ppx.DictCursor)
# Some builds do not have a start_time, so we will also query the
# creation_time from the events table.
postgreSQL_select_Query = """SELECT brew.build.*,brew.events.time
AS creation_time FROM brew.build
INNER JOIN brew.events ON brew.build.create_event=brew.events.id
WHERE brew.build.pkg_id=34590 and brew.build.state = 1
ORDER BY brew.events.id;"""
cur.execute(postgreSQL_select_Query)
# Selecting rows from brew.build table using cursor.fetchall
current = cur.fetchall()
for row in current:
# Data has start_time
print("id = ", row['id'])
print("pkg_id = ", row['pkg_id'])
print("version = ", row['version'])
print("release = ", row['release'])
# print(row[0])
# print(row[1])
# print(row[2])
# print(row[3])
# print(row[4])
# print(row[5])
# print(row[6])
# print(row[7])
# print(row[8])
# print(row[9])
# print(row[10])
# print(row[11])
# print(row[12])
# print(row[13])
# print(row[14])
# print(row[15])
# print()
# print("start_time = ", row[11])
# print("completion_time = ", row[6], "\n")
# Convert time stamp to unix time
p = '%Y-%m-%d %H:%M:%S.%f'
temp_c = str(row['completion_time'])
epoch_complete = time.mktime(datetime.datetime.strptime(temp_c, p).timetuple())
if row['start_time'] is not None:
temp_s = str(row['start_time'])
epoch_start = time.mktime(datetime.datetime.strptime(temp_s, p).timetuple())
print("start_time = ", epoch_start)
print("completion_time = ", epoch_complete)
# Calculate time duration, delta
print("build_duration = ", float(epoch_complete) - float(epoch_start), "\n")
elif row['start_time'] is None:
print("No start_time time stamp, replacing with creation_time")
# print("creation_time = ", item[15], "\n")
temp_t = str(row['creation_time'])
epoch_creation = time.mktime(datetime.datetime.strptime(temp_t, p).timetuple())
print("start_time = ", epoch_creation)
print("completion_time = ", epoch_complete)
# Calculate time duration, delta
print("build_duration = ", float(epoch_complete) - float(epoch_creation), "\n")
# Print ones without start_time seperately from the rest
# for row in current:
# # Data has start_time
# print("id = ", row[0])
# print("pkg_id = ", row[1])
# print("version = ", row[2])
# print("release = ", row[3])
# # print("start_time = ", row[11])
# # print("completion_time = ", row[6], "\n")
# if row[11] is not None:
# # Convert time stamp to unix time
# p = '%Y-%m-%d %H:%M:%S.%f'
# temp_s = str(row[11])
# epoch_start = time.mktime(datetime.datetime.strptime(temp_s, p).timetuple())
# print("start_time = ", epoch_start)
# temp_c = str(row[6])
# epoch_complete = time.mktime(datetime.datetime.strptime(temp_c, p).timetuple())
# print("completion_time = ", epoch_complete)
# # Calculate time duration, delta
# print("build_duration = ", float(epoch_complete) - float(epoch_start), "\n")
# for item in current:
# # Data is missing start_time, instead use creation_time
# if item[11] is None:
# print("id = ", item[0])
# print("pkg_id = ", item[1])
# print("version = ", item[2])
# print("release = ", item[3])
# print("No start_time time stamp")
# # print("creation_time = ", item[15], "\n")
# # Convert time stamp to unix time
# p = '%Y-%m-%d %H:%M:%S.%f'
# temp_t = str(item[15])
# epoch_creation = time.mktime(datetime.datetime.strptime(temp_t, p).timetuple())
# print("creation_time = ", epoch_creation)
# temp_c = str(item[6])
# epoch_complete = time.mktime(datetime.datetime.strptime(temp_c, p).timetuple())
# print("completion_time = ", epoch_complete)
# # Calculate time duration, delta
# print("build_duration = ", float(epoch_complete) - float(epoch_creation), "\n")