def sql(self, db, data, startLin, endLin, param):
result = db.query(
"SELECT stress,mood,socquant,weight,starttime FROM general"
+ " WHERE starttime>"
+ startLin
+ " AND endtime<"
+ endLin
)
ut.initialiseData(data, ["stress", "mood", "socquant", "weight"])
for row in result:
vals = [
["stress", row["stress"]],
["mood", row["mood"]],
["socquant", row["socquant"]],
["weight", row["weight"]],
]
ut.fillData(
data,
math.floor((row["starttime"] + 43200) / 86400) * 86400 + 43200,
vals,
)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
"SELECT paper,ubuntu,driving,ridingcar,store,starttime "
+ "FROM generalactivities WHERE starttime>"
+ startLin
+ " AND endtime<"
+ endLin
)
ut.initialiseData(data, ["paper", "ubuntu", "driving", "store", "ridingcar"])
for row in result:
vals = [
["paper", row["paper"]],
["ubuntu", row["ubuntu"]],
["driving", row["driving"]],
["store", row["store"]],
["ridingcar", row["ridingcar"]],
]
ut.fillData(
data,
math.floor((row["starttime"] + 43200) / 86400) * 86400 + 43200,
vals,
)
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, "activity")
result = db.query(
"SELECT starttime,endtime,activity,"
+ "sum(calories),sum(steps) "
+ "FROM sports s INNER JOIN basis b "
"ON b.insttime>=s.starttime AND b.insttime<=s.endtime "
'WHERE (activity="'
+ param
+ '") AND starttime>'
+ startLin
+ " AND endtime<"
+ endLin
+ " GROUP BY starttime"
)
ut.initialiseData(data, ["steps", "calories"])
for row in result:
vals = [["steps", row["sum(steps)"]], ["calories", row["sum(calories)"]]]
ut.fillData(
data, math.floor((row["starttime"]) / 86400) * 86400 + 43200, vals
)
def sql(self, db, data, startLin, endLin, param):
result = db.query("SELECT steps,calories,insttime FROM basis WHERE" +
" insttime>" + startLin + " AND insttime<" + endLin)
ut.initialiseData(data, ["steps", "calories"])
for row in result:
vals = [["steps", row["steps"]], ["calories", row["calories"]]]
ut.fillData(data, row["insttime"], vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query('SELECT steps,calories,insttime FROM basis WHERE' +
' insttime>' + startLin + ' AND insttime<' + endLin)
ut.initialiseData(data, ['steps', 'calories'])
for row in result:
vals = [['steps', row['steps']], ['calories', row['calories']]]
ut.fillData(data, row['insttime'], vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query("SELECT starttime,(starttime)/86400," +
"sum(endtime-starttime) FROM screenSaver WHERE " +
"starttime>" + startLin + " AND endtime<" + endLin +
" GROUP BY ((starttime)/86400)")
ut.initialiseData(data, ['duration'])
for row in result:
ut.fillData(data, row['(starttime)/86400'] * 86400 + 86400 / 2,
[['duration', row['sum(endtime-starttime)']]])
def sql(self, db, data, startLin, endLin, param):
result = db.query(
'SELECT starttime,endtime,effortInt FROM sports' +
' WHERE (activity="Via Ferrata" OR activity="Climbing") ' +
'AND starttime>' + startLin + ' AND endtime<' + endLin)
ut.initialiseData(data, ['effortInt'])
for row in result:
ut.fillData(data,
math.floor(row['starttime'] / 86400) * 86400 + 43200,
[['effortInt', row['effortInt']]])
def sql(self, db, data, startLin, endLin, param):
result = db.query(
'SELECT starttime,endtime,avg(intensity),max(intensity) ' +
'FROM pain WHERE ' + ' starttime>=' + startLin + ' AND endtime<=' +
endLin + ' GROUP BY starttime')
ut.initialiseData(data, ['meanIntensity', 'maxIntensity'])
for row in result:
vals = [['meanIntensity', row['avg(intensity)']],
['maxIntensity', row['max(intensity)']]]
ut.fillData(data, (row['starttime'] + row['endtime']) / 2, vals)
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, 'activity')
result = db.query('SELECT starttime,endtime,activity FROM sports' +
' WHERE (activity="' + param + '") AND starttime>' +
startLin + ' AND endtime<' + endLin)
ut.initialiseData(data, ['duration'])
for row in result:
ut.fillData(data,
math.floor((row['starttime']) / 86400) * 86400 + 43200,
[['duration', row['endtime'] - row['starttime']]])
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, 'location')
result = db.query('SELECT starttime,endtime,intensity ' +
'FROM pain WHERE (location="' + param + '") AND ' +
' starttime>=' + startLin + ' AND endtime<=' +
endLin)
ut.initialiseData(data, ['intensity'])
for row in result:
ut.fillData(data, (row['starttime'] + row['endtime']) / 2,
[['intensity', row['intensity']]])
def sql(self, db, data, startLin, endLin, param):
result = db.query("SELECT (insttime)/86400," +
"sum(steps),sum(calories) FROM basis WHERE " +
" insttime>" + startLin + " AND insttime<" + endLin +
" GROUP BY (insttime/86400)")
ut.initialiseData(data, ['steps', 'calories'])
for row in result:
vals = [['steps', row['sum(steps)']],
['calories', row['sum(calories)']]]
ut.fillData(data, row['(insttime)/86400'] * 86400 + 86400 / 2,
vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
'SELECT stress,mood,socquant,weight,starttime FROM general' +
' WHERE starttime>' + startLin + ' AND endtime<' + endLin)
ut.initialiseData(data, ['stress', 'mood', 'socquant', 'weight'])
for row in result:
vals = [['stress', row['stress']], ['mood', row['mood']],
['socquant', row['socquant']], ['weight', row['weight']]]
ut.fillData(
data,
math.floor((row['starttime'] + 43200) / 86400) * 86400 + 43200,
vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query("SELECT starttime,(starttime)/86400,keys,clicks " +
"FROM whatPulse WHERE " + "starttime>" + startLin +
" AND endtime<" + endLin +
" AND id IN (SELECT max(id) FROM " +
"whatPulse GROUP BY date)")
ut.initialiseData(data, ['keys', 'clicks'])
for row in result:
vals = [['keys', row['keys']], ['clicks', row['clicks']]]
ut.fillData(
data,
row['starttime'] + 86400 / 2 +
86400, # Should this be changed ??? #
vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
"SELECT starttime,endtime,effortInt FROM sports"
+ ' WHERE (activity="Via Ferrata" OR activity="Climbing") '
+ "AND starttime>"
+ startLin
+ " AND endtime<"
+ endLin
)
ut.initialiseData(data, ["effortInt"])
for row in result:
ut.fillData(
data,
math.floor(row["starttime"] / 86400) * 86400 + 43200,
[["effortInt", row["effortInt"]]],
)
def sql(self, db, data, startLin, endLin, param):
result = db.query("SELECT starttime,endtime FROM manicTime WHERE" +
" name='Activité' AND" + " starttime>" + startLin +
" AND endtime<" + endLin)
ut.initialiseData(data, ['active'])
for row in result:
ut.fillData(data, row['starttime'] - 1, [['active', 0]])
ut.fillData(data, row['starttime'], [['active', param]])
ut.fillData(data, row['endtime'], [['active', param]])
ut.fillData(data, row['endtime'] + 1, [['active', 0]])
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, 'activity')
result = db.query(
'SELECT starttime,endtime,activity,' +
'sum(calories),sum(steps) ' + 'FROM sports s INNER JOIN basis b '
'ON b.insttime>=s.starttime AND b.insttime<=s.endtime '
'WHERE (activity="' + param + '") AND starttime>' + startLin +
' AND endtime<' + endLin + ' GROUP BY starttime')
ut.initialiseData(data, ['steps', 'calories'])
for row in result:
vals = [['steps', row['sum(steps)']],
['calories', row['sum(calories)']]]
ut.fillData(data,
math.floor((row['starttime']) / 86400) * 86400 + 43200,
vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
"SELECT starttime,(starttime)/86400,"
+ "sum(endtime-starttime) FROM manicTime WHERE name='Activité' "
+ "AND starttime>"
+ startLin
+ " AND endtime<"
+ endLin
+ " GROUP BY ((starttime)/86400)"
)
ut.initialiseData(data, ["duration"])
for row in result:
ut.fillData(
data,
row["(starttime)/86400"] * 86400 + 86400 / 2,
[["duration", row["sum(endtime-starttime)"]]],
)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
"SELECT starttime,endtime,avg(intensity),max(intensity) "
+ "FROM pain WHERE "
+ " starttime>="
+ startLin
+ " AND endtime<="
+ endLin
+ " GROUP BY starttime"
)
ut.initialiseData(data, ["meanIntensity", "maxIntensity"])
for row in result:
vals = [
["meanIntensity", row["avg(intensity)"]],
["maxIntensity", row["max(intensity)"]],
]
ut.fillData(data, (row["starttime"] + row["endtime"]) / 2, vals)
def sql(self, db, data, startLin, endLin, param):
result = db.query(
'SELECT paper,ubuntu,driving,ridingcar,store,starttime ' +
'FROM generalactivities WHERE starttime>' + startLin +
' AND endtime<' + endLin)
ut.initialiseData(data,
['paper', 'ubuntu', 'driving', 'store', 'ridingcar'])
for row in result:
vals = [['paper', row['paper']], ['ubuntu', row['ubuntu']],
['driving', row['driving']], ['store', row['store']],
['ridingcar', row['ridingcar']]]
ut.fillData(
data,
math.floor((row['starttime'] + 43200) / 86400) * 86400 + 43200,
vals)
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, "activity")
result = db.query(
"SELECT starttime,endtime,activity FROM sports"
+ ' WHERE (activity="'
+ param
+ '") AND starttime>'
+ startLin
+ " AND endtime<"
+ endLin
)
ut.initialiseData(data, ["duration"])
for row in result:
ut.fillData(
data,
math.floor((row["starttime"]) / 86400) * 86400 + 43200,
[["duration", row["endtime"] - row["starttime"]]],
)
def sql(self, db, data, startLin, endLin, param):
print('\nSports:')
result = db.query('SELECT starttime,endtime,activity FROM sports' +
' WHERE starttime>' + startLin + ' AND endtime<' +
endLin)
ut.initialiseData(data, ['active'])
for row in result:
ut.fillData(data, row['starttime'] - 1, [['active', 0]])
ut.fillData(data, row['starttime'], [['active', param]])
ut.fillData(data, row['endtime'], [['active', param]])
ut.fillData(data, row['endtime'] + 1, [['active', 0]])
print(row['activity'])
def sql(self, db, data, startLin, endLin, param):
print("\nSports:")
result = db.query("SELECT starttime,endtime,activity FROM sports" +
" WHERE starttime>" + startLin + " AND endtime<" +
endLin)
ut.initialiseData(data, ["active"])
for row in result:
ut.fillData(data, row["starttime"] - 1, [["active", 0]])
ut.fillData(data, row["starttime"], [["active", param]])
ut.fillData(data, row["endtime"], [["active", param]])
ut.fillData(data, row["endtime"] + 1, [["active", 0]])
print(row["activity"])
def sql(self, db, data, startLin, endLin, param):
param = ut.returnParam(param, "location")
result = db.query(
"SELECT starttime,endtime,intensity "
+ 'FROM pain WHERE (location="'
+ param
+ '") AND '
+ " starttime>="
+ startLin
+ " AND endtime<="
+ endLin
)
ut.initialiseData(data, ["intensity"])
for row in result:
ut.fillData(
data,
(row["starttime"] + row["endtime"]) / 2,
[["intensity", row["intensity"]]],
)
