/Aparat-clone

The Final Project of the Database Design course using Mysql and Python.

Primary LanguagePython

Aparat-Clone

This is my final project of the Database Design course at AUT.
Aparat-Clone is a basic version of the Iranian video-sharing service Aparat.

All the logic parts of the project are written in MySQL queries ( as it's my DB course :) )

How To Use

You first need to create a new user in MySQL as follows

mysql> CREATE USER 'username-you-like'@'localhost' IDENTIFIED BY 'a-strong-password';

and then grant all permission to the new user

mysql> GRANT ALL PRIVILEGES ON * . * TO 'username-you-like'@'localhost';
mysql> FLUSH PRIVILEGES;

and finally create database

mysql> CREATE DATABASE IF NOT EXISTS Aparat

before you run the main program, you need to set the configurations you did before.

you just need to set the config.json file as:

{
  "user": "your-user-name",
  "password": "your-password",
  "host": "127.0.0.1",
  "database": "Aparat",
  "buffered": true,
  "autocommit": true
}

To test this program, install requirements of it by pip. like this.

pip install -r requirements.txt

then you can start program by below command.

python3 main.py

Features

  • Create an Aparat account
  • Sign-in as admin and CRUD the films, categories, and see the log history of what users have done
  • Sign-in as a user
  • Watch movies, add new comments, and rate
  • Create a Playlist of Aparat films and share it with others
  • Upgrade to VIP-Member to watch the VIP-films
  • Follow and Unfollow a friend to see his/her Playlist
  • ...

Requirements

  • MYSQL
  • mysql-connector-python
  • prettytable