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 |
---|