mythicalLibrarian - a tool to build Movie and TV Show library from MythTV recordings

Code:

@@@@@@@@@@@NEW SEARCH INITIATED AT Wed Jan  5 18:46:16 EST 2011@@@@@@@@@@@@@@

Revision 909 Wed Jan 5 18:39:04 EST 2011 on Linux

%%%NO DATABASE INFORMATION. CHECK LOGIN/PASS OR FILE %%%%%

SEARCHING: www.TheTvDb.com SHOW NAME: mister rogers EPISODE: show 1332

DATE:  FILE NAME: testfile.ext

FOUND:Mister Rogers' Neighborhood ID#:77750 WITH CONFIDENCE:-2

Creating MythicalLibrarian Database Folder

AIRDATE FAILED. TITLE MATCH ON ABSOLUTE EPISODE NUMBER: 

###################DEBUG MODE ENABLED####################

MY USER NAME:bobby-

LISTING INTERNAL VARIABLES USED BY mythicalLibrarian.

INTERNET TIMEOUT:50- TVDB API KEY:6DF511BB2A64E0E9- mythicalLibrarian WORKING DIR:/home/bobby/.mythicalLibrarian-

MOVE DIR:/home/bobby/.mythicalLibrarian/mythicalSetup/Episodes-

FAILSAFE MODE:Enabled- FAILSAFE DIR:/home/mythtv/FailSafe- ALTERNATE MOVE DIR:/home/bobby/.mythicalLibrarian/mythicalSetup/Episodes-

USE ORIGINAL DIR:Enabled NOTIFICATIONS:Enabled

INPUT SHOW NAME:mister rogers- LOCAL SHOW NAME TRANSLATION:- ShowName:mister rogers

DATABASE UPDATED:- TVDB LAST UPDATED:- CURRENT:-

RESOLVED SERIES ID:77750- RESOVED SHOW NAME:Mister Rogers' Neighborhood-

INPUT EPISODE NAME:show 1332- Absolute EPISODE NUMBER:462- RESOLVED EPISODE NAME:Show 1332-

SEASON:S07- EPISODE:E07- SYMLINK MODE:MOVE- FILESIZE: 0kB-

CONFIDENCE:-3 LOGIC PATH:  Attempted Match On Zap2itID: Failed; Attemted match on Standard Logic: Failed; Attemted Title match on Fuzzy Logic: Sucessful; Attemped match on OriginalAirDate: Failed; Attemted SubTitle match on Standard logic: Sucessful; 

CREATE AND DELETE FLAGS: ORIGINALDIR:1- FREE:1558480kB- WORKINGDIR:1 FREE:1558480kB-

MOVEDIRWRITABLE:1- FREE:1558480kB- ALTERNATEMOVEDIR:1- FREE:1558480kB-

PRIMARYSHOWDIRWRITABLE:1-  FREE:1558480kB-ALTERNATESHOWDIRWRITABLE:1- FREE:1558480kB-

PRIMARYMOVIEDIRWRITABLE:1- FREE:1558480kB- ALTERNATEMOVIEDIR:1- FREE:1558480kB-

DATABASE TYPE:-

 RECSTART:- MOVIE YEAR:- ORIGINAL SERIES DATE:-

 PROGRAMID:- CHANNEL ID:- CATEGORY:- GOFORDOOVER:0-

 EXTRAPOLATED DATA DETERMINED THIS RECORDING AS A:- STARS: RATING:0

 ZAP2IT SERIES ID:- MATCHED TVDB SERIES ID:-

PLOT: 

####################END OF DEBUG LOG#####################

CREATING FOLDER: /home/bobby/.mythicalLibrarian/mythicalSetup/Episodes/Mister Rogers Neighborhood

Code:

ctrl+alt+F1

Code:

sudo apt-get install ssh

Code:

ssh *yourLogin*@192.168.1.100

mkdir ~/.mythicalLibrarian && mkdir ~/.mythicalLibrarian/mythicalSetup && cd ~/.mythicalLibrarian/mythicalSetup

curl http://mythicallibrarian.googlecode.com/svn/trunk/mythicalSetup.sh>./mythicalSetup.sh

sudo chmod +x ./mythicalSetup.sh && sudo ./mythicalSetup.sh

Code:

sudo su mythtv

sudo mythicalLibrararian --update

Code:

echo Processing 1022_20091230200000.mpg

mythcommflag -c 1022 -s 2009-12-30-20-00-00 --gencutlist

mythtranscode --chanid 1022 --starttime 2009-12-30-20-00-00 --mpeg2 --honorcutlist

rm /mnt/video2/store/1022_20091230200000.mpg

mv /mnt/video2/store/1022_20091230200000.mpg.tmp /mnt/video2/store/1022_20091230200000.mpg

mythcommflag --file 1022_20091230200000.mpg --rebuild

NEWFILESIZE=`du -b /mnt/video2/store/1022_20091230200000.mpg | cut -f1`

echo "UPDATE recorded SET basename='1022_20091230200000.mpg',filesize='$NEWFILESIZE',transcoded='1' WHERE chanid='1022' AND starttime='2009-12-30-20-00-00'" > update-database.sql

mysql --user=dbuserHere --password=password mythconverg < update-database.sql

rm /mnt/video2/store/1022_20091230200000.mpg*.png

Code:

read -p "Enter folder to scan:" Folder 

read -p "Enter DBUserName:" DBUsername

read -p "Enter DBPassWord:" DBPassword

 

echo "creating list of files in $Folder"

ls -1  "$Folder" > ./tempList

 

while read line

do 

  test "${line:0:3}" != "mpg" && continue 

  FileName=`basename "$line"`

  echo Processing "$FileName".mpg

 

#This part can be automated... it requires a bit of reference using

 

#Chanid=`mysql -u"$DBUserName" -p"$DBPassWord" -e \'use mythconverg; select chanid from recorded where basename like "$FileName";\'`|sed -n 2p

#Starttime=`mysql -u"$DBUserName" -p"$DBPassWord" -e \'use mythconverg; select starttime from recorded where basename like "$FileName";\'|sed -n 2p

  mythcommflag -c $Chanid -s $Starttime --gencutlist

  mythtranscode --chanid $Chanid --starttime $Starttime --mpeg2 --honorcutlist

  rm "$Folder"/"$FileName".mpg

  mv "$Folder"/"$FileName.mpg".tmp "$Folder"/"$FileName".mpg  mythcommflag --file "$FileName".mpg --rebuild

  NEWFILESIZE=`du -b "$Folder"/"$FileName".mpg | cut -f1`

  echo "UPDATE recorded SET 

#Same for starttime

basename='$FileName.mpg',filesize='$NEWFILESIZE',transcoded='1' WHERE chanid=\'$Chanid\' AND starttime=\'$Starttime\'" > update-database.sql

  mysql --user=$DBUserName --password=$DBPassWord mythconverg < update-database.sql

  rm "$Folder"/"$FileName".mpg*.png

done < ./tempList

echo "Removing previously created list of files in $Folder"

rm ./tempList