python:
#!/usr/bin/env python

import requests

import json

import sys

import base64

import os, re, os.path



import sqlite3

con = sqlite3.connect('/home/path/.kodi/userdata/Database/MyVideos116.db')

cur = con.cursor()



kodi_credentials = b'user:password' 

kodi_encoded_credentials = base64.b64encode(kodi_credentials) 

kodi_authorization = b'Basic ' + kodi_encoded_credentials 

kodi_header = { 'Content-Type': 'application/json', 'Authorization': kodi_authorization } 

kodi_ip = '127.0.0.1'

kodi_port = '8080'

kodi_url = 'http://' + kodi_ip + ':' + kodi_port + '/jsonrpc'



playlist_path = '/home/path/.kodi/userdata/playlists/video/'



#in progress + next up episodes - episodeid + path

sql_result = (cur.execute(" select idepisode,c18,c13,show from (SELECT files.idfile, episode.c00, episode.c18, episode.c12, episode.c13, episode.c05, idepisode, tvshow.c00 as show, episode.idShow, playcount, lastplayed from episode, files, tvshow where episode.idfile=files.idfile and episode.idshow = tvshow.idshow and files.idfile in (select idfile from(SELECT min(files.idfile) as idfile, min(episode.c05) as firstaired, tvshow.c00 FROM  episode, files, tvshow where episode.idfile=files.idfile and episode.idshow = tvshow.idshow and playcount is null   GROUP BY tvshow.c00) )  ) where idshow in (select idshow from(SELECT files.idfile, episode.c00, episode.c05, idepisode, tvshow.c00, episode.idShow, playcount, lastplayed from episode, files, tvshow where episode.idfile=files.idfile and episode.idshow = tvshow.idshow and files.idfile in (select idfile from(SELECT max(files.idfile) as idfile, max(episode.c05) as firstaired, tvshow.c00 FROM  episode, files, tvshow where episode.idfile=files.idfile and episode.idshow = tvshow.idshow and playcount>0   GROUP BY tvshow.c00) ) )) and c05 < date('now') order by c05 desc").fetchall())



big_xml = '<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>' + "\n" + '<smartplaylist type="episodes">'  + "\n" 

big_xml = big_xml + '    <name>001_NEXT_EPISODES</name>' + "\n" + '    <match>one</match>'



for k in sql_result:

    episode_id = k[0]

    file_name = os.path.basename(k[1])

    big_xml = big_xml + "\n" + '    <rule field=\"filename\" operator=\"is\"><value>'+ file_name.replace('&','&amp;')  +'</value></rule>' 



big_xml = big_xml + "\n"+'    <order direction=\"descending\">year</order>' + "\n" +'</smartplaylist>'

f = open(playlist_path + "NEXT_EPISODES_PLAYLIST.xsp", "w")

f.write(big_xml)

f.close()



kodi_params = ('{"jsonrpc":"2.0","method":"VideoLibrary.SetEpisodeDetails","params":{"episodeid":' + str(episode_id)+',"playcount": 1},"id":"1"}')

kodi_response = requests.post(kodi_url, headers=kodi_header, data=kodi_params)

json_data = json.dumps(kodi_response.json(), indent=4, sort_keys=True)



kodi_params = ('{"jsonrpc":"2.0","method":"VideoLibrary.SetEpisodeDetails","params":{"episodeid":' + str(episode_id)+',"playcount": 0},"id":"1"}')

kodi_response = requests.post(kodi_url, headers=kodi_header, data=kodi_params)

json_data = json.dumps(kodi_response.json(), indent=4, sort_keys=True)

print(json_data)



cur.close()

exit()

(2019-05-22, 20:18)Lunatixz Wrote: Curious, Why did you choose to access Kodi's DB directly instead of using json RPC?

Also if this is for a widget, why write a physical xml playlist? node didn't work?

(2019-05-22, 21:15)henryjfry Wrote: Doesnt the LazyTV addon generate a smart playlist too? I figured it was just a limitation in kodi that outside of the db kodi playlisting support is very poor.
Ive seen nothing in the hours of reading it took me to get this all working which suggests otherwise.

(2019-05-22, 21:09)henryjfry Wrote:

(2019-05-22, 20:18)Lunatixz Wrote: Curious, Why did you choose to access Kodi's DB directly instead of using json RPC?

Also if this is for a widget, why write a physical xml playlist? node didn't work?

I was thinking about doing it as a node but im not entirely sure how that works so i would need to figure it out first.     

