# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import defineTables as tabDef import dataset import csvToDatabase csvFile = '../1_initialRawData/ManicTimeData.csv' csvToDatabase.csvToDatabase(csvFile, tabDef.manicTimeTab) db = dataset.connect('sqlite:///olidata.db')
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import csvToDatabase import dataset import defineTables as tabDef csvFile = "../1_initialRawData/manualLogPain.csv" csvToDatabase.csvToDatabase(csvFile, tabDef.painTab) db = dataset.connect("sqlite:///olidata.db") # result = db.query('SELECT * FROM pain') # for row in result: # print(row) # # result = db.query('SELECT * FROM pain') # for row in result: # print(row['year'],row['month'],row['day'],row['location'], # row['intensity'],row['starttime'],row['endtime'])
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import csvToDatabase import dataset import defineTables as tabDef csvFile = "../1_initialRawData/bodymetrics.csv" csvToDatabase.csvToDatabase(csvFile, tabDef.basisTab) # View the taplog file to know what to change below (this is time zone stuff) db = dataset.connect("sqlite:///olidata.db") db.query("UPDATE basis SET insttime=insttime+3600 WHERE id<133318") db.query( "UPDATE basis SET insttime=insttime+7200 WHERE (id>133318 AND id<=359920)") db.query( "UPDATE basis SET insttime=insttime-21600 WHERE (id>=359921 AND id<=361360)" ) db.query( "UPDATE basis SET insttime=insttime-25200 WHERE (id>=361361 AND id<451567)" ) db.query("UPDATE basis SET insttime=insttime-28800 WHERE id>=451568") # Sometimes, basis lost some data or there were some other technical # issues => needs to be fixed manualLogPhysicalActivities
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import defineTables as tabDef import dataset import csvToDatabase for i in range(1,87) : csvFile='../1_initialRawData/whatPulse/whatpulse-input-history'+str(i)+'.csv' csvToDatabase.csvToDatabase(csvFile,tabDef.whatPulseTab) db = dataset.connect('sqlite:///olidata.db') #db = dataset.connect('sqlite:///olidata.db') #result =db.query('SELECT * FROM whatPulse WHERE id IN (SELECT max(id) FROM'+ # ' whatPulse GROUP BY date)') #for row in result: # print(row)
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import defineTables as tabDef import dataset import csvToDatabase csvFile='../1_initialRawData/manualLogsGeneralActivities.csv' csvToDatabase.csvToDatabase(csvFile,tabDef.generalActivities) db = dataset.connect('sqlite:///olidata.db')
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import csvToDatabase import dataset import defineTables as tabDef csvFile = "../1_initialRawData/screensaver.csv" csvToDatabase.csvToDatabase(csvFile, tabDef.screenSaverTab) db = dataset.connect("sqlite:///olidata.db")
# -*- coding: utf-8 -*- """ Created on Mon Jul 4 21:07:43 2016 @author: Olivier """ import defineTables as tabDef import dataset import csvToDatabase csvFile = '../1_initialRawData/taplog.csv' csvToDatabase.csvToDatabase(csvFile, tabDef.taplogTab) db = dataset.connect('sqlite:///olidata.db') db.query('UPDATE taplog SET insttime=(ms/1000)') # Not entirely sure why the following is necessary db.query('UPDATE taplog SET insttime=insttime-32400 WHERE id>=501')
import defineTables as tabDef import dataset import csvToDatabase import time import datetime def toLinuxTime2(s, formatTime): t = time.mktime(datetime.datetime.strptime(s, formatTime).timetuple()) return t csvFile = '../1_initialRawData/manualLogPhysicalActivities.csv' csvToDatabase.csvToDatabase(csvFile, tabDef.sportTab) db = dataset.connect('sqlite:///olidata.db') result = db.query( "SELECT id,year,month,day,start,duration FROM sports WHERE start!='taplog'" ) for row in result: strr = str(row['year']) + '/' + str(row['month']) + '/' + str( row['day']) + '/' + str(row['start']) strr = toLinuxTime2(strr, '%Y/%m/%d/%H:%M') strend = strr + float(row['duration']) * 60 db.query('UPDATE sports SET starttime=' + str(strr) + ',endtime=' + str(strend) + ' WHERE id=' + str(row['id'])) lastid = 0