Question: Please correct my code as I'm getting the error shown in the picture Question: Video Store [2 points] Recall the movie database example given in

Please correct my code as I'm getting the error shown in the picture

Please correct my code as I'm getting the error shown in thepicture Question: Video Store [2 points] Recall the movie database example given

Question: Video Store [2 points] Recall the movie database example given in class. In this question, you are to complete two functions in the following cell using the table movies from videostore. db For the function allMovies() , return a list of all movie records where each record is in the form of tuple. For example, if table movies of videostore.db contains only two records, say (101, "Casablanca', 'drama romance', PG') (102, Back to the Future', 'comedy adventure', "PG) then the function should return the list (101 Casablanca' 'drama romance' PG'), (102, Back to the Future' comedy adventure', 'PG')] The function addMovie(movieid, title, genre, rating) takes four inputs to add a new movie record to the database. For simplicity, you may assume that all inputs to addMovies(..) are appropriate In [65] def allMovies() dbsqlite3.connect('videostore.db') cursor = db . cursor() sql- "SELECT * FROM MOVIES"! cursor.execute (sql) resultscursor.fetchallo) for row in results: movieidrow[e] title - row[1] genre row[2] rating row[3] print("novieid-Xs,title-%s,genre-M , rating-Xs" % (movieid, title, genre, rating) ) db.close() def addMovie(movieid, title, genre, rating): db sqlite3 . connect('videostore . db') cursor-db.cursor) sql"INSERT INTO MOVIE (MOVIEID, TITLE, VALUES GENRE, (%d', RATING) \ '%s', %s', %s')" % (movieid, title, genre, rating) cursor.execute (sql) db.commit() db.close()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!