Esempio n. 1
0
# -*- coding: utf-8 -*-
"""
Scrap resting heartrate data from Fitbit web panel to sqlite database.
"""
from lib.config import Configuration
from lib.db import DBConn
from lib.tilesdata import TilesData

if __name__ == '__main__':
    config = Configuration()
    if not config.ok:
        print 'Error reading config file!'
        exit(1)

    db = DBConn(config.dbname, config.decsep, config.thsep)
    td = TilesData(config.htmlfile)
    d = dict()
    d['heartrate'] = td.data['getRestingHeartRateData']['data']['dataPoints']  # resting heartrate data to import
    db.save(d)
Esempio n. 2
0
from lib.config import Configuration
from lib.db import DBConn
from lib.utils import filelist, convert_tstamp
from csv import reader

if __name__ == '__main__':
    # global configuration
    config = Configuration()
    if config.ok:
        csvpath = config.csvpath
        header = config.header  # dict - only contains interesting data block names
    else:
        print 'Error reading config file!'
        exit(1)

    db = DBConn(config.dbname, config.decsep, config.thsep)
    flist = sorted(filelist(csvpath))  # older files before
    for csvfile in flist:
        # save data blocks in a dict using header as key
        datablocks = dict()
        dblock = []  # this data block is a list of lists
        hdr = ''  # new data block's header - if not empty, we're currently reading data
        with open(csvpath + '/' + csvfile, 'rb') as f:
            print 'processing file ' + csvfile
            csv = reader(f)
            for row in csv:
                if hdr == '':  # this is the data block's header
                    hdr = row[0]
                else:
                    if row == []:  # end of data block
                        if hdr in header.keys():  # skip ignored data blocks