digsim / missingtvshows Goto Github PK

Sometimes a Season is reported as having missing items:

################## Watched Missing

|Title (SeasonId) | Season (Downloaded/Available)| Missing |

|XXXX (12345 ): | S5 (15/12)| missing: |

The log says that we have 15 local episodes but 12 are available in this season.

sqlite> select * from (select tvshow.c00 as Title, episodeview.c12 as Season, count(*) as Episodes, tvshow.c12 as SeriesiD, episodeview.idSeason as SeasoniD, sum(episodeview.playCount) as Played from episodeview join seasons on seasons.idSeason = episodeview.idSeason join tvshow on tvshow.idShow = seasons.idShow group by tvshow.c00, episodeview.c12 order by tvshow.c00) where Played is not NULL and SeriesiD=12345;
Title|Season|Episodes|SeriesiD|SeasoniD|Played
XXX XXXX|3|12|12345|221|12
XXX XXXX|4|12|12345|222|12
XXX XXXX|5|15|12345|223|15
sqlite>

The Episodes Column contains the same value as the Played Column => Rewrite SQL Query!!!

When using python 3 the TV Show titles are not properly decoded using UTF-8. Instead of printing:

'Star Trek: The Next Generation'  : Season 3  and has watched 10/26 Episodes

it prints

b'Star Trek: The Next Generation'  : Season 3  and has watched 10/26 Episodes

python --version

Python 3.4.2

and

python2 --version

Python 2.7.9

OS: Arch Linux

$ python missing_tvshows.py


[=========                                                                                           ] 8%Traceback (most recent call last):
  File "/usr/lib/python3.4/site-packages/pytvdbapi/api.py", line 192, in __getitem__
    return self.seasons[item]
KeyError: 3

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "missing_tvshows.py", line 323, in <module>
    sms.getArguments(sys.argv[1:])
  File "missing_tvshows.py", line 299, in getArguments
    self.main()
  File "missing_tvshows.py", line 282, in main
    unwatched_finished_shows,  unwatched_unfinished_shows,  watchedsome_unfinished_shows,  watchedsome_finished_shows = self.getSeriesInformation()
  File "missing_tvshows.py", line 176, in getSeriesInformation
    number_of_episodes = self.getTotalNumberOfEpisodes(int(rowId),  int(rowSeason))
  File "missing_tvshows.py", line 111, in getTotalNumberOfEpisodes
    number_of_episodes = len(show[season])
  File "/usr/lib/python3.4/site-packages/pytvdbapi/api.py", line 194, in __getitem__
    raise error.TVDBIndexError(u"Season {0} not found".format(item))
pytvdbapi.error.TVDBIndexError: ('Season 3 not found', (), {})`

For now as it seems, the script does not work on windows. Try to create a wheel for pypi instead of a bdist.

Searching for missingTVShows
Reading https://pypi.python.org/simple/missingTVShows/
Best match: missingTvShows 1.1.1
Downloading https://pypi.python.org/packages/2.7/m/missingTvShows/missingTvShows-1.1.1-py2.7.egg#md5=fabfa0351f43df010b6251a9d2da790b
Processing missingTvShows-1.1.1-py2.7.egg
Moving missingTvShows-1.1.1-py2.7.egg to c:\program files\python27\lib\site-packages
Adding missingTvShows 1.1.1 to easy-install.pth file
Installing missingTVShows script to C:\Program Files\Python27\Scripts

Installed c:\program files\python27\lib\site-packages\missingtvshows-1.1.1-py2.7.egg
Processing dependencies for missingTVShows
Finished processing dependencies for missingTVShows

Is that script runnable on Windows? easy_install does not create a .exe launcher as it should (i think)