Using my DB and FitBit Python code to download the last five days of FitBit data (because I don't necessarily sync the thing every day)

fitbit.download.py

#!/usr/bin/env python

# downloads last five days of fitbit info, not including the current day.
# the current day's info isn't finished, and I often don't have it sync
# during the weekend

import datetime 
import httplib
import os
import simplejson as json
import time
from oauth import oauth

import fitbit
import mydb

def main():
    #date = datetime.datetime( 2012,6,20,1,0,0 )
    date = datetime.datetime.now()
    
    for i in range(0,5):
        date = date - datetime.timedelta(1)
        insert_day_data( get_day_data( date ) )

def check_day( date='' ):
    if date == '' :
        date = datetime.date( 2012,06,20 )
    datestr = date.strftime("%Y-%m-%d")
    db = mydb.Database( 'itap' )
    sql = "SELECT * FROM fitbit_daily WHERE datestamp = %s "
    out = db.db_array( sql , ( datestr ) )
    return len(out)

def insert_day_data( obj ):
    db = mydb.Database( 'itap' )
    sql = "REPLACE INTO fitbit_daily ( floors , steps , miles , kilometers , datestamp ) VALUES ( %s , %s , %s , %s , %s )"
    out = db.db_array(sql, ( obj['floors'], obj['steps'], obj['distance_m'], obj['distance_k'], obj['date'] ) )

def get_day_data( date='' ):
    if date == '' :
        date = datetime.date( 2012,06,20 )
    # start is june 20 2012
    weekdays = ( 'Mon' , 'Tue' , 'Wed' , 'Thu' , 'Fri' , 'Sat' , 'Sun' ) 
    data = {}
    datestr = date.strftime("%Y-%m-%d")
    fb = fitbit.make_class()
    fbr = fb.activities_date_json( datestr )
    summary         = fbr['summary']
    distances       = summary['distances']
    data['date']    = datestr
    data['floors']  = summary['floors']
    data['steps']   = summary['steps']
    data['distance_k'] = 0
    
    for d in distances:
        activity = d['activity']
        if activity == 'total':
            data['distance_k'] = d['distance']
    data['distance_m'] = "%.02f" % ( data['distance_k'] * 0.621371 )
    data['distance_k'] = "%.02f" % data['distance_k'] 
    return data

if __name__ == '__main__':
    main()