Untitled

import sqlite3

def main():
        conn = sqlite3.connect('/home/deebo/movingpictures.db3')
        c = conn.cursor()
        c.execute('select id, imdb_id, title from movie_info')
        movies = dict()
        for row in c:
                movies[row[0]] = (row[1], row[2])
        ##print movies
        c.execute('select id, fullpath from local_media')
        files = dict()
        for row in c:
                files[row[0]] = row[1]
        ##print files
        c.execute('select local_media_id, movie_info_id from local_media__movie_info')
        combo = dict()
        for row in c:
                combo[row[0]] = row[1]
        ##print combo
        for key in files:
                path = files[key].replace('\\','/').replace('X:', '/store/media')
                lastslash = path.rfind('/')
                path = path[0:lastslash+1]
                info = movies[combo[key]]
                print path+'Movie.nfo - ', info[0]
                file = open(path+'Movie.nfo', 'w')
                file.write('http://www.imdb.com/title/'+info[0])
                file.close()


if __name__ == '__main__':
        main()