List movies from Plex database

list_plex_movie_files.py

#!/usr/bin/python3

import sqlite3
from urllib.parse import unquote, parse_qs


PLEX_DB = '/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db'

conn = sqlite3.connect(PLEX_DB)
res = conn.execute('SELECT hints FROM media_items WHERE library_section_id = 1;')

for row, in res:
    qs = parse_qs(row)
    name = qs['name'][0]
    print(name)