import sqlite3

dbfile= raw_input("Enter the name of the database file: ")
outputfile= raw_input("Enter the name of the output file: ")

db = sqlite3.connect(dbfile)
cursor = db.cursor()

#Query 2
dirname = raw_input("Enter Movie Director's name: ")
query = '''SELECT Movie.name, Movie.runtime FROM Movie, Director, Person WHERE
Movie.id = Director.movie_id AND Director.director_id = Person.id AND Person.name
= ? ''';
cursor.execute(query, [dirname])

outfile = open(outputfile, 'w')

cnt = 0

for tuple in cursor:
    line = str(tuple[0]) +"  "+ str(tuple[1]) + "\n"
    outfile.write(line)
    print tuple[0],tuple[1]
    cnt = cnt + 1

if cnt == 0:
    print "Movie Director " + dirname + " not found"

db.commit()
db.close()
outfile.close()