68 lines
2.2 KiB
Python
68 lines
2.2 KiB
Python
#!/usr/bin/python3
|
|
|
|
# English lat should be around 50 so I've got them around the wrong way, lets
|
|
# swap them.
|
|
|
|
import os
|
|
import json
|
|
|
|
|
|
def convert_year(date):
|
|
""" convert date string d/m/y to a standardized format. """
|
|
d, m, y = date.split('/')
|
|
return "/".join(['%d%s' % (19 if int(y) >= 50 else 20, y), m, d])
|
|
|
|
|
|
def write_json_file(workspace, file, data):
|
|
""" write data to a JSON with sorted keys. """
|
|
file = workspace + file
|
|
print(file)
|
|
print(data)
|
|
with open(file, "w") as jsonFile:
|
|
json_contents = json.dumps(data, sort_keys=True, indent=4)
|
|
print(json_contents)
|
|
jsonFile.write(json_contents)
|
|
|
|
|
|
def documents(workspace, fileList):
|
|
""" load each file's JSON content and yielding the file name along with its contents."""
|
|
print("Entering documents function")
|
|
print("length of fileList: " + str(len(fileList)))
|
|
# for file in fileList:
|
|
for index, file in enumerate(fileList):
|
|
print(index, '--->', file)
|
|
# For each file in the list, read its json and provide a generator
|
|
contents = json.load(open(workspace + file))
|
|
# print(contents)
|
|
yield file, contents
|
|
|
|
|
|
# workspace_home = '/var/tmp/lawsoc_new/'
|
|
workspace_home = os.getcwd()
|
|
workspace = workspace_home + "/json_out/"
|
|
office_workspace = workspace + "office/"
|
|
|
|
|
|
if __name__ == '__main__':
|
|
# Get a list of files in the workspace...
|
|
office_fileList = os.listdir(office_workspace)
|
|
|
|
for file, data in documents(office_workspace, office_fileList):
|
|
tmp = data["location"]
|
|
# print("Office fileList: ", office_fileList)
|
|
# print("Office workspace: ", office_workspace)
|
|
print("File: ", file)
|
|
# print(type(tmp))
|
|
# print(len(tmp))
|
|
latitude = data["location"]["lat"]
|
|
longitude = data["location"]["lon"]
|
|
print("Old lon: ", data["location"]["lon"])
|
|
print("Old lat: ", data["location"]["lat"])
|
|
data["location"]["lon"] = latitude
|
|
data["location"]["lat"] = longitude
|
|
# print(location["admitted_date"])
|
|
print("New lon: ", data["location"]["lon"])
|
|
print("New lat: ", data["location"]["lat"])
|
|
|
|
write_json_file(office_workspace, file, data)
|