import json
import DB
database = DB.connTestDB()
cursor = database.cursor()
print "Connected to database and cursor initialized."
DB.clearDB(database)
print "Opening DatabaseJSON.json..."
# Parse JSON file.
with open('DatabaseJSON.json') as data_file:
data = json.load(data_file)
print "DatabaseJSON.json has been successfully parsed."
# The query to add a record.
add_record = ("INSERT INTO Records "
"(activity_id, activity_name, activity_instructions, activity_primary_muscles, activity_secondary_muscles, activity_lift_type, activity_rating, activity_equipment, image_0, image_1, url) "
"VALUES ")
# Add the appropriate number of records.
add_record += "(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
for row in data['data']:
# Result Row, URL, activity_name, activity_instructions
# activity_primary_muscle_group, muscle_0, Activity equipment
# activity_image_0, activity_image_1, activity_lift_type
# activity_video, activity_rating
# Save to temporary variables.
