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 1
 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
 = 'Steven Spielberg';'''
 cursor.execute(query)

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 not found"

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