#!/usr/bin/env python import sqlInfo import updateFitbitDb import timerangegenerator dateRange, tableName = timerangegenerator.parse() fbUpdater = updateFitbitDb.updateFitbitDb("fitbitKeys.json", sqlInfo, tableName=tableName) for date in dateRange: fbUpdater.updateDate(date)
import fitbitKeys, sqlInfo import updateFitbitDb as updateFitbitDb import datetime import argparse import calendar as cal parser = argparse.ArgumentParser(description='Update historcal Fitbit data') parser.add_argument('month', metavar='MONTH', type=int, help='Month to be requested') parser.add_argument('-t', '--table', default='Fitbit', help='Name of SQL table name') parser.add_argument('-y', '--year', default='2013', type=int, help='Year to be requested') args = parser.parse_args() tableName = args.table month = args.month year = args.year fbUpdater = updateFitbitDb.updateFitbitDb(fitbitKeys, sqlInfo, tableName=tableName) listOfDates = [] for i in range(1, cal.monthrange(year,month)[1]+1): listOfDates.append(datetime.datetime(year=year, month=month, day=i)) print "Saving historical Fitbit data from " + str(year) + "-" + str(month) for date in reversed(listOfDates): fbUpdater.updateDate(date)
import fitbitKeys, sqlInfo import updateFitbitDb as updateFitbitDb import datetime fbUpdater = updateFitbitDb.updateFitbitDb(fitbitKeys, sqlInfo) yesterday = datetime.date.today() - datetime.timedelta(days=1) lastTenDays = [] for i in range(0, 10): lastTenDays.append(datetime.date.today() - datetime.timedelta(days=i)) for date in reversed(lastTenDays): fbUpdater.updateDate(date)