eddyizm eddyizm

Listing watched files on kodi (xbmc)

To list the full path of all watched files that are still accessable: (assuming the sql query was saved to list-watched-files.sql)

sqlite3 ~/.kodi/userdata/Database/MyVideos90.db < list-watched-files.sql | xargs -L 1 -I filename ls "filename" 2>/dev/null

Explanation

Get the list of watched files from the Kodi database

Kodi uses sqlite databases, located in ~/.kodi/userdata/Database/. The video database is MyVideosXX.db, where XX is the version (MyVideos90.db on OSMC on 2015-05-09)

	# See details about Turnstile at https://blog.cloudflare.com/turnstile-private-captcha-alternative/

	from typing import Optional

	import pydantic
	import requests

	cloudflare_secret_key: Optional[str] = None

	# If errors are found, do this
	# clear contents of C:\Users\<username>\AppData\Local\Temp\gen_py
	# that should fix it, to test it type
	import win32com.client
	app = win32com.client.gencache.EnsureDispatch('Word.Application')
	app.Visible = True

	# OutlookMailer.py
	# Python 2.7.6

	import win32com.client as com

	outlook = com.Dispatch("Outlook.Application")

	"""
	Source - https://msdn.microsoft.com/en-us/library/office/ff869291.aspx
	Outlook VBA Reference

	Windows Registry Editor Version 5.00
	; Default color scheme
	; for Windows command prompt.

	; Values stored as 00-BB-GG-RR
	[HKEY_CURRENT_USER\Console]
	; BLACK DGRAY
	"ColorTable00"=dword:00000000
	"ColorTable08"=dword:00808080
	; BLUE LBLUE