Project Video Database

The idea of the project

This is an app which is storing information about YouTube videos. The app is designed using Model-View-Controller design pattern. The primary implementation uses SQLite Database to store thr data but there is also a possibility to add another way of saving objects. The app also provides a GUI for reading and editting all the data.

User Manual

In the main app window there are 3 buttons:

• "Add Video" - enables inserting new record to the database.
  ⚠️ Syntax is important:

  • the data should be in dd.mm.yyyy format (e.g. "01.01.2000")
  • key words should be separated by a comma and a space (e.g. "cat, dog" or "horse,")

• "Video Table" - enables viewing all information about that have been added to the database so far (there are multiple sorting options)

• "Keywords Table" - enables viewing keywords and their corresponding videos that have been added to the database so far (there are multiple sorting options)

Class Diagram

Running the program

Requirements

It is required to have Python 3.x interpreter installed.

Required libraries

Firstly, create Virtual Environment, install the required libraries and activate the created Virtual Environment.

Linux

python3 -m venv venv
source venv/bin/activate
pip3 install -r requirements.txt

Windows

py -m venv venv
.\venv\Scripts\activate
pip install -r requirements.txt

Start the app

Linux

python3 ./code/controller.py

Windows

py ./code/controller.py