(2019-05-22, 21:09)henryjfry Wrote: I originally had it done in jsonrpc but i figured that doing it in sql would be more efficient as i don't want to have to wait any longer than i have to for the widget to refresh.
Also it was far easier for me to figure out how to filter to the next unwatched episode using sql, with json i started having to do loops through every single episode to find the first unwatched. And i do sql in my job so i know how to do stuff, so i figured why not.

(2019-05-22, 21:09)henryjfry Wrote: Its for using with the skin helper service widgets, so not my own widgets or anything. Therefore, not knowing enough about addons and how to use the python xbmc module and internal functions i have no idea how i would populate these directly.

How would i use a node to populate the next up episodes into it? I installed library node editor and i had thought maybe the nodes are specific tables in sql so i could maybe create a new node and populate the sql table, but i dont think it works that way, correct me if im wrong.

(2019-05-22, 21:09)henryjfry Wrote: So if i created a node can i add episodes directly to it? Could you point me to some help documents as all ive found about nodes is for the library node editor and these are barely more complex than playlists.

(2019-05-22, 21:09)henryjfry Wrote: So yeah basically ive done it this way because i couldnt figure out any better way to do it without first learning how to build addons. And ive been hesitant to start building addons because ive got no idea how testing/addon development for kodi actually works.
Any time i try and import xbmc it just fails in python.  

(2019-05-22, 23:42)Lunatixz Wrote:

(2019-05-22, 21:15)henryjfry Wrote: Doesnt the LazyTV addon generate a smart playlist too? I figured it was just a limitation in kodi that outside of the db kodi playlisting support is very poor.
Ive seen nothing in the hours of reading it took me to get this all working which suggests otherwise.

LazyTV was written a long time ago... what's available today, wasn't then. Kodi playlist support is not "very poor"; it's one of the most robust features.

(2019-05-23, 00:04)Lunatixz Wrote:

(2019-05-22, 21:09)henryjfry Wrote:

(2019-05-22, 20:18)Lunatixz Wrote: Curious, Why did you choose to access Kodi's DB directly instead of using json RPC?

Also if this is for a widget, why write a physical xml playlist? node didn't work?

I was thinking about doing it as a node but im not entirely sure how that works so i would need to figure it out first.     

https://kodi.wiki/view/Video_nodes

(2019-05-22, 21:09)henryjfry Wrote: I originally had it done in jsonrpc but i figured that doing it in sql would be more efficient as i don't want to have to wait any longer than i have to for the widget to refresh.
Also it was far easier for me to figure out how to filter to the next unwatched episode using sql, with json i started having to do loops through every single episode to find the first unwatched. And i do sql in my job so i know how to do stuff, so i figured why not.

Accessing Kodi's DB directly is unorthodox; jsonrpc is the gold standard.  "refresh" time is negligible... as for loops this all depends on your code and query; json allows filters along with parameters. This can help boil down the results.

(2019-05-22, 21:09)henryjfry Wrote: Its for using with the skin helper service widgets, so not my own widgets or anything. Therefore, not knowing enough about addons and how to use the python xbmc module and internal functions i have no idea how i would populate these directly.

How would i use a node to populate the next up episodes into it? I installed library node editor and i had thought maybe the nodes are specific tables in sql so i could maybe create a new node and populate the sql table, but i dont think it works that way, correct me if im wrong.

Depends on your exact needs; if its a widget for specific shows you can create a node or smartplaylist that lists a show by title and only displays episodes with a "0" playcount. then make sure it's sorted by episode number and or airdate. In some cases, python maybe needed (rarely) and in those cases writing a physical xml is resource heavy and not needed for a widget. You can use plugin listitems to fill skin widgets directly, no need for nodes or smartplaylists.

(2019-05-22, 21:09)henryjfry Wrote: So if i created a node can i add episodes directly to it? Could you point me to some help documents as all ive found about nodes is for the library node editor and these are barely more complex than playlists.

Yes and no... smartplaylists and nodes are better suited for matching criteria, not specific items. Smartplaylists and nodes are not the same as m3u, pls playlists where the latter is a queue playlist. If you are using python you can drop the need for smartplaylists and nodes. It's an unneeded step.

(2019-05-22, 21:09)henryjfry Wrote: So yeah basically ive done it this way because i couldnt figure out any better way to do it without first learning how to build addons. And ive been hesitant to start building addons because ive got no idea how testing/addon development for kodi actually works.
Any time i try and import xbmc it just fails in python.  

Addon development would ultimately be what you want... sure you can get away with the above code, however; I wouldn't recommend this method for the masses.

You can find support for addon development below:
https://forum.kodi.tv/forumdisplay.php?fid=26
https://kodi.wiki/view/Add-on_development

(2019-05-23, 09:45)henryjfry Wrote:

(2019-05-22, 23:42)Lunatixz Wrote:

