import json

file_path = 'results.json'

with open(file_path, 'r') as file:
    data = json.load(file)

upc = None
track_id = None

print('INSERT INTO `split` (`identifier`, `split_rate`, `collaborator_id`, `split_type_id`, `rate_type`, `source`) VALUES')

for track in data:
    if upc != track['UPC']:
        upc = track['UPC']
        print(f'\n  -- UPC: {upc}')

    if track_id != track['TRACK_ID']:
        track_id = track['TRACK_ID']
        print(f'  -- track {track_id}')

    print(f"  ('{track['TRACK_UNIQUE_ID']}', {track['SPLIT_RATE']}, {track['COLLABORATOR_ID']}, {track['SPLIT_TYPE_ID']}, '{track['RATE_TYPE']}', 'AS-2956'),")