-
Notifications
You must be signed in to change notification settings - Fork 0
/
backfill.py
92 lines (84 loc) · 2.57 KB
/
backfill.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
import time
import sqlite3
from datetime import datetime as dt
while True:
try:
conn = sqlite3.connect('/home/pi/Desktop/RPi/backfill.db',check_same_thread=False)
#conn = sqlite3.connect('./backfill.db',check_same_thread=False)
cur = conn.cursor()
break
except Exception as e:
print 'backfill.py: ',e
time.sleep(1) #Wait 1 secs before retrying
class database_backup():
def insertDb(self,arg,errGsm,errMain,errTime,errUnknown):
try:
cur.execute('''INSERT INTO backfill (dredger_name,\
time,\
storage_tank_level,\
storage_tank_cap,\
service_tank_level,\
service_tank_cap,\
flowmeter_1_in,\
flowmeter_1_out,\
engine_1_status,\
flowmeter_2_in ,\
flowmeter_2_out,\
engine_2_status,\
error_gsm,\
error_main,\
error_timeout,\
error_unknown)\
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);''',
(arg['dredger_name'],
arg['time'],
arg['storage_tank_level'],
arg['storage_tank_cap'],
arg['service_tank_level'],
arg['service_tank_cap'],
arg['flowmeter_1_in'],
arg['flowmeter_1_out'],
arg['engine_1_status'],
arg['flowmeter_2_in'],
arg['flowmeter_2_out'],
arg['engine_2_status'],
hex(errGsm),
hex(errMain),
hex(errTime),
hex(errUnknown)))
conn.commit()
except Exception as e:
print ('insertDb: '+str(e))
def deleteDb(self,arg):
try:
cur.execute("DELETE FROM backfill where time = ?",(arg['time'],))
conn.commit()
except Exception as e:
print ('deleteDb: '+str(e))
def fetchData(self):
try:
cur.execute("SELECT * FROM backfill order by time")
row = cur.fetchone()
if not row:
return None # If database is empty
else:
dictRow={}
dictRow['dredger_name'] = row[1]
dictRow['time'] = row[2]
dictRow['storage_tank_level'] = row[3]
dictRow['storage_tank_cap'] = row[4]
dictRow['service_tank_level'] = row[5]
dictRow['service_tank_cap'] = row[6]
dictRow['flowmeter_1_in'] = row[7]
dictRow['flowmeter_1_out'] = row[8]
dictRow['engine_1_status'] = row[9]
dictRow['flowmeter_2_in'] = row[10]
dictRow['flowmeter_2_out'] = row[11]
dictRow['engine_2_status'] = row[12]
dictRow['errGsm'] = int(row[13],16)
dictRow['errMain'] = int(row[14],16)
dictRow['errTimeout'] = int(row[15],16)
dictRow['errUnknown'] = int(row[16],16)
return dictRow
except Exception as e:
print ('2fetchData: '+str(e))