def insert_json_data(database, insert_query, insert_data):
try:
connection = open_connection_with_dict_factory(database)
cursor = connection.cursor()
cursor.execute(insert_query, insert_data)
connection.commit()
connection.close()
return maxrest.build_json_response({'success':True}, 200)
except:
print "Unexpected error:", sys.exc_info()[0]
return maxrest.build_json_response({'success':False}, 500)
raise
def import_excel(file_path, year):
metrics_importation.import_articles(file_path, year)
metrics_importation.import_videos(file_path, year)
return maxrest.build_json_response({'success':True},200)
