In [6]:

    

import json

def regionsToDB():
    regions = {}
    
with open('regions.json', 'r') as inpfile:
    regions = json.loads(inpfile.read())

with open('regions.sql', 'w') as sqlfile:
        for item,value in enumerate(regions):
#             print(regions[value])
                sqlfile.write("INSERT INTO regions (name, id) VALUES ('{}', {});\n"
                         .format(regions[value], value[6:]))

# def regionsFromDB():
def generateJSON():
    regions = {}
    teams = {}
    cups = {}
    out = {}
    
    with open('db/regions.json', 'r') as inpfile:
        regions = json.loads(inpfile.read())['RECORDS']
    with open('db/teams.json', 'r') as inpfile:
        teams   = json.loads(inpfile.read())['RECORDS']
    with open('db/contests.json', 'r') as inpfile:
        cups    = json.loads(inpfile.read())['RECORDS']
    for region in regions:
#         print(region['id'])
        r_teams = list(filter(lambda x: int(x['region']) == int(region['id']), teams))
        r_cups  = list(filter(lambda x: int(x['region']) == int(region['id']), cups))
     #   print(r_teams)
#         tst = list(i['name'] for i in r_teams)
#         print(tst)
        tmp = {
            'name' : region['name'],
            'team_list' : ', '.join(list(i['name'] for i in r_teams)),
            'cup_list'  : ', '.join(list(i['name'] for i in r_cups)),
            'teams' : r_teams,
            'cups' : r_cups
        }
        out['region'+region['id']] = tmp
#         out.append(tmp)
    with open('api.json', 'w') as outfile:
        json.dump(out, outfile, indent=4, sort_keys=True, ensure_ascii=False)

if __name__ == "__main__":
    #regionsToDB()
    generateJSON()


    

In [ ]:

    




    

In [ ]: