FilmFlix-Python-App-with-database

FilmFlix application

Introduction

You have been asked to develop a command line python application for FilmFlix, to manage their film database. As a start-up FilmFlix have no more than 40 records of films in their database. A database developer volunteered to work with FilmFlix a while back to develop their database and for ease of use and integration implemented SQLite3 SQL database. However, due to unforeseen circumstance the developer is unable to connect the database with python application, but a copy of the SQLite database has been made available for you to work with if you chose to. Otherwise, you can create the database using SQLite.

Note:

CRUD: Create Read Update Delete. Only one table in the database with records, which is all you need for this project. Database name filmflix.db Table name tblfilms filmID(integer), title(text), yearReleased(integer),rating(text),duration(integer),genre(text)

You have now been tasked with developing a python application to manipulate the FilmFlix database. Perform CRUD operation on the database from the python command line

• Print all records in tblfilms in database filmflix.db
• Allows users to add, update or delete records in the filmflix.db database (CRUD)
• Print a selection of reports, these functions demonstrate different techniques of writing sql commands and printing reports

Hint: for FilmFlix CRUD: create Options menu to include Options menu

1. Add a record
2. Delete a record
3. Amend a record
4. Print all records
5. Exit

Hint: for FilmFlix report create Options menu to include

1. Print details of all films
2. Print all films of a particular genre
3. Print all films of a particular year
4. Print all films of a particular rating
5. Exit