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 :) )
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
- 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
- ...
- MYSQL
- mysql-connector-python
- prettytable