Dump scoop sqllite cache

scoop-show-cache.py

import sqlite3

database = 'C:/Users/jeffm/scoop/scoop.db'

try:
    with sqlite3.connect(database) as conn:
        cur = conn.cursor()
        cur.execute("""
SELECT DISTINCT
	bucket,
	name,
	description,
	FIRST_VALUE(version) OVER (
		PARTITION BY bucket,name ORDER BY version DESC
	) latest_version
FROM
	app
WHERE
	bucket NOT IN ('java', 'versions')
ORDER BY
	bucket ASC, name ASC, version DESC
""")
        rows = cur.fetchall()

    for row in rows:
        print(f'{row[0]}/{row[1]} v{row[3]} : {row[2]}')
except sqlite3.Error as e:
    print (e)