Extract data from nwqs

nwqs_data_extract.py

import json
import sqlparse
import xmltodict

from pprint import pprint

def xml2dict(xmlString):
    '''Return json object'''
    jsonString = json.dumps(xmltodict.parse(xmlString), indent=4)
    xml_in_dict = json.loads(jsonString)
    return xml_in_dict

nwqs_file = 'file.nwqs'

with open(nwqs_file) as f:
    nwqs_dict = xml2dict(f.read())

for index, data in enumerate(nwqs_dict["QuerySet"]["Query"]):
    with open('{} {}.sql'.format(index, data["Name"]).replace(' ', '_'), 'w') as f:
        f.write(sqlparse.format(data["SQL"], reindent=True, keyword_case='upper'))