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): 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): 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): 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 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): 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): 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): 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): 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"]]], )