I have a sqlite database were I store my workout exercises. I have been working to get these exercises into a JSON files to send to my website to display graphs using Chartjs.

Going through this article (https://changsin.medium.com/how-to-serialize-a-class-object-to-json-in-python-849697a0cd3) they take two objects and turn them into a JSON output. Like this:

label1 = Label("person", 10, 10, 4, 10)
label2 = Label("car", 20, 20, 5, 11)

image_bboxes = {"image1.jpg": [label1, label2]}

output:
{"version": 1,
"type": "box",
"bounding box":
    {"image1":
        [{"label": "person",
            "x": 10,
            "y": 20
          },
          {"label": "car",
            "x": 10,
            "y": 20
          }
         ]
    }
}

Now I have a list of lists looking like this:

all_exercises = [[planks1, planks2],[bench1,bench2]]

I want to create a JSON output that will allow me to pass it off to my website. Then use JS and Chartjs to display the user selected graph. I can get the graph to do what I want it to do. I don't know how to make the JSON output. I'm not understanding something fundamental when I am using JSON. I just don't know what it is. A book or resource would be greatly appreciated.

My output currently looks like this:

{
  "version": 1,
  "exertest": {
    "second": [
      { //Need's to be labeled PLANK here
        "id": 325,
        "interval": 1,
        "resistance": 0,
        "set_number": 1,
        "workout_id": 58,
        "workout_date": "2022-03-28T06:00",
        "exercise_id": 24,
        "exercise_name": "Plank"
      },
      {
        "id": 326,
        "interval": 1,
        "resistance": 0,
        "set_number": 2,
        "workout_id": 58,
        "workout_date": "2022-03-28T06:00",
        "exercise_id": 24,
        "exercise_name": "Plank"
      },
      {  // Needs to be labeled HIP BRIDGE here
        "id": 327,
        "interval": 15,
        "resistance": 0,
        "set_number": 1,
        "workout_id": 58,
        "workout_date": "2022-03-28T06:00",
        "exercise_id": 25,
        "exercise_name": "Hip Bridge"
      }
    ]
  }
}

I must first preface this with the fact that I’m extremely new to python. Like just started learning it a little over a week ago.
I have been racking my brain over how to convert a json object I opened and loaded into a dictionary from a list so I can use the get() function nested within a for loop to do a student ID comparison from another json file (key name in that file is just ID).
Below is the command I’m trying to load the json file:
With open(‘file.json’) as x: object=json.load(x)
When I print(type(object)), it shows up as class list.
Here’s a sample of what the json looks like:
[

{

“Name”: “Steel”,

“StudentID”: 3458274

“Tuition”: 24.99

},

{

“Name”: “Joe”,

“StudentID”: 5927592

“Tuition”: 14.99

}

]
HELP! Thank you!

I am learning Python, and in particular, working with JSON and sqlite in Python. Ultimately I plan to use Python to load the JSON into a sqlite database.

Here is the question: Is there a way in to list all of the keys from a JSON file (not from a string) using Python? I want a list of all of the keys so I can determine what columns I will need/use in my sqlite table(s), without having to manually read the file and make a list.

BTW, this is something along the lines of using INFORMATION_SCHEMA.COLUMNS in SQL Server, or the FINDALL in Python for XML.

All of this is for personal learning, so I'm not looking to use other technologies, I'm sticking to Python, JSON, and sqlite on purpose.

I know that, list can be converted into JSON by using json.dumps(mylist).

But how can I convert something like this into JSON ?

[["abc", "bcd", "cde"] , ["pgr", "xyz"]]