import csv
import json
import datetime


f = open('chrome_ver_google_wiki.csv', 'r', encoding='utf-8')
reader = csv.reader(f)
next(reader)

versions = {}
for row in reader:
    if row[0]:
        value = row[1].split()[0]
        versions[row[0]] = value
f.close()

f = open('chrome_ver_github_combined.json', 'r', encoding='utf-8')
v2 = json.load(f)
for i in v2:
    if i['version'] not in versions:
        versions[i['version']] = i['date']

# v = {k: v for k, v in sorted(list(versions.items()))}
# v = {k: v for k, v in sorted(versions.items(), key=lambda v: int(v[0].split('.')[0]))}
v = {k: v for k, v in sorted(versions.items(), key=lambda v: (int(v[0].split('.')[0]), int(v[0].split('.')[1]), int(v[0].split('.')[2]), int(v[0].split('.')[3]) if len(v[0].split('.')) > 3 else 0))}

for i in v:
    v[i] = datetime.datetime.strptime(v[i], '%Y-%m-%d').strftime('%Y-%m-%d')
f.close()

f = open('chrome_versions_history.json', 'w', encoding='utf-8')
json.dump(v, f, indent=2)
f.close()

v2 = {}
last = datetime.datetime(2005, 12, 3, 0, 0)
for i in v:
    if datetime.datetime.strptime(v[i], '%Y-%m-%d') > last:
        v2[i] = v[i]
        last = datetime.datetime.strptime(v[i], '%Y-%m-%d')
f = open('chrome_versions_history_graph.json', 'w', encoding='utf-8')
json.dump(v2, f, indent=2)
f.close()