import sys
import mysql.connector

if len(sys.argv) < 2:
    print("Usage: python movie3.py <actor-name>")
    exit()

aname = sys.argv[1]

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(prepared=True)

query = ("select title,year,role from imdb.productions natural join imdb.principals natural join imdb.persons where name=%s and type='movie' and (category='actor' or category='actress') order by year")
cursor.execute(query, (aname,))

for (title,year,role) in cursor:
    if(year is None):
        movieid = title.decode()
    else:
        movieid = title.decode()+" ("+str(year)+")"
    print("{:40}   {}".format(movieid,role.decode()))

cursor.close()
cnx.close()