| 1 | #!/bin/bash |
|---|
| 2 | |
|---|
| 3 | API_KEY='c27cb71cff5bd76e1a7a009380562c62' |
|---|
| 4 | |
|---|
| 5 | CONFIG=~/.mythtv/config.xml |
|---|
| 6 | DBSERV=`cat $CONFIG | grep DBHostName | perl -p -e 's/^[ ]*//;s/<.*?>//g'` |
|---|
| 7 | DBUSER=`cat $CONFIG | grep DBUserName | perl -p -e 's/^[ ]*//;s/<.*?>//g'` |
|---|
| 8 | DBPASS=`cat $CONFIG | grep DBPassword | perl -p -e 's/^[ ]*//;s/<.*?>//g'` |
|---|
| 9 | DBNAME=`cat $CONFIG | grep DBName | perl -p -e 's/^[ ]*//;s/<.*?>//g'` |
|---|
| 10 | |
|---|
| 11 | MYSQL="mysql -u${DBUSER} -p${DBPASS} -h${DBSERV} ${DBNAME}" |
|---|
| 12 | |
|---|
| 13 | IDLIST=`echo 'select intid from videometadata where inetref regexp "[0-9]{7}" and inetref <> 0' | $MYSQL | grep -v intid` |
|---|
| 14 | |
|---|
| 15 | for INTID in $IDLIST |
|---|
| 16 | do |
|---|
| 17 | IMDBID=`echo "select inetref from videometadata where intid=$INTID" | $MYSQL | grep -v inetref` |
|---|
| 18 | TMDBRES=`wget "http://api.themoviedb.org/2.0/Movie.imdbLookup?imdb_id=tt${IMDBID}&api_key=${API_KEY}" -O - -q` |
|---|
| 19 | TMDBID=`echo $TMDBRES | perl -p -e 's/.*<id>(\d*)<\/id>.*/$1/'` |
|---|
| 20 | echo "Moving $INTID from $IMDBID to $TMDBID" |
|---|
| 21 | echo "update videometadata set inetref=${TMDBID} where intid=${INTID}" | $MYSQL |
|---|
| 22 | sleep 2 |
|---|
| 23 | done |
|---|
