#!/usr/bin/env python3

import sqlite3
import json

db = sqlite3.connect(".config/chromium/Default/Local Storage/https_ingress.com_0.localstorage")
c = db.cursor()
c.execute('select value from ItemTable where key="plugin-uniques-data"')
row = c.fetchone()[0]

data = json.loads(row.decode('utf-16le'))


visited = {k: v for k, v in data.items() if v['visited'] }
captured = {k: v for k, v in data.items() if v['captured'] }
print("portals: "+str(len(data))+" - visited: "+str(len(visited))+" - captured: "+str(len(captured)))

print("WTF: portals")
wtf = {k: v for k, v in data.items() if not v['visited'] }
print(json.dumps(wtf))

print("del: ")
for k, v in wtf.items():
  print('j=JSON.parse(localStorage[\\"plugin-uniques-data\\"]);delete j[\\"'+k+'\\"];localStorage[\\"plugin-uniques-data\\"]=JSON.stringify(j);')