Python csvToDatabase Exemples

Exemple #1

# -*- 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')

Exemple #2

# -*- 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'])

Exemple #3

Fichier : updateBasis.py Projet : oliviermirat/MyAIGuide

# -*- 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

Exemple #4

# -*- 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)

Exemple #5

Fichier : updateGeneralActivities.py Projet : correlaid-paris/MonsterMizer

# -*- 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')

Exemple #6

Fichier : updateScreenSaver.py Projet : oliviermirat/MyAIGuide

# -*- 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")

Exemple #7

Fichier : updateTaplog.py Projet : correlaid-paris/MonsterMizer

# -*- 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')

Exemple #8

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