(2019-05-22, 21:15)henryjfry Wrote: Doesnt the LazyTV addon generate a smart playlist too? I figured it was just a limitation in kodi that outside of the db kodi playlisting support is very poor.
Ive seen nothing in the hours of reading it took me to get this all working which suggests otherwise.

LazyTV was written a long time ago... what's available today, wasn't then. Kodi playlist support is not "very poor"; it's one of the most robust features.        

I think we are taking about different things when we are talking about playlists in Kodi.

The Kodi internal playlist is great and I can add all the stuff I want with playlist.add but it's not persistent and you can't save it. At least not via JSON.

This posts talks about the same limitations I'm experiencing with Kodi playlists (ie smart playlists).

https://forum.kodi.tv/showthread.php?tid=330349&highlight=Node+tv

And by extension most of these limitations would extend to nodes. There are some more filtering options but you couldn't filter for example only the next 1 unwatched episode for TV shows in progress on one playlist (or node, from what I am reading).

So can add-ons create nodes with more internal filtering options?
How do add-ons create nodes on the fly?
Because I'm thinking this would need to be done by writing XML files, which is basically what I'm doing.

The documentation you linked to (which I had already seen) is not very helpful in clearing that up and expanding on what nodes are other than special smart playlists.        

(2019-05-23, 14:49)Lunatixz Wrote:

(2019-05-23, 09:45)henryjfry Wrote:

(2019-05-22, 23:42)Lunatixz Wrote: LazyTV was written a long time ago... what's available today, wasn't then. Kodi playlist support is not "very poor"; it's one of the most robust features.        

I think we are taking about different things when we are talking about playlists in Kodi.

The Kodi internal playlist is great and I can add all the stuff I want with playlist.add but it's not persistent and you can't save it. At least not via JSON.

This posts talks about the same limitations I'm experiencing with Kodi playlists (ie smart playlists).

https://forum.kodi.tv/showthread.php?tid=330349&highlight=Node+tv

And by extension most of these limitations would extend to nodes. There are some more filtering options but you couldn't filter for example only the next 1 unwatched episode for TV shows in progress on one playlist (or node, from what I am reading).

So can add-ons create nodes with more internal filtering options?
How do add-ons create nodes on the fly?
Because I'm thinking this would need to be done by writing XML files, which is basically what I'm doing.

The documentation you linked to (which I had already seen) is not very helpful in clearing that up and expanding on what nodes are other than special smart playlists.        

We are talking about the same thing... I'm trying to point out the confusion. Smart Playlists are not to be confused with m3u playlists... ie smart playlists filter based on matched criteria. They're rarely used to queue items.

Playlist.add has nothing to do with smart playlists... if you wanted to create a permanent "playlist" on par with playlist.add you'd use a m3u which can be directly imported to the player. https://codedocs.xyz/xbmc/xbmc/group__python___play_list.html#gadb9c48b725cb3d3de3d4a17bbc5d7fcb

The confusion is in the term "playlist" which has a broad terminology. I suggest since you want a "widget" look into plugin creation and abandon writing a playlist file or at the least try replacing your direct access DB code with json queries; which is safer for long term use.

Some of your observations on what's achievable and how; are limited... When you say things like "But you can't"; I'd rather not argue on the contrary.

Good Luck

(2019-05-23, 15:46)henryjfry Wrote: Well is it possible to have a saved playlist file (m3u, m3u8, pls or any other playlist type) which can pickup Kodi metadata as well as having specific ordering?

Even if I have to write the metadata into the playlist at creation?

Because Ive tried looking for this sort of information and it seems geared towards mp3s and maybe including album art but that's about it.

If there is any documentation anywhere that shows how to do this id love to read it. I have looked.

I already have a widget but it's slow to update when using the built in "next up" widget. Updating the widget from a playlist is very fast, hence me taking that approach.

(2019-05-23, 14:49)Lunatixz Wrote:

(2019-05-23, 09:45)henryjfry Wrote: I think we are taking about different things when we are talking about playlists in Kodi.

The Kodi internal playlist is great and I can add all the stuff I want with playlist.add but it's not persistent and you can't save it. At least not via JSON.

This posts talks about the same limitations I'm experiencing with Kodi playlists (ie smart playlists).

https://forum.kodi.tv/showthread.php?tid=330349&highlight=Node+tv

And by extension most of these limitations would extend to nodes. There are some more filtering options but you couldn't filter for example only the next 1 unwatched episode for TV shows in progress on one playlist (or node, from what I am reading).

So can add-ons create nodes with more internal filtering options?
How do add-ons create nodes on the fly?
Because I'm thinking this would need to be done by writing XML files, which is basically what I'm doing.

