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