import sys
import mysql.connector

if len(sys.argv) < 3:
    print ("Usage: python moviestogether.py <actor1-name> <actor2-name>")
    exit()

aname1 = sys.argv[1]
aname2 = sys.argv[2]

cnx = mysql.connector.connect(user='alice', password='tiger', host='sql.cs.oberlin.edu', database='imdb', charset='utf8', auth_plugin='mysql_native_password')
cursor = cnx.cursor()

query = ("select title,year from imdb.productions "
        "where type='movie' and tcode in "
          "(select p1.tcode from imdb.principals p1, imdb.principals p2 "
           "where p1.tcode=p2.tcode "
           "and p1.ncode in "
           " (select ncode from imdb.persons where name='"+aname1+"') "
           "and p2.ncode in "
           " (select ncode from imdb.persons where name='"+aname2+"') "
           "and p1.category!='self' "
           "and p2.category!='self') "
         "order by year")

cursor.execute(query)

for (title,year) in cursor:
    print  (title+" ("+str(year)+")")

cursor.close()
cnx.close()