python

import MySQLdb as mdb
import sys
import json
import MySQLdb
import sys


host = "localhost"
db_id = "root"
db_pw = "1q2w3e"
db_name = "fitbit_db"

db = MySQLdb.connect( host, db_id, db_pw, db_name )
cursor = db.cursor()
#cursor.execute( "select version()" )
#data = cursor.fetchone()
cursor.execute( "show tables")
data = cursor.fetchall()
print data
print data

db.close()

with open('001_sleep_start.txt') as f:
	data = f.read()
	jsondata  = json.loads(data)

with open('002_sleep_timeInBed.txt') as a:
	timeinbed = a.read()
	timeinbed_1 = json.loads(timeinbed)
	
for row1 in timeinbed_1['sleep-timeInBed']:
	print row1['value']
	print row1['dateTime']

for row in jsondata['sleep-startTime']:
	print row['value']
	print row['dateTime']