The documentation you linked to (which I had already seen) is not very helpful in clearing that up and expanding on what nodes are other than special smart playlists.        

We are talking about the same thing... I'm trying to point out the confusion. Smart Playlists are not to be confused with m3u playlists... ie smart playlists filter based on matched criteria. They're rarely used to queue items.

Playlist.add has nothing to do with smart playlists... if you wanted to create a permanent "playlist" on par with playlist.add you'd use a m3u which can be directly imported to the player. https://codedocs.xyz/xbmc/xbmc/group__python___play_list.html#gadb9c48b725cb3d3de3d4a17bbc5d7fcb

The confusion is in the term "playlist" which has a broad terminology. I suggest since you want a "widget" look into plugin creation and abandon writing a playlist file or at the least try replacing your direct access DB code with json queries; which is safer for long term use.

Some of your observations on what's achievable and how; are limited... When you say things like "But you can't"; I'd rather not argue on the contrary.

Good Luck

(2019-05-23, 15:57)Lunatixz Wrote:

(2019-05-23, 15:46)henryjfry Wrote: Well is it possible to have a saved playlist file (m3u, m3u8, pls or any other playlist type) which can pickup Kodi metadata as well as having specific ordering?

Even if I have to write the metadata into the playlist at creation?

Because Ive tried looking for this sort of information and it seems geared towards mp3s and maybe including album art but that's about it.

If there is any documentation anywhere that shows how to do this id love to read it. I have looked.

I already have a widget but it's slow to update when using the built in "next up" widget. Updating the widget from a playlist is very fast, hence me taking that approach.

(2019-05-23, 14:49)Lunatixz Wrote: We are talking about the same thing... I'm trying to point out the confusion. Smart Playlists are not to be confused with m3u playlists... ie smart playlists filter based on matched criteria. They're rarely used to queue items.

Playlist.add has nothing to do with smart playlists... if you wanted to create a permanent "playlist" on par with playlist.add you'd use a m3u which can be directly imported to the player. https://codedocs.xyz/xbmc/xbmc/group__python___play_list.html#gadb9c48b725cb3d3de3d4a17bbc5d7fcb

The confusion is in the term "playlist" which has a broad terminology. I suggest since you want a "widget" look into plugin creation and abandon writing a playlist file or at the least try replacing your direct access DB code with json queries; which is safer for long term use.

Some of your observations on what's achievable and how; are limited... When you say things like "But you can't"; I'd rather not argue on the contrary.

Good Luck

Yes, meta in a m3u is possible using the #KODIPROP flag; sort is dictated by the list order.

As for a physical playlist; IMO the logic is faulty, you want a static list for dynamic content, ie episode watch status will change after view (your list grows stale quickly). If your widget is "slow" think about Memoization.... balance stale data with practical refresh rates.

(2019-05-23, 18:29)henryjfry Wrote: If and when I actually start trying to figure out how to build an add-on then I'll definitely look into the various pointers you have posted.

But for now what I'm doing is triggering my playlist generator script on playback ended and then causing the widgets to reload, which keeps everything up to date.

So a non dynamic list works well enough for what I want. Obviously other methods might be better. But as I'm the one who is doing this it has to be methods I understand.
And any add-on/built in methods, I currently don't understand.

I find any "help" posts and a lot of stuff on the wiki to be pretty unhelpful.
As it's usually the syntax I'm having trouble with not the actual command. Add to this that I don't have a debugger and am debugging everything with print statements it makes this a pretty frustrating experience.

But that is literally the first mention of this KODIPROP flag I have seen anywhere.

Perhaps those more familiar with python can read this stuff easier but not me.
That's why I've been posting my full scripts every time because if someone is trying to figure out how to do something I don't wa t them pulling their hair our like I have been.
 

(2019-05-23, 15:57)Lunatixz Wrote:

(2019-05-23, 15:46)henryjfry Wrote: Well is it possible to have a saved playlist file (m3u, m3u8, pls or any other playlist type) which can pickup Kodi metadata as well as having specific ordering?

Even if I have to write the metadata into the playlist at creation?

Because Ive tried looking for this sort of information and it seems geared towards mp3s and maybe including album art but that's about it.

If there is any documentation anywhere that shows how to do this id love to read it. I have looked.

I already have a widget but it's slow to update when using the built in "next up" widget. Updating the widget from a playlist is very fast, hence me taking that approach.

Yes, meta in a m3u is possible using the #KODIPROP flag; sort is dictated by the list order.

As for a physical playlist; IMO the logic is faulty, you want a static list for dynamic content, ie episode watch status will change after view (your list grows stale quickly). If your widget is "slow" think about Memoization.... balance stale data with practical refresh rates.