def save(data):
connect = Connect()
cursor = connect.initConnect()
query = ("INSERT INTO movies "
"(title"
", original_title"
", year"
", release_date"
", duration"
", imdb_rating"
", imdb_id"
", imdb_poster)"
"VALUES (%s, %s, %s, %s, %s, %s, %s, %s)")
data = (data['title']
, data['original_title']
, data['year']
, data['release_date']
, data['duration']
, data['rating']
, data['imdb_id']
, data['poster']
)
cursor.execute(query, data)
connect.commit()
id_movie = cursor.lastrowid
connect.closeConnect()
return id_movie
def addDirector(id_movie, id_director):
connect = Connect()
cursor = connect.initConnect()
query = ("INSERT INTO movies_directors "
"(id_movie, id_director)"
"VALUES (%s, %s)")
data = (id_movie, id_director)
cursor.execute(query, data)
connect.commit()
connect.closeConnect()
def addGenre(id_movie, id_genre):
connect = Connect()
cursor = connect.initConnect()
query = ("INSERT INTO movies_genres "
"(id_movie, id_genre)"
"VALUES (%s, %s)")
data = (id_movie, id_genre)
cursor.execute(query, data)
connect.commit()
connect.closeConnect()
def save(id_imdb):
connect = Connect()
cursor = connect.initConnect()
query = ("INSERT INTO imdb "
"(id_imdb)"
"VALUES (%s)")
data = (id_imdb,)
try:
cursor.execute(query, data)
except MySQLdb.Error:
raise
connect.commit()
connect.closeConnect()
def save(name):
connect = Connect()
cursor = connect.initConnect()
query = ("INSERT INTO directors "
"(name)"
"VALUES (%s)")
data = (name,)
cursor.execute(query, data)
connect.commit()
id_director = cursor.lastrowid
connect.closeConnect()
return id_director
