Retrieve bookmarks from Pindroid

pinextract.py

import json
import sqlite3

output = []

conn = sqlite3.connect('PinboardBookmarks.db')
c = conn.cursor()
for row in c.execute("SELECT url, description, tags FROM bookmark"):
    output.append({"href": row[0], "description": row[1], "tags": row[2]})

with open("PinboardBookmarks.json", "w") as f:
    json.dump(output, f)