Json file?

[lerocha]

Json file?

[SubOptimal]

I've used DB Browser for SQLite to export the database.

The exported files look as

Album.json

[
    {
        "AlbumId": "1",
        "ArtistId": "1",
        "Title": "For Those About To Rock We Salute You"
    },
    {
        "AlbumId": "2",
        "ArtistId": "2",
        "Title": "Balls to the Wall"
    },

... truncated

Artist.json

[
    {
        "ArtistId": "1",
        "Name": "AC/DC"
    },
    {
        "ArtistId": "2",
        "Name": "Accept"
    },

... truncated

(the other files are omitted)

A simple usage example:

import pandas as pd
from tabulate import tabulate

with open('data/Album.json', 'r') as f:
    album_json = f.read()

with open('data/Artist.json', 'r') as f:
    artist_json = f.read()

album_df = pd.read_json(album_json)
artist_df = pd.read_json(artist_json)

# - merge the two DataFrames on column 'ArtistId'
# - drop the columns 'AlbumId', 'ArtistId'
merged_df = pd.merge(artist_df, album_df, on='ArtistId') \
    .drop(columns=['AlbumId', 'ArtistId'], axis=1)
# set the column labels
merged_df.columns = ['Artist', 'Album']

print(tabulate(merged_df, headers='keys', showindex=False))

output

Artist                Album
--------------------  -------------------------------------
AC/DC                 For Those About To Rock We Salute You
AC/DC                 Let There Be Rock
Accept                Balls to the Wall
Accept                Restless and Wild
Aerosmith             Big Ones

... truncated

[marko-knoebl]

To expand a little on the work of @pangoro24, here's both the data and the database schema as JSON:

https://github.com/marko-knoebl/chinook-database-json/tree/master/src

[pangoro24]

Just as reference, I extracted them and saved the json and txt files here>
https://github.com/pangoro24/chinook-refit/tree/master/backend/files

[lerocha]

You can now find the JSON file that is used to generate all the chinook database SQL scripts in the Releases page assets.

https://github.com/lerocha/chinook-database/releases

Thank you!